Smartstaff
2,091
edits
Changes
m
:*:* This will vary slightly depending on your version of Microsoft Excel. Check the Microsoft Website or Help Menu in Excel for assistance.:[[File:ExcelImportData.png]]* Browse to the location of the exported report .txt file and click '''Open'''* Select '''Unicode (UTF-8)''' as the '''File Origin''' and click '''Finish''' (UTF-8 normally appears near the bottom of the list):[[File:ExcelFileOriginUTF8.png]]* Choose the cell you wish to place the data and click OK.
→Import Data
In order to support '''Special Characters''' , such as French -accented letters, euro Euro symbols , etc ., [[SmartSimple]] uses UTF-8 encoding throughout the system, including when reports are exported.
* This is a flaw with Excel.
In order to export data containing special characters from [[SmartSimple]] to Excel , use one of the procedures outlined below.
* Open a blank worksheet in Excel
* From the '''Data''' menu select '''Import External Data''' followed by '''Import Data'''
* [[File:ExcelImportData.png]]
** Browse to the location of the exported report .txt file and click '''Open'''
** Select '''Unicode (UTF-8)''' as the '''File Origin''' and click '''Finish''' (UTF-8 normally appears near the bottom of the list)
*: [[File:ExcelFileOriginUTF8.png]]
*
** Choose the cell you wish to place the data and click OK.
===CSV Data Security===
When exporting data into a CSV format, files can become vulnerable to [https://owasp.org/www-community/attacks/CSV_Injection malicious CSV injection attacks]. As a precautionary measure, an additional space will be added at the beginning of any values starting with at signs ( @ ), plus signs ( + ), minus signs ( - ), piping symbols ( | ), or equals signs ( = ). Therefore, when you export a file from Platform3 into a CSV format and later need to import that file into another system, please ensure you trim the additional space in front of any values.
==Copy and Paste from Notepad/Wordpad==
[[Category:Reports]][[Category:Integration]]