Client User Guide - PSMA Australia Limited
Contents
1. Database is not ANSI SQL 92 compliant and Import into another database type isn t Microsoft SQL Server For example Microsoft Access is not ANSI compliant Database is not running Please refer to the appropriate database reference manual for instructions on how to start the database User does not have sufficient privileges Ensure the user for the database has the appropriate privileges eg create table insert update etc Unsupported database version You may not be able to load into a database version that is not supported by the LYNX Data Importer Importer will not enable the State Territories The import directory you have specified is invalid checkboxes This could be because e the directory does not include Standard extracts directory the directory does not contain 1ynx files in its sub directories the directory has special characters in the path Changing the default memory settings for the To change the memory settings go the LYNX Data Importer application Importer application directory and edit the file Lynx Data Importer lax Add the parameter lax nl java option additional With the desired memory settings For example to set the LYNX Data Importer memory allowance to a minimum of 200 MB and a maximum of 500 MB lax nl java option additional Xms200M Xmx500M Note If you make the minimum value too high the LYNX Data Importer may not run because the system is unable to assign the required min2. G NAF G NAF FEBRUARY 2010 jJabe roracle thin 8krypto l152l1 kryptodb oracle jdbc driver OracleDriver test test E ACT NSW true PSITIA AUSTRALIA LIMITED Note this example is called from the LYNX Data Importer directory Paths to jar files are relative The script will output a message at the end describing if the import was successful or not It also writes a log file to the directory specified by Log file directory Please ensure you are using the correct JDBC driver for the destination database If your database is different to those supported by the installer then please make sure you change the command line classpath to use the appropriate JDBC driver LYNX Data Importer Version 1 3 Client User Guide Page 10 PSITIA AUSTRALIA LIMITED Database Drivers The LYNX Data Importer uses Java database drivers to communicate with your database The default drivers provided are MySQL mysql connector java 3 0 10 stable bin jar Oracle ojdbcl4 jar SQLServer 2000 msbase jar mssqlserver jar msutil jar SQLServer 2005 jtds 1 2 jar PostgreSQL postole 1 0 0 ar postgis debug 1 O0 0 jar postgresql 8 1 404 jdbc2 jar postgresql 8 1 404 jdbc2ee jar postgresql 8 1 404 jdbc3 jar ODBC Connection sun jdbc odbc JdbcOdbcDriver If you discover that the LYNX Data Importer cannot communicate with your database using these default drivers you will need to supply your own JDBC driver and start th
3. database MySQL Son mysql jdbc Driver Oracle oracle jdbc driver OracleDriver SQL Server 2000 com microsoft jdbc sglserver SQLServerDriver SQL Server 2005 net sourceforge jtds jdbc Driver PostgreSQL 8 1 org postgresql Driver ODBC sun jdbc odbc JdbcOdbcDriver U The name of the database user P The password for the database user This can be ignored if there is no password T F Full import O Overwrite_existing_tables Values are true or false S States territories to be imported separated by comma eg ACT NSW QLD VIC LYNX Data Importer Vedonis Page 9 Client User Guide For example to perform a full import of the states ACT and NSW on an Oracle9i database the following command line would be used java cp 7 lib lynx distribute jar 1 Veber ar waib ourail er jdbc_drivers PostgreSQL8_1 postgis_1_0_0 Jar Njdbc driversNPostgreSQL8 l Mpostgis debug 1 O0 0 jar jdbc_drivers PostgreSQL8_1 postgresql 8 1 404 jdbc2 jar jdbc_drivers PostgreSQL8_1 postgresql 8 1 404 jdbc2ee jar jJdbc_drivers PostgreSQL8_1 postgresgql 8 1 404 jdbc3 jar jdbc_drivers MySQOL mysql connector Jjava 3 0 10 stable bin jar jdbc_drivers Oracle9i ojdbcl14 jar jdbc_drivers SQLServer2000 msbase jar jdbc_drivers SQLServer2000 mssqlserver jar jdbc_drivers SQLServer2000 msutil jar jdbc_drivers SQLServer2005 jtds 1 2 jar au com geometry lynx_distribution importer Importer D
4. is the directory containing the sql files eg G NAF FEBRUARY 2010 States Territories After selecting the Import Directory some all of the States Territories checkboxes will be enabled based on the data available This determines which jurisdiction data will be imported Select at least one Username Password The database user must already exist and have the ability to create tables Host Enter the IP address or name of the server that hosts the database LYNX Data Importer erence Page 7 Client User Guide EJ PSM AUSTRALIA LIMITED TCP Port Defaults to the port value associated with the selected Database Type Only change if necessary Database Identifier Identifier for the database The database must exist on the database server Instance Optional Only enabled when the Database Type of SQL Server 2005 is selected Enter the database instance Re Create Tables Deselect this checkbox if you are appending data to a database that contains existing PSMA data tables eg adding another state s data If selected all previous tables and data will be overwritten with the new data 3 Click the button 4 Click to continue Overwrite Database d You have chosen to perform a Re create the database mE Any existing data you may have loaded will be lost Are you sure you wish to continue 5 Wait for the load to complete 4 j Importing Lynx Data Loading TAS ADDRESS DETAIL lynx Note T
5. t Other Java enabled Platforms Download 5 4M LYNX Data Importer Versions Client User Guide Instructions View View View View View PSITIR AUSTRALIA LIMITED Page 4 a PSITI AUSTRALIA LIMITED Running the Installer If you have downloaded the installer you may need to unzip the file provided Windows Double click the file install exe Notes e For Vista and Windows 7 you will need to run the installer as an Administrator e You do not need to install any other software A Java virtual machine is included with the download Mac OS X Double click install Notes e Be sure you have Java installed You can download Java for free from the Java website www java com e The compressed installer should be recognised and automatically expanded after downloading e lf you have any problems launching the installer make sure that the compressed installer was expanded If problems persist please contact technical support support psma com au Solaris Linux Open a shell and ca to the directory where the installer is located At the prompt type sh install bin Notes e A Java virtual machine is included with the download It will run automatically with the shell script Other Platforms Java enabled In a console window ca to the directory where the installer install jar is located Add install jar to your CLASSPATH Start the main class of the installer named install Not
6. Importer Installer folder or through the PSMA Online Data Delivery System For additional information on accessing and using the PSMA Online Data Delivery System see the PSMA Online Data Delivery System User Guide From the PSMA Online Data Delivery System installers and instructions can be accessed by following these steps 1 Log into the Online Data Delivery System requires a username and password El dz Online Data Delivery User Name usemame Password eeeeece Log in Close 2 From the menu select Obtain Data PSMA Data ty baf quesiti sumere sti flit Patio cnn nu LYNX Data Importer Client User Guide Version 1 3 Page 3 3 Select a dataset eg G NAF This will open the Available Releases page Aone eh Dunne deos tn o o eo e does Te ELI ewe Si nonis qe e Fh onse andes con Taster of maar tema eg 5 G NAF An index of all Australian addresses 4 Select the download link on the Available Releases page Available Releases MAY 2013 Download Now MAY 2013 Download Now FEBRUARY 2013 Download Now NOVEMBER 2012 Download Now AUGUST 2012 Download Now Note To use data in the Lynx format you will need to install the Lynx Importer which can be downloaded from here 5 Select the required installer to download Available Installers Platform includes Java VM without Java VM MacOSX Download 5 9M X gt WA Download 33 6 A uU Download 54 5M M7 Solaris Download 63 9M
7. LYNX Data Importer Client User Guide a PSITIA AUSTRALIA LIMITED Disclaimer PSMA Australia believes this publication to be correct at the time of printing and does not accept responsibility for any consequences arising from the use of information herein Readers should rely on their own skill and judgement to apply information to particular issues This work is copyright Apart from any use as permitted under the Copyright Act 1968 no part may be reproduced by any process without prior written permission of PSMA Australia Limited LYNX Data Importer Client User Guide VOR Page E PSITIR AUSTRALIA LIMITED Revision History e NN August 2013 Update Darryl Gibson LYNX Data Importer Client User Guide Version 1 3 Page ii a PSITIR Contents Initgoro U eji e ccs ue O 1 Document PUN DOS Een m 1 PUGS ING ETT TT RT 1 Ricci NNI EP 1 s jaja TNR RN R a opnes 1 OVETVIC NC RETRO 2 BENS Fed AN ON Noises ese sete ge P 3 Opamning the Installer een neun ea euren doeceads 3 Running the Maji ceicsnercnexsaccentscanasnantanainddsnescaettessandssaicesnauhandtnddensrcnenhesnentasacessauiusstaideasscacthantenueatnensns 5 Obtaming PSMA Dad ciis tyrant reece eet pene ete tee a ae se linearen een seen rear 6 BID O FUNG PSMA Al t 7 Import Using the LYNX Importer A
8. e LYNX Data Importer from the command line with this driver in the classpath For example to start the LYNX Data Importer with a different database driver java cp 7 lib lynx distribute jar eV Vober Jar XlrbNOgutzl ars lt path s to your JDBC driver library s goes here gt au com geometry lynx distribution importer Importer I D NG NAFNG NAF FEBRUARY 2010 J JDBC connection string for this driver D the java class to use for this driver U test P Lest D iF S ACT NSW O true LYNX Data Importer Client User Guide Version 1 3 Page 11 PSITIA AUSTRALIA LIMITED Fully Supported The current version of the LYNX Data Importer v1 3 fully supports the import of e Standard extracts e Test amp Development extracts Limited The current version of the LYNX Data Importer v1 3 has limited support for the loading of Buffer extracts It can handle loading each state into its own separate schema Data from states cannot be loaded into the same schemas as there will most likely be duplicate addresses between the buffer extracts and this will cause a primary key error Unsupported The current version of the LYNX Data Importer v1 3 does not support the import of e Incremental extracts e Any profile other than the Standard Buffer or Test amp Development extracts LYNX Data Importer Version 1 3 Page 12 Client User Guide EJ PSITIR AUSTRALIA TED Troubleshooting Guide Issue Solution
9. es e Be sure you have Java installed You can download Java for free from the Java website www java com LYNX Data Importer Client User Guide Seel Page 5 Obtaining PSMA Data a PSITI AUSTRALIA LIMITED When obtaining data in the LYNX format the directory structure is very important as the LYNX Data Importer relies on a particular structure for loading Once you have obtained your PSMA data in LYNX format there will be a directory titled with the dataset name and release eg G NAF FEBRUARY 2010 This directory will contain the following directories and files Mame Date modified 4 Files Currently on the Disc 7 dJi Authority Code 27 05 2013 1 48 PM i Standard 27 05 2013 1 48 PM add fk constraints sal 22 05 2013 5 13 PM alter tables ansi sal 22 05 2013 5 13 PM alter tables sqlserver sal 22 05 2013 5 13 PM create tables ansi sal 22 05 2013 5 13 PM create tables sqlserver sal 22 05 2013 5 13 PM Type File folder File folder SQL File SQL File SQL File SQL File SQL File The directories Authority Code and Standard will contain the LYNX format Lynx files Important Note for Mac OS X Users If you are an OS X user please be aware that data downloaded from the LYNX website come as Windows archive files The default OS X archive utility may not preserve the archive files original directory structure and may instead extract the files to a single directory with file names reflecting t
10. he LYNX Data Importer will write a log file to the location specified by Log file directory eg import 20130226 134831 10g 6 Success Message The LYNX data has been successfully imported Timetaken 0 hours 0 minutes 6 seconds LYNX Data Importer erence Page 8 Client User Guide PSITIA AUSTRALIA LIMITED Import via Batch Script Sometimes it is more convenient to automate the loading of data To support this the LYNX Data Importer supports command line mode operation This mode is only supported if you have Java SE 6 0 or greater installed on your machine The command line syntax is java cp required classpath gt au com geometry lynx distribution importer Importer I import directory J JDBC connection string D lt driver gt U lt username gt P lt password gt T import type F gt O overwrite existing tables true false S lt states gt Parameters I The location of the import directory Use quotes if the directory path contains spaces J The JDBC connection string This will be different for each type of database MySQL jdbc mysql server port db Oracle jdbc oracle thin server port db SQL Server 2000 jdbc microsoft sqlserver server port DatabaseName db SQL Server 2005 jdbc jtds sqlserver server port db PostgreSQL 8 1 jdbc postgresql server port db ODBC jdbc odbc odbcName D The Java Class to use as the database driver This will be different for each type of
11. he original directory structure In this case please use an archive utility that preserves the original directory structure as seen above For example the free iZip archiver application available from the OS X App Store LYNX Data Importer Client User Guide Version 1 3 Page 6 EJ PSM AUSTRALIA LIMITED Import Using the LYNX Data Importer Application Note for MySQL database users The LYNX Data Importer provides MySQL databases with ANSI compliant SQL Later versions of the MySQL database may not operate in ANSI SQL mode by default and may require you to configure this mode prior to running the LYNX Data Importer Instructions for checking and configuring SQL modes are detailed in the following MySQL article http dev mysql com doc refman 5 0 en ansi mode html 1 Open the LYNX Data Importer application LYNX Data Importer v1 3 Database Type SQL Server 2000 States Territories SQL Server 2005 S S PostgreSQL Other Territories ODBC Connection Username Password Host TCP Port 3306 Database Identifier Re Create Tables Note A generic JDBC driver is used to connect to this database type Compatibility with future database releases is likely but not guaranteed Please see documentation for specific driver details Log file directory C Users DarmyIG AppData LocaNTemp Import 2 Enter the Import Parameters Database Type Select the database type from the Database Type panel Import Directory Select the import directory This
12. imum amount of memory at initialisation LYNX Data Importer Client User Guide Version 1 3 Page 13
13. pplication ccccccccsssceeceseeeeeeeeeeeceeeeeesaeaeeesseaseeeseeseeessneessnaeeees 7 IMPOr US BE ACR SCH Farsar E ee ae een 9 Da abase Bs ee ee ee ee ee 11 supported Bata Pro MES uini vcits nannte 12 Troubleshooting UNG Pc M 13 putes Data importer Version 1 3 Page iii Client User Guide a PSITIA AUSTRALIA LIMITED Introduction Document Purpose This document provides instructions on installing and using the PSMA LYNX Data Importer application for use with PSMA data provided in the LYNX proprietary format Audience This document is intended to be used by any person with access to PSMA data in LYNX format as a guide and reference to using the associated Importer application References e PSMA Online Data Delivery System User Guide Support PSMA Australia Support PSMA Australia Limited Email support psma com au Web www psma com au LYNX Data Importer Client User Guide Versions Page 1 a PSITIA AUSTRALIA LIMITED PSMA s LYNX Data Importer is a utility that can be used directly or via a batch script to import data held in PSMA s LYNX proprietary format into a database The current supported databases are MySQL An ANSI SQL 92 compliant database For more information see htto www mysql com Oracle An ANSI SQL 92 compliant production level database from Oracle For more information see http www oracle com database Oracle 9 x 10 x and 11g Release 2 have been used successfully wi
14. th the Importer SQLServer 2000 A production level database from Microsoft SQLServer 2005 Not ANSI SQL 92 compliant For more information see http www microsoft com sgl default asp SQLServer 2000 2005 and 2008 R2 have been used successfully with the Importer PostgreSQL An open source ANSI SQL 92 compliant database For more information see http www postgresgl org PostgreSQL 8 1 to 9 2 have been used successfully with the Importer ODBC Connection The destination database must be ANSI compliant Compatibility with future database releases is likely but not guaranteed To load LYNX proprietary format data into your database you will need to do the following e Ensure that a database is available for the data to be loaded into e Install the LYNX Data Importer application e Run the LYNX Data Importer application via user interface or batch script If you do not have an ANSI compliant database you can download a free open source database system such as e MySQL available from www mysgl com e PostgreSQL available from www postgresgl org LYNX Data Importer Version 1a Page 2 Client User Guide b PSMA USTRALIA LIMITED Installation Obtaining the Installer LYNX Data Importer application installers are available for the following platforms Windows includes Java VM Mac OS X Linux includes Java VM Oracle Solaris includes Java VM Other Java enabled Platforms The installers are included with data DVDs in the LYNX
Download Pdf Manuals
Related Search