|
Philip Wall
|
November 27, 2014 at 3:24 am
Hi, I have 87 events and need to backup/restore my site. On doing this the date format has been reversed from d/m/yr to the US format of m/d/yr which has now hidden most of my event sale start dates. Is there an easy way of fixing this? I initially had tried to export all my events a .csv format to remove one line of text from all my events and on deleting my events and re-importing I got an error on importing Date/Time Event Created[EVT_created]. That’s why I did the restoration. Any ideas?
|
|
Tony
|
November 27, 2014 at 3:35 am
Hi Philip,
How did you backup/restore the events?
Did you use a full database backup or export the events them import then?
|
|
Philip Wall
|
November 27, 2014 at 3:45 am
Hi Tony,
Apologies for the confusion. I did a full database backup using managewp .com (as I had deleted the events prior to that.)
|
|
Philip Wall
|
November 27, 2014 at 3:49 am
Initially when I had selected all events and exported them, I opened them up excel, (deleted the line of text from each event I didn’t need) saved as a .csv and tried to import into event espresso, which recognised I was trying to import into the same database, and failed on importing Date/Time Event Created[EVT_created].
|
|
Philip Wall
|
November 27, 2014 at 4:07 am
This was the error message on importing the normal way:
CSV Data appears to be from the same database, so attempting to update data
The following errors have occurred:
Could not update Event with the csv data: ‘EVT_name=Leopardstown+Pre-Marriage+Course&EVT_desc=test&EVT_slug=test-bewley&EVT_created=17%2F10%2F2014+16%3A45&EVT_short_desc=&EVT_modified=17%2F10%2F2014+17%3A56&EVT_wp_user=1&parent=0&EVT_order=0&status=publish&EVT_display_desc=0&EVT_display_ticket_selector=1&EVT_visible_on=17%2F10%2F2014+15%3A45&EVT_additional_limit=2&EVT_default_registration_status=RPP&EVT_member_only=0&EVT_phone=&EVT_allow_overflow=0&EVT_timezone_string=&EVT_external_URL=&EVT_donations=0’ for an unknown reason (using WHERE conditions EVT_ID=123)
EE_CSV – save_csv_to_db – 522
|
|
Tony
|
November 27, 2014 at 4:17 am
So you created your events, exported them to CSV, restored to a backup with no events, then imported the events once again?
What is set within Dashboard -> General Settings -> Date format?
Is it possible for you to link me to the site so I can what is happening?
|
|
Philip Wall
|
November 27, 2014 at 5:15 am
Hi Tony, I created my events, exported them, thrashed (and then finally deleted them) and then imported them using the EE import tool. This created the error. So I then restored the website from a backup I had made (using managewp.com): The General settings: Date Format is Date Format November 27, 2014 (Custom: November 27, 2014).
The events will not show on the front end as the the event sale start date has changed as a result.
Do you need access to the back-end? http://www.avalonrc.ie/wordpress/event-category/athlone-courses/
|
|
Tony
|
November 27, 2014 at 6:01 am
That may be easier.
If you can use this form to send temporary login details:
https://eventespresso.com/send-login-details/
I’ll see what I can find.
|
|
Philip Wall
|
November 27, 2014 at 7:21 am
Form sent. Thanks
|
|
Tony
|
December 2, 2014 at 4:40 am
Updating this thread with the current findings for any future readers.
The reason the events switched the days and months is was due to the file being edited within MS Excel. When the events are exported they use the MySQL date format which is YYYY-MM-DD. However when you open up the CSV in MS Excel it will automatically format the date to (usually) DD-MM-YYYY, we had some code in place to try and continue with the imports by checking if the date format had changed and tried to use MM-DD-YYYY then if that also failed DD-MM-YYYY.
The problem with this (besides Excel not allowing you to disable this auto format) is that events like 05/12/2014 cause problems, was that intended as December 5th or May 12th?
So considering MS Excel is likely the most used Spreadsheet editor, we are considering swapping this check to first check for DD-MM-YYYY.
Currently to avoid this issue do not use MS Excel to edit the CSV files, the auto date format function can not be disabled so will always cause this problem (it also appears that the date format may possibly change depending on you location settings). OpenOffice appears to leave the dateformat as is and causes no issues, also using a text editor such as Sublime Text will also preserver the current date.
The other error when importing events the normal way is a bug within the event importer that we have a ticket to address in a future version. The import function is checking for details within the CSV (the site URL) and if it matches your currently URL, or a URL that has previously imported events, it will try to update the events with the new values within the CSV, if the events have been deleted, this fails.
|
|
Philip Wall
|
December 5, 2014 at 8:19 am
Hi Tony,
the good news is that the dates all worked with that import. I did get one error on import (which I have included in a screenshot below). What I noticed though is that none of the venues originally assigned to the events have imported. So all events have no venues. There are also no tickets showing as setup (as per the originals). One thing gets fixed and 2 others disappear. Typical lol. Maybe a suggestion for the next update is an option to bulk add events to a venue in the edit option.
P.S. Within the Events, the events are not associated with their original Event Categories either.
|
