01. Overview
The Notes to ASCII Task type can create Comma Separated Value (CSV), fixed length or EDI exports from Notes.
02. Sample Uses
02.01. Use the EDI export to create a file that a non-ODBC compliant system can read. This format lists every field and its content:
INFOMANNUMBER:00034894
STATUS:OPEN
CLOSEDATE:07/29/94
TIMECLOSED:09:00
CHANGECONTROLNO:1234ABC
END
02.02. Create a CSV file for an external user or customer, with whom you do not have a direct ODBC connection.
03. Task Specifics
03.01. Data Mover creates a CSV format the Notes does not support.
03.02. Structured text exports are useful for handling large text fields or rich text fields of over 255 bytes. This Export looks similar to a report, and is limited to 80 characters wide before it word wraps.
03.03. You must list fields for export. Other choices select all fields if none are listed (see Notes to Notes). However, as ASCII file formats are very structured, the Data Mover needs to know what data will be exported.
03.04. Subselect the Notes file for only certain Notes by using a View. This will reduce the Export to only certain records.
04. Task Reference - ASCII formats supported.
04.01. Comma Delimited
"Boston General Hospital","BGH1",20000
"Boston General Hospital","BGH2",30000
"Boston General Hospital","BGH3",4000
"Boston General Hospital","BGH4",6000
"Douglas Medical Group","DMG1",34
"Douglas Medical Group","DMG2",345
"Douglas Medical Group","DMG3",45
"Douglas Medical Group","DMG4",4000
"Imaging Associates","IA1",1000 |
04.02. Length Defined
JOHN RSMITH Director of Sales Hospital Products Eastern
SUSAN AJOHNSON Field Sales Medical Supplies Western
KATHY GAPPLEBEE Regional Sales Manager Medical Supplies Western
DONNA TWALTERS Western Area Sales Manager Hospital Products Western |
04.03. EDI
INFOMANNUMBER : 00034894
STATUS : OPEN
DATEOPENED : 07/29/94
TIMEOPENED : 09:00
PROBLEMNOTES : DESCRIPTION
DESCRIPTION
DESCRIPTION
DESCRIPTION
DESCRIPTION
END |
|