-
Make the import file a flat ASCII file with .txt as the extension.
-
Place all physical columns on one line, forming a physical record.
-
Separate each TAG and Value with an equal sign ('=').
-
Separate values by placing a pipe (‘|’) between them.
-
Terminate each physical record with a new line character. The new line character is different depending on the platform:
-
UNIX: single line feed character
-
ASCII: code 10
-
Windows: line feed and a carriage return #10+#13
-
For example, one line in such a file might look like this:
POH_PROC_TYPE=I|PO_NUMBER=OPI_001|ORDER_TYPE=PO|SUP_CODE=SUP-100| ……..
The opi_dtd.dtd file on the Smart Materials disk contains the document type definition (dtd) for the XML file. You can use all TAGS that are available in the opi_dtd.dtd file.
In the import file, provide all data that is mandatory in the opi_dtd.dtd file.