Home › Forums › implementation › Implementation discussion ›

PostCode and Suburbs

Submitted by Guest on Thu, 21/07/2011 - 17:43
in

Hi,

I have OPENVPMS up and running, except for Suburbs, PostCodes and State.

I was wondering if I can use the dataload or archload to populate the relevant tables (Suburb, Postcode, State) within the database?

thanks,

James

‹ Questions regarding OpenVPMS OpenVPMS on x64 hardware ›

Comment viewing options

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

Re: PostCode and Suburbs

Submitted by tony on Thu, 21/07/2011 - 18:05.

Hi James,

if you want to load the Australian postcodes then you can do so using dataload.

 dataload.bat -f ..\import\data\postcodesAU.xml

Cheers

Tony

Re: PostCode and Suburbs

Submitted by Yuri on Fri, 22/07/2011 - 09:41.

Parallel question: what's the function of the -f switch in the code above?

Yuri.

Re: PostCode and Suburbs

Submitted by tony on Fri, 22/07/2011 - 10:14.

Hi Yuri,

There are a number of flags you can use on dataload to control what files to process.



	Usage: java org.openvpms.tools.data.loader.StaxArchetypeDataLoader



	[(-c|--context) <context>] [(-d|--dir) <dir>] [-s|--subdir] [(-f|--file) file1,file2,...,fileN ] [-v|--verbose] [--validateOnly] [(-b|--batchSaveSize) <batchSaveSize>]



	 



	  [(-c|--context) <context>]



	        Application context for the data loader (default:



	        application-context.xml)



	 



	  [(-d|--dir) <dir>]



	        Directory where data files reside.



	 



	  [-s|--subdir]



	        Search the subdirectories as well.



	 



	  [(-f|--file) file1,file2,...,fileN ]



	        Name of file containing data



	 



	  [-v|--verbose]



	        Displays verbose info to the console.



	 



	  [--validateOnly]



	        Only validate the data file. Do not process.



	 



	  [(-b|--batchSaveSize) <batchSaveSize>]



	        The batch size for saving objects. (default: 0)



	 



	If you have a look inside the dataload.bat file you will see some of these are used for the base and setup load options. 



	Cheers



	Tony

      


      

          

  

 





      

      Re: PostCode and Suburbs          

  
  
  
  

    Submitted by Yuri on Fri, 22/07/2011 - 12:50.  


  

    

	Ok, I understand: it's a java switch, not a DOS batch file switch (whew! - this DOS dinosaur's grey matter couldn't remember an -f batch file switch).



	Thanks.



	Yuri.

      


      

          

  

 

  

        


                  
Syndicate content