You can export the client computers data from the .XML files to other different data formats, for example, text files, HTML or CSV formats. Using ODBC you can export data to databases or electronic worksheets, i.e. MS Access or MS Excel. The programs data export is based on text template file processing. You can use the built-in set of templates or create your own.


Step-by-step instructions

      Export to the text formats:

·   Run ADMIN.EXE  
·   Click File menu / Export Data  
·   In the 'Select template to export' window select the text format you need (Comma-separated files (CSV), Text files or Web Site), then click Next  
·   Wait for the progress bar page to finish exporting computers. The duration of this process depends on the number of computers.  
·   In the 'Property page' window select the 'Save my data to the hard disk' option, and then specify the path to the directory.  
·   After you have completed the export you will find the. TXT, .HTM or .CSV files in the folder you specified.  

Export to databases and electronic worksheets via ODBC:  

·   Set up the corresponding ODBC data source (MS Access or MS Excel)  
·   Run ADMIN.EXE  
·   Click File menu / Export Data  
·   In the 'Select template to export' window select Microsoft Access database (via ODBC) or Microsoft Excel worksheet (via ODBC), then click Next  
·   Wait for the progress bar page to finish exporting computers. The duration of this process depends on the number of the computers.  
·   In the Property page window select the 'Import it to the ODBC data source' option, then specify the corresponding item from the 'To this data source' list, then click Next  
·   Wait for the completion of the SQL instructions execution. It can take some time depending on the number of computers.  
 
Note: You can use the report.xls file from the \Export\ directory to export data to into the Excel file in a formatted appearance. You should create a copy of the sample report.xls file and then set up the MS Excel ODBC data source to use this copied file and perform the export as shown above. Exporting into the \Export\report.xls is not recommended as the sample template will be lost.  

How to modify or create your own export templates
 
The program's data export is based on the use of the template files that are located in the subdirectories of the \Export\ folder and represent usual text files. If you are unhappy with the existing templates you can modify them or create new ones by editing the corresponding text files in any text editor. The data is transmitted into the templates by means of special variables - macro's. For example %OS_NAME% , %USER_NAME% etc.

You can find the names of all possible macro's in built-in templates. If you want a new template to appear in the Select template to Export window, you have to create the new subdirectory in the \Export\ folder and place the corresponding text file there.

Please note that you should not use spaces in the names of the \Export\ subfolders, please use the underline symbol ("_") instead.