WatsINFO

Originally posted 6-21-08.

Instructions for ordering monographs using EDIFACT (Electronic Data Interchange For Administration, Commerce, and Transport) from within Millennium Acquisitions.

To access the version of the document including screenshots, see the following files. The text of both documents is included below. Note that changes made on and after 8-7-09 are made only here on the WatsINFO post and not on the Word documents listed below. –DPL

• S > LIBRARY SYSTEMS > EDIFACT > Ordering via EDIFACT – part 1.doc (placing orders)
• S > LIBRARY SYSTEMS > EDIFACT > Ordering via EDIFACT – part 2.doc (sending orders)

Ordering via EDIFACT – part I

The purpose of this document is to provide instructions for ordering monographs using EDIFACT (Electronic Data Interchange For Administration, Commerce, and Transport) from within Millennium Acquisitions. EDIFACT is ISO standard 9735, an international standard for data exchange.

The benefits of using EDIFACT to place orders include:

• Create records in Watsonline before/as the order is placed,
• Offers the ability to assign funds, indicate selectors and insert notify notes, as the order record is created so that it does not need to be revisited after the order is placed,
• Offers enhanced duplicate detection,
• Highlights the possible availability from other vendors as we select bib records from OCLC,
• Does not have time outs as on many vendor web sites so orders can be created when needed,
• Gives us control over when files of records are sent so we do not have to rely on vendors’ schedules for downloading records,
• Uses the same interface (Millennium) to place orders with major vendors, avoiding having to deal with multiple vendor web sites,
• Lets us use Millennium’s keyboard shortcut keys so that we can avoid using the mouse,
• Means that “not-in-database” records do not need to be typed into the vendor’s website,
• Provides the possibility of electronic claiming in the future.

At the present time EDIFACT is available only for: Aux Amateurs, Baker & Taylor, Casalini, East View, Erasmus (both Amsterdam and Paris offices), Harrassowitz, JPT, Puvill Libros, and YBP firm monograph orders. Also available for Harrassowitz standing orders for the MA-STO-MARC account (see this post for info).

Summary of procedure – Part 1 – Creating the order

1. Create or find the order record to be used in Millennium Acquisitions
2. Edit the order record
3. Queue the order.

Step-by step procedure:
Millennium Acquisitions — Under Admin > Settings > New records, adjust your settings to make sure that the box labeled “Queue Purchase Orders for records” is checked and that the appropriate template for Edifact orders from the vendor you are using is available.

1. Create an order record as usual – in all cases use the appropriate EDIFACT order template.
   1. Import a BIB record using Z39.50
      1. Availability from other vendors may show in a 938 field when searching WorldCat via Z39.50 – keep this in mind. (see example)
      2. Watsonline may also be checked to offer another opportunity to check for duplicates.
   2. Attach an order record to an existing BIB
   3. Key in an order record
2. Edit the order record as usual
   1. Edit the FUND, if necessary
   2. Edit VOL, if necessary
   3. Add a selector (s), if necessary
   4. Place a hold, if necessary
   5. Add the volume number in a “i” field, if necessary (field “i” (Volume) will not export to the vendor; it is local use only)
   6. IF THE BIB RECORD IS FOR A MULTI-VOLUME SET OR HAS ISBN’S FOR MULTIPLE EDITIONS USE “ISBN PICK” TO SELECT THE CORRECT ISBN (ISBN PICK IS THE LAST CHOICE IN THE DROP-DOWN MENU UNDER “INSERT FIELD”) (see example)
      1. Note that only one ISBN PICK field is sent to the vendor. If ordering more than one volume but not the entire set, do not use the ISBN PICK field. Instead, use the “v” (Vendor note) field to explain.
      2. If ordering an entire set, use the ISBN PICK field to select the ISBN for the set if available. Otherwise, use the “v” (Vendor note) field to request the entire set.
   7. Use the “v” (Vendor note) field to clarify something with the vendor, especially if there is no ISBN (for example: “Please supply English edition” or “v.10 only”).
      1. Note that only one VENDOR NOTE field is sent to the vendor.
   8. Do not use Note fields except for NOTIFY notes.
   9. Make sure “Queue P.O.” is checked (it should be automatically) and answer “Yes” when asked, ‘Do you want to save changes?’ This will queue the P.O. Be conscious of this step, since there is no immediate indication that the P.O. has been queued afterwards; if you have a doubt, click “Queue P.O.” and save the record again.
3. Repeat steps 1-2 for all titles being ordered.

Ordering via EDIFACT – part 2

The purpose of this document is to provide instructions for transmitting orders for monographs using EDIFACT (Electronic Data Interchange For Administration, Commerce, and Transport) from within Millennium Acquisitions. EDIFACT is ISO standard 9735, an international standard for data exchange.

Millennium authorizations required: 072 (Send orders electronically) and 075 (Print/Send Purchase orders). Setting up vendor records for EDIFACT is documented in the Innovative manual (page #105116) and often on vendor web sites.

Summary of procedure:

1. Open the ‘Send’ mode of Millennium Acquisitions and select “Print/Send orders.”
2. Select “[number] purchase orders to FTP” from the dropdown menu and click the FTP button.
3. Review FTP records in “Order Type” column and delete any marked ‘a’ (approval) or ‘p’ (PCard).
4. FTP all or selected, depending on the situation — you may sort by vendor.
5. Connect to the appropriate vendor’s FTP site.
6. Put the file, using the naming convention prescribed by the vendor.
7. Exit the Send mode and/or Millennium.
8. Viewing EDIFACT-submitted orders in Millennium.

Step-by step procedure:

SENDING THE RECORDS

Transfer the orders to the appropriate vendor via the “Send” mode in Millennium Acquisitions. Open this mode and then follow the steps below for each vendor:

• Aux Amateurs
• Baker & Taylor
• Casalini
• East View
• Erasmus (Amsterdam and Paris)
• Harrassowitz (MA-STO-MARC standing orders info in this post)
• Japan Publications (JPT)
• Kubon and Sagner
• Puvill Libros
• YBP

See below for a Quick reference table for vendor FTP addresses and logins.

Choose ” (total number) PO to FTP” (records can be sorted)

Step-by step procedure for Aux Amateurs:
Follow the procedures in Part I. Then, do the following for Aux Amateurs orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qfaal. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “auxam.wmginfo.com”
   2. Click “Connect”
   3. Use the login / password: metmus / mt1295m and click “OK”
   4. Your FTP file should be listed on the left side as qfaal.edifact
   5. Click “Put” (Aux Amateurs does not require file renaming).
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Aux Amateurs; an email order acknowledgment will follow in the next day or two.

Step-by step procedure for Baker & Taylor:
Follow the procedures in Part I. Then, do the following for Baker & Taylor orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qbtay. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “ftp.baker-taylor.com”
   2. Click “Connect”
   3. Use the login / password: 3531813 / 3531813 and click “OK”
   4. Open the 3531813.in folder
   5. Your FTP file should be listed on the left side as qbtay.edifact.[number]
   6. Click “Put.”
   7. Click “Disconnect” and then “Close.”
   8. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Baker & Taylor.

Step-by step procedure for Casalini:
Follow the procedures in Part I. Then, do the following for Casalini orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qicas. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “ftp.casalini.it”
   2. Click “Connect”
   3. Use the login / password: ediorder / casalini and click “OK”
   4. Your FTP file should be listed on the left side as qicas.edifact
   5. Click “Put” (Casalini does not require file renaming).
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Casalini.

NOTE: As of June 2011, the loading procedure for Casalini approval plan records now incorporates EDIFACT ordering.  Please see this post for details: http://libmma.org/watsinfo/2010/10/26/instructions-for-loading-approval-plan-marc-records/

Step-by step procedure for East View: (Aug. 2009)
Follow the procedures in Part I. Then, do the following for East View orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code quevi. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “ftp.eastview.com”
   2. Click “Connect”
   3. Use the login / password: MET / MMA73009! and click “OK”
   4. Your FTP file should be listed on the left side as quevi.edifact
   5. Click “Put”.
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to East View.

Step-by step procedure for Erasmus:
Follow the procedures in Part I. Then, do the following for Erasmus Amsterdam orders. Use the codes in parentheses for Erasmus Paris. If applicable, you may transfer both Amsterdam and Paris orders at the same time.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qnera (Paris: qfera). You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “ftp.erasmusbooks.nl”
   2. Click “Connect”
   3. Use the login / password: 20595 / 20595TJWL and click “OK”
   4. Your FTP file should be listed on the left side as qnera.edifact (Paris: qfera.edifact)
   5. Click “Put” (Erasmus does not require file renaming).
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Erasmus; an email order acknowledgment will follow in the next day or two.

Step-by step procedure for Harrassowitz:
Follow the procedures in Part 1. Then, do the following for Harrassowitz orders. See this post for info on ordering MA-STO-MARC standing orders via EDIFACT.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode. Select the first Harrassowitz ftp site.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qghar. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it)
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select the first entry for “ftp.harrassowitz.de”
   2. Click “Connect”
   3. Use the login / password: bookedi / bookedi and click “OK”
   4. Your FTP file should be listed on the left side as “qghar.edifact“
   5. Check the “Rename files upon transfer” box on the lower left.
   6. Click “Put” (renaming the file is no longer needed – OK, 12/16/2011))
   7. On the “remote” side of the next dialog box, rename the file using this naming convention:
   8. Rename the file yyyymmdd120000.MA.edi.orders where yyyymmdd is the order date. For example: An order placed on August 27, 2007 would be named: 20070827120000.MA.edi.orders
   9. After renaming the file, click OK.
   10. Click “Disconnect” and then “Close.”
   11. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Harrassowitz; an email order acknowledgment will follow in the next day or two.

Step-by step procedure for Japan Publications Trading Co. (JPT):
Follow the procedures in Part I. Then, do the following for JPT orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qjjpt. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “edi.jptco.co.jp“
   2. Click “Connect”
   3. Use the login / password: jptguest1 / IntmpAxz and click “OK”
   4. Your FTP file should be listed on the left side as qjjpt.edifact
   5. Check the “Rename files upon transfer” box on the lower left.
   6. Click “Put”
   7. On the “remote” side of the next dialog box, rename the file using this naming convention:
   8. Rename the file Order_met_yyyymmdd where yyyymmdd is the order date. For example: An order placed on August 27, 2007 would be named: Order_met_20070827
   9. After renaming the file, click OK.
   10. Click “Disconnect” and then “Close.”
   11. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”

   You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Japan Publications Trading Co.

Step-by step procedure for Kubon and Sagner:

Follow the procedures in Part I. Then, do the following for Kubon & Sagner orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qgkub. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “edi.kubon-sagner.de”
   2. Click “Connect”
   3. Use the login / password: p7748368-edi / pr0Cr!rOHa and click “OK”
   4. Your FTP file should be listed on the left side as qgkub.edifact
   5. Click “Put” (Kubon & Sagner does not require file renaming).
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

 

Step-by step procedure for Puvill Libros:
Follow the procedures in Part I. Then, do the following for Puvill Libros orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code qxpuv. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “212.36.64.35″
   2. Click “Connect”
   3. Use the login / password: fu0031 / 256134 and click “OK”
   4. Your FTP file should be listed on the left side as qxpuv.edifact
   5. Click “Put” (Puvill Libros does not require file renaming).
   6. Click “Disconnect” and then “Close.”
   7. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Puvill Libros.

Step-by step procedure for Worldwide:
Follow the procedures in Part 1. Then, do the following for Worldwide orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code quwor. You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select/Enter ftp.lightlink.com
   2. Click “Connect”
   3. Use the login / password: wwb / dartmout and click “OK”
   4. Your FTP file should be listed on the left side as “quwor.edifact.[system number]“
   5. Check the “Rename files upon transfer” box on the lower left.
   6. Click “Put”
   7. On the “remote” side of the next dialog box, rename the file using this naming convention:
   8. Rename the file quwor.edifact.yymmdd where yymmdd is the order date. For example: An order placed on August 2, 2010 would be named: quwor.edifact.100802
   9. After renaming the file, click OK.
   10. Click “Disconnect” and then “Close.”
   11. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to Worldwide; an email order acknowledgment will follow in the next day or two.

Step-by step procedure for YBP:
Follow the procedures in Part I. Then, do the following for YBP orders.

1. Open Millennium Acquisitions in the “Send” mode.
2. Select the “Print/Send orders” sub-mode.
3. Change the dropdown menu from “… Purchase orders to PRINT” to “… Purchase orders to FTP.” The number of purchase orders to print should equal the number of orders you have queued for EDIFACT-enabled vendors.
   1. Select all orders with the code quyan (or quybp for Shelf-Ready bypass account). You may click the buttons “Limit by vendor” or “Limit by location” if you need to narrow the orders to a particular vendor or location, or you may select the appropriate orders by clicking on each one. Use Ctrl-click (single order selection) or Shift-click (range of orders selection) to select multiple orders from the list.
   2. Confirm the number of orders (if a record has been queued twice, delete it). You may sort by any of the column headers to look for duplicate titles, etc.
4. Click the “FTP” button and confirm whether you are FTPing all or selected orders.
5. In the transfer files dialog box:
   1. Select “ftp.ybp.com”
   2. Click “Connect”
   3. Use the login / password: metmus / P9A3en and click “OK”
   4. Double click the “dropoff” subfolder on the right side. If Edifact files are not placed in the dropoff subfolder, they will not be processed.
   5. Your FTP file should be listed on the left side as quyan.edifact (Bypass - quybp.edifact)
      
   6. Click “Put” (YBP does not require file renaming).
   7. Click “Disconnect” and then “Close.”
   8. Click “Yes” to answer the dialog box question “Ftp completed. Delete processed FTP entries?”
6. You may now “Close” the send mode or click “Up one level” on the left to return to the main Millennium Acquisitions screen.

Orders have been FTPed to YBP; an email order acknowledgment will follow in the next day or two.

Viewing EDIFACT-submitted orders in Millennium.

The ORD TYPE field will read as follows for EDIFACT orders:

• ORD TYPE e EDIFACT

When the order is sent to the vendor via EDIFACT, the date and time are automatically inserted into the order record’s ISBN PICK field in subfield b.

If this information appears in the order record, this order has been submitted to the vendor via EDIFACT (see the example below). If the “order sent” information is not present, the order has not yet been sent.

• ISBN PICK |bOrder sent 11-15-2007 14:32

Quick reference table for vendor FTP host addresses and logins

Vendor (vendor code)	Host address	login	password
Aux Amateurs (qfaal)	auxam.wmginfo.com	metmus	mt1295m
^^Baker & Taylor (qbtay)	ftp.baker-taylor.com	3531813	3531813
Casalini (qicas)	ftp.casalini.it	ediorder	casalini
East View (quevi)	ftp.eastview.com	MET	MMA73009!
*Erasmus (qnera & qfera)	ftp.erasmusbooks.nl	20595	20595TJWL
**Harrassowitz (qghar)	ftp.harrassowitz.de	bookedi	bookedi
***JPT (qjjpt)	edi.jptco.co.jp	jptguest1	IntmpAxz
Kubon & Sagner (qgkub)	edi.kubon-sagner.de	p7748368-edi	pr0Cr!rOHa
Puvill Libros (inactive)	212.36.64.35	fu0031	256134
^Worldwide (quwor)	ftp.lightlink.com	wwb	dartmout
****YBP (quyan) & YBP Shelf-ready bypass (quybp)	ftp.ybp.com	metmus	P9A3en

^^Put Baker & Taylor files in the 3531813.in folder.

*Transfer both qnera and qfera orders using this FTP account.

**Rename Harrassowitz files to yyyymmdd120000.MA.edi.orders format.

***Put JPT files in the “EdiOrder” folder and rename to Order_met_yyyymmdd format.

^Rename Worldwide files to quwor.edifact.yymmdd format.

****Put file in “dropoff” subfolder.  Transfer both quyan and quybp orders using this FTP account.

Fields transmitted via EDIFACT (from Innovative Manual page 102819)

Bib record fields and maximum number of characters:
ISBN (i) — 13  [if ISBN PICK is used in the order record, the ISBN chosen is inserted here]
EDITION (e) — 70
TITLE (t) — 70
AUTHOR (a) — 70
PUBLISHER (p) — 70

Order record fields and maximum number of characters:
ORDER RECORD NO. — 13 (‘.’ and o are transmitted)
COPIES — 15
EPRICE or FOR CURR — 15
FUND — 35
LOCATION — 5
VEN NOTE (v) — 70
[ISBN PICK (b) -- not sent as an ISBN PICK field, but the ISBN used here is sent to the vendor as if it were the Bib record's ISBN field]