PVsyst v6: Inconsistent Date Format in Hourly Output .CSV File

[kjs55]

PVsyst v6.8.0. The date column of the output CSV file varies back and forth several times from this format:

12/11/2018 11:00:00 PM

To this format:

13/11/18 00:00

Steps to see this: 1.) Run simulation, 2.) Save hourly output CSV file, 3.) Open in Excel, 4.) Convert text to columns via semicolon delimiter, 5.) Look at date column

Is this bug fixed in PVsyst v7?

[jtp4652]

On 9/25/2020 at 2:57 PM, kjs55 said:

PVsyst v6.8.0. The date column of the output CSV file varies back and forth several times from this format:

12/11/2018 11:00:00 PM

To this format:

13/11/18 00:00

Steps to see this: 1.) Run simulation, 2.) Save hourly output CSV file, 3.) Open in Excel, 4.) Convert text to columns via semicolon delimiter, 5.) Look at date column

Is this bug fixed in PVsyst v7?

Have you found a fix to this issue?

[aspf]

Hi, I am running on ver 7.4.8 and i also faced the same issue. I have problems extracting respective day, month, hour and minute values from the raw data (1st column) despite trying "text to columns". Is it a bug from PVsyst and is there a way to fix this? The additional steps to reformat the date are taking up more time than expected. 

 

 

[Michele Oliosi]

Hi, It's more likely a problem of compatibility of the PVsyst output with the regional format on your Excel/Windows installation.

In PVsyst you can try changing the format and see if anything helps
 

There are also more options on Excel, but I'm no expert there:

[Michele Oliosi]

If you can, let us know what you find that would be great.