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

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?

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.

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.

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.

 

That worked Comment.

Thank you.

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