Categories
View Replies (3)

Resolved Custome Table Import

  1. gtcnetworking
    gtcnetworking
  2. RO CSVI
  3. Tuesday, 23 August 2016
  4.  Subscribe via email
Hi All
I am having trouble using Custom Tables import.
Version 6.6.3

The import runs fine with no errors and no debug log.
The analyser finds the source file OK
But all I get in the SQL table is a blank line for each line in the source file.
I have the first entry to match the primary key in the table but it will not update the existing records.

Source file attached. first field is primary key.

Obviously it cannot match any of the source fields to the primary key. But why ?

I note in the documentation that version 6.7.0 has a new option to specify the key field.
Is this in Beta ?
How do obtain a copy please.

Quote
Available from version 6.7.0

You can now set the field based on with which import should be done. It is now not restricted to primary key field but to any valid column name from the database table. On options tab, under the custom table, you can select the import based on field. If nothing is set then custom table primary key field will be used.

endquote

Many thanks
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you send the debug log of the import? Lets check why it is not updating before i send you the copy of code for specifying the key field. To know how to get the debug log, have a look at the section "Where to get the debug information?" on top of this page.
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. # 1
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
Hi
Thanks for quick response.
I figures out why I was not getting a debug log. I had it set on the wrong test import template.
So here it is attached

It says it cannot find the field _accountNumber

But I have attached the SQl screen with it on

am I missing something obvious ?
Attachments (2)
com_csvi.log.19.zip
sql.jpg sql.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The problem is with your table field names, Joomla doesnt support column names starting with _. You need to correct them and then your import would work good. Also to let you know, since accountNumber field is primary key field you need it in your import file only when you want to update the record. If it is a new insert you dont need that column in your import 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. # 3
  • Page :
  • 1


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