inserting csv - solved, but more to the puzzle

In case anyone might find this of the least interest, probably not, but
I always hope to add to discussion just as part of the thank you for help.

Further work with same issues found that a file received from a PC based
client, if opened in PC environment, didn't have the same problems (so
far) as if opened in a Mac environment. The next file I had to work with
in this particular project, I opened in PC, then uploaded using
phpMyadmin with no issues. Same client, same type of file.

So, maybe there is a PC/Mac thing happening to cause the line 17,
missing commas in csv?

Just a thought. If anyone has any insight, most appreciated.

--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: inserting csv - solved, but more to the puzzle

I've run into similar situations w/regard to Mac vs PC CSV files,
it usually has to do with the EOL character sequence. Macs use
LF (chr(10)), while PCs use CRLF (chr(13)chr(10)).

andy

Patrice Olivier-Wilson wrote:
> In case anyone might find this of the least interest, probably not, but
> I always hope to add to discussion just as part of the thank you for help.
>
> Further work with same issues found that a file received from a PC based
> client, if opened in PC environment, didn't have the same problems (so
> far) as if opened in a Mac environment. The next file I had to work with
> in this particular project, I opened in PC, then uploaded using
> phpMyadmin with no issues. Same client, same type of file.
>
> So, maybe there is a PC/Mac thing happening to cause the line 17,
> missing commas in csv?
>
> Just a thought. If anyone has any insight, most appreciated.
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: inserting csv - solved, but more to the puzzle

Thank you for the confirmation, Andy. I appreciate your patience with
such a newbie who is just trying to learn.


Andy Wallace wrote:
> I've run into similar situations w/regard to Mac vs PC CSV files,
> it usually has to do with the EOL character sequence. Macs use
> LF (chr(10)), while PCs use CRLF (chr(13)chr(10)).
>
> andy
>
> Patrice Olivier-Wilson wrote:
>> In case anyone might find this of the least interest, probably not,
>> but I always hope to add to discussion just as part of the thank you
>> for help.
>>
>> Further work with same issues found that a file received from a PC
>> based client, if opened in PC environment, didn't have the same
>> problems (so far) as if opened in a Mac environment. The next file I
>> had to work with in this particular project, I opened in PC, then
>> uploaded using phpMyadmin with no issues. Same client, same type of
>> file.
>>
>> So, maybe there is a PC/Mac thing happening to cause the line 17,
>> missing commas in csv?
>>
>> Just a thought. If anyone has any insight, most appreciated.
>>
>


--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org