Errors in multiple import of CSV files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to import many (more than 20K) CSV files using input tool and wildcards. However, I am getting errors/warnings during the import. How can I identify which files error messages are related to?
For example, here is a screen shot of error messages that I am getting.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @oerdem19
Dear, Judging from the prompt information, your all csv file schema is inconsistent, so the fields are missing or concentrated and an error is reported. So you need check file first or change the input option about field .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @oerdem19,
To solve the warning about the closing quote, you have to set line 9 to None: "Ignore delimiters in" instead of quotes.
For the second warning about the field length, increase the field length value in line 7 to the maximum as I did by setting it to 1 million.
Also remember to indicate 'no delimiter' in the input data tool by signifying it with \0 in line 5. You can then split into columns with the Text to columns tool
Find all the details associated with what I said above in screenshot below.
Let me know if there is another issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Rather than the errors, I am trying to figure out which file that has been imported has errors in it.
So, in the picture, it says "170 records are were read from D:\....xxx.csv"
Are the errors under it related to that particular file?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@oerdem19Yes. it's file. then errors. Keep in mind - these are just warnings and TBH depending upon the quantity of data and number of files this stuff happens. If you have a text/description field and a large enough set of data - you'll get these kind of errors.
