Registration field mapping from csv file

  • Christoph
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #113952 by Christoph
Registration field mapping from csv file was created by Christoph
Hello,

is it possible to map registration fields with data pulled from a csv file? Any hints how to let the booking component pull the csv data loaded into an array?

The user has been logged in and the ID is the email address. Same email address is in the csv file which I can load into an temporary array or object. But from there, how do I continue? Any help would be highly appreciated.

Regards,
Christoph

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #113954 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registration field mapping from csv file
To do that, you will need to know how to write a Joomla Plugin. Not sure if you can do it because seems you don't have much experience with Joomla

So maybe the solution could be modified one of existing plugin

1. Publish Events Booking - Userprofile plugin

2. Then look at the file plugins/eventbooking/userprofile/userprofile.php

3. Modify the method onGetProfileData

Somehow, in that method you will have to load data from CSV file, then return an array contains data which will be used to pre-fill registration form:

For example:

$data = 'Tuan';
$data = 'Pham Ngoc';
$data = 'tuanpn@joomdonation.com';

return $data;

Something like that. You will need to have some programming experience to do that

Tuan

Please Log in or Create an account to join the conversation.

  • Christoph
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #113963 by Christoph
Replied by Christoph on topic Registration field mapping from csv file
Thank you Tuan, I have installed Community Builder and created a data base there.

But somehow system fields like email address and name cannot be mapped, they don't appear in the pull down menu of fields mapping in Edit Custom Field backend.

??? Please help

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #113966 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registration field mapping from csv file
Name and Emails are mapped automatically by the system, you don't have to map it manually

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Christoph
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #113974 by Christoph
Replied by Christoph on topic Registration field mapping from csv file
Ok thanks, that is so obvious with email. I didn't see that. With name there is still an issue. In some countries and cultures there is no First Name and Last Name of people. W3C proposes and we do that as well to have one single Full Name Field where First and Family Name would be combined together. In the Community Builder you can set the system name field to the single Fullname field in configuration settings. In that case, is the mapping also done automatically and does this work with Event Booking ?

Thank you,
Chris

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #113978 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registration field mapping from csv file
Hi Chris

If you have two separate fields in Community Builder for name, then you can map these two fields with two fields in Events Booking

If you just have a single name field, the system will use Name stored in Joomla core user account, split it to pre-fill first name and last name on registration form of Events Booking

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Christoph
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #113987 by Christoph
Replied by Christoph on topic Registration field mapping from csv file
Ok, great, it works now. Thank you for pointing this out. :)

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #113993 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Registration field mapping from csv file
OK, great.

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc