How to Export Resources (Locations, Offices, Desks, Meeting rooms, etc.)

Last Updated: November 19, 2024 08:42

Summary

Some customers use the Import Resources feature for bulk updates of existing resources, such as price changes for multiple offices. In order to update all of them through the Resources Import option, they need to have the Name, Type, Location, and Available From date for every office. The quickest way to obtain this data is to export it in .CSV file format, make the changes, and import the updated file.

What Resources & Properties Can Be Exported?

The following resources and their properties can be exported from OfficeRnD Flex.

Locations

Name
Target Revenue
Total Desks

Private Offices

Resource Name - the name of the office
Resource Type - the export displays the resource type being exported, which in this case is Private Office
Location - the name of the location of the office
Floor - the floor on which the office is located
Target Plan - the name of the plan used as a Target Plan for the office
List Price - the target price of the office
Deposit - the target deposit of the office
Size (Area) - the size of the office in sq.mt or sq. ft.
Size (People) - the size of the office in the number of people it can accommodate
Available From - the date when the office becomes operational and available for booking.
Available To - the date when the office stops being operational and available for booking.
Status - the current availability status of the office. The values can be available, occupied, or unavailable.
Member - the name of the company/member currently occupying the office
Period - the period (start date-end date) in which the office is occupied by the company/member
Sold Price - the price at which the office was sold to the company/member
Sold Price Per Desk - the price per desk at which the office was sold to the company/member
List Price Per Desk - the targeted price per desk for the office
[Custom Properties] - at the end of the export, customers find the values of the custom properties specified to further describe offices.

Custom Resources

Resource Name - the name of the resource
Resource Type - the name of the custom resource type
Location - the name of the location of the resource
Floor - the floor on which the resource is located
Target Plan - the name of the plan used as a Target Plan for the resource
List Price - the target price of the resource
Deposit - the target deposit of the resource
Resource Rate - the name of the resource rate controlling the price of the resource
Parent - the name of the resource’s parent if it has one.
Size (Area) - the size of the desk in sq.mt or sq. ft.
Size (People) - the size of the resource in the number of people it can accommodate
Available From - the date when the resource becomes operational and available for booking/purchase/rent.
Available To - the date when the resource stops being operational and available for booking/purchase/rent.
Privacy - the visibility of the resource to members:
- Public - When the exported resource’s privacy is Public, it means that the resource is available to all members and non-members and is visible on the public calendar.
- Active Members - When the exported resource’s privacy is Active Members, it means that the resource is only available to active members.
- Limited - When the exported resource’s privacy is Limited, it means that the resource is only available to specific companies and/or members.
Status - the current availability status of the resource. The values can be available, occupied, or unavailable.
Member - the name of the company/member currently occupying the resource
Period - the period (start date-end date) in which the resource is occupied by the company/member
Sold Price - the price at which the resource was sold to the company/member
Sold Price Per Desk - the price per desk at which the resource was sold to the company/member
List Price Per Desk - the targeted price per desk for the resource
Description - the description of the resource.
[Custom Properties] - at the end of the export, customers find the values of the custom properties specified to further describe the custom resource.

Desks

Resource Name - the name of the desk
Resource Type - the export displays the resource type being exported, which in this case can be Dedicated Desk, Office Desk and Hotdesk
Location - the name of the location of the desk
Floor - the floor on which the desk is located
Target Plan - the name of the plan used as a Target Plan for the desk. By default, this property is only applicable to Dedicated Desks.
List Price - the target price of the desk. By default, this property is only applicable to Dedicated Desks.
Deposit - the target deposit of the desk. By default, this property is only applicable to Dedicated Desks.
Resource Rate - the name of the resource rate controlling the price of the desk. By default, this property is only applicable to Hotdesks.
Parent - the name of the office where the desk belongs. Only applicable to Office Desks.
Available From - the date when the desk becomes operational and available for booking.
Available To - the date when the desk stops being operational and available for booking.
Privacy - the visibility of the desk to members. By default, this property is only applicable to Hotdesks.
- Public - When the exported desk’s privacy is Public, it means that the room is available to all members and non-members and is visible on the public calendar.
- Active Members - When the exported desk’s privacy is Active Members, it means that the room is only available to active members.
- Limited - When the exported desk’s privacy is Limited, it means that the room is only available to specific companies and/or members.
Status - the current availability status of the desk. The values can be available, occupied, or unavailable. By default, this property is only applicable to Dedicated Desks and Office Desks.
Member - the name of the company/member currently occupying the desk
Period - the period (start date-end date) in which the desk is occupied by the company/member
Sold Price - the price at which the desk was sold to the company/member
Description - the description of the meeting room.
[Custom Properties] - at the end of the export, customers find the values of the custom properties specified to further describe desks.

Meeting Rooms

Resource Name - the name of the meeting room.
Resource Type - the export displays the resource type being exported, which in this case is Meeting room
Location - the name of the location of the meeting room
Floor - the floor on which the meeting room is located
Resource Rate - the name of the resource rate controlling the price of the meeting room
Parent - the name of the meeting room’s parent if the room has one.
Size (Area) - the size of the meeting room in sq.mt or sq. ft.
Size (People) - the size of the meeting room in the number of people it can accommodate
Available From - the date when the meeting room becomes operational and available for booking.
Available To - the date when the meeting room stops being operational and available for booking.
Privacy - the visibility of the meeting room to members:
- Public - When the exported meeting room’s privacy is Public, it means that the room is available to all members and non-members and is visible on the public calendar.
- Active Members - When the exported meeting room’s privacy is Active Members, it means that the room is only available to active members.
- Limited - When the exported meeting room’s privacy is Limited, it means that the room is only available to specific companies and/or members.
Description - the description of the meeting room.
[Custom properties] - at the end of the export, customers find the values of the custom properties specified to further describe meeting rooms.

How To Export Resources

1. Open the Space module.

2. Click on the page of the resource type you want to export, e.g. Space/Desks.

3. Click on the Export button in the upper right corner of the page:

Export btn.png

4. Save the .CSV file on your computer.

Learn More