Other Documentations

** How to Troubleshoot CSV Import IssuesActions & Filters of RSVP AddonAuto Complete Ticket OrderAuto re-stocking refunded, cancelled or failed ordersBookings General User GuideChangelog ActionUser Paid Feature EventsChangelog Event ReviewerChangelog Event WishlistChangelog for ActionUserChangelog for ActionUser PlusChangelog for Advent CalendarChangelog for BookingsChangelog for CountdownChangelog for CSV ImporterChangelog for DailyViewChangelog for event APIChangelog for Event Dynamic PricingChangelog for Event Lists Ext.Changelog for Event Photos PlusChangelog for Event SearchChangelog for Event SeatsChangelog for Event SliderChangelog for Event TicketsChangelog for Events MapChangelog for FullCalChangelog for ICS ImporterChangelog for Include Anything AddonChangelog for Lists & ItemsChangelog for Moon Data AddonChangelog for PDFerChangelog for QRcodeChangelog for RemindersChangelog for Repeat CustomizerChangelog for RSS feedChangelog for RSVP EventsChangelog for RSVP Events InviteesChangelog for RSVP Events WaitlistChangelog for RSVP Points AddonChangelog for Single EventsChangelog for Speakers & ScheduleChangelog for SubscriberChangelog for Sync EventsChangelog for Weekly ViewChangelog Variations & OptionsChangelog Virtual PlusChangelog YearlyViewDynamic Pricing User Guide(Settings Overview)General Guide to Using the AddonGetting StartedHow to add additional data to confirmation emailHow to add additional fields at checkoutHow to add additional fields to download attendees CSV fileHow to add additional fields to event submission formHow to Add Extra Event Data to the JSON OutputHow to add more additional fields for RSVP formHow to add more google calendar profile supportHow to add sidebar to single events pageHow to add support for additional ICS fieldsHow to Add Variations to Booking BlocksHow to assign users to EventsHow to create a facebook APPHow to customize event feed with argumentsHow to customize RSVP emailsHow to customize single event pageHow to customize the invitation emailHow to customize ticket email templateHow To Fix Broken Virtual Events Join LinkHow to get startedHow to get startedHow to Give Access to User RolesHow to Install and use the Advent Calendar addonHow to Install and use the DailyView addonHow to Install and use the Event Countdown addonHow to Install and use the Event Dynamic Pricing addonHow To Install and Use the Event Photos PlusHow To Install and Use the Event Reviewer addonHow to Install and Use the Event Slider addonHow to Install and use the Events Map addonHow to Install and Use the FullCal addonHow To Install and Use the Include Anything AddonHow To Install and Use the Moon Data AddonHow to Install and use the Virtual Plus addonHow to manage capacity separately for repeat eventsHow to open RSVP form inside eventcardHow To Sell Price Options as Separate Tickets with the Ticket Variations & Options AddonHow to Sell Variations as Separate Tickets With the Ticket Variations & Options AddonHow to set up additional fields for RSVPHow To Set Up and Use Schedules with the Speakers and Schedule AddonHow To Set Up and Use Speakers with the Speaker AddonHow to Set Up and Use the Subscriber AddonHow to Set up and Use the Variations & Options AddonHow to set up Event TicketsHow to Set Up Front-end Event Manager for UsersHow to set up RSS addonHow to Set Up Seat Layout Map from the Admin DashboardHow to set up variable prices for TicketsHow To Set Up Virtual Events with Jitsi™ MeetHow to Setup ActionUser PlusHow to setup reminders for RSVPHow to setup reminders for TicketsHow to show only certain event types calendar on another siteHow To Stop Duplicating Images In CSV ImportsHow to use QR Code addon and check-in attendeesHow to use scanner gun to check in guestsHow to Use the Autogenerator to Create Booking BlocksHow To Use Webhooks in EventON with RSVP Trigger EventsImport Additional Fields Using HooksJSON Data structureMake Google Calendar public and Calendar IDShow events from current logged-in userSingle events page not working 404 error** How to Troubleshoot CSV Import IssuesChangelog for CSV ImporterHow To Stop Duplicating Images In CSV ImportsImport Additional Fields Using Hooks** What to check if eventON is not workingHow to debug for PHP code errorsHow to debug Javascript interactive issuesHow to find if an issue is coming from eventONHow To Fix Broken Virtual Events Join LinkHow to fix font awesome icons not working on your siteHow to fix style override issuesHow To Stop Duplicating Images In CSV ImportsIncreasing the WordPress Memory LimitWhy is Location Google Map grayed out or not displayed on Event Card
Home > Documentations > Addons > CSV Importer > How To Stop Duplicating Images In CSV Imports

How To Stop Duplicating Images In CSV Imports

June 16, 2022

Migrating events from one site to another or from one calendar to your EventON calendar should be hassle-free. In order to start importing events, you will need to have at least EventON 2.6 and the CSV Event Importer addon installed.

In this tutorial, we are going to be going through some steps that you can take to prevent duplicate images in your media gallery after a successful event import.

Formatting your CSV file

We recommend starting off the import process by copying and modifying the sample.csv file that comes with the addon after purchase. By default, the addon accepts the following CSV columns that should be used as headers on your CSV file:

  • publish_status – Publish status of the event: publish | draft
  • event_id (int) – Event post ID, if passed, event with this id will be updated with meta data
  • featured – Feature an event or no eg yes | no
  • color – Hex color for the event without # sign
  • event_name – Name of the event
  • event_description – Event main description
  • event_start_date & event_end_date – Start/End date in format mm/dd/YYYY
  • event_start_time & event_end_time – Start/End time in format h:mm:AM/PM
  • Location Fields:
    • location_name => Event location Name
    • event_location => Event location complete address
    • evcal_location_link => Location Link (http://)
    • evo_location_id => Location taxonomy term ID
  • Organizer Fields:
    • event_organizer => Organizer Name
    • evcal_org_contact => Organizer contact information eg. email
    • evcal_org_address => Organizer location address
    • evcal_org_exlink => Organizer external link (http://)
    • evo_organizer_id => Organizer taxonomy term ID
  • event_gmap – Generate google maps from address. eg yes | no
  • evcal_subtitle – Event Subtitle
  • all_day – All day event eg. yes | no
  • hide end time -Hide end time for event eg. yes | no
  • event_type categories – Event type category term IDs separated by commas eg. 4,19. You can add up to 5 event type categories in separate columns with column headers in format event_type, event_type_2, etc.
  • Custom Meta Fields:
    • cmd_{x} => Custom meta data values. You can add upto 10 custom meta field values with sepeate columns with column headers in format cmd_{x}
    • cmd_{x}L => can be used for custom field button url data
  • image_url – Complete http:// url to an image from external source
  • image_id – (integer) existing attachment ID from wordpress site you are importing events to
  • evcal_lmlink – Learn more link (http)
  • evcal_lmlink_target – Learn more link open in new window yes | no
  • User Interaction Fields:
    • _evcal_exlink_option => UX_val from 1-4 (integer)
    • evcal_exlink => UX_VAL link to event URL (http://)
    • _evcal_exlink_target => UX_val link open in new window yes | no
  • ActionUser Compatible Fields: 
    • evoau_assignu => User IDs seperated by comma to assign users to events

If the event images already exist in your media gallery, you should exclude the image_url column in your CSV file. This option downloads the image from the provided link and imports it to your media gallery hence causing multiple occurrences of the same images.

You should ONLY make use of the image_id column in your CSV file and populate this with the attachment ids of the images that exist on your media gallery.

How to get the attachment ID

  1. Head over to your media library by clicking on Media > Library.

2. Switch to the List view.

3. Hover / Mouse over the image that you would like to import and check the number that is displayed at the bottom left of the page.

You can use 30592 as the image_id in your import file and this will ensure that there are no duplicates after the import.

For additional import troubleshooting tips, please go through the following guide: How to Troubleshoot CSV Import Issues.

Did this article help you? If not, send us a ticket via helpdesk

Ready to setup your calendar?

LiteDownload Free

Or

FullGet started