A Text File example: Sage Sterling Stock Explosion
Contents
The Match-IT system installs with an example import filter for the Sage Line 50 Stock Explosion report. This filter extracts the bill of materials information. The example is given here along with the package script it generates. Also shown are a few sample ‘donor’ records that were used to create the sample package script.
Filter Script
ISSUE: 1.18
PACKET: Sage Stock Explosion Report
!Input to STREAM: is Sage Stock Explosion report sent to a file
!Output from STREAM: is
! F#1=Assembly stock code
! F#2=Part stock code
! F#3=junk
! F#4=Part quantity
STREAM:1
IGNORE: [F#0] == []
IGNORE: [F#0] << [<12>]
IGNORE: [F#0] << [<27>]
IGNORE: [F#0] << [Date :]
IGNORE: [F#0] << [Page :]
IGNORE: [F#0] << [Printed:]
F#1[22]
GROUP:1 WHEN: [F#0] !< [----]
IGNORE: [F#0] !< [----]
IGNORE: [F#0] !< [' ']
IGNORE: [F#0] << [<12>]
IGNORE: [F#0] << [<27>]
IGNORE: [F#0] << [Date :]
IGNORE: [F#0] << [Page :]
IGNORE: [F#0] << [Printed:]
F#2[22]F#3[77]F#4[8]
ENDGROUP: [F#0] == []
ENDSTREAM:
!Load mch:Material field with Part stock code and get record
LOOKUP:1 IN:mch
FIELDS:Material,ManQty
[S#1:F#2]
!Part stock code read from the input stream
ENDLOOKUP:
RECORD:mcg SEGMENT:Parts
FIELDS:Assembly,Rank,PartName
[F#1]|[R#1]|[F#1]:Part#[R#1]
ENDRECORD:
RECORD:mca SEGMENT:Materials
FIELDS:Component,Rank,Material,Quantity,Length,Width
[F#1],[R#1]|[R#1]|[F#2]|[L#1:F#2,1],[F#4]
![L#1:F#2,1] is the units name from mch:ManQty looked up
ENDRECORD:
ENDPACKET:
Package Script
! Package script created by gxImportFilter
!
! Created: 23/03/97 at 18:51:10
! Filter Script: E:\CLIENTS\BBRIDGE\MATCH_IT\DATA\LEGACY\5_BOM.FIL
! Packet:
! Source CSV: G:\TEMP\TEST.BOM
! Begin At:
! End At:
! Package file: G:\TEMP\TEST.PAK
! CSV Separator: ,
! Quotes: '"`
!Package separator: |
ISSUE: 1.18
IMPORT: FROM:{{{ mcg:Parts:1 TO:}}} AS:mcg
IMPORT: FROM:{{{ mca:Materials:1 TO:}}} AS:mca
END:
{{{ mca:Materials:1
mca:Component,Rank,Material,Quantity,Length,Width
|00244/1,1|1|11-700P-W|Each, 1.00
|00244/1,2|2|SC-UCC11-226-AAR|Each, 1.00
|00696/1,1|1|543-282|Each, 1.00
|00696/1,2|2|554815-1|Each, 1.00
|00696/1,3|3|554831-1|Each, 1.00
|00696/1,4|4|6-700P-W|Each, 1.00
|00696/1,5|5|CW13083PAIR|Metre, 30.00
|00696/1,6|6|H30X30MMBLACK|Each, 1.00
|00714/1,1|1|11-700P-W|Each, 1.00
|00714/1,2|2|SC-UCC11-226-CKO|Each, 1.00
|01205/1,1|1|001677261001|Metre, 15.00
|01205/1,2|2|01205SUBASSY|Each, 1.00
|01205/1,3|3|6-700P-W|Each, 3.00
|01205/1,4|4|65153-001|Each, 2.00
|01205/1,5|5|65155-001|Each, 3.00
|01205/1,6|6|75885-001|Each, 2.00
|01205/1,7|7|ATUM19/6BLACK-L|Metre, 0.10
|01205/1,8|8|BI1006|Each, 6.00
|01205/1,9|9|BI1007|Each, 3.00
|01205/1,10|10|XY80|Metre, 1.57
}}}
{{{ mcg:Parts:1
mcg:Assembly,Rank,PartName
00244/1|1|00244/1:Part#1
00244/1|2|00244/1:Part#2
00696/1|1|00696/1:Part#1
00696/1|2|00696/1:Part#2
00696/1|3|00696/1:Part#3
00696/1|4|00696/1:Part#4
00696/1|5|00696/1:Part#5
00696/1|6|00696/1:Part#6
00714/1|1|00714/1:Part#1
00714/1|2|00714/1:Part#2
01205/1|1|01205/1:Part#1
01205/1|2|01205/1:Part#2
01205/1|3|01205/1:Part#3
01205/1|4|01205/1:Part#4
01205/1|5|01205/1:Part#5
01205/1|6|01205/1:Part#6
01205/1|7|01205/1:Part#7
01205/1|8|01205/1:Part#8
01205/1|9|01205/1:Part#9
01205/1|10|01205/1:Part#10
}}}
Donor Text File
XYZ LIMITED Stock Reports - Stock Explosion Date : 270297
Page : 1
Printed: 19:39 27-02-97
00244/1 50WAY BT226 CABLE ASSY.(Iss.1) Last Cost Price Location Quantity
---------------------------------------------------------------------------------------------
11-700P-W *WHITE PAPER ADHESIVE LABEL 0.01 OFFICE CUPBOARD 1.00
SC-UCC11-226-AAR 226 CAB.ASSY ISSUE 1. (00244) 13.86 1.00
00696/1 CABLE ASSY P/No: 00696 ISSUE 1 Last Cost Price Location Quantity
---------------------------------------------------------------------------------------------
543-282 SLEEVED CABLE GROMMET 0.02 AZ04 1.00
554815-1 CONNECTOR 24WAY BACK/BACK AMP 4.43 AD02 1.00
554831-1 COVER KIT 24WAY BACK/BACK AMP 1.22 AD03 1.00
6-700P-W *WHITE PAPER ADHESIVE LABEL 0.01 OFFICE CUPBOARD 1.00
CW13083PAIR *CW1308 3 PAIR CABLE 0.07 BN01 30.00
H30X30MMBLACK BLACK NEOPRENE SLEEVE 30mmLONG 0.03 AZ03 1.00
00714/1 CABLE ASSY P/No: 00714 ISSUE 1 Last Cost Price Location Quantity
---------------------------------------------------------------------------------------------
11-700P-W *WHITE PAPER ADHESIVE LABEL 0.01 OFFICE CUPBOARD 1.00
SC-UCC11-226-CKO 50WAY CHAMP ASSY.(150Ft) Iss.1 35.57 AA01 1.00
01205/1 CABLE ASSY P/No 01205 ISSUE 1. Last Cost Price Location Quantity
---------------------------------------------------------------------------------------------
001677261001 B/PAN 50x2xAWG26(1)UNS CODE7 3.60 BB03 15.00
01205SUBASSY SUB KIT FOR MERCURY 01205 0.00 1.00
67023-001 3x32 26AWG(1) PIERCE BLOCK 0.38 AG04 1.00
77345-411 3x32 26AWG (1) CONTACT BLOCK 5.50 AG05 1.00
6-700P-W *WHITE PAPER ADHESIVE LABEL 0.01 OFFICE CUPBOARD 3.00
65153-001 32x2 PIERCE BLOCK 0.36 AH04 2.00
65155-001 DIN41612 BLACK UNIVERSAL COVER 0.40 AH02 3.00
75885-001 2x32 (26AWG(1) GOLD CONT BLOCK 8.10 AI04 2.00
ATUM19/6BLACK-L ATUM 19/6mm BLACK H/SHRINK(24M 4.85 BK02 0.10
BI1006 *No.2x3/8"PAN/SLOT 76412-002 0.01 AE01 6.00
BI1007 CABLE TIE PANDUIT SST 1M-M 0.02 AE01 3.00
XY80 8mm PVC BLACK HELLERMAN SLEEVE 0.09 BM04 1.57