Understanding FME error?FME Server WorkspaceConvert CSV files into OSM with FMEFME error - failed to validate...
Is `x >> pure y` equivalent to `liftM (const y) x`
Purchasing a ticket for someone else in another country?
What is the intuitive meaning of having a linear relationship between the logs of two variables?
Is there a problem with hiding "forgot password" until it's needed?
Is the destination of a commercial flight important for the pilot?
What is the difference between "behavior" and "behaviour"?
How can I get through very long and very dry, but also very useful technical documents when learning a new tool?
Detecting if an element is found inside a container
How did Doctor Strange see the winning outcome in Avengers: Infinity War?
Integer addition + constant, is it a group?
How do we know the LHC results are robust?
Lay out the Carpet
How does buying out courses with grant money work?
What can we do to stop prior company from asking us questions?
Anatomically Correct Strange Women In Ponds Distributing Swords
Sequence of Tenses: Translating the subjunctive
Short story about space worker geeks who zone out by 'listening' to radiation from stars
Implement the Thanos sorting algorithm
Was Spock the First Vulcan in Starfleet?
How can a function with a hole (removable discontinuity) equal a function with no hole?
Customer Requests (Sometimes) Drive Me Bonkers!
Is HostGator storing my password in plaintext?
How to pronounce the slash sign
How do I extract a value from a time formatted value in excel?
Understanding FME error?
FME 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.8k1781244
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.8k1781244
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.8k1781244
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.8k1781244
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781244
asked Feb 5 at 18:50
DAAF-GuadeloupeDAAF-Guadeloupe
916
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781244
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781244
edited Feb 5 at 19:06
PolyGeo♦
53.8k1781244
53.8k1781244
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;B;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)
answered 4 mins ago
samsam
133
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;B;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)
answered 4 mins ago
samsam
133
add a comment |
Can you check your CSV file please? I think that you have something like this
A;B;B;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)
answered 4 mins ago
samsam
133
add a comment |
Can you check your CSV file please? I think that you have something like this
A;B;B;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)
answered 4 mins ago
samsam
133
Can you check your CSV file please? I think that you have something like this
A;B;B;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)
answered 4 mins ago
samsam
133
answered 4 mins ago
samsam
133
answered 4 mins ago
samsam
133
answered 4 mins ago
samsam
133
133
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