You are here: Home Support Forums JEvents (Free Forums) JEvents 3.4 (Free Access) List by Year from today
Recent
Categories
Tags
You need to be logged in to view a user's profile.
View Replies (7)

Resolved Questions on csv import

  1. Technical
0
Votes
Undo
  1. ugenda
    ugenda
    Gold Member
  2. JEvents 3.4 (Free Access)
  3. Wednesday, 02 February 2022
I'm testing the import function of JEvents. I trying to migrate from Joomla Event Manager to JEvents. I've created a css file for import with the required fields and my extra fields.

Do I have to create a new calendar for each new import? I'm in testing mode, so I'm adding more and more unnecessary calendars. I also can't seem to delete existing calendars. It warns me I'm about to dele the content as well, but then nothing happens. Even after I've deleted all events in that calendar first.

Can I move (all) events from one calendar to another? In the list of events in the admin, I specifically have to select a calendar to show the events of that calendar. I can't seem to show all events of all calendars at once.

What I would like to have is all events, eiher created on the website or via import, to be in the same calendar. I don't want to end up with a huge amount of calendars over the years to come.

It doesn't import the locations of the events, though I use the exact same names. It does however add an extra line in the frontend of JEvents in the description: "Location locationname" but without the address information. In the admin I don't see a location associated with the event, neither any field where the location name is stored.
iCal Support
Export ical without using menu item?
Responses (7)
tonyp
tonyp
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
Hello,

So by default you can create a new calendar for each import.

But you can enable frontend imports in the event editing section under JEvents. And then you can login to the frontend and under all calendar views you will be able to import from file.

You can batch change them via the database too.

We would need the full location to match them up, or use the location ID I believe. In the Managed Locations options you can configure how the locations match up with. In:

More Creation Options -> Match Locations for iCal Imports - Yes - Matching method by Name

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 1
ugenda
ugenda
Gold Member
Accepted Answer Pending Moderation
0
Votes
Undo
Apparently there's something wrong with all locations I've imported directly into the database. Though they show up in the list of locations and can be selected as a location with an events, the import of events (either css or iCal/vcal format) doesn't recognize the matching location, although the location setting is set to match imports by name and the name is exact the same.
When I create a new location within JEvents itself and use an import file with the name of that location, it works.
I'll have to look into that, what the difference is between my imported locations and the JEV created locations.

The other question still remains: why can't I delete an (empty) calendar, even though there's a delete option?

And can I assign an event to an existing user when using the import feature, or all all events always assigned to the user that did the import? If so: how can I batch assign users to existing events? Or fix this in the database?
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 2
tonyp
tonyp
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
Hello,

1. There shouldn't be a problem with the name matching unless you have a space in the db? Ensure the locations are created by the user importing. seE: If this is set to yes AND the location field in the CSV file is an exact match for an existing location title then it will be matched up with the location in the database (as long as the importing user is the creator of the location or the location is a shared/global location).

2. You cannot delete a calendar if any events are assigned to it, have you emptied your trash?

3. Try setting 'CREATOR' field. Failing that you can set the creator in the DB directly.

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 3
ugenda
ugenda
Gold Member
Accepted Answer Pending Moderation
0
Votes
Undo

  1. I've figured it out, by comparing the two locations: I had to set the access and the global to 1 for the imported locations.
  2. Yes, I've deleted the events and emptied the trash.
  3. I'll test the creator field. Should it be an id or a full username? Setting creators in the db will be some work. There are 2500+ future events. (And 37.000 archived events :o )
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 4
tonyp
tonyp
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
1. Great!
2. Can you check the db for any events assigned to the calendar and also repeats and event details?
3. Ouch ok... you need a way to set it. Try:

X-CREATEDBY = the user's ID in the new site.

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 5
ugenda
ugenda
Gold Member
Accepted Answer Pending Moderation
0
Votes
Undo

  1. I've figured it out:
    2. When you upload a file (csv or iCal) to a calandar, a record will be created in the table ##_jevents_icsfile, with the uploaded filename in the field filename. That record prevents you from deleting the calendar.
    In the admin of Joomla you only see the name of the calendar and the settings, but can't see what file is associated with that calendar. So there's no way to remove de association. Only if you delete the record in the database table mentioned, then you will be able to delete the calendar through the Joomla admin.

  2. I've tried X-CREATEDBY and created_by, even changed the order of the fields. I can't seem to get it working.
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 6
tonyp
tonyp
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
Thanks, I've asked Geraint to take a look as he wrote that routine.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  1. more than a month ago
  2. JEvents 3.4 (Free Access)
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.

Login Form