Zum Hauptinhalt springen

Export user data - Developer & Reporting / DPQL Examples - Deskpro Support

Export user data

Autorenliste

Question

Is there a method I can use to export my user data for use in MailChimp or similar ??

Answer

You can go to the Reports section Stat Builder > Add to export a list of users.

The following query will give you the users name, id, email address and organization.

SELECT people_emails.person.id, people_emails.date_created, people_emails.person, people_emails.email, people_emails.person.organization.name

FROM people_emails

WHERE people_emails.date_created = %THIS_MONTH%

You can change the time period under WHERE depending on what users you want to export e.g users that were created THIS_YEAR, LAST_MONTH etc.

This report will give you more information - all of the above plus their address and phone number

SELECT people_emails.person.id, people_emails.person, people_emails.email, people_emails.person.organization.name AS 'Organization Name', people_emails.person.contact_data.field_1 AS 'Address', people_emails.person.contact_data.field_2 AS 'City', people_emails.person.contact_data.field_3 AS 'State', people_emails.person.contact_data.field_4 AS 'Zipcode', people_emails.person.contact_data.field_5 AS 'Country', people_emails.person.phone_numbers.number AS 'Phone Number'

FROM people_emails

ORDER BY people_emails.person.id

Hilfreich Nicht hilfreich

20 von 32 Personen fanden diese Seite hilfreich

Fügen Sie einen Kommentar hinzu

Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.

Benötigen Sie eine Passwort-Erinnerung?