secretgaq.blogg.se - Ms excel import xml file

When I double-click the file, Excel displays it correctly: 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.This file has the following scheme/style information embedded: The data in the MS Excel file will now be uploaded into the XML field in SmartSimple.Click OK when asked if you wish to overwrite the current server data.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:.You must use that window to open the MS Excel file to be imported. A Microsoft Excel window will now open.Click OK when the following message appears:.Open the Import menu, select MS Excel, then Launch MS Excel. The XML Data field will open in a pop-up window.Find the XML Data field into which you wish to import and click on the Open button on the record:.Note: if you wish to import the data into a new record you should create and save the new record now. Opened the desired record within SmartSimple with the SmartSimple XML Editor.First close the MS Excel document that you wish to import, if it is open.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.

This document can now be treated as a normal MS Excel document and saved locally, e-mailed etc.

A MS Excel window will now open containing the data from the XML field that you exported.

Open the Export menu and select MS Excel:

Once you have opened the desired record with the SmartSimple XML Editor find the XML Data field you wish to export and click on the Open button on the record:.

(Click "Show Search" if you do not see the search panel on the right).

Using the filter and search options on the right-hand side of the SmartSimple XML Editor window you should now search for the desired record.

After a few seconds you will be presented with the Level 1 interface for your UTA.

Select the desired UTA from the Applications list and click List.

Once the SmartSimple XML Editor has authenticated with SmartSimple the Application pull-down list will populate with a list of the UTAs in your SmartSimple instance, and the List button will become active.

Click to Enable SSL if you wish to encrypt the connection to SmartSimple.

Enter your SmartSimple Server URL, Alias, User Name and Password:.

If you are logged into SmartSimple via a web browser you should log out.

Open SmartUTABudget from your Programs menu.

Install the SmartSimple XML Editor application, following these instructions.