File Import Specs
|Top Previous Next|
File Import Specifications for the July Release of SAMS:
•SAMS will require that the import file contain a header line in which the first six characters contain the districts code and that columns 14-17 must be the form year (1011). Columns 7-13 are not edited;
•The import file must end with a line containing only 6 capital letter Xs. XXXXXX The files produced by the DEA always had this as an end of file marker so that incompletely transmitted files could be rejected;
•SAMS will reject any file containing a form and item data record unknown to SAMS (such as deleted accounts) or data records containing invalid numeric data or data which otherwise violates hard edit rules in SAMS (such as project numbers must be at least 6 characters etc.). This is unlike the DEA so vendors must be certain to remove any extraneous records.
•SAMS will display an appropriate message if the file is rejected.
For example for the upcoming year a sample file would look like: