Import and Export Region Properties

You can export the Region Properties as a datafile or copy all properties into clipboard, and edit them using Excel, LibreOffice/OpenOffice Calc or even your text editor. After finishing your edits, you can import the data file or paste the modified data from clipboard back into the Data Grid.

• Export Region Properties to edit in other software
• Import Region Properties into Data Grid
• Copy Region Properties to clipboard
• Paste Region Properties from clipboard into Data Grid

1:05" Edit Region Date in Data Grid

Export Region Properties to edit in other software

1. Click Export Data File to the bottom right corner of the Data Grid dialog. You will be prompted to save the Region Properties data as a text file in Unicode Text Format.
2. Open the data file in your favorite software to change the data. We recommend using spreadsheet software like Microsoft Excel or LibreOffice/OpenOffice Calc for easy editing of the data. If you are using LibreOffice or OpenOffice, you may rename the extension of the file from .txt to .csv so that Calc can pick up the file directly.

Import Region Properties into Data Grid

1. Make sure that the header column is present, and have the same number of columns when it is compared with the original data file exported from Data Grid. Tab characters are not allowed within the data, and you must replace them with spaces.
2. Save the data file in our recommended format:
   • Microsoft Excel: Save as Unicode Text format (.txt). This can be found from the Save as Type drop down on the Save dialog.
   • LibreOffice/OpenOffice Calc: Save as Text CSV format (.csv). This can be found from the Filter drop down on the Save dialog. Click Save to continue. In Export Text File dialog, please change the Field Options as follows:
     • Character Set: Unicode (UTF-8)
     • Field Delimiter: {tab}
     • Text Delimiter: Delete any characters and leave it blank.
3. Go back to iMapBuilder HTML5 software and open the Data Grid. Click Import Data File to the top of the Data Grid dialog and browse for the data file. Click OK to import.

Copy Region Properties to clipboard

1. Click the Copy all to Clipboard button to the bottom right of the Data Grid dialog. You will be prompted that all data are successfully copied.
2. Open your favorite software and paste the data directly for editing. We recommend using spreadsheet software like Microsoft Excel or LibreOffice/OpenOffice Calc for easy editing of the data.

Paste Region Properties from clipboard into Data Grid

1. Select all relevant data from the software you have used to edit. Make sure that the header column is present, and have the same number of columns when it is compared with the original data copied and pasted. Tab characters are not allowed within the data, and you must replace them with spaces.
2. Go back to iMapBuilder HTML5 software and open the Data Grid. Click Paste from Clipboard to the top of the Data Grid dialog. You will be prompted if you have successfully pasted the data or not. If you cannot paste the data into the grid, please check if your data satisfy the conditions mentioned from step 1. Adjust the data and paste again.

[ Top of Page ]