Export Wizard - database to flat file
Copyright © 2000, William Weiland
Overview
This module will export data to a flat file report from any of your Miva Merchant databases. You can have several pre-saved reports. Their structure will be in a file called /exwizard/reports.tbl in your data directory once you save your first report.
Setup
1) In admin, click Add Modules
2) Click the file upload button
3) Browse to find the file on your hard drive and upload
4) Click Add to add it to the domain

Usage
1) In admin, click on Stores
2) Click the image to the left of your store name
3) Click the image to the left of Utilities under your store
4) Click the image to the left of Export Data
5) Click on the link to this module
6) Enter the database and destination file. Most of the databases are in your store directory so you just put the name of the database. If the database you want is in a subdirectory, you might put something like customer/orderhx.dbf for the order history database. You can also store your completed reports in a different subdirectory if you've created a subdirectory beforehand for report storage.
7) Select a delimiter, the Pipe is best in most cases
8) Select Next
9) Set the order you want the fields exported. If you remove a number, that field won't be included. You do not have to renumber them starting with 1. The module sorts the order number/field combinations.
10) If you want to save the report structure for use again (so that you can skip the field numbering step), enter a report name and description.
11) Select Export
12) When you use the wizard again, pre-saved reports are available for selection. If you select a pre-saved report you do not need to fill in the database origin and destination or delimiter. That is done from the pre-saved report format.