Front end CSV import?

[Webguy262]

We need to allow approved users to upload bulk events in CSV format. Any ideas as to how to accomplish this?

[Caroline]

Hi there,

Thanks so much for stopping by and checking out our plugins! I’m sorry to say that none of our plugins include CSV import functionality for front-end users at this time. 🙁 At the moment, user-submitted events are only supported as single event submissions using our Community Events plugin. However, if you only need this functionality for specific users, you might consider creating a user role for these users to access portions of your WordPress backend, granting them permissions for the CSV import tool but restricting their access to other portions of the backend. This can be accomplished using a third-party plugin such as User Role Editor to set individual permissions for specific user roles. We aren’t affiliated with this plugin in any way and can’t provide any direct support for its features, but I can confirm that some of our users have applied it to similar tasks with great success! 🙂

I hope that helps to get you started here! Thanks again for reaching out, and let us know if you should have any other questions!

[Webguy262]

Caroline, thanks for all your help! Two questions…

Is there a way to use “User Role Editor” to only allow access to the “Events Import” page? We can’t allow access to the other Events options in the backend because it allows one user to CRUD other users events. Select other’s Venues, Organizations, etc.

If multiple events are imported in the admin via CSV, is each individual event still editable via Community Events?

Thanks!

[Webguy262]

BTW, the only Events capabilities I see in “User Role Editor” are…

Delete others tribe events
Delete private tribe events
Delete published tribe events
Delete tribe events
Edit others tribe events
Edit private tribe events
Edit published tribe events
Edit tribe events
Publish tribe events
Read private tribe events

Nothing relates to import function.

Thoughts?

[Caroline]

Hi there,

Thanks for following up with some more information here! On further review, I do see that the abilities of the User Role Editor are somewhat limited if you need to restrict access to event creation and editing tools while leaving the import tools freely accessible. 🙁 In this case, I’d suggest adding the plugin Admin Menu Editor alongside this tool. This plugin adds some extra options for restricting access to admin menu options by user role, and you can set up your import user roles in this way:

1. Using User Role Editor, grant your import user role permissions for publish_tribe_events, if this permission is not already granted. Save your changes.
2. Using Admin Menu Editor, expand each sub-menu option under the Events menu heading. You’ll see a field for Extra capability in each pane.
3. For menu options that you wish to hide from import users, select “Administrator” under the Roles heading in the drop-down menu. For menu options that you wish to show to import users, select your import user role from the same section of the menu.
4. Click the blue Save Changes button to apply your new permissions.
5. Test by creating a new user with your import user role and logging in. If your settings were configured properly, you should see the Events menu in the WordPress sidebar, and Import should be the only option that appears underneath.

I hope that this solution will work for your needs! Give it a try, and let me know if you should have any other questions or concerns. Thanks much! 🙂

[Webguy262]

Thanks again!

BTW, at my request, my client bought Community Events and Filter Bar, and renewed their license for PRO. Your responsiveness and sound advice have sold me on TEC!

Can you respond to the question below from my email earlier today?

“If multiple events are imported in the admin via CSV, is each individual event still editable via Community Events?”

[Caroline]

Hi there,

Awesome, I’m so glad to hear it–and we hope that your client will enjoy working with their new plugins! 🙂

I’m sorry for missing your second question from your previous post today! Events that are imported via CSV or other batch import tasks (using Event Aggregator) will be brought in as single events, and these can easily be edited or deleted by administrators in the same manner as events created directly in The Events Calendar. However, they won’t be assigned to the importing user in the same manner as events created using Community Events–by default, all events imported using our import tool will be assigned to the site administrator. You might consider trying out a third-party import plugin such as WP All Import Pro, which may allow you to reassign the post_author field for your imported posts, though you’d have to adjust the event visibility settings and permissions using Admin Menu Editor to ensure that your users would still be able to see their events!

Obviously this is a fairly complicated topic, and to achieve this in exactly the manner you’re seeking, it may help to be willing to brave a bit of customization. I hope, though, that these suggestions might give you some ideas for how to get started, or at least give you an idea of whether or not this is a project you’d feel comfortable taking on! 🙂 Let me know if you should have any other questions or concerns–I’d be more than glad to assist as best I can!

[Webguy262]

> Obviously this is a fairly complicated topic, and to achieve this in exactly the manner you’re seeking, it may help to be willing to brave a bit of customization.

Seems like it might be easier to modify Community Events to handle bulk imports since it is designed for user-specific entry and management. Modifying post_author, event visibility settings and permissions for the admin CSV import sounds more challenging and further away from it’s admin focus.

Do you have someone at Tribe who can give me an estimate on customization?

[Caroline]

Hi there,

A custom-developed solution would certainly be most likely to get you the features you’re looking for in a package that closely aligns with the existing functionality of Community Events. While we’re not able to field development projects of this type in-house, we do maintain a list of third-party developers who work with our plugins and are more than happy to take on projects such as these. I’d suggest reaching out to any one of these developers with some details to get the ball rolling–we’re sure you’ll find a great match there! 🙂

I hope that helps to get you started! Cheers, and best of luck!

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts