{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Catalog Validator","Set List Separator"],"not_rendered":{"images":5,"macros":1,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Catalog Validator","index":0,"n_rows":45,"n_cols":9,"rows_kept":45}
["FedMall Supplier Catalog Format Validator",{"$nulls":7},"About FedMall Supplier Catalog Format Validator"]
[]
[null,1,"Select a .csv file:",{"$nulls":5},"This is an unofficial validator, meant to support effective file creation. Success or failure using this tool does not guarantee FedMall system behavior."]
[]
[null,2,"Click here -->",{"$nulls":5},"For questions about this tool, reach out to Don Tennant at don.tennant@us.ibm.com. Last updated 9-9-2017"]
[]
[null,3,"Monitor progress in the status bar at the bottom of the window. If it gets stuck, hit Ctrl-Break (or Ctrl-Pause)",{"$nulls":5},"Copyright 2017 IBM"]
[]
[{"$nulls":8},"Correct header line for comparison (do not delete/modify):"]
[{"$nulls":3},"<-- Time Started",{"$nulls":4},"Item Master Primary Spec/Item Status Information/Archive^Item Master Primary Spec/Common Information/Commercial and Government Entity Code^Item Master Primary Spec/Common Information/Contract Number^Item Master Primary Spec/Common Information/Part Number^Item Master Primary Spec/Common Information/Part Name^Item Master Primary Spec/Common Information/Federal Supply Class^Item Master Primary Spec/Pricing/Original Unit Price^Item Master Primary Spec/Pricing/Original Unit of Issue^Item Master Primary Spec/Pricing/Quantity Per Unit Pack^Item Master Primary Spec/Common Information/Original Equipment Manufacturer Part Number^Item Master Primary Spec/Common Information/Original Equipment Manufacturer CAGE Code^Item Master Primary Spec/Common Information/Original Equipment Manufacturer Name^Item Master Primary Spec/Short Description^Item Master Primary Spec/Common Information/Days After Receipt of Order^Item Master Primary Spec/Long Description^Item Master Primary Spec/Common Information/Universal Product Code^Item Master Primary Spec/Commercial Information/Environmental Information/Hazardous Material Flag^Item Master Primary Spec/Sale Pricing/Sale Start Date^Item Master Primary Spec/Sale Pricing/Sale End Date^Item Master Primary Spec/Sale Pricing/Sale Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Standard Shipment Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Expedited Shipment Price^Item Master Primary Spec/Commercial Information/Shipping Information/Shipment Level of Service/Next Day Shipment Price^Item Master Primary Spec/Special Properties/Environmentally Preferred/Environmentally Preferred Indicator^Item Master Primary Spec/Special Properties/Environmentally Preferred/Justifying Comment^Item Master Primary Spec/Special Properties/Energy Star/Energy Star Indicator^Item Master Primary Spec/Special Properties/Energy Star/Justifying Comment^Item Master Primary Spec/Special Properties/Made in the USA/Made in the USA Indicator^Item Master Primary Spec/Special Properties/Made in the USA/Justifying Comment^Item Master Primary Spec/Characteristic Information"]
[{"$nulls":3},"<-- Time Ended"]
[{"$nulls":3},"<-- Does the first line (header row) match the format?"]
[{"$nulls":3},"<-- Number of records processed (not including the header row)",{"$nulls":4},"This validator only knows how to validate certain things…for now."]
[{"$nulls":3},"<-- Total number of records in the file (not including the header row)",{"$nulls":4},"This validator knows how to check for:"]
[{"$nulls":3},"<-- Number of errors found in this file (includes header, and may be more than 1 per row)",{"$nulls":4},"Test 1: Are there the right number of columns / delimiters per row?"]
[{"$nulls":8},"Test 2: Does the Archive field contain either a Y or an N?"]
[{"$nulls":8},"Test 3: Is the CAGE code 5 alphanumeric characters?"]
[null,"Line #","Severity","Error Description","Value from file",{"$nulls":3},"Test 4: Is the Contract Number 1-20 alphanumeric characters (or MarketPlace)?"]
[{"$nulls":8},"Test 5: Is the Part Number present and 1-80 characters (alphanumeric + hyphen)?"]
[{"$nulls":8},"Test 6: Is the Part Name present and free of bad characters?"]
[{"$nulls":8},"Test 7: Is the PSC present and 4 alphanumeric characters?"]
[{"$nulls":8},"Test 8: Is the Price present, numeric, and without a dollar sign, and no more than 2 decimal places?"]
[{"$nulls":8},"Test 9: Is the Unit of Issue present and 1 or 2 alphanumeric characters?"]
[{"$nulls":8},"Test 10: Is QUP present and numeric?"]
[{"$nulls":8},"Test 11: Is OEM Part Number present and free of bad characters?"]
[{"$nulls":8},"Test 12: Is OEM CAGE Code (if provided) 5 alphanumeric characters?"]
[{"$nulls":8},"Test 13: Is OEM Name present and free of bad characters?"]
[{"$nulls":8},"Test 14: Is Description present and free of (select) non-printable characters?"]
[{"$nulls":8},"Test 15: Is Days ARO present and numeric?"]
[{"$nulls":8},"Test 16: Is Expanded description present and free of (select) non-printable characters?"]
[{"$nulls":8},"Test 17: Is UPC (if provided) present, numeric, and max length 12?"]
[{"$nulls":8},"Test 18: Is the HAZMAT Flag (if provided) a Y or an N?"]
[{"$nulls":8},"Test 19: Is the Sale Start Date (if provided) formatted YYYY-MM-DD?"]
[{"$nulls":8},"Test 20: Is the Sale End Date (if provided) formatted YYYY-MM-DD?"]
[{"$nulls":8},"Test 21: Is the Sale Price (if provided) numeric without a dollar sign, and no more than 2 decimal places?"]
[{"$nulls":8},"Test 22: Is the Standard Shipment Price (if provided) numeric without a dollar sign, and no more than 2 decimal places?"]
[{"$nulls":8},"Test 23: Is the Expedited Shipment Price (if provided) numeric without a dollar sign, and no more than 2 decimal places?"]
[{"$nulls":8},"Test 24: Is the Next Day Shipment Price (if provided) numeric without a dollar sign, and no more than 2 decimal places?"]
[{"$nulls":8},"Test 25: Is the Env Pref Flag (if provided) a Y or an N?"]
[{"$nulls":8},"Test 26: Is the Env Pref Comment provided if and only if the flag is Y, and free of invalid characters?"]
[{"$nulls":8},"Test 27: Is the Energy Star Flag (if provided) a Y or an N?"]
[{"$nulls":8},"Test 28: Is the Energy Star Comment provided if and only if the flag is Y, and free of invalid characters?"]
[{"$nulls":8},"Test 29: Is the Made in USA Flag (if provided) a Y or an N?"]
[{"$nulls":8},"Test 30: Is the Made in USA Comment provided if and only if the flag is Y, and free of invalid characters?"]
[{"$nulls":8},"Test 31: Is the Characteristic Information (if provided), well formed, and free of invalid characters?"]

{"sheet":"Set List Separator","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[12,1,12,3]]}
[]
[]
[null,"This is the list separator as shown in your Regional Settings -->",","]
[]
[null,"The Windows default is comma; use this when not processing FedMall .csv catalogs."]
[]
[null,"For FedMall .csv catalogs, you can set the separator to a caret."]
[]
[null,"For file exports, you can set the separator to a pipe."]
[]
[]
[]
[null,"Use the buttons above as an alternative to manually changing the delimiter in Regional Settings. This can make viewing the raw .csv files easier. \n\nNote, however, that the \"Catalog Validator\" will work just fine regardless of what value you set here. This tool is provided here for convenience and is not related to the Catalog Validator."]