CSV import, max no. of rows exceeded at 3,739??

[Citizendee]

I've just exported my music collection from MediaMonkey to a CSV file. Total of 3,739 records. I've confirmed this by also exporting to HTML and opening the CSV export in PSPad but when importing to Calc I get an error saying maximum number of rows have been reached and remainder will be ignored. The data stops at row 3,386. Running latest OOo 3.0 on Windows XP.
Why is this occurring? It's very annoying considering I uninstalled MS Office thinking OOo could handle everything.

-CD

[TheGurkha]

Hi and welcome to the forums.

Not sure. The limit should be 65536 of course. Could you zip the file and upload it here if it goes to less than 128K? If it is bigger than that you could host it on a free site like MediaFire and post the link here. I will take a look at it.

[kevlar]

I had a similar problem on ooo 3.0.1 and found (for me atleast), that when I removed the contents (quotation mark) of the "text delimiter" option on the text import dialog, then it imported the complete csv file rather than stopping at 2112. In a larger file containing the same data and more it said it had cut it short but actually seemed to import 12689 out of 13406 and did import the last csv line of the file. I had used the -a option of grep for amalgamating csv files which were said to have some binary data.

My file had quotation marks in the first csv, but I couldn't see any difference between the lines where it stopped.

[TheGurkha]

@kevlar: You could host your file on a free site like MediaFire and post the link here.