|
How can I check out the demo in a sql server environment? |
|
|
|
If you using the jLogbookserver version, 1. archive the existing Demo database to a text file using: jLogbookserver --instance=Demo --exportdata c:\temp\demo.txt You will need to run this from the c:\program files\jLogbook directory in a command shell. 2. Create a new sql server database. I used qtado to do this and I called the database pbmsql, 3. Add an instance in your jLogbook.prefs file. Mine looked like this: Pbmsql = Common: DBNAME = "pbmsql" DBHOST = HURLEY DBUSER = "sa" DBPASSWORD = "" DBPROVIDER = "SQLOLEDB.1" DBTYPE = "sqlserver" attachmentsdir = "attachments/demo" sessionkey='pbmsql-change' gridrefreshinterval=30 formheight=45 gridheight=55 logform: MESSAGE: SPELLCHECK = "True" It is important that the database connection information is correct. 4. Add the index reference at the bottom of the jlogbook.prefs page. I.e. IndexPage = Demo: serverclass = jlogbook.jLogbookMultiServer title = "jLogbook Menu Page" instances: Demo = Demo Logs = Logs KnowledgeBook = KnowledgeBook OrderBook = OrderBook HandoverBook = HandoverBook Legacy = Legacy Pbmsql = Pbmsql 5. Run the restore command. I.e. jLogbookserver --instance=Pbmsql --importdata --restoreconfig c:\temp\demo.txt You will need to run this from the c:\program files\jLogbook directory in a command shell. 6. Run the jLogbookserver command and in the browser (IE or Firefox) enter the URL http://<name of computer>:8080 and select the new instance. You should see the same data as the demo, but this time it will be coming from a SQL Server database not an access database.
|