Problems with Export
Ok, Thank you Daniel
It seems the problem is because of the group_id. If a user is in more than one group then i have these "pipes". Is there a way to export only user from a specific usergroup? Without the Pipes ?
You are seeing the records separated with a | symbol because the tables you mentioned above have one to many relationship i.e. a single record in the main table i.e. #__users have multiple related records in the other table #__jsn_users.
That's to display the records from both tables in a single row, We have separated these records with | . This setting can be changed in vData configuration. Please check the attached screenshot. You can have records from these tables in separate rows.
Attachment ScreenshotatMar2417-29-50.png not found
I'm trying to merge two tables - #_users and #_jsn_users (easyprofile user) and export it as a csv-file.
It works, but there is a strange behaviour in certain fields: i have double and triple entries like this "8003|8003" "4056|4056|4056" or "||" in the csv table.
Thank you for helping