Bug with Excel conversion and dates - VisualCron - Forum

Community forum

AmTech
2016-02-29T12:48:24Z
Morning,

There is a problem with converting dates in Excel to csv using the 'Excel Convert' job type.

In 6.1.5 it used to convert the dates to a integer. (an OADate if you will) However between 6.1.5 and 8.0.2 the handling of dates has been changed. It now seems to try to export them as a string, presumably using the format of the original cell. However it doesn't appear to work all the time. Some styles are begin converted to strings that are of no use.

I created an Excel sheet with today's date and various formats and converted it using 8.0.2. Attached are the results.

Converting yyyy-mm-dd is really strange as Visual Cron exports this as 2016-00!

  DateTest.xlsx (10kb) downloaded 32 time(s).  DateTest-8_0_2.txt (1kb) downloaded 33 time(s).  DateTest-6_1_5.txt (1kb) downloaded 33 time(s).
Support
2016-02-29T14:14:00Z
It seems like the format in your Excel file contains a lot of junk characters but we have tried to clean it up. Please test this version:

http://www.visualcron.co....aspx?g=posts&t=5506 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
AmTech
2016-02-29T14:21:15Z
They are standard Excel 2010 formats, not custom ones. See: http://i.imgur.com/73vVUCE.png 

Edit: the client claims we're on the latest version. http://i.imgur.com/E57dmkI.png 
Support
2016-02-29T14:30:03Z
Ok, but they do contain a lot of junk that we need to filter out as the parsing is done half-automatically. Please try the latest.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
AmTech
2016-02-29T14:37:59Z
Originally Posted by: Support 

Ok, but they do contain a lot of junk that we need to filter out as the parsing is done half-automatically. Please try the latest.



You'll have to take that up with Microsoft!

Installed the beta 8.0.3, things look better, but its still malformed.

For example '29 00' and 'Monday' in the output file below.

  DateTest-8_0_3beta.txt (1kb) downloaded 32 time(s).
Support
2016-02-29T18:29:05Z
Originally Posted by: AmTech 

Originally Posted by: Support 

Ok, but they do contain a lot of junk that we need to filter out as the parsing is done half-automatically. Please try the latest.



You'll have to take that up with Microsoft!

  DateTest-8_0_3beta.txt (1kb) downloaded 32 time(s).



Sure 😁

Originally Posted by: AmTech 

Originally Posted by: Support 


Installed the beta 8.0.3, things look better, but its still malformed.

For example '29 00' and 'Monday' in the output file below.



Can you tell us which output format you expect for these two?



Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
AmTech
2016-03-01T09:31:47Z
I'd have thought they should appear as they do in Excel.

So like this: http://i.imgur.com/v2hfONW.png  (Actual versions from 8.0.3 are shown along side.)
Support
2017-12-29T10:39:13Z
Scroll to Top