Categories
View Replies (45)

Resolved How can I fill the field that has the primary key after insertion

  1. psmits
    psmits
  2. RO CSVI
  3. Thursday, 01 December 2016
  4.  Subscribe via email
I am new to CSVI but I got it working, I can add records and update fields in my table
But in order to create a new record it is necessary to deliver a new record without a value for the field that has the primary key
How can I populate this field after the insertion with the proper value so it gets found by the primary key when I want to update it
I have tried with combining but that does not work
PHP version 7.0.13
Joomla! version 3.6.4
Database schema version 6.6.0
CSVI version 6.6.4.
0
Responses (45)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If you are looking for updating custom table based on a field other than primary key field in database, the functionality is coming in our next CSVI release. Please check custom table import documentation under SETTING THE OPTIONS section.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 41
psmits
psmits
Accepted Answer Pending Moderation
Hi Tharuna

That is disapointing for me as it means more work to maintain the table
Can you tell me in which peace of the code, this decision is made
Because then I can change the code
If an update does deliver a rowcount "0" then I can decide to insert it
Or is it somehow possible to combine two import fields and use them to update the field afterwards ?
I know combination is possible, but that happens up front
  1. more than a month ago
  2. RO CSVI
  3. # 42
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If you are using custom table import then yes you need primary key field else records will be inserted. As i said earlier you can export the primary key field with other fields using custom table export template, do the update to fields and import the file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 43
psmits
psmits
Accepted Answer Pending Moderation
Hi Tharuna
I am using component CSVI PRO with import on custom tables, so no Joomla related tables
If I leave the field that is the primary key out of the import, than all records are inserted !!
Which fields are rquired for import ??
Ho can I indicate which fields need to be used to search the table ??
  1. more than a month ago
  2. RO CSVI
  3. # 44
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You don't actually need a primary key field for doing an update. I am not sure which import your are using but there are few required fields for import, if the value of these required fields match with the one in database, CSVI will automatically do an update to a record.

But then one way to get primary key field for update is that you can export the needed fields along with primary key field using an export template and do your updates to the export file and import the file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 45
  • Page :
  • 1
  • 2
  • 3


There are no replies made for this post yet.
Be one of the first to reply to this post!