0
edits
Changes
→Exporting XML Fields
* The XML Data field will open in a pop-up window. Open the '''Export''' menu and select '''MS Excel''':
:[[Image:Xmlexport.png]]
* MS Excel will then open with the exported data.
'''Important''': If you plan to edit the data using MS Excel and Import it back into [[SmartSimple]] the structure of the data must be retained so that it matches the XML structure of the XML Data field in [[SmartSimple]].
==Importing XML Fields==
* First close the MS Excel document that you wish to import, if it is open.
* Once you have opened the desired record with the '''SmartSimple XML Editor''' find the '''XML Data''' field into which you wish to import and click on the '''Open''' button on the record:
:[[Image:Xmlopen.png]]
* The XML Data field will open in a pop-up window. Open the '''Import''' menu, select '''MS Excel''', then '''Launch MS Excel'''.
:[[Image:Xmlimport.png]]
* Click OK when the following message appears:
:[[Image:Xmlmsg.png]]
* An Microsoft Excel window will now open. You '''must''' use that window to open the MS Excel file to be imported.
* Once you have opened the relevant MS Excel file return to the XML file window of the '''SmartSimple XML Editor''' and select '''Import''' >> '''MS Excel''' >> '''Import Active Worksheet''':
:[[Image:Xmlimport2.png]]
'''Important''': The structure of the data in the MS Excel file you import must match the XML structure of the XML Data field in [[SmartSimple]].
==See Also==