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
Hello,
i try to create template but if i set k2 component i didn't have user
We do not have a specific operation to export user in K2. In K2 item table created_by is the field which holds the user ID of the author. This is the Joomla user table ID which means the author is already a Joomla user. May i know why you want to import the users as Joomla users again?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
hello just a question any way to preserve id of imported user ?
Hello,
There is no option to import users with IDs from import file in Joomla User import template. Can i ask why you need the same IDs?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i, i have a site and i create a new one and i will import all user/content i want to keep the link between content and create by
in my news site my index of if isn't same because i create 3 users (for working)
ah maybe i found ... my new site start id user 350-354 and all site start to 921 it will be good !
but last question for user, i use joomla profil plugin how to export value inside ?
i try to update fields and add to custom no way ..
thanks for your powerfull support !
Hello,
Keeping the same ID is not possible with Joomla users import but you can do that with RO CSVI Custom table import. In custom import template on Options tab set Custom table as Users table, Import based on as email and save the template. See attached screenshot. That should create Joomla users with same ID as in import file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
but last question for user, i use joomla profil plugin how to export value inside ?
i try to update fields and add to custom no way ..
Are the fields you are exporting from core Joomla users table? Can you please send a screenshot on the fields you are trying to export?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
The information collected by the profile plugin is stored in a separate table called user_profiles. This is a table not supported by RO CSVI, we support the custom fields instead. Not all is lost :) To move this data from one site to another site, you can use the RO CSVI Custom table export to export the data from the source site and RO CSVI Custom table import to import the data into the target website. You will need to use all 4 columns for export and import.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
i didn't have same option and display
what i am doing wrong ?
You are not doing anything wrong. We show only the database table field of type int in the drop down list. That is because most of the integer fields are ID fields and joining tables using ID fields is more effective than with text fields. In your case you will join the tables using user_id field. See attached screenshot.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
ok i try it, export is great but import doesn't works
Unsupported Failure These fields have been found but are not supported by RO CSVI:
ordering
profile_key
profile_value
user_id
Either these fields do not exist in your system, or the list of available fields need to be updated. Update the list to ensure you have all fields available.
i update avaiable list but nothing more
in attached , file for import + template
thanks
Hello,
export is great but import doesn't works
Import did not work because the table user_profiles is supported with Joomla users import. You can import to user_profiles table using RO CSVI custom table import. But remember this table has multiple rows with same user_ids so you need to set import based on field to user_id and profile_key. See attached screenshot. Based on user_id and profile_key values in import file, RO CSVI will find the existing row. If row does not exist then profile_value will be inserted else row will be updated.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Forgot to mention that with RO CSVI Custom table import you can import into only table. So with your export file you can do two imports
- Import the fields of Joomla users table using Joomla Users import template.
- Import the fields of user_profiles table using RO CSVI custom table import and the rest of the fields can be set to Skip template field in import template.
You can use the same export file for both of these imports. Just set the fields which are not supported in the import to skip template field .
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
hello i import user without problem but i didn't find how to export profil
i add custom table export, set users_profil => but i can select only user field in template
i attach template export
Hello,
The attached template has HTML content and not the actual XML content needed for template so not able to check your template settings. Please backup the template again and send it. You can also send me a screenshot of Options tab of export template to check on your table settings.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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,
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
hello i am return i create my k2 user export template
but nothing in file (juste title columns
i add my template configuration
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?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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,
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
ok i do that you say but now i have this error
Column 'userName' in field list is ambiguous
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
ah sorry for this mistake !
it works
thanks
Hello,
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
Log in to reply to this topic.