Difference between revisions of "Polaris sql.properties"

From MeLibraries Wiki
Jump to: navigation, search
 
Line 20: Line 20:
 
     <entry key="email-format-id">2</entry>
 
     <entry key="email-format-id">2</entry>
 
     <entry key="country-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.  
+
      <!-- 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.'''
+
      <!-- this has been changed to AddressLabelID in Polaris 6.2. See below. -->
     '''<entry key="conformance">Polaris 6.2</entry> // (Optional) in fact the application checks the string ends with 6.2 '''
+
     <entry key="free-text-label">Home</entry>  
     '''<entry key="address-label-id">1</entry> // (Optional) and translates to "Home" in the AddressesID table'''
+
      <!-- Optional tag but required for Polaris 6.2 or greater -->
 +
     <entry key="conformance">Polaris 6.2</entry>
 +
      <!-- Optional tag but required for Polaris 6.2 or greater. File can also have a 'free-text-label' entry as well without issue. -->
 +
     <entry key="address-label-id">1</entry>  
 
     <entry key="user-1">Not in the List</entry>
 
     <entry key="user-1">Not in the List</entry>
 
     <entry key="user-2">NULL</entry>    // Case insensitive
 
     <entry key="user-2">NULL</entry>    // Case insensitive

Latest revision as of 14:55, 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>
       <!-- fee-text-label is currently required, but if your ILS version is 6.2 or greater it will be ignored. -->
       <!-- this has been changed to AddressLabelID in Polaris 6.2. See below. -->
    <entry key="free-text-label">Home</entry> 
       <!-- Optional tag but required for Polaris 6.2 or greater -->
    <entry key="conformance">Polaris 6.2</entry>
       <!-- Optional tag but required for Polaris 6.2 or greater. File can also have a 'free-text-label' entry as well without issue. -->
    <entry key="address-label-id">1</entry> 
    <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>