GENERIC DATA IMPORT FILE SPEC
Filename: RANGE.INF
Type : Comma Delimited
This file contains the Season Name to be selected by the user when viewing and/or importing the range and the Unique Season descriptor that will be used as a file name to store the data for the Selected Season.
FieldnameTypeLengthDecimalExample
Unique SeasonA8SUMM99
Season NameA40???? CLOTHING SUMMER ’99
Month/Year first del A 1019990402
The following files contain the department, sub department, product and or category names and associated link codes to be used when setting up internal links prior to imports. As system structures may vary from retailer to retailer this provides the ability to link to most variations and once configured provide a seamless import.
Filename: DEPART.TBL
Type : Comma Delimited
FieldnameTypeLengthDecimalExample
Depart()A10SURF
Link CodeA2C
Filename: SUBDEPT.TBL
Type : Comma Delimited
FieldnameTypeLengthDecimalExample
Subdep()A10SURF
Link CodeA2C
Filename: PRODUCT.TBL
Type : Comma Delimited
FieldnameTypeLengthDecimalExample
Product()A10MENS/UNISEX/GENERIC
Link CodeA2MG
Filename: CATEGORY.TBL
Type : Comma Delimited
FieldnameTypeLengthDecimalExample
Product()A10WALKSHOR
Link CodeA2SH
Filename: ????STYL.TXT
Type : Comma Delimited
This Structure contains all data relevant to importing styles either directly into Osipos or via import jump tables as well as the auto generating the Purchase Orders.
FieldnameTypeLengthDecimalExample
Style CodeA108WFBM
DescriptionA25BEDFORD MEXICAN SHORT
Short ColourA3ASS
Full ColourA20ASSORTED
SizeA3XL
W/S Cost AU$N8230.00
Retail AU$N8259.95
W/S Cost NZ$N8240.00
Retail NZ$N8274.95
Barcode #1A139999999999999
Barcode #2A139999999999999
DepartmentA2C
Sub-departmentA2N/A
Product TypeA2MG
CategoryA2SW
Season FlagA3S99
Pack IDA324B
Pack QuantityA34
Valid MonthsA12NNNNNNYYYYNN
Account #A10STARS
Purchase Order# A1010990
Date OrderedD1001/07/98
Delivery DateD1001/10/98
Order QuantityN536
Tax RateA620.00
Bundle QuantityA324
Minimum OrderA312
DummyA3
DummyA10
DummyA 3
Valid Months for Orders Where a Y or N is indicates a valid month
Ie:
JFMAPJJASOND
NNNNNNYYYYNN
5
SURF
C
GIRLS
G
ACCESSORIES
A
WETSUITS
W
MOUNTAIN
S
SUBDEPART.TBL CONTENTS
1
N/A
N/A
PRODUCT.TBL CONTENTS
05
MEN/UNI/GEN
MG
BOYS
BY
LADIES
LA
GIRLS
GL
KIDS
KD
CATEGORY.TBL CONTENTS
39
BOARDSHO
SB
WALKSHOR
SH
PANT/JEAN
PA
TRAKPANT
TP
POLOS
TO
BASIC TE
TB
FASH TEE
TF
TANK TOP
TT
FASH TOP
JF
SHIRT
TS
KNIT/JUMP
JK
PP FLEECE
JW
JACKETS
JJ
DRESSES
GD
SKIRTS
GR
1PC SWIM
G1
2PC SWIM
G2
HAT/CAP/BEAN
XH
SOCKS
XS
SNOWPANT
NP
SNOWSUIT
NS
SNOW LAY
NL
SUNGLASS
GL
WATCHES
WA / WATCHBND
WD
CARRY BAGS
BC
BACKPACK
BP
BOARDBAG
BB
BRIEFCAS
BR
WALLET
BW
JEWELERY
JE
VIDEOS
VI
STEAMERS
SM
SPRINGSU
SP
RASHVEST
VR
VEST/SHO
VS
WATERSKI
WK
G/HOOD/B
XG
MISC
XA