jhetrick62

Marketing Master,

Not sure why you are having so much trouble with the em.com/importer-exporter. As I stated in posts on Pg#1, I did add the modification for date/time that Steve098 suggested and had no issues after that. I’m able to import locations no issues. It seems to import them IF they are properly defined as the same in WP where it creates another location that is blank if you have a name that isn’t in your WP directory.

Do yourself a favor and use Open Office or Libre Office to create your csv file. I used open office. It’s just that much easier and more predictable that Excel. I was struggling to keep the date/times correct in Excel. No issue at all in Open Office. This should solve your date/time issues as long as you use the patch Steve had and use the proper formatting for it. Mine worked like a snap.

As far as Categories, I’m betting that based upon my limited knowledge of databases and how they work, you can’t import more than 1 category as if there is only 1 category header, it will fail and either grab the 1st one or the last one. Meaning if there are headers for cat1, cat2, cat 3 ect. then it would work. There is only 1 heading for categories inside the import template, so I’m confident that won’t work.

Jeff

Marketing,

I haven’t looked at this export_LIGHT.xlsx file yet, but in general, it depends on how your excel file exports to a .csv file for importing. Have you opened your file in a clear text editor such as Wordpad or Notepad, or even better yet a linux editor to see if it truly meets the criteria?

I find that working in OpenOffice which is free, is highly better than working in Excel when manipulating the export of spreadsheet files to .csv file.

Ok, you were correct and I have it fixed! For all Hostgator accounts and possibly many of the other entities that the conglomerate that owns them also owns, you have to put a code snippet into your .htaccess file on a Linux Shared host. It enables the PHP 5.3 code in each domain. You would have to add it for each domain if you needed it in more than 1 of course. There are other help notes for Windows Shared or VPS hosting, this one is Linux Shared specific if your host is not running 5.3. Newer builds will be running 5.3.

Here is the code so that you don’t have to do the research.

# Use PHP 5.3
AddType application/x-httpd-php53 .php

Thanks to Steve098 for his re-engineered code to make the date import work and hopefully this post saves someone else 2 hours of playing with their dates in frustration as I did last night.

You are correct! 5.2.17 on PHP! I will have to find the code for the earlier version I guess? I doubt that it can be upgraded as this is a shared host, not a VPS at this point.

Sorry, about the double post! My mistake. I will look that up now.

I do appreciate the work of Steve as well as Marcus for pointing us to the importer. It does work well, except that I can’t get the dates to work myself. If I put in the fix that Steve suggested, I get a class error and that is throwing me off. I get the code that he put in and it appears correct, but doesn’t work for me for some reason.

I did output my file to Textwrangler on my Mac to verify and it is formatted properly,
,07/08/2013 16:00:00,07/08/2013 18:00:00,
That is the dtstart and dtend portion of my file in the line above. Here is the error I get, which I’m not sure as to why:

>> Error
Call to undefined function date_create_from_format() in /home4/jhetrick/public_html/demo-mm/wp-content/plugins/events-manager-import-export-0.0.3-alpha/class.EM_ImpExpImport.php on line 483
<< End of error

Seems to be a php error code and I’m not that good with this stuff. Maybe with an hour or so on Google I can figure it out, but I’m running fully updated WP. I can check my host for PHP and MySql versions.

Any thoughts?

I do appreciate the work of Steve as well as Marcus for pointing us to the importer. It does work well, except that I can’t get the dates to work myself. If I put in the fix that Steve suggested, I get a class error and that is throwing me off. I get the code that he put in and it appears correct, but doesn’t work for me for some reason.

I did output my file to Textwrangler on my Mac to verify and it is formatted properly,
,07/08/2013 16:00:00,07/08/2013 18:00:00,
That is the dtstart and dtend portion of my file in the line above. Here is the error I get, which I’m not sure as to why:

>> Error
Call to undefined function date_create_from_format() in /home4/jhetrick/public_html/demo-mm/wp-content/plugins/events-manager-import-export-0.0.3-alpha/class.EM_ImpExpImport.php on line 483
<< End of error

Seems to be a php error code and I’m not that good with this stuff. Maybe with an hour or so on Google I can figure it out, but I’m running fully updated WP. I can check my host for PHP and MySql versions.

Any thoughts?

Matt, I’m running 2.7.1 Visual Form Builder Pro. Has the patch for that been released yet as It’s not showing up in my WP install and I had a customer complaint about this very error today?

Thank you.