You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Ritz123 <ri...@gmail.com> on 2008/01/11 03:08:22 UTC

Good way to create ids?

Hi,

Does anyone know of a better way to create ids for seed data to avoid PK
conflicts with already existing data?

Ideally being able to define a base # and reference that in the seed data
file instead of hard coding ids or something similar?
-- 
View this message in context: http://www.nabble.com/Good-way-to-create-ids--tp14748354p14748354.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: Good way to create ids?

Posted by Hans Bakker <ma...@antwebsystems.com>.
Either use alphanumeric or numbers lower than 10000


On Thu, 2008-01-10 at 18:08 -0800, Ritz123 wrote:
> Hi,
> 
> Does anyone know of a better way to create ids for seed data to avoid PK
> conflicts with already existing data?
> 
> Ideally being able to define a base # and reference that in the seed data
> file instead of hard coding ids or something similar?


Re: Good way to create ids?

Posted by BJ Freeman <bj...@free-man.net>.
everything below 10,000 is considered Demo ID's
Some use named ID's
beyond that, I would suggest you change the auto ID start numbers load
you data via the UI then export.


Ritz123 sent the following on 1/10/2008 6:08 PM:
> Hi,
> 
> Does anyone know of a better way to create ids for seed data to avoid PK
> conflicts with already existing data?
> 
> Ideally being able to define a base # and reference that in the seed data
> file instead of hard coding ids or something similar?


RE: Good way to create ids?

Posted by "skip@thedevers" <sk...@thedevers.org>.
You can use low numbers (< 10000) for you seed and import data and then
after everything is loaded, manually change the next sequence of numbers
that are loaded after you do ant run-install-seed.  These id numbers from
which the sequences are obtained are stored in a data file.

Skip

-----Original Message-----
From: Ritz123 [mailto:ritesh.trivedi@gmail.com]
Sent: Thursday, January 10, 2008 6:08 PM
To: user@ofbiz.apache.org
Subject: Good way to create ids?



Hi,

Does anyone know of a better way to create ids for seed data to avoid PK
conflicts with already existing data?

Ideally being able to define a base # and reference that in the seed data
file instead of hard coding ids or something similar?
--
View this message in context:
http://www.nabble.com/Good-way-to-create-ids--tp14748354p14748354.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM