Matching columns
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
24 Jun 2014 14:54 #310
by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
I've replied!
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
23 Jun 2014 07:09 #308
by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
I'm waiting your support.
Thanks
Thanks
Please Log in to join the conversation.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
20 Jun 2014 09:08 #306
by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
Mail sent.
Thanks
Thanks
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
19 Jun 2014 16:16 #305
by Daniel
Thanks
Daniel
Replied by Daniel on topic Matching columns
Please send us your back end login details via Contact Us form, We'll look into it..
Thanks
Thanks
Thanks
Daniel
Please Log in to join the conversation.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 14:36 #304
by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
See attachments
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 14:32 #303
by Maurizio Campani
Replied by Maurizio Campani on topic Matching columns
It answers there's a duplicate entry for ID.
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
19 Jun 2014 14:29 #302
by Daniel
Thanks
Daniel
Replied by Daniel on topic Matching columns
You don't need to select reference to, Please select data file and then Number and select data file and then string for description field. Then the profile is ready to update the description column in database.
Thanks
Thanks
Thanks
Daniel
Please Log in to join the conversation.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 14:26 #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?
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.
- Daniel
- Offline
- Administrator
-
19 Jun 2014 14:18 #300
by Daniel
Thanks
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.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 14:03 #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.
- Daniel
- Offline
- Administrator
-
19 Jun 2014 13:54 #298
by Daniel
Thanks
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
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.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 13:51 #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.
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.
- Maurizio Campani
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
19 Jun 2014 13:49 #296
by Maurizio Campani
Matching columns was created 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.
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.