Export Customers to a Flat File

With MIVA Merchant you can export customer data to a flat file — a plain-text file containing set types of data separated by a tab or text character. You can edit this file in any text editor or import it into a spreadsheet. Use the data elsewhere or edit it and import the results back into MIVA Merchant.

Export Customer to File

Specify a name for the file where you will export the category information. The default is customers.dat.

You might find it useful to include the date or other detail in the file name like custs-october2007.dat. The file will be saved on the server, under Merchant5/s01/export/filename.dat, where s01 indicates your first store. If you have additional stores the directory will correspond to the store number (s02, s03, etc.).

Export

Select the fields to export.

Delimiter

Specify how each data field in a record will be separated from the next. Tab-delimited flat files are common. You can use any character, a comma or a vertical line ("pipe") character: |. Be aware that if the specified character appears in a customer record, such as the commas in "Fruits, Flowers, and More", it will be interpreted as a break between one field and the next. Choose a character that is not used in any customer data.

If File Exists

Specify how you want the data handled if a file of the same name as that you have specified already exists. Select Append To File to have the newly exported data added on to the end of the existing file. Select Replace File to discard the earlier version and save only the data currently being exported.

When you are satisfied with your selections click Export.

The file containing the exported information will be located in the data directory on your server. If you have a problem finding the directory, contact your hosting service and ask where the data directory is located.