1

When I launch a treatment on FME 2018 the following message will appear :

CSV reader: Detected excess data and/or delimiters in addition to the defined schema in line XXXX

Note that the treatment works very well, I am just wondering how I got this message, is there a limit of tuples imposed by FME in the .csv reader ?

5
  • can you give an example of the 'treatment' csv file? how is the csv generated?
    – Mapperz
    Feb 5, 2019 at 18:59
  • 3
    the header needs to match number of fields needs to match the commas and quotes (,'text',) >sometimes there are commas and quotes in the fields themselves that can cause errors reading csv.
    – Mapperz
    Feb 5, 2019 at 19:02
  • Yeah I think this may be caused by the file structure. The file only has one column of which I take substrings to create new attributes with.
    – user107482
    Feb 5, 2019 at 19:22
  • 1
    It sounds like there is a comma in at least one line that is causing FME to think that there are multiple columns in it. If it's just a single like of text, then try the Text File reader instead of CSV. It won't have that issue because it won't try to split up the data. Or - if the data is column-aligned - try the CAT (Column-Aligned Text) reader. Feb 5, 2019 at 19:37
  • To add, my concern would be that the line in question would/could be truncated because of this, so even if the workspace runs to completion, it's something you should probably fix. Feb 5, 2019 at 19:43

1 Answer 1

-1

Can you check your CSV file please? I think that you have something like this A;B;C;D 5;5;5;4;8 The information 8 has no column and that will give you the error mentioned above (not really an error because it is not in red as I think). Be careful because the information 8 will not be written in the output.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.