Home › Forums › implementation › Implementation discussion ›

Problem installing postcodes/suburbs

Submitted by Guest on Thu, 19/02/2015 - 02:59
in

Hi,

 

I'm installing a new OpenVPMS database and am up to the point where I install the postcode data.

I used dataload.bat -f ../import/data/postcodesAU.xml (the file is definitely in that location)
 

When I run it again I get the duplicate errors, however the suburbs still aren't visible in OpenVPMS.

I'm running windows 7 on a 64 bit machine.

 

Any help would be greatly appreciated.

 

Thanks,

Shanon

‹ Windows 8/MySQL 5.1 warning A solution for email logging ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Problem installing postcodes/suburbs

Submitted by Carnarvonvet (not verified) on Thu, 19/02/2015 - 06:05.

Not to worry, I restarted the tomcat and mysql service and the suburbs have magically appeared.

Thanks

Re: Problem installing postcodes/suburbs

Submitted by tgething (not verified) on Thu, 19/02/2015 - 06:33.

Shanon - its not magic. What is happening is that a) dataload is being run outside the OpenVPMS web application; and b) the web application caches as much as possible so as to minimise database accesses.  Specifically the country/state/suburb stuff is read in when the first user logs on after Tomcat starts (which is why login is slow for the first user). The cache is updated if you use Administration|Lookups|Suburb etc - but NOT if you use dataload.

So your mysql retart was not necessary, but the Tomcat restart was mandatory.

For more information see http://www.openvpms.org/documentation/csh/1.7/reference/caching

Regards, Tim G

Syndicate content