Resolved Import k2 user to joomla user

Hello,
No problem, we are glad to know that export works as expected

ah sorry for this mistake !
it works
thanks

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.

hello
my screenshot

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.

same error

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.

ok i do that you say but now i have this error
Column 'userName' in field list is ambiguous

Hello,

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.

cooool its works ... i have export !
did you have an idea to have the good id to create relation between k2 profil to joomla profile ?

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.

ok screen here

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?

hello i am return i create my k2 user export template
but nothing in file (juste title columns
i add my template configuration

Hello,

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.

ahhh its works ! cool
i continu to works on it and found strange information
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 ??

Hello,
Seems like you did not set the Import Based on field in your import template. I sent a screenshot on how to set these fields in my previous reply. Attaching it here again.

ok export is cool !
but in import that doesn't work

Could not load table CsviTableCustomTable. Error: The custom table has no primary key field or there is no import based on field set in the template

Hello,
Now i understand what has happened. You should be having two custom table export templates one with users table and other with user_profiles table. With custom tables import/export we list all the fields of selected tables in custom table template. You should be seeing user_id, profile_key and profile_value fields along with Users table fields. You can select only user_id, profile_key and profile_value for user_profile custom table export and run the export.

hello screen here