CSV exporter is mixing columns

0
I am using the CSV module to create a CSV-file from pre-selected data, using following entities: It creates a CSV file but the order of the columns are mixed (showing columns A, M, N, O, P, B, C, D, E, etc).   Does anyone has an idea how I can correct this, or where to look setting a correct ordering? 
asked
1 answers
0

This is listed as a known bug in the module. The work around to fix the ordering in the documentation, which I have included here.

 

https://marketplace.mendix.com/link/component/108605

 

Create a (non-persistent) entity that reflects your CSV structure (columns). The names of the attributes should be ordered alphabetical in respect to the CSV.

E.g. a CSV having the following contents: ID,Username,FirstName,LastName 1,jdoe,John,Doe

Could have an entity with the following attributes to maintain an alphabetical order:

  • C01_ID
  • C02_Username
  • C03_FirstName
  • C04_LastName

 

I hope this helps.

answered