Categories
View Replies (8)

Resolved Date wiped/changed in other areas on import update

  1. gardenho
    gardenho
  2. RO CSVI
  3. Tuesday, 24 July 2018
  4.  Subscribe via email
Today the store owner is finally ready to do import updates and first attempt was nothing but errors. They were importing to joomla custom fields to update them. The fields updated but it also wiped out the article titles and replaced them with the article alias. It also wiped out the image paths and image alt descriptions, changed the created date to today date and changed language from english to all. Why is it touching any of these fields when they are not in the template or in the import sheet? I restored it all to original and I tried an update myself with same results.

The template was using Joomla Content as component with content as operation, although custom fields was all that was being updated. This was identical to what I used successfully back in May after patch was applied - forum post #58396. I cannot recall if CSVI pro was 7.6.2 or 7.6.1 at that time.

I then changed the template to use Joomla custom fields component with fields as the operation. It failed immediately saying no title. Adding the title to the import sheet and the template then it worked. Title is not mandatory on updates if the id, alias and category_path were present I thought. It still changed the language to all and the created date to today's date.

I have applied the patch again and waiting for the store owner to send me another import sheet to work with. They do not want to continue using your tool because it is wiping out other data that requires even more importing to replace it. I need to fix this but first I need to know what is causing it. I've searched your forum and don't find other posts with the same issue.

So in your opinion and knowledge what causes other data to be changed that is not in the template or the import sheet?

I realize it would be best to include debug, log and template but I've changed the template since the first failed attempt today and debug was not in use through any of it. I will use debug when they send me another file to test with. I have the import working with addition of the title field and/or re-applying the patch but the issue now is what is causing imports to change values in other fields like the date created and language.

This is Joomla 3.8.10 with CSVI pro 7.6.2 and J2store 3.3.1 Pro. Thanks for your time and consideration.
0
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Today the store owner is finally ready to do import updates and first attempt was nothing but errors. They were importing to joomla custom fields to update them. The fields updated but it also wiped out the article titles and replaced them with the article alias. It also wiped out the image paths and image alt descriptions, changed the created date to today date and changed language from english to all. Why is it touching any of these fields when they are not in the template or in the import sheet? I restored it all to original and I tried an update myself with same results.

Are you sure the article has been updated? The change you are saying about the created date will happen only when the article is a new article. Do you still have the import file? If yes, can you post that? we will run the import here and check.

The template was using Joomla Content as component with content as operation, although custom fields was all that was being updated. This was identical to what I used successfully back in May after patch was applied - forum post #58396. I cannot recall if CSVI pro was 7.6.2 or 7.6.1 at that time.

Are you are talking about the thread here? The patch was to remove intotext and fulltext to be not mandatory. You had CSVI 7.6.2 version as per the screenshots in the post.

I then changed the template to use Joomla custom fields component with fields as the operation. It failed immediately saying no title. Adding the title to the import sheet and the template then it worked. Title is not mandatory on updates if the id, alias and category_path were present I thought. It still changed the language to all and the created date to today's date.

Yes, Id, alias and category_path are needed fields for Joomla content import, you are doing a Joomla custom fields import here and so title and name/alias are needed field for this import. The created date will be today's date only when the field is a new one. The modified date is what changes to today's date on update.

So in your opinion and knowledge what causes other data to be changed that is not in the template or the import sheet?

We would like to see your import file, debug log and also your import template to tell what would have gone wrong.

I realize it would be best to include debug, log and template but I've changed the template since the first failed attempt today and debug was not in use through any of it. I will use debug when they send me another file to test with. I have the import working with addition of the title field and/or re-applying the patch but the issue now is what is causing imports to change values in other fields like the date created and language.

Yes, send us your debug log to check on the issues with language and created date.
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
gardenho
gardenho
Accepted Answer Pending Moderation
My sincere apologies, it appears once again I have wasted your time and mine. After importing many test files, I cannot reproduce the problem on the staging site. As long as the title is in the template and import sheet it imports to custom fields perfectly and does not modify or change any other fields. The only time it was incorrect was import without title field, then it replaced title with alias. Something else they did must have changed date & language as it is not happening with this particular import template.

However, to clarify on the template for Joomla custom fields - Setting the component to custom fields resulted in importing fields and/or categories of fields NOT the field values. Indeed my original setting of Joomla content was needed to import field values which was the purpose of this import. You put me on track with that one when you asked if it was actually updating. The changes applied by the import were subtle so hard to spot at a glance and when I checked this morning on yesterday's import sure enough they had not actually updated anything in the articles.

Thank you and my apologies for wasting your time!
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The only time it was incorrect was import without title field, then it replaced title with alias.

Thats right, when there is no title alias is used as title.

However, to clarify on the template for Joomla custom fields - Setting the component to custom fields resulted in importing fields and/or categories of fields NOT the field values.

Yes, Joomla custom fields is for importing fields and its categories and not for importing values. We need article title or alias, category_path or catid to link the custom field values to articles so that can be done only using Joomla content import.

Thank you and my apologies for wasting your time!

No problem, we are glad that your issues are all solved.
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
gardenho
gardenho
Accepted Answer Pending Moderation
I am back with the same issue. It is wiping out the joomla images tab information when importing after all, I don't know why or how as it is inconsistant. I tested this last Wednesday over and over again and no issues with the images, although they said it was doing this in previous attempts and I saw it myself at least once. I received a note from the site owner over the weekend saying they imported and prepared the sheet exactly as instructed and it wiped the images tab blank on import. I tested their exact same file on the developer site and sure enough it did. Attached is the debug log & import sheet in zip and import template for the file in question.

csvi_templates_lynne.ca_20180730.xml img-wipe-files.zip
Attachments (2)
csvi_templates_lynne.ca_20180730.xml
img-wipe-files.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
gardenho
gardenho
Accepted Answer Pending Moderation
Hello? A response is requested here, this issue is not fixed after all!
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Apologies for delayed response, we had some technical difficulties so there were no notifications on your message.

I had a look at the issue you mentioned and yes i can see importing Joomla content with the fields from your debug log removes the Joomla image tab fields. I have fixed this with the attached patch file. Please load it using CSVI maintenance menu and run the import. Let me know if it fixes your issue.

patch_content_2018_08_07.zip
Attachments (1)
patch_content_2018_08_07.zip
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. # 6
gardenho
gardenho
Accepted Answer Pending Moderation
Yahoo it worked great. I tested 4 imports, 3 small and one large one and they did not wipe the images for a total of 200 items. Thank you for the fix.
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for confirming the patch is working :)
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. # 8
  • Page :
  • 1


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