Would you like to...

Print this page

Email this page

Post a comment

Subscribe me

del.icio.us

Digg it

Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (3 votes)

100% 0%

---

How would you rate this answer?

Helpful

Not helpful Help us improve. Why was this unhelpful?

Thank you for rating this answer.

Last Updated: 10th September 2010 08:29:53 am

You can import existing SQLite databases used in License Statistics v3.0 and older to License Statistics v3.5 and newer by copying the databases to a db directory in the current License Statistics version. Upon starting License Statistics the database files in the db directory will imported automatically. The import status will be printed to the log\xflicstat.log file.

If you have existing databases that contain overlapping data; that is, they contain information about the same vendor and license server, the databases must be merged before the import.

A typical case of when such a merger is needed is for databases that have been archived. For instance, let's assume that there are two SQLite database files for vendor MyVendor and MyServer. The first file, MyVendor_MyServer_2007.db, contains data from the year 2007 and  the second file, MyServer_MyServer_2008.db, contains data from the year 2008. These two databases must be merged using the xfeditdb utility before importing, as follows:

xfeditdb.exe -merge MyVendor_MyServer.db MyVendor_MyServer_2007.db MyVendor_MyServer_2008.db

This command will result in the new file MyVendor_MyServer.db, which contains the data from both 2007 and 2008. This merged file can then be imported to License Statistics as described above.