In Exports you can create individual exports.


Example of how to export firstname and surname for a specific e-mail address:




Following values are available (sorted after the tabs)


If you added custom queries in Registration - Setup - Participant these values are available as export values in the tab "ADDITIONAL INFORMATION".


PROFILE


Value

Example

m-anage.com login: BirthDate

01/01/1970

m-anage.com login: EFN

987654321

m-anage.com login: E-Mail

XXXXX@XXXXXXXXX.XXX

m-anage.com login: External id

123456789

m-anage.com login: Fax

00 555 4444 333 1110

m-anage.com login: Firstname

Max

m-anage.com login: Gender

Mr.

m-anage.com login: Initials

M. M.

m-anage.com login: Mobile

00 555 444 333 1111

m-anage.com login: Nationality

German

m-anage.com login: PassportExpiryDate

01.01.2020

m-anage.com login: PassportNumber

9876543210

m-anage.com login: Phone1

00 555 444 333 1112

m-anage.com login: Phone2

00 555 444 333 1113

m-anage.com login: RoleName

User, Visitor, GroupOperator

m-anage.com login: Salutation

Mr.

m-anage.com login: Surname

Mustermann

m-anage.com login: Title

Dr.

Participant: Area of interest

Clinical Research, Medical Practice

Private address: City

Munich

Private address: Company

JMT

Private address: Country

Germany

Private address: Department1

DEVELOPMENT

Private address: Department2

QUALITY MANAGEMENT

Private address: Institution

HTML

Private address: PostalCode

88888

Private address: Street

Musterstr. 125



Registration


Value

Example

Group: Operator E-mail

XXXXXXXXX@XXXXXXXX.XX

Group: Operator name

Max Mustermann

Group: Operator number

GO-000001

Group: Participant note

Not member

Group: Participant number

GV-00001

Group: Participant picked up tickets?

1

Group: Participant registration date and time

12/12/2014

Participant: Approved

YES, NO

Participant: Congress bag fetched?

YES, NO

Participant: Expiry date (society link)

31/12/2014

Participant: Is group operator?

YES, NO

Participant: MemberCode1

98765

Participant: MemberCode2

43210

Participant: MemberCode3

98745

Participant: Type

Member, Non-member, Participant, Exhibitor

Participant: Type needs approval?

YES, NO

Ticket: Category

Registration Fee

Ticket: Name

Refund

Ticket: Type name

Registration Fee, Credit Note from Registration



Orders


Value

Example

Booking status: cancelled?

NO

Group order create date and time

12/12/2013

Group order number

201500001

Group order paid sum

560,00

Group order paid: date and time

12/12/2013

Group order status: cancelled?

NO

Group order sum

560,00

Invoice address (Last order): Additional name

Invoice address (Last order): City

Munich

Invoice address (Last order): Company

JMT

Invoice address (Last order): Country

GERMANY

Invoice address (Last order): Department1

Invoice address (Last order): Department2

Invoice address (Last order): Intitution

Invoice address (Last order): Name

Mr. Max Mustermann

Invoice address (Last order): PostalCode

88888

Invoice address (Last order): Street

Musterstr. 125

m-anage.com login: OneClickAccess

https://www.m-anage.com/publicContent/oneClickAccess.aspx?action=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Notes

Onsite payment

Order cancel date and time

13/12/2013

Order Credit

560,00

Order date and time

12/12/2013

Order method of payment

Pending, Credit card, Cash payment

Order number

201400001

Order paid sum

560,00

Order paid: date and time

13/12/2013

Order status

Canceled, Open

Order status: cancelled?

NO

Order sum

560,00

Participant Id

10000001



Statistics


Value

Example

Group: Booking count

3

Group: Booking sum (Currency)

0

Group: Cancelled booking sum

0

Group: Total Credit (Currency)

0

Group: Total of cancellation fees

0

Group: Total payment of paticipants (Currency)

0

Participant: Account balance

0.00

Participant: Has cancelled bookings?

NO

Participant: Total amount of cancelled orders (Currency)

0

Participant: Total amount of payment

0

Participant: Total credit

0

Registration: Foreign fees

0.00

Registration: Paid bookings_SELF

0

Registration: Personal fees

0.00

Registration: Total negative movements (Currency)

-61870,00

Registration: Total orders sum

0.00

Registration: Total positive movements (Currency)

61870,00

Registration: TotalCancellationFee

0

Registration: Valid bookings sum_FOREIGN

0

Registration: Valid bookings sum_SELF

0

Registration: Valid bookings_FOREIGN

0

Registration: Valid bookings_SELF

0

Registration: Valid orders

0