Categories
View Replies (1)

Resolved xml import to custom table not working

  1. New
  1. scottk
    scottk
  2. RO CSVI
  3. Monday, 06 April 2026
  4.  Subscribe via email
I created a custom sql table. The "Field name" is each field in this table and "Your field" is each field in the xml file. The analyze function reads in the xml file properly, but when running the template import, it does not work. See the attached log file. What am I missing?

Also, I would like to read in XML formatting from a URL, but it doesn't have a ".xml" extension, is there a way to disable the check for ".xml" or a way to have the XML copied to a .xml file so this check works?
Attachments (1)
com_csvi.log.41.zip
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Debug log shows two issues

1. Not going to check if row exists because we have no value for the key field reference_number
2. Cannot add custom table data. Error: Field 'reference_number' doesn't have a default value

It looks like you are importing based on reference_number field and this field has no value. What do you have set in reference_number field? Can you post screenshot of import preview page? Also post template XML and sample of import XML file to check. To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. Post the downloaded XML file.
Kind regards,

Tharuna

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


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