With MIVA Merchant 5, you can export affiliate information to a flat file, or a plain-text file containing set types of data, separated by a tab or text character. The flat file allows you to view it in any text editor, import it into a spreadsheet, use the data elsewhere, or edit it and import the results back into an eCommerce application if you wish.
Export Affiliates to File
Enter the name of the file to which you will export the affiliate information. The default name is affiliates.dat.
You might find it useful to include the date or other details in the file name, such as affs-EOY-2006.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.).
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, such as a comma, or a vertical line ("pipe") character: |. Note that if the specified character appears in an affiliate's date, such as the comma in "1234 Main Street, Suite B", that will be interpreted as a break between one field and the next. Choose a character that is not used in any affiliate data.
If File Exists
Choose how you want data handled if a file exists with the same name as the file you have specified. Select 'Append To File' to have the newly-exported data added to the end of the existing file. Select 'Replace File' to discard the earlier version and save only the data currently being exported.
Data to Export
Check each box for the type of data that is to be exported. For each type of date, select the specific fields to be exported under each of the corresponding tabs (Affiliates, Earnings, and Payouts).
Click Export at any point after selecting the desired fields on all of the tabs. You can switch between the four tabs on the screen, making selections on each. Click Export from any of the tabs once you are ready to create the flat file.
The file is located in your MIVA Merchant data directory for your domain.
For reference, MIVA Merchant files are located in the following locations:
/var/www/cgi-bin
/var/www/html/mm5/ or /var/www/html/Merchant2
~/htsdata
For more information, please contact our expert technical support team or see: http://docs.mivamerchant.com/en-US/merchant/5/webhelp/export_customers_to_a_flat_file.htm