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,
No problem, we are glad to know that export works as expected :)
Kind regards,

Tharuna

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

Tharuna

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

Tharuna

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

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
ok i do that you say but now i have this error
Column 'userName' in field list is ambiguous
  1. 2 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

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

Tharuna

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

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
hello i am return i create my k2 user export template
but nothing in file (juste title columns
i add my template configuration
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
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 CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
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 ??
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 16
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. # 17
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. # 18
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. # 19
Accepted Answer Pending Moderation
hello screen here
Attachments (1)
  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!