Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Problems with Export

More
1 year 3 months ago #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
1 year 3 months ago #2406

Any idea?

Thank you
Christoph

Last Edit: 1 year 3 months ago 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
1 year 3 months ago #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
1 year 4 months ago #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
1 year 4 months ago #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
1 year 4 months ago #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
1 year 4 months ago #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.