Design Manager
Knowledge Base Article
|
Title/Subject: |
.SIF file
specification |
|
Category: |
Design Manager Professional 7.0 |
|
Type: |
Info. |
|
Last Reviewed: |
Tuesday, December 07, 2010 |
|
Article ID: |
10000258 |
Header (one per file):
SF=<Specification File-Cross Reference>
ST=<Specification Title>
Records (repeat for each item in file):
PN=<Product Number>
PD=<Product Description>
MC=<Manufacturer (Vendor) Code (up to 5 chars.)>
TG=<Side mark>
QT=<Quantity>
PL=<List Price>
S-, S%=<Discount Percentage,
i.e.: Sell Price = PL – (PL * S- * 0.01)>
P%, B%=<Purchase/Buy Percentage,
i.e.: Purchase Cost = PL – (PL * P% * 0.01)>
ON=<Option Number>
OD=<Option Description>
AN=<Attribute Number>
AD=<Attribute Description>
PV=<Product Picture - Path and Filename of a Windows
Bitmap or TIF file>
DXSC=<a valid Design Manager Sales Category>
DXBD=<Item budget amount
DXLC=<location code>
DXLN=<location name>
Notes:
- Standard
SIF files (i.e. from Giza™, CAP, etc.) are designed to be for a single
project only. Either SF or ST is
required – Both may exist but at least one has to be present. ST is displayed to the user when they
select the file for import; if ST is not present then SF is
displayed. It is a good idea to set
ST equal to the name of the Project so the Designer importing the SIF can
select the proper Design Manager destination Project.
- PN,
PD, MC, QT, and PL are required.
The rest are optional. ON
and OD must be paired together, AN and AD must be
paired together. PN must come
before all other types as it designates the beginning of a new item, after
PN the order does not matter (except that ON-OD, AN-AD, DXSN-DXSD must be
paired). When using PV to import a
picture, the default directory of the .SIF file will be assumed (i.e.: if
just a filename is specified then the program will assume that the file exists
in the same directory as the .SIF file).
- MC is an up
to five-character alphanumeric. MC
is the manufacturer code of the party that sends the bill. For example, if the merchandise is from
many vendors, but the sender of the SIF files bills the client for all
merchandise, then MC should be the same for all items—that is, a
five-character acronym for the sender.
See #7 below.
- ON
and OD are meant to be any kind if additional info that is not normally
part of the product number or description, such as color or size.
- Attributes
(AN and AD) can be any kind of notes that go
along with the item. It might be a
good idea to include an attribute with the original vendor in it, since
the MC entry may be the same if the sender bills the client.
- No
entries can contain an embedded CRLF, as this is the record terminator.
- Four
character acronyms are not part of the normal SIF file format. They begin with DX (Design Manager
Extension) to allow the creator of the SIF file send additional
information specific to Design Manager.
All DX entries are optional.
- DXSC, if
present, must be a valid Design Manager Sales Category Code that exists in
the Design Manager Sales Category Glossary. If the code is not found then the code entered
by the user on the import window will be used.
- DXBD
is an amount placed in the budget field on the line item (found on the
Pricing Tab of the Item Window).
- DXLC, if
present, must be a valid Design Manager Location Code that exists in the Design
Manager Location Glossary. If the
code is not found then the code entered by the user on the import window
will be used. If the code is not
found and DXLN is used in combination with DXLC, then a new Location entry
will be created for the project.
Sample SIF File (as displayed in a program such as Notepad):
SF=Generic SIF;SIF-User
ST=Accessories for receptionist
workstation
PN=AKP2500-PA1821-AMP
DXTN=876776
MC=UDO
DXPO=100032
PD=Keyboard drawer with mouse pad
QT=2.000
PL=155.00
S-=0.00
ON=B
OD=Black
PN=BSE29
MC=UDO
PD=Side Support Bracket, for 29"h
Work surface (1 pair)
QT=2.000
PL=33.00
S-=70.00
ON=G
OD=Grey