Please download writeoutputcsv.zip and unzip to the root level of the AccuZIP6 5.0 folder, e.g., C:\Program Files\AccuZIP6 5.0\WriteOutputCsv.fxp
Follow the simple steps below to create a new CSV with your Original Field names and additional fields in Presort Order:
1. Open AccuZIP6 5.0.
2. Use the File|Open List to open your original Input File.
3. Validate and Presort the list.
4. Once the file is presorted, click “Print Labels” from the Print Presort window. This generates the Presort.prt
5. Close the Print Presort window
6. From the Edit menu, choose Command…
7. Click New and give the command a name, e.g., Write New CSV with Original Field Names
8. Press TAB and type the following syntax in the large box:
Code: Select all
=WriteOutputCsv()
10. You Prompt #1 – Locate Original Input CSV with long field names in header
Note: This is the file you opened with Open List
Prompt #2 – Locate Presort.prt inside last Presort Folder
The Presort folder and Presort.prt file were created during the presort
Prompt #3 – Give the new CSV a Name
Note: This is the resulting CSV file that will contain the long file names[/color]
You can also use the Utility Program with parameters to suppress the prompts:
Code: Select all
=WriteOutputCsv("c:\demofile.csv","c:\presort folder\presort.prt","c:\demofile clean.csv")
Code: Select all
=WriteOutputCsv("c:\demofile.csv","","c:\demofile clean.csv")
You can also have the software always use the Current Databases name with a Date Stamp saved to the same folder, like this:
Code: Select all
=WriteOutputCsv("c:\demofile.csv"," c:\presort folder\presort.prt ",FORCEEXT(DBF(),"")+ALLTRIM(STR(YEAR(DATE())))+PADL(ALLTRIM(STR(MONTH(DATE()))),2,"0")+PADL(ALLTRIM(STR(DAY(DATE()))),2,"0"))