Info |
---|
This guide has been reviewed against our global client base and classed as relevant to the following regions: UK, APAC, UAEall regions |
When information is shown in a grid, it can be exported to Microsoft Excel
Expand | ||
---|---|---|
| ||
A grid is any list of information shown where the column headings can be grouped/sorted filtered - e e.g. report results, viewing full results from an Organiser panel - grids are found throughout Reapit Agency Cloud when a list of information is shown An example grid is shown below |
Grid contents can be exported using standard or custom export methods:
- Standard: allows you to export the information shown in the current grid
- Custom: allows you to choose what information is exported, this might include all/some information some information shown in the grid, along with other related data currently not shown
If the information you require is already shown in a grid, then choosing to carry out a standard export from that grid is recommended - see steps 1 & 2 below
If not, then it is recommended to view a grid as close as possible to the information required, then carry out a custom export and add/edit the required columns - see steps 1 & 3+
Info |
---|
A custom export is reliant on where the information is stored within database tables in Reapit Agency Cloud AgencyCloud For example, if you want to see properties that have had viewings in the last three months along with the applicants that viewed, this cannot be gained from a property report, as the related diary and applicant information is not held here - however, running a diary report would allow this information to be retrieved, as the diary table is where the required information is held |
1. Accessing the export to Excel options From the required grid:
| |||
2. Standard export Selecting to do a Standard export opens Excel and pulls the content of the grid (shown in step 1) into a worksheet If the grid was grouped, the export to Excel will include a pivot table worksheet too | |||
3. Custom export When selecting to do a Custom export, choose which template type you need (if custom templates have already been created, the screen shown in step 7 will be displayed)
| |||
4. Add/edit data included in export As the Create template from standard option was chosen in the previous step, standard columns for the report type are automatically shown the Excel Export Designer Use this screen to edit / remove / change column order shown, as well as add new columns
| |||
5. Adding a new export column Merge codes are needed to pull the required information from the database From the Excel Export Designer (shown in step 6):
| |||
6. Accessing custom Excel templates Once a custom Excel template has been created it will be available on all grids of the same type
| |||
7. Edit/delete custom Excel templates To edit or delete any custom Excel templates created As shown in step 6:
|
Custom Excel export examples
Each section below outlines column headings and their associated merge codes which can be added to the Excel Export Designer to create a custom Excel template
All columns/codes shown could be added to the template, or just a selection, as required
Expand | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
|
Expand | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
Staff details are shown in one column, separated by a tilde (~)
|
Expand | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||
|
Expand | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||
This report returns properties along with vendor details - when an external property is returned (i.e. one that is not being sold/let by your company) this is identified and will include the old vendor details from when the property was last listed with you
|
Expand | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||
|
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Feefo exports
Currently there currently isn't an automated process for providing Feefo data - where a Feefo export is required, the following reports should be set-up
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
|
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
|
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
|
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tenant details
Joint tenants
|
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Page Propertiesexcerpt | ||
---|---|---|
| ||
Related issues When information is shown in a grid, it can be exported to Microsoft Excel |