Hazox Issue Tracker : Article #112
MSDS Data Import Format (AS/400)
This article describes the format of the MSDS Import member. For more information on importing, see the article entitled “Importing MSDS Data (AS/400)”.

The first five lines are MSDS ID (@@MSD@@), Language ID (@@CTY@@), Type (@@TYP@@) (T=Template, I=Image), Chemical or Product Name (@@CHN@@), and Manufacturer (@@MNF@@). These should be all UPPER CASE. All are required except Language ID and Type.

The CHN and MNF values will also become INX values (categories 1 and 2).

The @@INX@@ lines must appear, but you do not need to have entries under them. If you put entries here, they must be all UPPER CASE. They serve as additional ways to look up an MSDS. Categories 3 - 7 can be customized, but come supplied as:

3 Chemical Family Name
4 CAS Number
5 DOT Classification
6 NA Number
7 UN Number

You can have multiple MSDS's; @@MSD@@ marks the beginning of an MSDS.

@@MSD@@---------x-- (up to 12 characters)
@@CTY@@----- (optional, up to 5 characters)
@@TYP@@- (optional, up to 1 character)
@@CHN@@---------x---------x---------x---------x---------x---------x (up to 60 characters)
@@MNF@@---------x---------x---------x---------x---------x (up to 50 characters)
@@INX@@01
optional additional entries for Chemical Name index
one per line to 60 characters
@@INX@@02
optional additional entries for Manufacturer Name index
one per line to 60 characters
@@INX@@03
optional entries for index 3, one per line to 60 characters
@@INX@@04
optional entries for index 4, one per line to 60 characters
@@INX@@05
optional entries for index 5, one per line to 60 characters
@@INX@@06
optional entries for index 6, one per line to 60 characters
@@INX@@07
optional entries for index 7, one per line to 60 characters
@@SEC@@The name of the first section, to 73 characters (can be Mixed Case).
The first line of text from the first section, to 78 characters (Mixed Case).
You can include @@STD@@ codes for standard phrases, as well as any other
codes for formulation (@@XXX@@). The following is an example of a Standard
Phrase reference (notice that the ID is in all CAPS):
@@STD@@FIRE001
@@SEC@@Second Section Name
Second Section text, etc.
@@MSD@@The next one...

Updated: 05/09/2001 10:24AM Visited: 141