Date Format in sales exports

  • Posts: 37
  • Thank you received: 0
11 years 8 months ago #94189

What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided.

Thanks,

DAve

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
11 years 8 months ago #94388

I'm not sure if you're talking about the CSV of the sales reports of the CSV of the orders.
The sales reports CSV uses the RFC 822 format and the orders CSV use the format %Y-%m-%d %H:%M:%S

Normally, you can change the date format in excel options so that the date get properly recognized:
stackoverflow.com/questions/12766595/dat...wertab=votes#tab-top

Please Log in or Create an account to join the conversation.

  • Posts: 37
  • Thank you received: 0
11 years 8 months ago #94392

Hmmm nope. I have this in MySQL and the orders export CSV for the order_modified field.

1331044648

Excel doesn't recognize it. RFC 822 is an email RFC.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
11 years 8 months ago #94399

That's the unix timestamp of the date. You must be using an old version of HikaShop as the CSVs use human readable format for dates since a few releases.

Please Log in or Create an account to join the conversation.

  • Posts: 37
  • Thank you received: 0
11 years 8 months ago #94400

We are on 1.5.6. We made a lot of modifications so we were hesitant to upgrade. It works pretty well with no real problems, so the desire was not there. We have a business subscription, but I don't know that we will upgrade until we upgrade Joomla.

Sorry for not noticing the format, it just did not jump out at me that it was a Unix Time Stamp.

Thanks,

DAve

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum