Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Matching columns

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #310

I've replied! ;-)

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #309

Sent you an email


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #308

I'm waiting your support.

Thanks

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #306

Mail sent.

Thanks

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #305

Please send us your back end login details via Contact Us form, We'll look into it..

Thanks


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #304

See attachments

Attachments:

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #303

It answers there's a duplicate entry for ID.

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #302

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
Daniel

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #301

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 or Create an account to join the conversation.

More
3 years 1 month ago #300

You can find the primary key usually ID in joomla back end where you manage the items...


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #299

How I can obtain or set primary key in CSV?

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #298

Hi,

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

Thanks


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #297

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 or Create an account to join the conversation.

  • Maurizio Campani
  • Maurizio Campani's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 years 1 month ago #296

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 or Create an account to join the conversation.