Matching columns

More
11 years 2 months ago #296 by Maurizio Campani
This is my situation:

Database has many columns, but one, called "Description", is empty. I want fill it by importing data from CSV file.
That CSV has two fields: TitleCSV and DescriptionCSV.

In HexData profile I setted:

-column "Description" of REFERENCED TO column "DescriptionCSV" as DataFile->String

but I don't know how match "Title" of DB with "TitleCSV". I tried to use Referenced To, but I wrong something.

Any help?

Thanks.

Please Log in to join the conversation.

More
11 years 2 months ago #297 by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
This is my situation:

Database has many columns, but one, called "Description", is empty. I want fill it by importing data from CSV file.
That CSV has two fields: TitleCSV and DescriptionCSV.

In HexData profile I setted:

-column "Description" of database with column "DescriptionCSV" as DataFile->String

but I don't know how match "Title" of DB with "TitleCSV". I tried to use Referenced To, but I wrong something.

Any help?

Thanks.

Please Log in to join the conversation.

More
11 years 2 months ago #298 by Daniel
Replied by Daniel on topic Matching columns
Hi,

You can update records in database only when you've primary key value in your CSV file..

Thanks

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 2 months ago #299 by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
How I can obtain or set primary key in CSV?

Please Log in to join the conversation.

More
11 years 2 months ago #300 by Daniel
Replied by Daniel on topic Matching columns
You can find the primary key usually ID in joomla back end where you manage the items...

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 2 months ago #301 by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
I found the primary key.

Now I want, with HexData, make an operation like "INSERT INTO '...' ('description') VALUES ('descriptionCSV') WHERE ID=xyz.

But for primay key there isn't a "Reference To".

In substance, I would make a simple operation. Only update a db column (description) for each records. Each record has an ID (primary key) and a title.
It's possible or not?

Please Log in to join the conversation.

Cron Job Starts