Categories
View Replies (5)

Resolved Issue importing Date_From and Date_To in J2Store price import

  1. jo.vandriessche@jodela-it.be
    jo.vandriessche@jodela-it.be
  2. RO CSVI
  3. Sunday, 19 June 2022
  4.  Subscribe via email
Hi, I have issue importing prices in J2 Store.
I'm using the Example J2store Price Import template to do this.
When importing the date from and date to are not filled in, although they show up correctly in the preview.
I even did a price export and imported the same file without manipulation and it failed and added a row with blank dates instead.
Any thoughts please?
See screenshots in the attachement + attached import file enclosed as well.
Thanks, Jo


PHP versie 7.4.30
Joomla! versie 3.10.9
RO CSVI 8.3.0
Attachments (1)
Datefrom issue.docx
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jo,
Is there a way I can change the Price import to have also the d/m/Y format instead, for future cases.

The problem is database supports Y-m-d H:i:s format so any other format of date value will not be saved in database. This is not RO CSVI setting but MySQL database thing.

the option to change the date format seems not available in import, only on export.

Thats correct. That is because import is to save the values to database and does not support all date formats.
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
jo.vandriessche@jodela-it.be
jo.vandriessche@jodela-it.be
Accepted Answer Pending Moderation
Thanks again for the quick reply Tharuna.
I managed to import the file now, changing the date format into Y-m-d
However in Europe we all use d/m/Y
Is there a way I can change the Price import to have also the d/m/Y format instead, for future cases.
the option to change the date format seems not available in import, only on export.

Thanks, Jo
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jo,
Thank you for posting the requested files. The problem is with date format. In the export template on File tab change the date format from d/m/Y H:i:s to Y-m-d H:i:s. See attached screenshot. Run the export then import and see if the dates are imported.
Attachments (1)
Screenshot 2022-06-20 at 3.36.59 PM.png Screenshot 2022-06-20 at 3.36.59 PM.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. # 3
jo.vandriessche@jodela-it.be
jo.vandriessche@jodela-it.be
Accepted Answer Pending Moderation
Hi Tharuna,
Enclosed the log file and the importfile.
I can't see any error, but still the date fields remain empty.
Thanks for looking into it.
regards, Jo
Attachments (2)
com_csvi.log.60.zip
CSVI_Example J2Store Price Export_19-06-2022_11.34.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please also post the import debug log to check. To get the debug log check How to collect debug information? document.
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. # 5
  • Page :
  • 1


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