Export Wizard - database to flat file |
Copyright © 2000, William Weiland |
Overview This module will export data to a flat file report from your Miva Merchant databases. You can have several pre-saved reports. Their structure will be in a file called /export/exwizard_reports.tbl in your data directory once you save your first report. Do not delete that reports table or you will have to recreate your pre-saved reports. You can also email the export file as an attachment. |
|
Setup 1) In admin, click Add Modules 2) Click the file upload button 3) Browse to find the exwizard.mvc file on your hard drive and upload 4) Click Add to add it to the domain 5) Click the + to the left of Utilities under your store 6) Click the + to the left of Export Data 7) Click on the link to this module. Enter the order number and where you purchased the license from. You will also need to supply a license key before you can use the module. This is not the license key you may have received when you purchased the license, as some vendors have their own license system. This license key is obtained directly from Emporium Plus by clicking the link to "Request License Key" in the module's admin screen. 1) enter your order number and where you got it, 2) click Update, 3) then request the key. Make sure the order number, domain, and store code are correctly inserted in the request form. The license key is based on these three elements. If you provided that info, the key will be sent back to you. After entering the key and saving, the module will be available for use in your store. |
|
Usage 1) Click the + to the left of Utilities under your store 2) Click the + to the left of Export Data 3) Click on the link to this module 4) Enter the database name and destination file. Most of the databases are in your store directory so you just put the name of the database, e.g. Products. If the database you want is in a subdirectory, you might put something like CFM_ProdValues for the custom product fields database which is in the CFM subdirectory. If you want to access a mall database, e.g. Modules you would put -Modules. The minus character tells it to go to the mall directory rather than your store directory. 5) Select a delimiter, the Pipe is best in most cases 6) Select Next 7) 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. 8) 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. 9) Select Export 10) 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. 11) If you want the file emailed to you, include the email address in the input provided. Some email servers won't let you have attachments. You'll need to determine that with your host if you don't get the email with the attachment. |