1. m3support
  2. RO CSVI
  3. Tuesday, 20 October 2020
  4.  Subscribe via email
Importing a date field converts it to GMT instead of site time. Alters the field value.
Accepted Answer Pending Moderation
Hello,
Please post import debug log and sample of your import file to check. We do not convert dates for Joomla custom fields so would like to check with your import file. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you. Here you go.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

The date is not off by 1 day but by the timezone difference. Joomla sees your date as UTC time.

Your very first event has an event date of 12/15/2020. This is how RO CSVI stores the date, as you can see that is exactly the same.

INSERT INTO `tgmyc_fields_values` (`field_id`,`item_id`,`value`) VALUES (4,2003057,'12/15/2020')

The problem you see comes from the moment your website is rendering the date. This alters the date to something else.

What you can do is enter 1 event date manually, export that record and see how it comes out. You can then update the import file to reflect the same and the rendering on the site should be good as well. I have no idea how things are rendered, but another option may be to change the way the dates are rendered.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Hi Roland!

Thanks for your response. What would it take to create a "Set Timezone" rule plugin for import?

I noticed a similar issue: https://rolandd.com/support/ro-csvi/dates-changed-on-import-from-csv-into-k2-article#reply-45266
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

That is quite an old issue, from 2015. Without the answers to my question in my previous post, I have no clue what we are talking about in terms of what is actually expected.

One thing I was thinking of earlier is that you can use the multi-replace plugin to add a timestamp to your imported date. Which I guess is essentially the "Set Timezone" rule. You can add for example " 02:00:00" to the end of the date your import, that would represent the timezone. However the 2 all depends on your location and server settings of course, you will need to find out which number applies to you.
Kind regards,

RolandD

=========================
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. # 5
Accepted Answer Pending Moderation
Thanks Rolland! Your advice sent me in the proper direction.

I played around and used the combine plugin (probably not the most suitable), but I was able to combine the original field with a combine field of " America/Los_Angeles", and it did the trick, and now Joomla Renders the date correctly.

Any suggestion as to how to use a field from an imported file to set more than one article value? In my case, I want to set the publish_down date using the "END DATE" custom field. For some reason, I can't seem to use the same CSV value twice ...
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Any suggestion as to how to use a field from an imported file to set more than one article value? In my case, I want to set the publish_down date using the "END DATE" custom field. For some reason, I can't seem to use the same CSV value twice ...

You can use RO CSVI Field Copy rule plugin to copy value of one field to another. Let me know if that helps.
Kind regards,

Tharuna

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


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