Difference between revisions of "Usermanual/ExportXL"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
(Created page with 'Export will create and download a file readable by Microsoft Excel or any other 3rd party Office product. Export file options inlclude * All records: Unlike the default limited …')
 
m (5 revisions imported)
 
(4 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 inlclude
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
* Related records: 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 keys instead of readivle values
* '''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 ...".