Before going live with ILLiad, you may want to remove the addresses supplied by default and use addresses from another database or electronic format. This can be done by formatting the addresses in an Excel file and then importing it into the LenderAddresses(ALL) table within the ILLData database. If you are a hosted site, you will format the Excel file but then send that file to Atlas Systems for it to be imported into your database.
Remember that you only want to do this step before going live with ILLiad so that you do not remove any addresses already used during processing. If you run this query after going live, you will lose the link between lending requests and the library who requested them as well as borrowing requests and the supplying library. This will disrupt processing as well as statistics for all those requests.
Note that in a shared server installation, your LenderAddresses table will be named LenderAddressesALL. Inside that table is a set of addresses for each site code (NVTGC). You will need to remove the entries for each site code you wish and then add new entries for each site code using these instructions. The term LenderAddresses in this article is synonymous with LenderAddressesALL for a shared server installation.
The Excel file must have the appropriate fields in it to import into LenderAddresses. Descriptions of each field and its use are in the Reference Guide, but below is a list of all fields in LenderAddresses with any notes about the appropriate value. Fields that are required are starred (*) and those that are strongly recommended are in bold.
| Field | Field Length in chacters | Notes |
| LenderString * | 16 | The symbol for that library. It should be the OCLC or Docline symbol if you receive requests from them over those systems. |
| AddressNumber * | [number] | This should typically be a value of 1. If you have multiple addresses for an OCLC symbol, you can add them in with the same LenderString but an AddressNumber of 2, 3, etc. |
| NVTGC * | 20 | If you are shared server, this should be your site code. If you are single server, this should be Lending. If your table is named LenderAddressesALL, this field is used to separate each view of LenderAddresses for the shared server site codes. |
| LibraryName | 40 | The name of the library |
| Address1 | 80 | The first line of the library address (not library name - generally the institution name) |
| Address2 | 80 | The second line of the library address |
| Address3 | 80 | The third line of the library address |
| Address4 | 80 | The forth line of the library address |
| BAddress1 | 80 | The first line of the billing address (optional if different than shipping address above) |
| BAddress2 | 80 | The second line of the billing address (optional) |
| BAddress3 | 80 | The third line of the billing address (optional) |
| BAddress4 | 80 | The forth line of the billing address (optional) |
| Fax | 15 | The library fax number |
| ArielAddress | 50 | The library Ariel address |
| Phone | 15 | The library phone number |
| PriorityShipping | 3 | This field should be skipped. |
| CopyrightPayer | 3 | Only give a value of "Yes" (case-sensitive) if this library includes copyright fees in their charges. Otherwise, the value can be blank or "No". This only pertains to borrowing requests where you would not want to pay additional copyright on items received from this symbol. |
| BillingExempt | 3 | This field should be skipped. |
| BillingCategory | 50 | Enter the value you wish to assign the library based off of your billing setup. If you do not bill for lending, you can skip this field and leave it blank. |
| LibCopyCharge | 50 | This field is only used for reference so you can store any additional information here. |
| LibLoanCharge | 50 | This field is only used for reference so you can store any additional information here. |
| LibBillingMethod | 50 | This field is only used for reference so you can store any additional information here. |
| Notes | 250 | This field is only used for reference so you can store any additional information here. |
| EFTS | 3 | Values of "Yes" or "No" (case-sensitive). Only set to Yes if that library is a Docline institution that you wish to charge via EFTS. |
| EMailAddress | 50 | The library email address |
| OdysseyIP | 50 | This field should be skipped. It will be auto-populated by ILLiad once you receive article requests from other Odyssey users. |
| OverrideIFM | 3 | This field should be skipped. It is *very* rarely used and only for libraries who send you requests with IFM information but that you wish to bill by an invoice. |
| ISO | 3 | Only fill out this field with a "Yes" value if you have all the ISO ILL information for this library and plan on using ISO ILL. |
| ISOIPAddress | 50 | The ip address of that library if they are using ISO ILL. Otherwise leave blank. |
| ISORequesterId | 50 | The requester id of that library if they are using ISO ILL. Otherwise leave blank. |
| ISOUsername | 50 | This field should be skipped. |
| ISOPassword | 50 | This field should be skipped. |
| WebPassword | 100 | This field should be skipped. You can reset the web password from within the client for any libraries you wish to give access to your Lending web pages. |
| Blocked | 3 | This field should be skipped. |
| TrustedSender | 3 | This field should be skipped. |
| ISOPaymentMethod | 6 | This field should be skipped. |
| DefaultShippingMethod | 50 | This field should be skipped. |
Some helpful hints in adding addresses to your Excel file are below.
