When implementing Backbone, you may need to import an existing spreadsheet of POMs to your POM Library. This article provides an easy workflow for this process.
How to format your existing spreadsheet
Before uploading your POMs you will need to make sure the spreadsheet meets our upload requirements.
Ensure that your file is saved as a .CSV file and matches the "Sample Template". The format requires the following column headers:
POM Name
POM Code
Tolerance (+ / -)
Sizes across the columns (S, M, L, XL, etc...)
Sample Size
The following column headers are optional and may be left blank:
How to measure: this will import any entered values. Blanks will import blank.
Critical: this will import any "TRUE" or "t" values as checked checkboxes and "FALSE", or "f" values as unchecked checkboxes. This is not case-sensitive. Blanks will import blank.
Type: this will import any "half" or "h" values as Half, and "full" or "f" values as Full. This is not case-sensitive. Blanks will import blank
For additional tips, check out our article: Size Spec: CSV Import Template
How to upload your CSV and add POMs to the Library
Once the spreadsheet matches the formatting requirements, follow these steps to upload the data and add POMs to your Library.
Create a new Block in your Block Library for all the POMs in your spreadsheet
Once the Block is created, click the 3-dot menu and select "Import from CSV"
Upload your .CSV file. (If you receive an error, see this article for tips)
Once uploaded, select All POMs to bulk edit
Click the [+] Button to export the selected POMs to your POM Library
If one or more POMs already exist in your Library, you will be prompted to decide whether to "Create" or "Skip" these POMs when adding to your Library.
