RE: Problem with adding parts after I imported part data

[Chris K. <kac...@ho...>]

Found the problem.  There is a sequence id defined.  I just need to make the
number higher than the number I used when loading in the parts and then I
should be set.  Please let me know if this will not work.

cheers,

ski

 -----Original Message-----
From: 	Chris Kacoroski [mailto:kac...@ho...]
Sent:	Sunday, February 03, 2002 9:39 PM
To:	'sql...@li...'
Subject:	Problem with adding parts after I imported part data

What I did:
I had to put in about 100 parts.  Instead of entering each one through the
gui, I tested a few and found that the tables affected were parts, partstax,
and makemodel.  I then dummied up a spreadsheet for each of these tables
with ids and imported them into the postgres tables (pgaccess is really
cool).

What Happened:
This worked fine until I tried to add in a new part via the web interface.
When I did this, the new part showed up twice in the parts table (same id
number which confused me because I thought this was a unique field).  Also,
it over wrote an id number in the parts table from one of the parts I
imported.

What may be happening:
Does SQL-Ledger keep a counter somewhere of the next available id number.
If so, where is the counter so I can update it.  Of perhaps there is a
better way of importing a lot of data into SQL-Ledger.

Thanks in advance for your help.  I really like the program, just do not
want to do a bunch of hand entry.

cheers,

ski