DarkmiraTour / community-event-manager

Web application with a collection of tools helping people organising community events such as multi-days conference with reminders, CRM and such
GNU General Public License v3.0
21 stars 21 forks source link

add upload form to import Speakers from openCFP to DB #122

Closed kevinjhappy closed 5 years ago

kevinjhappy commented 5 years ago

PR informations

Q A
Branch? Develop
Bug fix? no
New feature? yes
Tests pass? yes
Related issue #97

Description

The opencfp project implement features for openCFP admin to extract in CSV form data from the speakers and from the talks

There is one extract dedicated to Talk Title and Speakers called emailExport which will extract the following information:

There is another extract dedicated to Talks called talkList which will extract the following information:

You can find details of how are called those export in this PHP file from the project

The feature can create Speakers and associate Talks with their title and description by uploading the two kind of extract on the same form. Unfortunately, the Biography, title (Mr., Ms, ...) and a photo are not available on those extract, therefore it will be necessairy to update Speakers entry accordingly once created. The submitted form will upload the file and associate useful informations to create Speakers.

Example:

if EmailExport contains:

title,selected,first_name,last_name,email
"PHP for the winner",true,"Gary","Okin","gary.okin@gmail.com"

and TalkList contains:

user_id,title,description,type,level,category,favorite,selected,created_at,updated_at
3920228291,"PHP for the winner","How to become the best at what you do","talk","beginner","PHP",false,true,"2019-02-03 13:23:56","2019-02-03 13:23:56"

Then the new Speaker will be: Gary Okin gary.okin@gmail.com Title will be set by default to "Mr/Ms" Biography to "To be completed..." PhotoPath to empty

And the associated talk will be: PHP for the winner - How to become the best at what you do