Search

[mbcarr1975]

I need to create a CSV file of all of my suppliers. Is there a way to do this?

[David Johns]

mbcarr,

Currently SuperManager can just export suppliers one at a time.  You can set it up, however, to keep adding them to a file one at a time.

1. Go to "View" | "Program Settings..." and select the "Export Formats" tab
2. Click "Add" to add a new format
3. Create a prototype of how the csv file should be arranged and put it in the box at the bottom.  For example:

Code Select Expand

supplier_name, supplier_contact, supplier_address1, supplier_address2, supplier_city, supplier_state, supplier_zip
For a complete list of all the fields you can export see section 12.1.e of the User's Manual

4. You can optionally tell it you would like a header row and define the header row.
5. Checkmark "Append" so it adds new suppliers to the end of the file
6. You can check "Remember file path" so that you only have to tell it one time where to export the file.
6. Click 'Ok' to save and close the program settings
7. Go to the Suppliers screen
8. Select each supplier one at a time and choose "Actions" | "Export" from the menu and choose the export format you just made.

Thanks,
David

[mbcarr1975]

Thanks! Worked like a charm!