=File Export=
==File Extension==
By setting A report can be exported into a flat file with the following file extension, you define which program on your computer should be used to process the exported report data. Some common extensions that are useful for exporting data are:
* '''txt''' – Windows Notepad.
* '''csv''' - Comma Separated Values.
* '''xml''' - Extensible Markup Language (can be opened in Notepad).
1. Set the '''Extension''' to '''txt'''.
7. Close the '''Notepad''' [[Application|application]].
==Export to Excel==
If you change the extension to '''xls''', then the file will be opened with MS-Excel.
1. Click the '''Reports''' tab.
2. Click the '''Edit''' button for the '''Employee List''' report.
3. Click the''' Custom Export''' tab.<br />
[[image:Advanced export settings.png]]
You can specify the layout of the report to be exported in the next screen
[[image:Advanced export settings2.png]]
'''Header''' section : you specify the column headings for your report to be exported.
'''Fields''' drop down : gives a list of variables that correspond to the fields selected in the report through report builder.
'''Details''' section : you specify the fields for the report to be exported. The fields that you select will be displayed right to left in exported report so select the field for the last column first.
4. Change the '''Extension''' to '''XLS''' or '''CSV'''.
5. Save the '''Layout'''.
6. Return to the '''Report''' list and click the '''Export''' button.
[[Image:Advanced export settings3.png|thumb|none|900px]]
The '''File''' is opened in MS-Excel.
[[Image:Excel report.png]]
'''IMPORTANT:''' In order to support '''special characters''' such as French accented letters, euro symbols etc [[SmartSimple]] uses UTF-8 encoding. When opening exported files Microsoft Excel always imports using ASCII, so special characters do not appear correctly. This is a flaw with Excel. In order to export data containing special characters to Excel use one of the procedures outlined on the [[Exporting Reports with Special Characters to Excel]] article.
'''Note:''' If the report has sub reports attached then you must set up the Custom Export settings for each of the sub report attached.
==Export to XML==
==Export to XML==
If you change the '''File extension''' to '''xml''', then the report will construct an XML document from the report results.
* The following would export a report and subreport in Comma Separated Values format (CSV):
<pre> @Companies/Accounts - Company name@, @Companies/Accounts - Address 1@, @Companies/Accounts - City@, @Companies/Accounts - State@, @Companies/Accounts - Company ID@, @subreport_0@ {BREAK}</pre>
=Custom Export=
=Export to SmartFolder or SFTP=
A report can now be automated to export to a SmartFolder or an external SFTP site. You can now as report as per schedule a recurring task on a daily, weekly, or monthly basis to automatically run a report and export the contentsSmartFolder or an external SFTP site.The file will be exported based the normal ''File Export''' and no option for '''Custom Export''' is currently available.<!--54913 - Ability to store report export to specified SmartFolder--><!--67965 - Extend schedule report export to custom template-->
From the report configuration, go to '''FILE EXPORT''' tab and under '''Go to [[Scheduled Report Export''', ]] on how to configure desired settings:scheduled report exports.
[[File:ScheduledExport.PNG|800px]]
* '''Export Type '''- specify the type of export for the scheduled export
: ''Options:'':* File Export <!- export file based on settings from [wiki/Exporting_Reports '''File Export'''] tab:* Custom Export - export file based on settings from [wiki/Custom_Export '''Custom Export''']:* '''Frequency''' 54913 - choose the frequency of the export:** Disabled:** Daily :** Weekly:** Monthly:** Quarterly:** Yearly:** On Demand - used when Ability to store report is linked to an autoloader.'''At (Start Date)''' - specify time for the scheduled export'''Starting''' - specify the start date for the scheduled export:* '''Export To''' - select where to export the file:** '''SFTP''':*** '''URL''' specified SmartFolder- enter the url of the sftp site:*** '''Username''' - username to allow access to the sftp:*** '''Password''' - password to allow access to the sftp:*** '''Path''' - sftp folder location where the files will be pushed i.e. ''/in'' or ''/out''>'''Configuration Folder''''''SmartFolder''':*** '''SmartFolder''' <!- select the SmartFolder where the files will be pushed'''Update Status After Export''' - status of the records will changed to the selected status after export.'''Trigger Workflow After Export''' 67965 - workflow selected will be triggered to all records after Extend schedule report export.:* '''Export File Name''' - file name of the file can be specified including stamp date. It is recommended to append a timestamp. To stamp the date, use [YYYY],[YY],[MM],[DD],[HH],[mm]. i.e. MyExportedReport_[YYYY]custom template-[MM]-[DD]:* '''Last Exported''' - date and time of the last export.:* ===Examples===:* :*:* Export Every Monday of the week @ 0900:*:: Choose a future date that falls on a Monday for the '''Start Date''', '''Weekly''' for the '''Frequency''' and select the '''Time of Export''' dropdown list.:*: :*:* Export Every 15th of the month:*:: Choose '''15th''' (future date) for the '''Start Date''' and '''Monthly''' for the '''Frequency''' and select the '''Time of Export''' dropdown list. ===Troubleshooting===:* :*:* This won't work for reports that have any criteria, or reports with any other variables that require a user session or user input - for instance, the setting that allows you to select a template from a SmartFolder before exporting. Reports violating these will either not be exported, or have no data when exported, or maybe some other unpredictable result.>:*:* To reset/change the schedule, '''Disabled''' the '''Frequency''' then save it. This will delete the current setting configurations from the database. Then, enter new schedule settings and save. :*:* No option for '''Custom ExportSee Also''' is currently available *
==See Also==
:** [[Exporting List View Results to Microsoft Excel]]
:** [[Report Variables]]
