Eclipse Community Forums: DTP » CSV import with auto-generated primary key

Help

Home

Home » Eclipse Projects » DTP » CSV import with auto-generated primary key

Show: Today's Messages :: Show Polls :: Message Navigator

CSV import with auto-generated primary key [message #677448]

Wed, 08 June 2011 14:48

Messages: 10
Registered: July 2009

Junior Member

Hi,
I load a CSV file into a table but DTP insists on each row in the file
having a primary key. But I want DTP to genewrate that.

The rows in the CSV file do not have a primary key. In the destination
table, the first column is defined as a non-null, auto-generated primary
key. I was hoping that when the first column in the CSV is empty, that
DTP will auto-generate that column. Instead, it gives and error stating
that a null value is being assigned to a non-null column.

Is there way to get DTP to auto-generate IDs during CSV import?

I am using DTP 1.9.

Thanks, yo

Report message to a moderator