![]() |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Import File Layout | Shipping File | Forms | Carrier Codes | Order Import
File Specification This document is the specification of the file structure for orders to be imported into the PSSC database management system using the Enhanced version. The Enhanced version is the same as the base version with 2 additional fields (caddress5 & csan) added. File Type: ASCII text file Field Delimiter: comma Text Delimiter: double quotation (e.g. SHDOME) The import file is a single ASCII text file with both header records (orders) and detail records (line items) included. Each order (header record) shall have its own line followed by separate a detail line for each line item on the order. The detail lines are related to the header records by the invoiceno. Each detail record is also on its own separate line. Header and detail records shall have a carriage return, linefeed (CR-LF) at the end of the line to signify the end of the record. NOTE: If you have no data for a field, you MUST still include an empty placeholder field to maintain field position. A placeholder field needs to be delimited the same as any other field, with a comma to separate it and empty quotes () to represent its data. Fields do not have to contain the maximum field width. The data may be any length less than the Max Width for each field.
The following tables detail the specific field position, widths and data types for both the header and detail records. NOTE: Field position must be maintained. The field name is irrelevant and only used for reference
NOTE: Each detail record MUST relate to a header record on the invoiceno (field 4). The invoiceno is the link between header and detail records.
Example: - Here is a sample file. It has three orders. The first order has two lineitems, the second order has 1 lineitem and the third order has 2. NOTE: All information in example is false. It was created for
demonstration purposes only. "D","7777","1","INVOICE1" "D","9","1","INVOICE1" "D","1039","1","INVOICE2" "D","9","11","INVOICE3" "D","1039","1","INVOICE3" If you are unable to create the import text file in your system you may download an excel template file (available HERE) which you can fill in with your order information and email to your publisher relations representative at PSSC. Contact Publishers Storage and Shipping Corp. to find out your PUB CODE code or any other questions you may have. You can also email Bruce Siart in Massachusetts with any questions or comments regarding these files. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PSSC · 46 Development Road · Fitchburg, MA 01420 · 978-345-2121 · FAX: 978-348-1233 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||