Hi,
so here's the deal: for my work placement I work for a small association (+/- 100 members) to create them a new website. Until now they used an offline Access database.
I have less than one month left, still a lot to do, and last friday I understand that they want me to add all the members in the new MySQL database myself, and I never expected to do that because I don't have time for huge copypasta sessions. So I tried to add the users with external SQL queries in php pages.
For the native Joomla fields such as name username email it works, and the data shows in the backend. However for community builder's fields it is not the case. My queries actually work, and I can see the data I sent in phpMyAdmin (the comprofiler table), but CB's fields are simply Blank in the Joomla backend and frontend.
It must be a common problem (or misuse ?), but I didn't find a good workaround in order for the data to show in CB.
So my questions are:
- Is there a mean for submitted data from external SQL queries to show in CB ?
- what can I do to add user data to community builder using a script ?
Thank you
PH
nant