Resolved Import usertype

Hello,
You can add equivalent template fields to your import template in the same order as in your import file and set Use file for configuration to No in your template settings on File tab. This setting will read the headers from your template fields and data from your import file.

Thank you for your answer,

When i try this, we have this preview:


And, after the import, we have this:


But, we haven´t got the users:

Hello,
You need to post your import debug log to check. To know on how to get the debug log, check Where to get the debug information? section on top of this page.

Thank you, i have attached mi log in this message com_csvi.log.7.zip

Hello,
Your debug log shows there is no processing happened on user details and so your are not seeing any users after import. Can you also post your template XML file to check?. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.

Thank you, here it is:
csvi_templates_20170424.xml

Hello,
You are not importing usergroup_name field in your import which is a required field and so users are not processed. CSVI would have shown error "COM_CSVI_NO_USERGROUP_NAME_FOUND" after the import is done and in the log details page. I see that you have usertype field in your import file so what you can do is add usergroup_name to your template fields after password field and in your import template settings on File tab set Use file for configuration option to No and save the template. Try import after that.

Thank you for your anwer, but in my "field name" box, we can´t found "usergroup_name"

Hello,
If you are not seeing fields in your template fields then try to update your available fields.

Thank you, it solved it.

But now, when i try to import, i have this error:

Hello,
I found an issue with your import file, the usergroup_name for multiple group should be separated with | like Manager|Super Users but in your import file it is Manager*Super Users. You need to correct this and try the import again.

Thank you, i have deleted it, but the problem continues. I attatch the log.
com_csvi.log.15.zip

Hello,
In your import template settings, on File tab set Skip first line to Yes and save the template. Run the import again and see if it solves the issue.

Hello,
In your import template settings, on File tab set Skip first line to Yes and save the template. Run the import again and see if it solves the issue.

I have tried it, but the problem continues:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL=INSERT INTO `#__user_usergroup_map` VALUES (44, )

Hello,
Can you post the debug log of your latest import?

Yes, sorry
Here it is:
com_csvi.log.16.zip

Hello,
In your Joomla administrator, Go to Users >> Groups, what do you see in there? Can you post the screenshot of it?

I see this:


It is in spanish. Is it a problem?

Hello,
Yes, that is the problem. You have usergroup_name in english in your import file but in database tables its in spanish. CSVI is not able to get the correct user group id. You need to correct your import file usergroup_name to spanish.

Thank you! it is solved