Hi
I have a running Joomla! 3 Website and i'm looking for a way to import all the (user)Extrafields i builded with Easyprofile. Easy Profile extends the Joomla user fields with any new fields. Unfortunately, Easyprofile is no longer being developed. There is no version for Joomla 4. So i have a table with all extrafield Values (connected with the unique joomla user id called #_jsn_users.
Whats the best way to import all these values as Joomla user Custom fields to the correspondending users?
Thank you
Regards
Christoph
Hello Christoph,
Whats the best way to import all these values as Joomla user Custom fields to the correspondending users?
Try these steps and see if it works for you
- Using RO CSVI custom export template you can export extra field values from #_jsn_users table along with joomla user id.
- Create Joomla user custom fields with same name as extra fields.
- Update available fields in RO CSVI
- Create Joomla User import template.
- On Options tab set Keep user id to Yes and save the template.
- Run the import and check.
If you have any problem, please post the export file from RO CSVI custom export template and also send us the screenshots on how you have setup Joomla user custom fields.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Thanks for answering and for your hep. So i will try this. But first i have to create the Joomla user custom fields. (more than 100!) ;)
I'll be happy to come back to it after a while.
Regards
Christoph
Hello Christoph,
But first i have to create the Joomla user custom fields. (more than 100!) ;)
You can import those as well with RO CSVI ;)
Perhaps that is worth looking into.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Rolandd
Thank you very much
You can import those as well with RO CSVI ;)
Where to start? With an "Example Joomla Custom Fields Import"?
I tried this with "load from Database" with "use Joomla Connection" and the "jsn_fields" Table List. But when i try the preview, im landdin back in the template list.
Best regards
Christoph
Hello Christoph,
Where to start? With an "Example Joomla Custom Fields Import"?
Yes it is good to start with Example Joomla Custom Fields Import template. Please check Joomla Custom Fields import document on how to import custom fields. Check the examples in the linked document.
I tried this with "load from Database" with "use Joomla Connection" and the "jsn_fields" Table List. But when i try the preview, im landdin back in the template list.
Do you see any error? Can you post a screenshot on what you see when you get back to template list page?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Thanks for helping. No Error. I tried to upload a wmv file. But this is unsupported. So i send you the clip via email.
Best regards
Christoph
Hello Christoph,
Available fields were not updated on your site and so import did not work. I did the update of available fields and now see import loading. Please check now.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Great! It seems to work. Now, i have all the Easy Profile Customfields under Article > Fields. Thank you!
But i need these Customfields in the Contact Component. Is there a way to bring it to Components > Contact > Fields?
Best regards
Christoph
Hello Christoph,
You can export article custom fields using Joomla custom fields export template and import it using Joomla custom fields import template. Only change you need to do is with context_type field in the file. For content it is article and for contact it is contact. This needs to be changed.
Let me know if that helps.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Christoph,
Do i have to fill out the default value with "article" or "contact"?
Create a rule using RO CSVI Find and replace to find and replace word article with contact. Apply this rule on context_type field in Joomla custom fields export template.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Thanks very much! It seems to work like this. Great!
However, I realized that the first import only worked for the "Text" and "Textaerea" types. I'm missing all selectlist, checkbox and other values.
This probably has something to do with the fact that easy profile "writes" the values for selctlists, checkboxes, etc. in the Parameter field. Is there a workaround to import data from this table correctly?
Thanks very much
and all the best
Hello,
This probably has something to do with the fact that easy profile "writes" the values for selctlists, checkboxes, etc. in the Parameter field. Is there a workaround to import data from this table correctly?
Yes the format in which Joomla and Easy Profile stores custom fields should be different. There is no direct way in RO CSVI. You can write a rule plugin to write custom code to convert these values in the way Joomla stores it and run the import.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Christoph,
Looks like you have a duplicate field with name email. Joomla contacts has email field from #__contact_details table and used as available field. Do you have any custom field with the same name?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna
Sorry for my late Reply (Holidays).
That was the Point.
And thanks for helping.
Best regards
Christoph
Log in to reply to this topic.