Home › Forums › Users › General User's Discussion ›

Product Importing

Submitted by EastsideVetEmerg on Fri, 12/02/2016 - 10:01
in

Hi,

I have a bunch of products I would like to import. However I would like to assign IDs to these that are not necessarily in keeping with the sequential numbering system used currently.

Is it:

a) possible to do a batch import to add a heap of items.

b) Possible/sensible to have pre-assigned ids

Thanks,

Adrian

 

 

‹ Creating a Customer Form document that only inputs customer details, rather than customer details linked to a patient Refunds in excess of a client's balance ›

Comment viewing options

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

Re: Product Importing

Submitted by tanderson on Fri, 12/02/2016 - 13:40.

a) Yes, via the dataload tool, or using Pentaho Data Integration

b) Not easily. You need to adjust auto-increment identity columns in the database to do this.

Re: Product Importing

Submitted by tgething (not verified) on Fri, 12/02/2016 - 17:52.

Adrian - I am about (say a couple of weeks) to put a spreadsheet in te Resource Library that you can use to generate the XML needed by dataload. I use this technique to load the complete ProVet product set for a new OpenVPMS user.

As Tim A says, you cannot explicitly set the ID as this is an autoincrement field.

Regards, Tim G

Re: Product Importing

Submitted by EastsideVetEmerg on Sat, 13/02/2016 - 10:13.

Hi Tim and Tim,

Thanks for that.

I have a bunch of products in our Cubex but not in OVPMS. These are mainly stock control products, however we want to get them into OVPMS for reasons to boring to go into. The items in the Cubex have arbitary IDs. The IDs in Cubex and OVPMS need to match.

Thus I think what I will need to do is:

1) Export required items from Cubex

2) Import into OVPMS -> Generate OVPMS IDs

3) Change the IDs in Cubex to match those in OVPMS.

I will wait and use the XML you (TimG) mention for Step 2.

Thanks,

Adrian

Syndicate content