1. yberges
  2. RO CSVI
  3. Tuesday, 07 September 2021
  4.  Subscribe via email
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
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
hello just a question any way to preserve id of imported user ?
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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)
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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 !
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
hello
i use core profil plugin to add user custom information
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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
  1. 3 weeks ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
ok i start to create it
detail first screen
Options second screen
i didn't have same option and display
what i am doing wrong ?
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
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
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
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

1. Import the fields of Joomla users table using Joomla Users import template.
2. 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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
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
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
hello screen here
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
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
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!