mfl Posted September 23, 2013 Share Posted September 23, 2013 Hey all, I am trying to export FM data to an excel or CSV file but the result isn't coming out like I would like it to. The data is Program/Style/Color, a program can have multiple styles, styles can have multiple colors. What I want is to have an excel or csv list of the above but what i am getting is... ProgramA - Style1 - Color1 BLANK - Style2 - Color2 BLANK - BLANK - Color2,2 ProgramB - Style1 - Color1 BLANK - BLANK - Color2 The export function is not filling up all the cells. Can this be corrected or is this a FM fail? Thanks Michael Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 23, 2013 Share Posted September 23, 2013 We would need to see your data first to know how to get to that result. Can you show the table view of the found set you are trying to export? Link to comment Share on other sites More sharing options...
Lee Smith Posted September 23, 2013 Share Posted September 23, 2013 GIGO Have you tried to export as a tab file? Could you perhaps have an empty field default of null? Why not attach a copy of your file. Link to comment Share on other sites More sharing options...
comment Posted September 23, 2013 Share Posted September 23, 2013 a program can have multiple styles, styles can have multiple colors. You are obviously exporting from the parent Programs table. To get a fully flat table, export from the grandchild Colors table, including the required fields from Styles and Programs in the export order. Link to comment Share on other sites More sharing options...
mfl Posted September 23, 2013 Author Share Posted September 23, 2013 According to the error message I am not permitted to upload this kind of file. Tried using the advanced and basic uploader but neither will let me. Tried uploading a screen shot but that fails also. Link to comment Share on other sites More sharing options...
mfl Posted September 23, 2013 Author Share Posted September 23, 2013 That worked Comment. Thank you. Link to comment Share on other sites More sharing options...
Lee Smith Posted September 23, 2013 Share Posted September 23, 2013 In the future, your file must be compacted. Link = Here are the steps to upload a file. How to attach a file Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3890 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now