When you give us your account number, we will generate several data files (same data in different formats) for you to choose from to import your data into your computer system.  We prefer to email this data to you for expediency.  Though our prices change very rarely, this process is automated and you can receive your data by email within minutes of your request.

To support computers from Main Frames to PC's, we send these file types:
NOTE: Each file contains the "same data" in different file formats

• .DBF dBase/FoxPro (Excel compatible) w/headers
• .CSV Comma Delimited fields
• .DEL Comma & Quote Delimited fields
• .FIX Fixed Width fields
• .DIB Fixed Width fields for DoItBest CS2000 systems (V. 08/07/06)

The support files we send are:

• Abbrev.TXT Text File – Documentation of abbreviations used in the Item descriptions
• Pric2006.PDF Adobe Acrobat - Entire printable Price List
• ReadMe.PDF Adobe Acrobat – This documentation file
• PricCods.PDF Adobe Acrobat - Current pricing for coded products (Coded products are products that have 3-digit codes printed on the labels instead of actual prices because of cost fluctuations.)

File Descriptions:  All data files include the following columns of data: (Except *.DIB files)

• Part # - Our Noble Wire part number
• Item Description - A long description of the part number
• Label Descript. #1 - 1st Description line on labels
• Label Descript. #2 - 2nd Description line on labels
• UPC # - The UPC number
• Pieces - The Pieces / package
• Price - The Retail Price / package
• Cost - Your Cost / package

The *.DBF files do contain headers since most users would use Excel to open them. However each column width may need to be adjusted wider to display all the column data.

The *.CSV files will not contain column headers. Headers would harm an import into most systems (ie: headers would import as real data).
IMPORTANT: If you import this file into Excel, it will mistake part numbers like “0002” as a number “2”. Also, the UPC field will open in scientific notation and must be re-formatted from type “General” to type “Number” and then remove the decimal value “.00”

The *.DEL files will not contain column headers. Headers would harm an import into most systems (ie: headers would import as real data). Each text column will be within quotes (ie: “Part No ABC”) and each column will be separated by commas (ie: “Part #”, 1234, “Pieces”, 4.90). The only difference between this and a *.CSV file is the text fields have quotes around them to preserve the “text field” characteristic.

The *.FIX files will not contain column headers. Headers would harm an import into most systems (ie: headers would import as real data). Each column is an exact width with no space between columns. The import process is expected to import each line and cut them into the necessary columns. The column widths are: Part # (Chr 12), Item (Chr 38), Desc1 (Chr 20) , Desc2 (Chr 20), UPC# (Chr 12), Pieces (Chr 13), Price (Num 7), Cost (Num 7).