Difference between revisions of "Polaris sql.properties"

Revision as of 13:50, 10 April 2019

See Extending the Metro server for more information.

 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
 <properties>
    <comment>
      SQL connection settings. MY_SQL or SQL_SERVER
    </comment>
    <entry key="load-dir">logs/Customers</entry>
    <entry key="connector-type">MY_SQL</entry>
    <entry key="host">mysql.epl.ca</entry>
    <entry key="database">Polaris</entry>
    <entry key="username">Patron_creator</entry>
    <entry key="password">***********</entry>
    <entry key="patron-code-id">25</entry>
    <entry key="organization-id">303</entry>
    <entry key="creator-id">1831</entry>
    <entry key="language-id">1</entry>
    <entry key="delivery-option-id">2</entry>
    <entry key="email-format-id">2</entry>
    <entry key="country-id">2</entry>
 Both entries are allowed at the same time. fee-text-label is currently required, but if your ILS version is 6.2 or greater it will be ignored. 
    <entry key="free-text-label">Home</entry> '''// this has been changed to AddressLabelID in Polaris 6.2. See next line.'''
    '''<entry key="conformance">Polaris 6.2</entry> // (Optional) in fact the application checks the string ends with 6.2 '''
    '''<entry key="address-label-id">1</entry> // (Optional) and translates to "Home" in the AddressesID table''' 
    <entry key="user-1">Not in the List</entry>
    <entry key="user-2">NULL</entry>    // Case insensitive
    <entry key="user-3">null</entry>
    <entry key="user-4">(none)</entry>  // literally "(none)" will be added  to this category.
    <entry key="user-5">(none)</entry>
 </properties>