Difference between revisions of "Usermanual/ExportXL"
Jump to navigation
Jump to search
old>Admin |
m (5 revisions imported) |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
Export will create and download a file readable by Microsoft Excel or any other 3rd party Office product. | Export will create and download a file readable by Microsoft Excel or any other 3rd party Office product. | ||
Export file options | Export file options include | ||
* '''All records''': Unlike the default limited to the records displayed in this page | * '''All records''': Unlike the default limited to the records displayed in this page | ||
* '''All fields''': Unlike default limited the fields displayed in the current view | * '''All fields''': Unlike default limited the fields displayed in the current view | ||
* '''Explode parents''': Include data from related '''parent''' records | * '''Explode parents''': Include data from related '''parent''' records | ||
* '''Explode children''': Include data from related '''child''' records in denormalized (flattened) form | * '''Explode children''': Include data from related '''child''' records in denormalized (flattened) form | ||
* '''System export''': Use | * '''System export''': Use system name in columns (good for later [[Usermanual/ImportCSV|CSV imports]]) | ||
After downloading the file you should save it in you preferred format using "Save as ...". | After downloading the file you should save it in you preferred format using "Save as ...". | ||
Latest revision as of 11:56, 10 December 2021
Export will create and download a file readable by Microsoft Excel or any other 3rd party Office product.
Export file options include
- All records: Unlike the default limited to the records displayed in this page
- All fields: Unlike default limited the fields displayed in the current view
- Explode parents: Include data from related parent records
- Explode children: Include data from related child records in denormalized (flattened) form
- System export: Use system name in columns (good for later CSV imports)
After downloading the file you should save it in you preferred format using "Save as ...".