All or alot of imported events apprea on same date (today)

Need help with VueMinder Pro or Ultimate? Ask your questions here.
slouw
Posts: 68
Joined: Tue Mar 07, 2017 3:42 pm

All or alot of imported events apprea on same date (today)

Post by slouw » Mon Apr 30, 2018 3:06 am

I am importing this CSV and I get a whole lot of events on the same day.
Not all but a lot, looks like most.
Tried twice.
Am I doing something wrong?
Upgraded to 2018.01 recently.
Image and CSV file attached

Image
Attachments
2018-04-30 17h58m 09 Vueminder Import.png
2018-04-30 17h58m 09 Vueminder Import.png (116.65 KiB) Viewed 2920 times
2018-04-25 TLaw Kids_007.csv
(2.68 KiB) Downloaded 221 times

User avatar
VueSoft
Dan Chartrand
Posts: 3863
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: All or alot of imported events apprea on same date (toda

Post by VueSoft » Mon Apr 30, 2018 10:59 pm

Hi slouw, VueMinder assumes the date format in the CSV file matches the date format configured in the regional settings of Windows.

In your CSV file, you have some dates formatted like "12/5/2018", which import correctly, but others formatted like "26-05-2018", which don't follow the expected format. When VueMinder is unable to process a date, it will default to today's date.

To fix the problem, replace the dashes in your CSV file with forward slashes, so all the dates are consistent with your Windows regional settings. Does that fix it?
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

slouw
Posts: 68
Joined: Tue Mar 07, 2017 3:42 pm

Re: All or alot of imported events apprea on same date (toda

Post by slouw » Tue May 01, 2018 1:56 am

My regional settings are as shown.
These are purposefully set as YYYY-MM-DD and my spreadsheet is... opps DD-MM-YYYY. Wrong.
Fix the spreadsheet fixes the problem.
Much appreciated :)
Attachments
2018-05-01 16h17m 00 regional settings.png
2018-05-01 16h17m 00 regional settings.png (47.22 KiB) Viewed 2914 times

Post Reply