I need to create an export CSV file (For Sage 200), from a standard customers table.
All good, easy enough but the sage CSV file requires a lot of additional fields (all blank) that I don't have.
So the CSV will have many extra columns with just no data. e.g 'name','address;,,,,,, etc.
Again I can simply add dummy fields in filemaker with nothing in them an export them but this seems very inefficient.
So is there a way of exporting blanks to pad out a CSV with fields that don't exist in FileMaker?