Offices
What is the meaning of office?
An office is a lower level than an agency. An agency can have several offices.
How to create an office
Considerations
It is an incremental load, so bear in mind these considerations:
If an office exists then it is updated.
If an office does not exist then it is created.
Existing offices that are not referenced are not removed.
If an existing office has to be removed from system then you have to contact with TravelgateX.
If there is any problem with an office’s information then it is omitted (and logged) but the load continues.
Specifications<
File name:
Master_Offices.csv
.Each line represents a unique office and contains all the information (fields) about it.
The first line is not a header line: it contains data directly.
Inside a line fields are separated using the character
#
. This character can’t be used inside data because fields would be gathered in a wrong way.The data of the fields is not encapsulated by
"
or any other character: the information must be included directly.Any blank line will be skipped.
The file and its data have to be encoded using UTF-8. Otherwise there can be stored strange characters.
If a field is mandatory then it has to be present in each line, even if it has no data: its used position cannot be omitted. If mandatory then we have to see if its data is mandatory or not.
If a field is not mandatory but we want to set it then all previous fields must be present: if any previous field is not mandatory and we don’t want to set a value we will have to include it with no value. We need it this way as it is used the field position to map it to the target data.
If a field’s data is not mandatory and we don’t want to set it then we just keep it empty: i.e. …##…
If a field’s data is mandatory then we have to set something (no value is not admitted).
Line fields
Position | Mandatory Field | Mandatory Data | Type | Description |
---|---|---|---|---|
0 | Yes | Yes | string | Office code |
1 | Yes | Yes | string | Office name |
2 | Yes | Yes | string | Agency code (to which the office belongs to) |
3 | Yes | Yes | boolean | Is active |
4 | Yes | Yes | decimal | Markup |
Examples
2#Office2#AG1#true#0.8
3#Office3#AG1I#false#1
4#Office4#AG1#true#0
1#Office#AG1#true#1.2
2#Office2#AG2#true#3.4