Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Problems with Export

More
21 Apr 2016 07:08 #2418

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 or Create an account to join the conversation.

  • Christoph Burkhard
  • Christoph Burkhard's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
19 Apr 2016 12:41 #2406

Any idea?

Thank you
Christoph

Last Edit: 19 Apr 2016 12:42 by Christoph Burkhard.

Please Log in or Create an account to join the conversation.

  • Christoph Burkhard
  • Christoph Burkhard's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
08 Apr 2016 15:23 #2341

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 or Create an account to join the conversation.

More
24 Mar 2016 18:07 #2245

Hi Christoph,
You can add filters on the main table to get some specific records.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Christoph Burkhard
  • Christoph Burkhard's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Mar 2016 15:59 #2244

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 or Create an account to join the conversation.

More
24 Mar 2016 12:05 #2237

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
Attachments:

Please Log in or Create an account to join the conversation.

  • Christoph Burkhard
  • Christoph Burkhard's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
24 Mar 2016 11:36 #2235

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 or Create an account to join the conversation.