Difference between revisions of "machine data format"

From InCircuit
Jump to: navigation, search
Line 143: Line 143:
  
 
*'''RefDes''' = part reference
 
*'''RefDes''' = part reference
*'''IC-Art#''' = internal material number from article master data (if material number not available, the three "DISTRIB" fields must be filled in)
+
*'''IC-Art#''' = internal material number from article data base (if material number is not available, the three "DISTRIB" fields must be filled in)
 
*'''Value''' = part value with unit (100nF, 470R, 100k, 10M)
 
*'''Value''' = part value with unit (100nF, 470R, 100k, 10M)
 
*'''PartDecal''' = part footprint
 
*'''PartDecal''' = part footprint
*'''Orient.''' = part orientation (90°, 180.33°, 270°, ...) without unit
+
*'''Orient.''' = part orientation (90°, 180.33°, 270°, ...) without unit (point ('''.''') as delimiter)
 
*'''X''' = part X coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point ('''.''') as delimiter)
 
*'''X''' = part X coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point ('''.''') as delimiter)
 
*'''Y''' = part Y coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point ('''.''') as delimiter)
 
*'''Y''' = part Y coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point ('''.''') as delimiter)
 
*'''Seite''' = side for part placement: Oben = top, Unten = bottom
 
*'''Seite''' = side for part placement: Oben = top, Unten = bottom
 
*'''Class''' = part class: SMD = surface mounting, THT = through hole mounting, DNP = do not place, MEC = mechanical parts
 
*'''Class''' = part class: SMD = surface mounting, THT = through hole mounting, DNP = do not place, MEC = mechanical parts
*'''PinCnt''' = the number of single pins if the part is seperatable (to fill out only necessary count of pins)
+
*'''PinCnt''' = the number of single pins if the part is seperatable (number of needed pins)
 
*'''DISTRIB_NAME''' = name of distributor
 
*'''DISTRIB_NAME''' = name of distributor
 
*'''DISTRIB#''' = part order number
 
*'''DISTRIB#''' = part order number
*'''DISTRIB_NPPU''' = part unit price (comma (''',''') as delimiter)
+
*'''DISTRIB_NPPU''' = part unit price in € (comma (''',''') as delimiter)
 +
 
  
 
;'''Format:'''
 
;'''Format:'''
 
:The table must be exported as '''CSV'''-file, delimiter is a (''';''') semicolon.
 
:The table must be exported as '''CSV'''-file, delimiter is a (''';''') semicolon.
:At that, headline is enclosed with two semicolon, following lines with only one (see PAP example).
+
:Furthermore the headline is enclosed with two semicolon, the following lines with only one (see PAP example).
 +
 
  
 
== Download ==
 
== Download ==
 
[[Media:PAP_example.zip| PAP example]]
 
[[Media:PAP_example.zip| PAP example]]

Revision as of 11:22, 26 November 2014

PAP list example

RefDes IC-Art# Value PartDecal Orient. X Y Seite Class PinCnt DISTRIB_NAME DISTRIB# DISTRIB_NPPU
C1 123.456 100nF 0603 0 12.05 14.75 Oben SMD
C2 13pF 0805 90 122.37 18.25 Unten SMD Digikey 1276-2582-1-ND 0,2
D1 LST679 P-LCC-2 180 45.07 33.88 Oben SMD Mouser 720-LST679D1F21Z 0,14
F1 Sicherung Littlefuse 270 12.05 14.75 Oben SMD Farnell 1596915 0,971
IC1 FT232RL SSOP28 45 15.02 19.35 Oben SMD Digikey 768-1007-1-ND 3,63
IC2 456.789 7812 TO220 90 122.00 26.35 Oben THT
R1 470R 0402 270 18.45 114.85 Oben DNP Digikey 311-470LRCT-ND 0,08
J1 789.123 Stiftleiste 40x1 RM2.54 H7.1 STL_10X1_RM2.54_H6.0_THT 270.000 1.050 19.000 Unten THT 10

Description

  • RefDes = part reference
  • IC-Art# = internal material number from article data base (if material number is not available, the three "DISTRIB" fields must be filled in)
  • Value = part value with unit (100nF, 470R, 100k, 10M)
  • PartDecal = part footprint
  • Orient. = part orientation (90°, 180.33°, 270°, ...) without unit (point (.) as delimiter)
  • X = part X coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point (.) as delimiter)
  • Y = part Y coordinate on board, unit millimeter (mm), part centre is point of reference, bottom left corner is point of origin (point (.) as delimiter)
  • Seite = side for part placement: Oben = top, Unten = bottom
  • Class = part class: SMD = surface mounting, THT = through hole mounting, DNP = do not place, MEC = mechanical parts
  • PinCnt = the number of single pins if the part is seperatable (number of needed pins)
  • DISTRIB_NAME = name of distributor
  • DISTRIB# = part order number
  • DISTRIB_NPPU = part unit price in € (comma (,) as delimiter)


Format:
The table must be exported as CSV-file, delimiter is a (;) semicolon.
Furthermore the headline is enclosed with two semicolon, the following lines with only one (see PAP example).


Download

PAP example

Personal tools