Good way to create ids?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Good way to create ids?

Ritesh Trivedi
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?
Reply | Threaded
Open this post in threaded view
|

Re: Good way to create ids?

hans_bakker
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?

Reply | Threaded
Open this post in threaded view
|

Re: Good way to create ids?

BJ Freeman
In reply to this post by Ritesh Trivedi
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?

Reply | Threaded
Open this post in threaded view
|

RE: Good way to create ids?

SkipDever
In reply to this post by Ritesh Trivedi
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:[hidden email]]
Sent: Thursday, January 10, 2008 6:08 PM
To: [hidden email]
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