|
Response |
  
|
|
Response |
|
Data format
| • | Data encoding is Unicode |
| • | Fields are separated by TAB character (ASCII code 09). |
| • | Each line is terminated with CR + LF (ASCII codes decimal 13 and 10) |
File structure
First line
The first line contains an status code, containing:
[status code] + TAB + [status message]
Second line
The second line of the file contains the field names as specified.
Subsequent lines
The subsequent lines contain the reservation data as specified.
Status codes
Status code |
Means |
100 |
Ok |
200 or higher |
Error |
Field structure
Position |
Field name |
Data type |
Manda |
Remark |
||||||
1 |
Username |
15AN |
ü |
The user name is the primary key and therefore has to be unique. If a user name cannot be found in Flightnet, it is assumed that it is a new user so the record is added. |
||||||
2 |
LastName |
50AN |
ü |
|||||||
3 |
FirstName |
15AN |
ü |
|||||||
4 |
Street |
100AN |
|
|||||||
5 |
AdditionalField |
50AN |
|
|||||||
6 |
ZipCode |
12AN |
|
|||||||
7 |
City |
20AN |
|
|||||||
8 |
Country |
50AN |
|
|||||||
9 |
PhonePrivate |
18AN |
|
|||||||
10 |
PhoneBusiness |
18AN |
|
|||||||
11 |
PhoneMobile |
18AN |
|
Use the international format: “+” + country code + regional code + number, e.g. |
||||||
12 |
Birthdate |
Date |
|
|||||||
13 |
CurrentEmailAddress |
255AN |
|
see email addresses |
||||||
14 |
NewEmailAddress |
255AN |
|
|||||||
15 |
NewPassword |
15AN |
(ü) |
New users: if you do not specify a password, then a random password is generated. |
||||||
16 |
Usergroup |
50AN |
ü |
One expression out of the user group keys defined in Flightnet |
||||||
17 |
UserResourcegroup |
50AN |
|
One expression out of the user resourcegroup keys defined in Flightnet |
||||||
18 |
UserCategory |
50AN |
|
One expression out of the user category keys defined in Flightnet |
||||||
19 |
Language |
de, fr, it, gb, us |
ü |
Language code (gb=English 24h, us=English AM/PM) |
||||||
20 |
ReservationLimit |
Integer |
ü |
Default: -1 |
||||||
21 |
ShowUserNotification |
Bool |
ü |
|
||||||
22 |
HideName |
Bool |
ü |
|
||||||
23 |
HideAddress |
Bool |
ü |
|
||||||
24 |
WaiveReservationRequest |
Bool |
ü |
|
||||||
25 |
LicenceNumber |
50AN |
|
|
||||||
26 |
MembershipExpirationDate |
Date |
|
|
||||||
27 |
LastAddressChange* |
Date |
|
READ ONLY Date of the last online change of address data |
||||||
28 |
LastContactChange* |
Date |
|
READ ONLY Date of the last online change of contact data (phone, email etc.) |
||||||
29 |
IsDeleted* |
Bool |
|
READ ONLY |
Remarks
| - | Currently, you can only download user data with the API. However, the structure can be used for manual upload. Therefore, the specification also contains fields used for upload only. |
| - | NewPassword: mandatory for new users. |
| - | Fields marked with * are export fields only. The content will be disregarded in the import process. |
| - | LastAdressChange and LastContactChange indicate the last change through the web interface. Upload of new user data through this interface will not change these dates. |
| - | If the “Include deleted users” option for file export is enabled, the deleted users of the last 365 are included in the file |
| - | The expression “[User _is_deleted!] is added to all deleted users to prevent reimport |
| - | Mandatory fields must have a value. |
| - | Non-mandatory fields can be blank. In such case, the previous value will be deleted in the database. |
Please note that read only columns will always be the last columns. If any new read/write columns will be inserted in future versions, they will be located BEFORE existing read-only fields (because read-only columns are not required for upload).