Questions on csv import
By ugenda on Wednesday, 02 February 2022
Posted in JEvents (Free Access)
Replies 7
Likes 0
Views 0.9K
Votes 0
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.
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
tonyp
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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?
ugenda
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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
tonyp
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·

  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 )
ugenda
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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
tonyp
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·

  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.
ugenda
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, I've asked Geraint to take a look as he wrote that routine.
tonyp
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post