As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3982919
Automatin
Open

Comments

  •  14
    Milan started the conversation
    May 3, 2025 at 9:17am

    Hi,

    i have multiple people who give workshops at multiple location. Every workshop date is an event.

    That is why i have a lot of work creating and editing events and event dates, times and info.

    Is there any way to automate this with google sheets and AI?

    Do you have any tip for me about how to optimize the process of creating and updating events?

    Best regards

    Milan

  •  1,718
    Uroš replied
    May 5, 2025 at 12:02pm

    Hello Milan,

    Thank you for reaching out.

    Unfortunately, Amelia does not support any automation for creating or updating events via Google Sheets or AI. All events must be managed manually within the plugin.

    Let me know if you have any other questions.

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  14
    Milan replied
    2 weeks ago on May 23, 2025 at 11:13am

    Hi, is there any chance to enter ney events with sql?

    And is there is, could you provide the sql for that?

    Best regards

    Milan

  •  1,718
    Uroš replied
    2 weeks ago on May 27, 2025 at 10:32am

    Hello Milan,

    Yes, it is technically possible to insert new events into the database using SQL. Below is the SQL template for inserting into the wp_amelia_events table:

    INSERT INTO `wp_amelia_events` ( `id`, `parentId`, `name`, `status`, `bookingOpens`, `bookingCloses`, `bookingOpensRec`, `bookingClosesRec`, `ticketRangeRec`, `recurringCycle`, `recurringOrder`, `recurringInterval`, `recurringMonthly`, `monthlyDate`, `monthlyOnRepeat`, `monthlyOnDay`, `recurringUntil`, `maxCapacity`, `maxCustomCapacity`, `maxExtraPeople`, `price`, `locationId`, `customLocation`, `description`, `color`, `show`, `notifyParticipants`, `created`, `settings`, `zoomUserId`, `bringingAnyone`, `bookMultipleTimes`, `translations`, `depositPayment`, `depositPerPerson`, `fullPayment`, `deposit`, `customPricing`, `organizerId`, `closeAfterMin`, `closeAfterMinBookings`, `aggregatedPrice`, `error` ) VALUES ( '[value-1]', '[value-2]', '[value-3]', '[value-4]', '[value-5]', '[value-6]', '[value-7]', '[value-8]', '[value-9]', '[value-10]', '[value-11]', '[value-12]', '[value-13]', '[value-14]', '[value-15]', '[value-16]', '[value-17]', '[value-18]', '[value-19]', '[value-20]', '[value-21]', '[value-22]', '[value-23]', '[value-24]', '[value-25]', '[value-26]', '[value-27]', '[value-28]', '[value-29]', '[value-30]', '[value-31]', '[value-32]', '[value-33]', '[value-34]', '[value-35]', '[value-36]', '[value-37]', '[value-38]', '[value-39]', '[value-40]', '[value-41]', '[value-42]', '[value-43]' );

    ⚠️ Important Note:
    Directly interacting with the database via SQL is risky and not officially supported. It bypasses all validation, triggers, and internal logic Amelia uses when creating an event through the dashboard — so it can lead to data corruption or malfunction if not done properly.

    Let me know if you need help filling in any specific values or want an example with real data.

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables