Hello
i need to export all k2 author to export it in joomla user
i try to create template but if i set k2 component i didn't have user
can you help me ?
regards
- yberges
- RO CSVI
- Tuesday, 07 September 2021
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
I said the created_by field in K2 item table is the ID of Joomla users table. We do not have support for exporting user information from K2 in RO CSVI. We only support category, extrafield and item exports in k2. If you want to export the K2 user information you can use RO CSVI custom table export.
you said that k2 profil was just a link to joomla user but i see some field on k2 user .. but we didn't have export user information in ro csvi ??
I said the created_by field in K2 item table is the ID of Joomla users table. We do not have support for exporting user information from K2 in RO CSVI. We only support category, extrafield and item exports in k2. If you want to export the K2 user information you can use RO CSVI custom table export.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
For some reason the template XML file you sent shows only one table k2_users as selected on Options tab. Is that what you have in your template? Can you please post a screenshot of Options tab on how you have tables selected?
For some reason the template XML file you sent shows only one table k2_users as selected on Options tab. Is that what you have in your template? Can you please post a screenshot of Options tab on how you have tables selected?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
Thank you for sharing the screenshot. I ran the export with your template and found there is an error. Export says "Column not found: 1054 Unknown column 'name' in field list" and that is because you have name in template fields which does not belong to this k2_users table. Change name field to userName and your export should work. Check the attached screenshot.
Thank you for sharing the screenshot. I ran the export with your template and found there is an error. Export says "Column not found: 1054 Unknown column 'name' in field list" and that is because you have name in template fields which does not belong to this k2_users table. Change name field to userName and your export should work. Check the attached screenshot.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
You can use userID in K2_users table to link to Joomla users table id field. See attached screenshot. You can then add fields of Joomla users table and k2 users table to export.
did you have an idea to have the good id to create relation between k2 profil to joomla profile ?
You can use userID in K2_users table to link to Joomla users table id field. See attached screenshot. You can then add fields of Joomla users table and k2 users table to export.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
ok i do that you say but now i have this error
Column 'userName' in field list is ambiguous
Column 'userName' in field list is ambiguous
Accepted Answer
Pending Moderation
Hello,
To solve the error, add alias for the tables on Options tab like in the attached screenshot. Save the template. Make sure to add the table alias for fields on template fields page too.
To solve the error, add alias for the tables on Options tab like in the attached screenshot. Save the template. Make sure to add the table alias for fields on template fields page too.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
What about the table alias in template fields page? Did you it to the field as in the screenshot sent in my previous reply? If not added, please add it and run the export. If you still have a problem, please send a screenshot of template fields page.
Edit:-
You also need to add table alias to other template fields according to the table the field belongs to. For k2 users table fields add table alias as k2users and for Joomla user table fields add users as table alias.
What about the table alias in template fields page? Did you it to the field as in the screenshot sent in my previous reply? If not added, please add it and run the export. If you still have a problem, please send a screenshot of template fields page.
Edit:-
You also need to add table alias to other template fields according to the table the field belongs to. For k2 users table fields add table alias as k2users and for Joomla user table fields add users as table alias.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
You do not have table alias added in your template fields page for userName field. Check the 3rd screenshot you have sent. Table alias is empty. You should add table alias for all the template fields based on the table it belongs to. See attached screenshot for userName field.
You do not have table alias added in your template fields page for userName field. Check the 3rd screenshot you have sent. Table alias is empty. You should add table alias for all the template fields based on the table it belongs to. See attached screenshot for userName field.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
No problem, we are glad to know that export works as expected
No problem, we are glad to know that export works as expected
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
- 2
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »