|
Website
Export
IBID
can export inventory data in either RAW ASCII or ASCII
COMMA DELIMITED format.
We
do not support any programs that may index or
run the list on your server.
A: CREATE
A WEB FORMAT IN IBID
- from
Main Menu goto F12 REPORTS, F1 ITEMIZED INVENTORY.
- You
must generate a report to get to the REPORT FORMATER
screen.
- I
suggest you chose a smallish catagory so reports don't
take so long to save to disk or convert to ASCII.
- When
IBID says SETUP SYSTEM PRINTER? hit F
for FORMAT.
- In
REPORT FORMATER SCREEN, hit F11 LAYOUT.
- There
are two segments to screen: HEADINGS, in middle and
SELECTED FIELDS on botton.
- from
HEADINGS you can TAB through your CHOICES
AVAILABLE.
- from
SELECTED FIELDS you can TAB through to
see what your report will contain.
- hit
S to clear the current SELECTED FIELDS area.
- chose
the column heading from HEADINGS area by hitting
ENTER on the first "="
- to
move selection to SELECTED FIELDS, hit ENTER
on the gap following the heading.
- you
may cut and paste entire strings of contiguous column
headings such as ISBN/item, TITLE, AUTHOR, PUBLISHER,
PRICE, BT
- when
you are done, please note the final WIDTH (in the
above suggestion, it is 77)
- hit
ESC (yes, ESC) to REPORT FORMATER then rename
the report format to WEBPAGE
- TAB
to REPORT FILE and name it WEB
- you
may write in a longer description in REPORT TITLE
- output
device should be F for FILE
- Change
Include Title and Include Heading to N;
leave everything else as is.
hit
F1 ADD to save this.
B: CREATING
AN EXPORT FILE FILTER
note:
If your software can handle RAW ASCI input, you may now
copy WEB00001.RFA to your indexing database software.
However, if you need a COMMA DELIMITED file, please read
on.
from MAIN MENU goto F14 NEXT PAGE then F1
INVENTORY then F6 EXPORT DATA.
-
to create, type 1 in DATA ID, then TAB
to Field Number
- hit
F7 DISPLAY then highlight a field, hit F11 SELECT.
- arrow
down to blank line and repeat above step, as needed.
- you
will need to change the information selected back to the
EXPORT DATA screen.
- change
the Field Numbers to be 001, 002, 003, etc
- change
all the Type to be A for ASCII,
especially on List Price
- change
all the Start Positions following the rules below:
-
first position is always 1
- for
line 1 only, add field length to 2
(ex: 10+2=12) to get line 2's start position.
- line
2, add previous number to length
plus one (ex: 12+30+1=43)
- line
N, add previous number to length
plus one
- change
Length on List Price to 8
- change
Output Mask on List Price to slash
dot dot dot dot dot dot slash
- TAB
to the top of the screen and type in FORMAT NAME
as WEB
- type
in INPUT FILE as WEB001.RF* (where * is terminal
letter).
- leave
PAGE alone, and leave DATA ID as 1
- change
REC. LEN. to Width of report (from REPORT
FORMATTER) + 2 (ex: 87 + 2 = 89)
- the
last START POSITION plus last LENGTH plus
2 should equal REC. LENGTH you entered.
Finished
screen should look like this: (be sure to hit F2 UPDATE
before ESCaping)
FORMAT
NAME |
WEB |
|
INPUT
FILE |
WEB001.RFA |
|
PAGE |
1 |
DATA
ID |
1 |
|
REC |
79 |
|
|
|
FIELD
NAME |
FIELD
DESCRIPTION |
TYPE |
START
POS. |
LENGTH |
OUTPUT
MASK |
001 |
ISBN/Item |
A |
1 |
13 |
/........../ |
002 |
Title |
A |
15 |
40 |
/............................/ |
003 |
Author |
A |
56 |
15 |
/............./ |
004 |
Publisher |
A |
71 |
7 |
/...../ |
005 |
List
Price |
A |
79 |
8 |
/....../ |
note:
You only need to perform this page once; proceed to C:
USING THIS REPORT
C: USING
THIS REPORT
1.
Generate INVENTORY List
-
From MAIN MENU chose F12 REPORTS F1 ITEMIZED INVENTORY
- Chose
your selection criteria (or leave blank), then hit F13
PRINT.
- When
it says SETUP UP SYSTEM PRINTER? chose <F>ORMAT.
2.
SAVE FILE TO HDD
-
In REPORT FORMATTER SCREEN, arrow up to Format
Name.
-
In Format Name, hit F5 NEXT or F6 PRIOR
to find WEBPAGE.
-
Check box in upper right hand corner to be sure it says
REPORT FILE "WEB"
-
Chose F13 PRINT
-
It will now say SET UP FILE WEB001.RF*, chose
<Y>ES.
-
It will ask if you want a MEMO -- say no.
-
It may ask if you want to APPEND -- say no.
-
When finished, say NO to Another Copy? and
ESCape back to MAIN MENU.
note:
If your software can handle RAW ASCI, your report is
done. Copy WEB00001.RFA to your indexing database software.
Otherwise continue to step 3
3.
EXPORT FILE
-
Hit F14 NEXT PAGE, F1 UTILITIES, F6 EXPORT DATA
- type
in the Format Name WEB, then hit F4 to fill
in details of screen.
- Check
to see that Input File is the correct file extension
(MAILM001.FR*).
-
Hit F12 PROCESS -- screen will automatically export
file to WEB.ASC.
- ESCape
back to an IBID prompt.
- You
may now copy this file to your indexing system or server.
- You
may also export your inventory notes fields; create then
save Notes.txt to disk.
Notes.txt
is ISBN and note fields only; you will need to merge this
with webpage.asc.
|
home
| about
us | products
| sales
| support
|
|