Import List
Overview

Select the Import List link in the View Serial Number Templates screen.

For China EDMC and AI(00) serial numbers, upload up to 4 million values. For AI(01)+(21) serial numbers, upload up to 2.7 million values.
Template Information

-
- Packaging codes are numeric values that correspond to the packaging of a particular product (e.g. bottle of 100, blister-pack of 25, etc.). Displays the Packaging Code of the template. If Nordic/National Trade Item Number. (NTIN) is selected, this is a type-ahead field that shows NTIN packaging codes from Master Data (existing codes do not appear).
-
- A written description of the Packaging Code. Displays one of the following:
-
Packaging Codes with English Descriptions display.
- Packaging Codes without English descriptions display the written description from the first language code (in alphabetical order) in that language. For example, if the first language code in Master Data is Spanish, the written description displays in Spanish.
-
Serial numbers assigned to the General Pool can be exchange with multiple packaging locations.
- The packaging location that the serial numbers are assigned to. -
- These attributes contain additional information relating to the serial numbers. The attributes vary according to the packaging code.
- For GTIN-14, the (GS1) Company Prefix and Filter Value display on 2 lines.
- For NTIN, dashes (--) display.
- For GS1 Company Prefix, the Filter Value and Extension Digit display on 2 lines.
- For CN-ResCode, the CN-Subtype and Code Version display on 2 lines.
-
- The encoding type options are one of the following:
- AI(01)+AI(21) - Indicates a 14-digit Global Trade Item Number that identifies a shipping container. (GTIN-14) serial number (14 digits) or a (20 digit serial number),
- AI(00) - Indicates an 14-digit Global Trade Item Number that identifies a shipping container.Serial Shipping Container Code (SSCC) serial number 18 digits long.
- CN-EDMC - Indicates an Electronic Drug-Monitoring Code (20-digit serial number) for China.

Packaging Code | CN-RESCODE 10533 | Packaging Code Attributes | CN-Subtype:1009401001, Code Version: 88 | |||
Description | ALLERGY MED 90 MG CAPS 30 | Encoding Type | CN-EDMC | |||
Assign Serial Numbers to | General Pool |
Serial Number List

Formatting the CSV
The format of the import file varies according to the type of serial number. For example, in China the Electronic Drug-Monitoring Code (CN-EDMC) format differs for Essential Drug List (EDL) drugs and Non-essential Drug List (non-EDL) drugs.
The following sections describe:
- Differences in each format.
- Validation rules for each format.
- Sample files for each format.
AI(00) Serial Shipping Container Code (SSCC) Serial Number Import Format
The AI(00) serial number file formats contain a header row with serial-number attributes followed by subsequent rows with serial numbers (one per row).
The header row must contain the following elements separated by commas without spaces:
- - This is the GS1 Company Prefix associated with the AI(00) serial number.
- - This is the Filter Value associated with the AI(00) serial number that indicates the packaging level, such as Pallet or Mixed Case.
AI(00) example header row and content:
088202,0
00008820210000002009
00008820210000002016
00008820210000002023
00008820210000002030
00008820210000002047
CN-EDMC Serial Number Import Format for EDL Drugs
The CN-EDMC EDL serial number file formats contain a header row with attributes about the serial numbers, followed by subsequent rows that contain the list of serial numbers, one per row.
The header row must contain the following elements separated by pound signs (#) without spaces:
The Application Code corresponds to the entered in Product Master Data.
- Indicates the package level (e.g. 1, 0).- - Identifies the product within the China Surveillance Code (CN-ResCode) (e.g. 30010, 38815).
- - 10 digit product sub-classification code that distinguishes different preparation and package specifications of the same drug (example: 4001010001).
- (e.g. 1).
- - The serial number component of the first Surveillance Code in the file (7 or 9 digits depending on drug type) (e.g. 000000000, 000322400).
- - The serial number component of the last Surveillance Code in the file (7 or 9 digits depending on drug type) (e.g. 00000499, 000322499).
- - Product code version number that identifies the pack level (e.g. 81, 88).
CN-EDMC EDL example header row and content:
#2#10230#1008721002#1#000000500#000000999#86
86102300000005000364
86102300000005011337
86102300000005021129
86102300000005036363
86102300000005049695
86102300000005050360
86102300000005062851
86102300000005079782
86102300000005089281
86102300000005096779
86102300000005105656
86102300000005112465
AI(01)(21) Serialised Global Trade Item Number [combines a Global Trade Item Number plus a unique serial number] SGTIN Serial Number Import Format
The AI(01)(21) serial number file formats contain a header row with attributes about the serial numbers, followed by subsequent rows containing the list of serial numbers, one per row.
The header row must contain the following element:
- - The GTIN-14 associated with the AI(01)+AI(21) serial number
AI(01)(21) example header row and content:
0882025030220
010088202503022021100000000900
010088202503022021100000000901
010088202503022021100000000902
CN-EDMC Serial Number Import Format for Non-EDL Drugs
The CN-EDMC Non-EDL serial number file formats contain a header row with attributes about the serial numbers, followed by subsequent rows that contain the list of serial numbers, one per row.
The header row must contain the following elements separated by pound signs (#) without spaces:
The Application Code corresponds to the entered in Product Master Data.
- Indicates the package level (example: 1, 0).- - Identifies the product within the China Surveillance Code (example: 30010, 38815).
- - The serial number component of the first Surveillance Code in the file (7 or 9 digits depending on drug type) (example: 000000000, 000322400).
- - The serial number component of the last Surveillance Code in the file (7 or 9 digits depending on drug type) (example: 00000499, 000322499).
- - Product code version number identifying the pack level (example: 81, 88).
CN-EDMC Non-EDL example header row and content:
#0#38815#000000500#000000999#81
81388150000005000364
81388150000005011337
81388150000005021129
81388150000005036363
81388150000005049695
81388150000005050360
81388150000005062851
81388150000005079782
81388150000005089281
81388150000005096779
81388150000005105656
81388150000005112465
- A CSV file containing a list of serial numbers to import
Available Operations


- Select the button.
- Locate the file with the serial numbers.
- Select the
The View Serial Number Templates screen displays with a confirmation message.
Download the list of serial numbers on the View Import History screen.
button.
Error Messages

Error Message | Description |
---|---|
The file contains no serial numbers. | The file contains a valid header but no serial numbers. |
File is not a text file. | The file is a binary file. |
The file could not be uploaded because it exceeds the maximum limit of 104 MB. | The file is greater than 104 MB in size. |
File contains more than 4,000,000 rows. | The file size check succeeds, but TraceLink detects the file has greater than 4 million serial numbers. |
Serial number [serial number] occurs more than once in the file. | Duplicate serial numbers are found within the file. |