Difference between revisions of "Usermanual/ExportXL"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 6: Line 6:
* '''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 name in columns (good for later [[Usermanual/ImportCSV|CSV imports]]
* '''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 ...".

Revision as of 12:59, 10 April 2013

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 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 ...".