Errors in multiple import of CSV files

Question

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.

apathetichell · Answer

@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.

oerdem19 · Answer

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.

Emmanuel_G · Answer

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.