Open full view…

import csv hangs with no error message

Wed, 25 Jul 2018 19:08:49 GMT

Windows version 2.3.9. I have a large CSV file to import. When I try to import it and click "Next", the "Import CSV File" dialog hangs and nothing is imported. I can cancel out of the dialog. I have tried : 1. Running from the command line to look for error messages 2. Leaving the dialog up after clicking for 30-40 minutes. There are no error messages. I could use "binary search" to try to find which lines it will accept. That will be very time-consuming. Does anyone have any suggestions on how to find out what lines are causing the import "indigestion". (Thanks in advance.)

Thu, 26 Jul 2018 01:20:14 GMT

Hi, If you send through the file to, then we can probably work out what the issue is (or a smaller subset if you find that it still isn't working) If you do not wish to do this, then I would suggest at least trying to import just the first few lines and see if that works - this will probably then tell you if it is an issue with the way that the file is formatted, or if it is going to be a specific line. You could also see if getting rid of specific columns helps, in case it is a specific item of data that is causing the issue (I assume you have more lines than columns) Jess