- Thank you received: 0
Long list problem
- Jamesb
- Topic Author
- Offline
Less
More
11 years 5 months ago #2161
by Jamesb
Long list problem was created by Jamesb
I have a list of usernames and passwords for my classes to access their online homework. When importing the csv file I can't see past 231 entries. That only covers alphabetical surnames up to the letter L. Any suggestions for what the problem might be?
Thanks in advance,
Ben.
Thanks in advance,
Ben.
Please Log in or Create an account to join the conversation.
- bert
- Offline
Less
More
- Thank you received: 749
11 years 5 months ago - 11 years 5 months ago #2162
by bert
Replied by bert on topic Long list problem
Hi Ben,
There shouldn't be a problem with that list ... other than taking a few seconds more than usual to render properly (you'd just have to wait a bit).
I'm guessing there might be some special character that tricks the app into thinking the CSV is actually shorter than it really is.
If you are on a PC or a MAC , I'd suggest you to use LibreOffice ( libreoffice.org ) to open the original CSV file , check that nothing is wrong around rows 230ish and export again to CSV with these settings:
PS: Around 300-350 rows, there is a limited number of columns you're allowed to add before the app runs out of memory, I guess you're using this "class" for reference only, and there will only be a few columns in it.
There shouldn't be a problem with that list ... other than taking a few seconds more than usual to render properly (you'd just have to wait a bit).
I'm guessing there might be some special character that tricks the app into thinking the CSV is actually shorter than it really is.
If you are on a PC or a MAC , I'd suggest you to use LibreOffice ( libreoffice.org ) to open the original CSV file , check that nothing is wrong around rows 230ish and export again to CSV with these settings:
- Character Set Unicode (UTF-8 )
- Field Delimiter , (comma)
- Text delimiter " (double quote)
- 'Save cell content as shown'
PS: Around 300-350 rows, there is a limited number of columns you're allowed to add before the app runs out of memory, I guess you're using this "class" for reference only, and there will only be a few columns in it.
Last edit: 11 years 5 months ago by bert.
Please Log in or Create an account to join the conversation.