Categories
View Replies (2)

Resolved What are "Incorrect" import entries, and how can I find them

  1. Anonymous User
  2. RO CSVI
  3. Wednesday, 29 June 2022
  4.  Subscribe via email
Hello!
The import template (xml -> Joomla! contacts) works good now. Thanks for all your help on the other threads :)
However: I added a general rule to skip empty entries, and it works fine. Since then I get a message after the template has run:
import-contacts-incorrect01.png
So, RO CSVI tells me that there are 28 "incorrect" entries, 14 entries have been empty and therefor skipped.

My question: How do I find those "incorrect" entries? I cannot see any incorrect contact entry, but that's hard having 220 entries ;-)
What puzzles me also: I know I have 220 entries in the xml file; I also counted 14 empty entries, both numbers are correct? But why 28 "incorrect" entries?

I could not find anything in the log files.

Thanks you very much!
Attachments (1)
import-contacts-incorrect01.png import-contacts-incorrect01.png
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
After import in the log details page where you see Incorrect entries (on the same page you sent the screenshot) under Log details section click on Filter options button and in the Select option filter select Incorrect. That should list out the incorrect entries from import. See attached screenshot.
Attachments (1)
Screenshot 2022-06-30 at 10.53.11 AM.png Screenshot 2022-06-30 at 10.53.11 AM.png
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. # Permalink
Responses (2)
regme_rojo
regme_rojo
Accepted Answer Pending Moderation
Thank you very much for the explanation and your patience (I could have fond this function by myself).

I found out, that RO CSVI logs two failure messages for every entry in the XML, which miss the "name" field:


Not added. Error: Field 'name' doesn't have a default value

Error: Field 'name' doesn't have a default value

That makes 28 failure messages for 14 empty entries (in the xml).
Actually interesting: If there is no skip rule in the import template, there is are no _incorrect_ import log messages, but empty entries go into the database. Which should not happen, because according to the documentation for importing a contact to have a name and an alias field is mandatory (obviously).

So, basic line: I don't need to worry about incorrect imports because these messages come with the empty entries in the xml.
  1. more than a month 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!