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

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

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

Wed, 08 June 2011 10:48

Eclipse User

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

Re: CSV import with auto-generated primary key [message #690467 is a reply to message #677448]

Wed, 29 June 2011 10:51

Eclipse User

Yo, I don't believe there is a way to do this currently. Can you create an enhancement request?

Previous Topic:	Connection error to SQL via BIRT viewer
Next Topic:	New connection profile to Sybase ASE database..(problems)

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 05 11:53:15 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter