Import Templates

Overview

Select the import icon () from the View Serial Number Templates Screen.

Add an existing serial number template to Serial Number Manager via comma-separated values (CSV) file.

Import Templates

The CSV file must provide the correct series of column headers with related titles. To download an example file, select the SerialNumberTemplatesSample.csv link.

The column head titles must follow the camel case format with no spaces, and all values can have no spaces before or after the commas.

See the Results Table in the Add Template topic for an example of these values in a template.

  • PackagingCodeType - Valid values are CN-RESCODE, GTIN-14, NTIN, and GS1 Company Prefix.
  • PackagingCodeValue - Insert the specific value for the packaging code.
  • ItemDescription - Insert some description text that will be helpful in identifying the template.
  • AssignToID - Insert either General Pool (default) or a company packaging location.
  • FilterValue - Filter value for the packaging code in Product Master Data.
  • ExtensionDigit - Select a value from 0 to 9.
  • TemplateType - Select a template type from: All (default), Auto-Replenished by Other Serial Number Manager, Generated Random List, Generated Sequential List, Generated Sequential Range, Manually Imported List, and Provisioned By Packager.
  • RequestFromID - Select a Serial Number Manager Partner that will provide numbers.
  • NotifyAfterInHours - If no response is received after the hours indicated here (default is 8), TraceLink will send notification (to users who have opted to receive notification).
  • MaximumRequestQuantity - This entry only allows a value up to 500,000.
  • MinThreshold - This required numeric text entry only allows users to enter up to 9 digits.
  • MaxThreshold - This required numerical text entry only allows users to enter up to 9 digits, and only to enter a value between the Minimum Threshold and up to 1,000,000.
  • SerialNumberLength - This value can be between 10 and 20.
  • StartingSerialNumber - This entry only allows between 10 and 20 digits, and the value cannot be changed once serial numbers are issued.
  • UseUpperCaseLetters - Select the use of Upper Case Letters (A-Z).
  • ExcludedUpperCaseLetters - Some letters are excluded by default, because they can easily be confused with other letters or numbers, and you can select other letters to exclude.
  • UseLowerCaseLetters - Select the use of Lower Case Letters (a-z).
  • ExcludedLowerCaseLetters - Some letters are excluded by default, because they can easily be confused with other letters or numbers, and you can select other letters to exclude.
  • Status - Active or Inactive, based on the value for the packaging code in Product Master Data.
  • UniquenessID - Contains either Product Code, Company ID, or Company Location ID.

    If blank, defaults to Packaging Code.

  • UniquenessValue - Contains the specific Product Code value, Company ID value, or Company Location ID value.

    If blank, defaults to Packaging Code.

  • UseCryptoCodes - Valid values are Yes or No. Indicates whether serial numbers must include crypto codes (i.e. encrypted identification numbers) generated by Kazakhstan's, Russia's, Russia BAFS's, or Uzbekistan's Order Management System (OMS).

    Can be set to Yes only if the following conditions are met:

    • The company owns the Kazakhstan Crypto Codes, Russia Crypto Codes, Russia BAFS Crypto Codes, or Uzbekistan Crypto Codes application.
    • PackagingCodeType is GTIN-14.
    • PackagingCodeValue has a Target Market of Kazakhstan, Russia or Uzbekistan in Product Master Data.
    • TemplateType is Auto-Replenished by Other Serial Number Manager or Generated Random List.

      Use Crypto Codes can be selected only if the Kazakhstan Target Market, Russia Target Market for Food Supplement products, or Uzbekistan Target Market has a Production Type of Imported in Product Master Data. A location can Use Crypto Codes for either an Imported or Locally Manufactured product, but not both for Russia pharmaceutical products.

    • SerialNumberLength is 13 (for Generated Random List templates only).

    If UseCryptoCodes is set to Yes, serial numbers provisioned through the template become available to locations (i.e. enter the Unreserved state) only after TraceLink receives their associated crypto codes.

  • PaymentType - Conditionally required if TemplateType is Generated Random List and UseCryptoCodes is Yes. Select how the company pays for crypto codes from: Free, Prepaid, Paid on Utilisation.

  • SerialNumberPrefix - This entry supports when the products with a target market of Russia, product type of Food Supplement, and a production type of Imported have the serial number prefix set to 5 by default.

    When the target market is not Russia, the SerialNumberPrefix must be a maximum of 4 alphanumeric characters and cannot start with zero for GTIN 14 and NTIN packaging codes, and Generated Random List template. It's a non-mandatory field.

Available Actions

  1. Select the Choose File button.

    2. The Choose File to Upload window displays.

  2. Specify a CSV file that contains the templates for serial number generation.
  3. Select the Submit button.

    4. The template uploads and the View Serial Number Templates screen displays.

Error Messages

Error Message Description
The file contains no serial numbers. The file contains a valid header but does not contain 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. Though the file size check is successful, 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.
Invalid file format - header must contain the columns "PackagingCodeType","PackagingCodeValue","ItemDescription","AssignToID","FilterValue","ExtensionDigit","TemplateType","RequestFromID","NotifyAfterInHours","MaximumRequestQuantity", "MinThreshold","MaxThreshold","SerialNumberLength","StartingSerialNumber","UseUpperCaseLetters","ExcludedUpperCaseLetters","UseLowerCaseLetters","ExcludedLowerCaseLetters","Status", "UsePrefix", “PushNumbersWithoutRequest” , “MustRequestWithProdOrderRef” , “SGTIN96Encoding”, “UniquenessID”, “UniquenessValue” and no spaces.” The file header does not contain exactly 25 columns.
The prefix is empty and must be set to 5 for the selected template type. When the target market is Russia, Product Type is Food Supplement, Production Type is Imported in product master data, the SerialNumberPrefix is empty.
The prefix must be set to 5 for the selected template type. When the target market is Russia, Product Type is Food Supplement, Production Type is Imported in product master data, the SerialNumberPrefix [starting serial number] is not set to 5.
The prefix must be a maximum of 4 alphanumeric characters for the selected template type. For Serial Number Prefix, the [starting serial number] contains more than 4 characters.
The prefix cannot start with zero for the selected template type. For Serial Number Prefix, the [starting serial number] is zero.
The prefix must contain alphanumeric characters for the selected template type. For Serial Number Prefix, the [starting serial number] contains characters other than alphanumeric.

Serial Number Prefix cannot contain any of the excluded letters in this template.

 For Serial Number Prefix, the [starting serial number] contains excluded letters designated by the template.
File header is missing a column called [COLUMN NAME] in the [HEADER] column. A column header does not match the expected value. For each row, verify that the required field values are present, and the field values are acceptable.