Exporting FM to CSV or excel

[mfl]

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

[Wim Decorte]

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?

[Lee Smith]

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.

[comment]

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.

[mfl]

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.

 

[mfl]

That worked Comment.

Thank you.

[Lee Smith]

In the future, your file must be compacted. Link =  Here are the steps to upload a file. How to attach a file