Problems with Export

More
21 Apr 2016 07:08 #2418 by Daniel
Replied by Daniel on topic Problems with Export
You can add filters on main table only. Please contact our sales team via Contact us form if you are looking to customise this feature.

Thanks
Daniel

Please Log in to join the conversation.

  • Christoph Burkhard
  • Topic Author
  • Offline
  • New Member
  • New Member
More
19 Apr 2016 12:41 - 19 Apr 2016 12:42 #2406 by Christoph Burkhard
Replied by Christoph Burkhard on topic Problems with Export
Any idea?

Thank you
Christoph
Last edit: 19 Apr 2016 12:42 by Christoph Burkhard.

Please Log in to join the conversation.

  • Christoph Burkhard
  • Topic Author
  • Offline
  • New Member
  • New Member
More
08 Apr 2016 15:23 #2341 by Christoph Burkhard
Replied by Christoph Burkhard on topic Problems with Export
Hi

I was not able to do this. The main table is #_users and i cant set a filter with the group_id there.
How can i solve this?

Thank you
Christoph

Please Log in to join the conversation.

More
24 Mar 2016 18:07 #2245 by Daniel
Replied by Daniel on topic Problems with Export
Hi Christoph,
You can add filters on the main table to get some specific records.

Thanks
Daniel

Please Log in to join the conversation.

  • Christoph Burkhard
  • Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2016 15:59 #2244 by Christoph Burkhard
Replied by Christoph Burkhard on topic 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 ;-) ?

Thank you
Christoph

Please Log in to join the conversation.

More
24 Mar 2016 12:05 #2237 by Daniel
Replied by Daniel on topic Problems with Export
Hi Christoph,
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


Thanks
Daniel

Please Log in to join the conversation.

  • Christoph Burkhard
  • Topic Author
  • Offline
  • New Member
  • New Member
More
24 Mar 2016 11:36 #2235 by Christoph Burkhard
Problems with Export was created by Christoph Burkhard
Hi

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

Christoph

Please Log in to join the conversation.

Cron Job Starts