Understanding FME error? The Next CEO of Stack OverflowFME Server WorkspaceConvert CSV files into OSM with FMEFME error - failed to validate FME worker licence keyLineJoiner in FMECalculate area with FMEHow to queue FME output on the same workspace?FME autocad to csvSQL Query in FMEFME Error with class extensionsFME Timer function?
Is HostGator storing my password in plaintext?
Is it okay to store user locations?
Grabbing quick drinks
How to Reset Passwords on Multiple Websites Easily?
If I blow insulation everywhere in my attic except the door trap, will heat escape through it?
When airplanes disconnect from a tanker during air to air refueling, why do they bank so sharply to the right?
Customer Requests (Sometimes) Drive Me Bonkers!
If the heap is initialized for security, then why is the stack uninitialized?
How do I construct this japanese bowl?
What does this shorthand mean?
Does the Brexit deal have to be agreed by both Houses?
Why do remote companies require working in the US?
How to be diplomatic in refusing to write code that breaches the privacy of our users
How should I support this large drywall patch?
What do "high sea" and "carry" mean in this sentence?
How do spells that require an ability check vs. the caster's spell save DC work?
Can I equip Skullclamp on a creature I am sacrificing?
Only print output after finding pattern
How easy is it to start Magic from scratch?
How can I quit an app using Terminal?
How to safely derail a train during transit?
Natural language into sentence logic
Can the Reverse Gravity spell affect the Meteor Swarm spell?
Why here is plural "We went to the movies last night."
Understanding FME error?
The Next CEO of Stack OverflowFME Server WorkspaceConvert CSV files into OSM with FMEFME error - failed to validate FME worker licence keyLineJoiner in FMECalculate area with FMEHow to queue FME output on the same workspace?FME autocad to csvSQL Query in FMEFME Error with class extensionsFME Timer function?
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 ?
csv fme
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
add a comment |
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 ?
csv fme
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
1
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 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.
– DAAF-Guadeloupe
Feb 5 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.
– Mark Ireland
Feb 5 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.
– Mark Ireland
Feb 5 at 19:43
add a comment |
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 ?
csv fme
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
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 ?
csv fme
csv fme
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781245
53.8k1781245
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
916
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
1
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 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.
– DAAF-Guadeloupe
Feb 5 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.
– Mark Ireland
Feb 5 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.
– Mark Ireland
Feb 5 at 19:43
add a comment |
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
1
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 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.
– DAAF-Guadeloupe
Feb 5 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.
– Mark Ireland
Feb 5 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.
– Mark Ireland
Feb 5 at 19:43
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
1
1
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 at 19:02
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 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.
– DAAF-Guadeloupe
Feb 5 at 19:22
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.
– DAAF-Guadeloupe
Feb 5 at 19:22
1
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.
– Mark Ireland
Feb 5 at 19:37
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.
– Mark Ireland
Feb 5 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.
– Mark Ireland
Feb 5 at 19:43
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.
– Mark Ireland
Feb 5 at 19:43
add a comment |
1 Answer
1
active
oldest
votes
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.
answered yesterday
samsam
114
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f311139%2funderstanding-fme-error%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered yesterday
samsam
114
add a comment |
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.
answered yesterday
samsam
114
add a comment |
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.
answered yesterday
samsam
114
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.
answered yesterday
samsam
114
edited yesterday
answered yesterday
samsam
114
answered yesterday
samsam
114
answered yesterday
samsam
114
114
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f311139%2funderstanding-fme-error%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
can you give an example of the 'treatment' csv file? how is the csv generated?
– Mapperz♦
Feb 5 at 18:59
1
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 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.
– DAAF-Guadeloupe
Feb 5 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.
– Mark Ireland
Feb 5 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.
– Mark Ireland
Feb 5 at 19:43