Logo Tree ® 
The Complete Wholesale Line of  Terminals, Wire and Wiring Devices,  Nationwide
Automotive - Truck - Marine - Farm - Industrial
Made in the U.S.A.
1620 32nd St.
Springfield, OR 97478

(800) 547-4711
FAX (541) 744-1173
Phone (541) 744-0630
Importable Data for your system
 
We generate several data files (same data in different formats) 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.

The updates to the right are going to be available for a couple of months.  After that, they will be taken off line and again made available on request.
   

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

  • XLS Excel file
  • .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
  • PriceSheet.PDF Adobe Acrobat - Entire printable Price List
  • ReadMe.PDF Adobe Acrobat – This documentation file

scriptions:  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).

jis_spc.gif (56 bytes)

Site Map: Home Page | About Us | Policies | Packaging | Assortments | Product Categories | F.A.Q.s
9910 (a) | 9910 (b) | 9915 (a) | 9915 (b) | Variations | 9724-9727 | Toppers | Download: Catalog.PDF (3.7MB)
Product Pages:  01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | Abbreviations

NOBLERegistered Trademark  is  Made in America (whenever possible)    1-800-547-4711
Call for your nearest representative, or more information!
Send Emails to:   Information  |  Orders@NobleWire.com
Copyright 1997-2017, NOBLE Wire & Terminal Corp.   All rights reserved.  Links welcome.

Jurgens Information Services, Inc. (www.JurgensIS.com)