Hi,
When I check my data in FME Data Inspector I have all my rows, but when I write the data to an Excel spreadsheet I have a lot of empty rows and some rows populated.
Does any one face the same situation ?
Thanks.
Jacob
Question
All rows populated in FME data Inspector, but not when written to Excel speadsheet
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+63
How are you viewing the data in the Data Inspector?
- If you are using an Inspector transformer in your workspace you'll get to see the data as it is handled by FME at that point, this may not be the same data that actually ends up in the file, as some formats impose limitations.
- If you use the Redirect to Inspection Application option in the Writers menu you get a closer approximation of your output data but it may still not be the same as what actually gets written to the file.
Those rows that are empty in Excel but filled in Data Inspector, are you noticing anything odd about them? Wrong data types perhaps? Are you getting any error messages in your log?
It would help if you could post your workspace along with a small sample of your data.
How are you viewing the data in the Data Inspector?
- If you are using an Inspector transformer in your workspace you'll get to see the data as it is handled by FME at that point, this may not be the same data that actually ends up in the file, as some formats impose limitations.
- If you use the Redirect to Inspection Application option in the Writers menu you get a closer approximation of your output data but it may still not be the same as what actually gets written to the file.
Those rows that are empty in Excel but filled in Data Inspector, are you noticing anything odd about them? Wrong data types perhaps? Are you getting any error messages in your log?
It would help if you could post your workspace along with a small sample of your data.
I did a writer redirect and I'm getting all the rows populated as I mentioned in my post.
I don't see anything odd about the rows that are not written properly. I getting no error messages.
I have changed for a CSV writer and every rows are there.
I think this is a bug in the software.
Thanks for your help.
+22- Safer
Thanks for your answer,
I did a writer redirect and I'm getting all the rows populated as I mentioned in my post.
I don't see anything odd about the rows that are not written properly. I getting no error messages.
I have changed for a CSV writer and every rows are there.
I think this is a bug in the software.
Thanks for your help.
+10- Contributor
I have had similar issues when I add or remove attribute fields for a spreadsheet within FME. Like if I create a new attribute and such. Last time it happened, I had to delete the original exported data and reconnect the reader before it pulled the data correctly.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.