Export CustomerUsers from all Customers

Moderator: crythias

Post Reply
imes
Znuny newbie
Posts: 39
Joined: 19 Sep 2019, 13:43
Znuny Version: 6.0.22
Real Name: Ismael

Export CustomerUsers from all Customers

Post by imes »

Hello everyone,

I have the CustomerUserImportExport module since I have not found another way to export the information of the Customer Users of a Customer.
The problem I have is that I have several Customers with enough CustomersUsers each of them.
When I use the CustomerUser export module it only exports the CustomerID = 1 information.
Why? How can I get the CustomerID = 2 information to be exported as well?

Thank you,
A greeting.
root
Administrator
Posts: 3965
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Export CustomerUsers from all Customers

Post by root »

imes wrote: 25 May 2020, 18:25 Hello everyone,

I have the CustomerUserImportExport module since I have not found another way to export the information of the Customer Users of a Customer.
The problem I have is that I have several Customers with enough CustomersUsers each of them.
When I use the CustomerUser export module it only exports the CustomerID = 1 information.
Why? How can I get the CustomerID = 2 information to be exported as well?

Thank you,
A greeting.
Hi,

This is a question for the author of the module. To get your data exported: this should be no problem for a database client.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
imes
Znuny newbie
Posts: 39
Joined: 19 Sep 2019, 13:43
Znuny Version: 6.0.22
Real Name: Ismael

Re: Export CustomerUsers from all Customers

Post by imes »

OK thanks.

Isn't there a quick way to CSV list all my CustomersUsers?

Even with stats reports?
root
Administrator
Posts: 3965
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Export CustomerUsers from all Customers

Post by root »

imes wrote: 26 May 2020, 08:06 Isn't there a quick way to CSV list all my CustomersUsers?
Hi,

The quick way is using a database client.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
skullz
Znuny superhero
Posts: 624
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Export CustomerUsers from all Customers

Post by skullz »

Quick way Admin > SQL box

select * from customer_user
Post Reply