Import past events??

  • Resolved catwingz

    (@catwingz)


    2 years, 7 months ago

    Hi, this is a pre-installation question but I’m leaving the option of support open. This website has been using the MF Gig Calendar plugin for a long time, eight years. If it’s not updated soon we’ll be looking for a replacement. At this point your plugin is a strong candidate because the two share the ability to show past events.

    However, this raises the question of whether it is possible to import past events into the plugin or not. If so, how would we go about this?

    Thank you

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Guido

    (@guido07111975)

    Hi,

    Main thing is that we make the database tables of your old plugin match the tables of the VSEL plugin.

    Your plugin has similar structure as mine, these are the tables:

    
start_date
end_date
time
location
details

    Time value may be different, not certain right now.

    Are you able/willing to share an export file of your events at your website?

    Guido

    Thread Starter catwingz

    (@catwingz)

    Hi,

    The plugin doesn’t appear to have an export feature. If there is a way to do this from the database I am able to follow instructions.

    Thank you

    Plugin Author Guido

    (@guido07111975)

    Hi,

    Did take a look at the site of the developer. It seems plugin structure is different from mine, there’s only 1 database table according to these replies:

    About export feature:
    there isn’t one built into the plugin specifically. You could use the RSS feed easily enough. Or you could use phpMyAdmin to export the database table

    About name of table:
    wp_mfgigcal (or something similar depending on what prefix you assigned to WP when you set it up).

    Guido

    Thread Starter catwingz

    (@catwingz)

    Where can I send an export file to? Or since the structure is different would this be of any use?

    Plugin Author Guido

    (@guido07111975)

    Hi,

    It may not work because it looks like it stores everything in a single table and there’s no own custom post type such as event..

    I notice a contact form at the website that you’ve provided in your profile. I can use that?

    Guido

    Plugin Author Guido

    (@guido07111975)

    Hi again,

    I did some testing on my own and it’s possible to export your events from the database as CSV-file (using phpMyAdmin) and to import them again using an import plugin. Only thing I had to do is to match your values with the ones from my plugin. But I have to find a free plugin to import custom fields as well. Used the WP All Import plugin but for custom fields I need pro-version.

    Guido

    Plugin Author Guido

    (@guido07111975)

    Hi again,

    With the WP Import Export Lite plugin I can also import the custom fields. It works, events are imported. Only problem I’m having are the dates. VSEL stores dates as UTC-timestamp, your plugin doesn’t. So I have to find a solution for this.

    Guido

    Plugin Author Guido

    (@guido07111975)

    Only problem I’m having are the dates. VSEL stores dates as UTC-timestamp, your plugin doesn’t. So I have to find a solution for this.

    Just found out you can change normal dates into UNIX-timestamps in Excel.

    So: yes, your events can be imported into VSEL.

    Guido

    Thread Starter catwingz

    (@catwingz)

    Hi,

    I actually just added a website to my profile. It would be more direct but you can use the contact form on either website. This is a client site I’m working on. Today I’ll work on getting the export from the database.
    Thank you for the awesome support!

    Plugin Author Guido

    (@guido07111975)

    Hi,

    Have send you a message via your website.

    Guido

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Import past events??’ is closed to new replies.