|
Nancy Meijer
|
September 5, 2014 at 9:41 am
Hi guys,
I love your plugin. But unfortunately I can’t import my event from one site to another. I’ve really tried several things.
Both are working on the 4.3.2.p versions.
It gives these errors
The following errors have occurred:
The column titled ?”Event Espresso Export Meta Data” is invalid for importing. It must be be in the format of ‘Nice Name[model_field_name]’ in row ?”Event Espresso Export Meta Data”
No file seems to have been uploaded
I’ve made a video, you can see it here
http://screencast.com/t/nAHlTkp9Vr
The file I’ve exported and trying to import can be downloaded here
http://cl.ly/1Z2N2F3u3D3o/test.csv
|
|
Josh
|
September 5, 2014 at 12:15 pm
Hi Nancy,
It turns out that this is a bug we discovered within the last week. We’ll be releasing a fix in an upcoming release, but in the meantime if you can FTP in to your site and change one line of code you can apply the same fix.
It’s in core/db_classes/EE_CSV.class.php on line 185
change this:
if($data[0] == EE_CSV::metadata_header){
to this:
if( strpos( $data[0], EE_CSV::metadata_header ) !==FALSE ){
|
|
Nancy Meijer
|
September 5, 2014 at 1:09 pm
Thanks for you reply.
I still get some errors. Can you please help me get rid of those 🙂
CSV Data appears to be from a different database (http://www.nvvl.nl instead of http://www.sportdietetiek.nl), so we assume IDs in the CSV data DO NOT correspond to IDs in this database
We noticed you have imported data via CSV from http://www.nvvl.nl before. Because of this, IDs in your CSV have been mapped to their new IDs in http://www.sportdietetiek.nl
The following errors have occurred:
Could not update Event with the csv data: ‘EVT_name=Sportvoedingscongres&EVT_desc=Thema%3AInterpreteren+van+trainingsschema%27s+en+inspelen+op+periodisering&EVT_slug=sportvoedingscongres&EVT_created=2014-09-04+15%3A28%3A42&EVT_short_desc=&EVT_modified=2014-09-04+17%3A40%3A26&EVT_wp_user=1&parent=0&EVT_order=0&status=private&EVT_display_desc=0&EVT_display_ticket_selector=1&EVT_visible_on=2014-09-02+16%3A26%3A47&EVT_additional_limit=1&EVT_default_registration_status=RAP&EVT_member_only=0&EVT_phone=0345+630+480&EVT_allow_overflow=0&EVT_timezone_string=&EVT_external_URL=&EVT_donations=0’ for an unknown reason (using WHERE conditions EVT_ID=466)
Could not update Datetime with the csv data: ‘EVT_ID=466&DTT_name=Details+Sportvoedingscongres&DTT_description=&DTT_EVT_start=2014-11-10+09%3A45%3A00&DTT_EVT_end=2014-11-10+16%3A00%3A00&DTT_reg_limit=INF&DTT_sold=6&DTT_is_primary=0&DTT_order=1&DTT_parent=0&DTT_deleted=0’ for an unknown reason (using WHERE conditions DTT_ID=3)
Could not update Ticket with the csv data: ‘TTM_ID=0&TKT_name=VSN+Leden&TKT_description=&TKT_start_date=2014-09-02+16%3A22%3A00&TKT_end_date=2014-10-31+17%3A00%3A00&TKT_min=0&TKT_max=INF&TKT_price=0&TKT_sold=3&TKT_qty=INF&TKT_uses=INF&TKT_required=0&TKT_taxable=0&TKT_is_default=0&TKT_order=1&TKT_row=1&TKT_deleted=0&TKT_parent=0’ for an unknown reason (using WHERE conditions TKT_ID=4)
Could not update Ticket with the csv data: ‘TTM_ID=0&TKT_name=Niet+Leden+%28en+stagiares%29&TKT_description=&TKT_start_date=2014-09-04+15%3A23%3A00&TKT_end_date=2014-10-31+17%3A00%3A00&TKT_min=0&TKT_max=INF&TKT_price=50&TKT_sold=3&TKT_qty=INF&TKT_uses=INF&TKT_required=0&TKT_taxable=0&TKT_is_default=0&TKT_order=2&TKT_row=2&TKT_deleted=0&TKT_parent=0’ for an unknown reason (using WHERE conditions TKT_ID=5)
Could not update Datetime_Ticket with the csv data: ‘DTT_ID=3&TKT_ID=4’ for an unknown reason (using WHERE conditions DTK_ID=3)
Could not update Datetime_Ticket with the csv data: ‘DTT_ID=3&TKT_ID=5’ for an unknown reason (using WHERE conditions DTK_ID=4)
Could not update Price with the csv data: ‘PRT_ID=1&PRC_amount=0&PRC_name=VSN+Leden&PRC_desc=&PRC_is_default=0&PRC_overrides=0&PRC_order=1&PRC_deleted=0&PRC_parent=0’ for an unknown reason (using WHERE conditions PRC_ID=5)
Could not update Price with the csv data: ‘PRT_ID=1&PRC_amount=50&PRC_name=Niet+Leden+%28en+stagiares%29&PRC_desc=&PRC_is_default=0&PRC_overrides=0&PRC_order=1&PRC_deleted=0&PRC_parent=0’ for an unknown reason (using WHERE conditions PRC_ID=6)
Could not update Ticket_Price with the csv data: ‘TKT_ID=4&PRC_ID=5’ for an unknown reason (using WHERE conditions TKP_ID=4)
Could not update Ticket_Price with the csv data: ‘TKT_ID=5&PRC_ID=6’ for an unknown reason (using WHERE conditions TKP_ID=5)
Could not update Term_Relationship with the csv data: ‘object_id=466&term_taxonomy_id=20&term_order=0’ for an unknown reason (using WHERE conditions object_id=466&term_taxonomy_id=20)
Could not update Term_Relationship with the csv data: ‘object_id=466&term_taxonomy_id=27&term_order=0’ for an unknown reason (using WHERE conditions object_id=466&term_taxonomy_id=27)
Could not update Event_Venue with the csv data: ‘EVT_ID=466&VNU_ID=467&EVV_primary=1’ for an unknown reason (using WHERE conditions EVV_ID=1)
Could not update Question_Group with the csv data: ‘QSG_name=NVVL+Details+Sportvoedingscongres&QSG_identifier=Sportvoedingscongres&QSG_desc=Details+Sportvoedingscongres&QSG_order=3&QSG_show_group_name=1&QSG_show_group_desc=0&QSG_system=0&QSG_deleted=0’ for an unknown reason (using WHERE conditions QSG_ID=3)
Could not update Event_Question_Group with the csv data: ‘EVT_ID=466&QSG_ID=1&EQG_primary=1’ for an unknown reason (using WHERE conditions EQG_ID=3)
Could not update Event_Question_Group with the csv data: ‘EVT_ID=466&QSG_ID=3&EQG_primary=1’ for an unknown reason (using WHERE conditions EQG_ID=4)
Could not update Question with the csv data: ‘QST_display_text=Wilt+u+gebruik+maken+van+gratis+busvervoer+van+het+station+in+Geldermalsen+naar+Geofort%3F&QST_admin_label=gratis+busvervoer&QST_system=&QST_type=SINGLE&QST_required=1&QST_required_text=Wij+willen+graag+weten+of+u+gebruik+maakt+van+het+gratis+busvervoer+naar+Geofort+of+niet&QST_order=11&QST_admin_only=0&QST_wp_user=1&QST_deleted=0’ for an unknown reason (using WHERE conditions QST_ID=11)
Could not update Question with the csv data: ‘QST_display_text=Geeft+hieronder+uw+1e+voorkeur+voor+een+workshop+aan&QST_admin_label=workshop+1&QST_system=&QST_type=SINGLE&QST_required=1&QST_required_text=Wij+willen+graag+weten+naar+welke+workshop+uw+voorkeur+uitgaat&QST_order=12&QST_admin_only=0&QST_wp_user=1&QST_deleted=0’ for an unknown reason (using WHERE conditions QST_ID=12)
Could not update Question with the csv data: ‘QST_display_text=Geeft+hieronder+uw+2e+voorkeur+voor+een+workshop+aan&QST_admin_label=workshop+2&QST_system=&QST_type=SINGLE&QST_required=1&QST_required_text=Wij+willen+graag+weten+naar+welke+workshop+uw+voorkeur+uitgaat&QST_order=13&QST_admin_only=0&QST_wp_user=1&QST_deleted=0’ for an unknown reason (using WHERE conditions QST_ID=13)
Could not update Question_Group_Question with the csv data: ‘QSG_ID=3&QST_ID=11&QGQ_order=0’ for an unknown reason (using WHERE conditions QGQ_ID=11)
Could not update Question_Group_Question with the csv data: ‘QSG_ID=3&QST_ID=12&QGQ_order=1’ for an unknown reason (using WHERE conditions QGQ_ID=12)
Could not update Question_Group_Question with the csv data: ‘QSG_ID=3&QST_ID=13&QGQ_order=2’ for an unknown reason (using WHERE conditions QGQ_ID=13)
‘One or more errors occurred, and a total of 22 existing records in the database were not updated.’
|
|
Tony
|
September 5, 2014 at 2:52 pm
Hi Nancy,
Unfortunately we can not see any reason for those errors, as they all state ‘for an unknown reason’
Would it be possible for you to email us a copy of the CSV file? I’d like to take a look and see if I can see a cause there. If so could you send to support[at]eventespresso.com be sure to include a reference to this thread so know what is it for.
|
