[Eng] Detail import file excel
Sheet Chain | Sheet Hotel | Sheet RoomType | Sheet Room | Sheet Media_hotel | Sheeet Media_roomType | Sheet Code | Sheet Block | Sheet Floor | Sheet Section | Sheet Code_roomType | Sheet Code_hotel | ||||||||||||||||||||||||
Main group, there will be many hotels | Hotel | Types of rooms available in the hotel | Rooms available in hotels, usually identified by number | The hotel's media information | The media information of the room type | Information that needs configuration (preferences: special, hotel feature,market code, source code ….) | Regional block of the hotel | The hotel's floor | Division by region | Room type code (Room type) | Hotel Code (Hotel) | ||||||||||||||||||||||||
Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status | Column | Meaning | Status |
id | Information exported from the software | System generated, do not enter | Id | Information exported from the software | System generated, do not enter | Id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter | id | Information exported from the software | System generated, do not enter |
name | Name of chain | Required to enter | logo | Logo of the Hotel, can it be imported using the link of the photo? | Not required to enter | name | Room Type Name | Required to enter | name | Room name | Required to enter | url | Where is the image link of this hotel to put in this excel file? | Required to enter | url | Where is the image link of this room type to put in this excel file? | Required to enter | name | Name definition | Required to enter | name | Block name | Required to enter | name | Floor name | Required to enter | name | Name definition | Required to enter | code | Ordinal number | Not required to enter | code | Ordinal number | Not required to enter |
slug | a type of code generated from the name used for identification | System generated, do not enter | name | Name of hotel | Required to enter | slug | a type of code generated from the name used for identification | System generated, do not enter | prefix |
| System generated, do not enter | title | Information exported from the software | System | title | Information exported from the software | Required to enter | description | Description of information | Not required to enter | description | Block description | Not required to enter | description | Floor description | Not required to enter | description | description | Not required to enter | roomTypeCode | Room type code (Room type) | Required to enter | hotelCode | Hotel Code | Required to enter |
description | Description of the chain | Not required to enter | slug | a type of code generated from the name used for identification | System generated, do not enter | code | Room type code | Required to enter | slug | a type of code generated from the name used for identification | System | order | Quantity | Not required to enter | order | Quantity | Not required to enter | order | Ordinal number | Not required to enter | order | Ordinal number | Not required to enter | order | Ordinal number | Not required to enter | order | Ordinal number | Not required to enter | hotel Code | Hotel Code | Required to enter |
|
|
|
order | Ordinal number | Not required to enter | description | Hotel description | Not required to enter | description | Room type description | Not required to enter | description | Room description | Not required to enter | type | Image type | Required to enter | type | Image type | System | icon | Image | Not required to enter | code | Block Code | Required to enter | code | Floor code | Required to enter | code | Section Code | Required to enter |
|
|
|
|
|
|
code | Chain Code | Required to enter | order | Ordinal number | Not required to enter | short Description | Short description of the room type | Not required to enter | order | Ordinal number | Not required to enter | size |
| System generated, do not enter | size |
| System generated, do not enter | type | What kind of information? | Required to enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter |
|
|
|
|
|
|
totalHotels | Total number of Chain hotels created in the Hotel sheet, system will automatically take the total => Do not enter | System generated, do not enter | location Coordinates | location coordinates | Not required to enter | order | Ordinal number | Not required to enter | roomNumber | Room.No (E.g: 1890, 1789,…0 | Required to enter | contentType |
| System generated, do not enter | contentType |
| System generated, do not enter | code | information code | Required to enter | createdAt | The date of starting to create block on the system, the system will automatically record the date | Not required to enter | createdAt | The date of starting to create floor on the system, the system will automatically record the date | Not required to enter | createdAt | The date of starting to create Section on the system, the system will automatically record the date | Not required to enter |
|
|
|
|
|
|
status | Input “1” the status is active. input “0” the status is inactive | Required to enter | star | hotel ratings | Not required to enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter | phoneNumber | Room’s phone number | Not required to enter | width |
| System generated, do not enter | width |
| System generated, do not enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter | updatedAt | Record the date of modification of block information on the system, the system automatically records the date | Not required to enter | updatedAt | Record the date of modification of floor information on the system, the system automatically records the date | Not required to enter | updatedAt | aRecord the date of modification of section information on the system, the system automatically records the date | Not required to enter |
|
|
|
|
|
|
createdAt | The date of starting to create chain on the system, the system will automatically record the date | Not required to enter | beginDate | Operation start date | Not required to enter | numberOfRoom | Number of "Rooms" under "Room Type". This information field will automatically get the information on the sheet "Room" | System generated, do not enter | isSmoking | Input "1" if smoking is allowed, input "0" if not allowed | Required to enter | height |
| System generated, do not enter | height |
| System generated, do not enter |
|
|
| hotelCode | Hotel code | Required to enter | hotelCode | Hotel code | Required to enter | hotelCode | Hotel code | Required to enter |
|
|
|
|
|
|
updatedAt | Record the date of modification of chain information on the system, the system automatically records the date | Not required to enter | legalOwner |
| System generated, do not enter | numberOfTotalRoom | Total Number of "Rooms" under "Room Type". This information field will automatically get the information on the sheet "Room" | System generated, do not enter | bedInfo |
| System generated, do not enter | hotelCode | Hotel code (Hotel Code) | Required to enter | roomTypeCode | Room type code (Room type) | Required to enter |
|
|
|
|
|
| blockCode | Block code | System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
| street | Hotel’s address | Not required to enter | numberOfBed | total number of beds for this room type | Not required to enter | roomStatus | System generated, do not enter |
|
|
| hotelCode | Hotel code containing this room type | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| postCode | Post code | Not required to enter | defaultOccupancy | Default occupancy | Not required to enter | foStatus |
| System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| city | city | Not required to enter | isHouseKeeping |
| System generated, do not enter | assignStatus |
| System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| telephone | Hotel’s phone number | Not required to enter | isGeneric |
| System generated, do not enter | hkStatus |
| System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| hotelphone | Hotel’s phone number | Not required to enter | isPseudo | Input “1” if it's a psuedo room. If it is not input “0” | Not required to enter | status | Input “1” the status is active. input “0” the status is inactive | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| numberOfRooms | Number of room | Not required to enter | isMeeting |
| System generated, do not enter | sectionId |
| System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| fax | Hotel’s FAX | Not required to enter | isGroup |
| System generated, do not enter | isPsuedo | Input “1” if it's a psuedo room. If it is not input “0” | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| webAddress | Hotel’s website address | Not required to enter | autoRoomAssign |
| System generated, do not enter | isPsuedo,isPseudo |
| System generated, do not enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hotel’s email | Required to enter | autoPopulate |
| System generated, do not enter | squareUnit | room area | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| currencySymbol | The currency used in the hotel | Not required to enter | maxOccupancy | Maximum occupancy | Required to enter | squareUnitType | unit for calculating area | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| checkInTime | Check in time | Required to enter | squareUnit | room area | Required to enter | hotelCode | Hotel code (Hotel Code), containing this room | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| checkOutTime | Check out time | Required to enter | squareUnitType | unit for calculating area | Required to enter | roomTypeCode | Room type code (Room type) containing this room | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| baseLanguage | Base language | Not required to enter | maxAdult | maximum number of adults | Required to enter | blockCode | Block code | System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| regionCode |
| System generated, do not enter | maxChild | maximum number of children | Required to enter | floor Code | Floor code | System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| code | Hotelcode | Required to enter | activeDate |
| System generated, do not enter | sectionCode | Section code | System |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| status | Input “1” the status is active. input “0” the status is inactive | Required to enter | createdAt | The date of starting to create room type on the system, the system will automatically record the date | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| createdAt | The date of starting to create hotel on the system, the system will automatically record the date | Not required to enter | updatedAt | Record the date of modification of information on the system, the system automatically records the date | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| updatedAt | Record the date of modification of hotel information on the system, the system automatically records the date | Not required to enter | typeOfRoom | Rooms of Room Type. There are 2 types of rooms Hotel room, villa | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| chainCode | If the hotel belongs to a chain, record that chain code | Required to enter | numberOfBedRoom | number of beds | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| hotelTypeCode | Hoteltype code | Not required to enter | maxExtraBeds | Maximum number of extra beds for children | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| countryCode | Country code | Not required to enter | hotelCode | Hotel code (This room type belongs to which hotel ?) | Required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| stateCode | State code | Not required to enter | chainCode | Chain code (This room type belongs to which chain?) | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| roomNumber | List Room.No of each Room Type | Not required to enter |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|