- Posts: 58
- Thank you received: 2
Registration field mapping from csv file
- Christoph
- Topic Author
- Offline
- Senior Member
-
Less
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
-
Less
More
- Posts: 58
- Thank you received: 2
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Christoph
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 58
- Thank you received: 2
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
Thank you,
Chris
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
-
Less
More
- Posts: 58
- Thank you received: 2
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.