Thursday, July 19, 2001


 

 

 

 

 


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


    1. from Main Menu goto F12 REPORTS, F1 ITEMIZED INVENTORY.

    2. 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.

    3. When IBID says SETUP SYSTEM PRINTER? hit F for FORMAT.

    4. In REPORT FORMATER SCREEN, hit F11 LAYOUT.

    5. 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.

    6. 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

    7. when you are done, please note the final WIDTH (in the above suggestion, it is 77)

    8. 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.

    1. to create, type 1 in DATA ID, then TAB to Field Number

    2. hit F7 DISPLAY then highlight a field, hit F11 SELECT.

    3. arrow down to blank line and repeat above step, as needed.

    4. 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

    5. TAB to the top of the screen and type in FORMAT NAME as WEB

    6. type in INPUT FILE as WEB001.RF* (where * is terminal letter).

    7. leave PAGE alone, and leave DATA ID as 1

    8. change REC. LEN. to Width of report (from REPORT FORMATTER) + 2 (ex: 87 + 2 = 89)

    9. 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 |