Uniforms: Import uniforms

If you have lots of uniform inventory and want to quickly input uniform items into Charms, use the Import Uniforms template. 

General import template information

• The template contains several columns. If the column heading font is red, the field is required.
• Do not move, delete, or rename columns.
• Do not change the template name. 
• Do not re-import a template. After an import, if you need to make changes to the data, do that manually in Charms.
• For money fields, do not add currency signs.
• For measurement fields, enter a number. No need to add the word inches or pounds/lbs.
• For date fields, use mm/dd/yyyy format.
• If there is a number in parentheses after the column name, that is the maximum number of characters you can enter for that field.
• If there is a pound sign in parentheses after the column name (#) enter a number in that field.

Import uniforms

Prerequisite

You must have uniform categories set up before you can import uniform information.

1. On the Main Sections menu, click Imports.
2. At the top right, for Select Upload Type, select Import Uniforms.

3. Click 

   

   .

4. Open the CharmsUniformTemplate and save it with the same name. Remember where you saved the template.
5. In the template, fill in the required fields (shown in red) and as many of the other fields as you wish.
   1. (Required) For Category, use the same spelling and case as the category is displayed in Charms.
   2. (Optional) If the item has a barcode, enter that in the Barcode field. If the barcode field is blank, Charms assigns a barcode number.
   3. (Required) For Item Number, you may use any system you want. We recommend using a category abbreviation plus a 4-digit code to help with sorting. For example, if the category is Tux Jacket, you might use TJ-1000.
   4. (Optional) For Condition, enter one of these options: New, Excellent, Good, Fair, or Poor.

6. Return to Charms and click 

   

   .

7. Navigate to your template and select it.
   1. You can click in the Drop Files or Click to Upload area and select your template.
   2. As an alternative, you can drag your template from its location and drop it into the Drop Files or Click to Upload area.

8. Charms uploads the information and if there are no errors, you receive an import successful message. Click 

   

   .

Your uniform information is updated in Charms. To see the new data, open the Uniform Report by Category report, which is found under Main Sections > Uniforms> Reports.

Fix import errors

If there are import errors, Charms displays a failed error message and no records are uploaded.

1. To see the errors, click View Data.

Errors are shown in red so you can easily spot the problem:

2. Go back to your template, correct the errors, and save the template. Remember to use the same template name.

3. Return to Charms, and on the Import Uniform Information page, click 

   

   .

4. Navigate to your template and select it.
   1. You can click in the Drop Files or Click to Upload area, and select your template.
   2. As an alternative, you can drag your template from its location and drop it into the Drop Files or Click to Upload area.
5. Continue this process until the template loads successfully.