InfoQube can sync with the Online User Manual so that any new content / changes will automatically be imported in any IQBase.

 

The "Welcome to InfoQube" IQBase is pre-configured to connect with our web server.

 

Steps are:

1. Download and install the mySQL ODBC connector (version 8.0)
   Select Windows (x86, 32-bit), MSI Installer or use this direct link
2. You'll be asked to login to Oracle. You can, but better still simply click on No thanks, just start my download
3. Install the downloaded file (mysql-connector-odbc-8.0.xx-win32.msi)
4. To synchronize, do Tool  > Database management  > Remote database sync 
   (you can customize the toolbar [right-click ->customize] to add it to a toolbar if you want)
    

1. In Field Management, create the following fields:
   • IQDoc: Yes/No
   • IQDocDate: Date: Doc update date
   • IQDocNID: Number: Doc node ID
   • IQDocPID: Number: Doc parent node ID
   • IQDocStatus: Text: New / Update status
      
2. To have a direct link to the online page, add the following in the Equations > Auto-assign section of the field IQDocNID:
   AM:[URL]="https://infoqubeim.com/drupal5/node/" & [IQDocNID] | E:[URL]=
    
3. Create a new grid IQDoc (will automatically use the field IQDoc)
    
4. In Tools > Options > This File > Data storage
   1. Enable Remote database one-way Sync
   2. Set  the auto-sync delay (in minutes, 0=manual only -- recommended)
   3. In Sync Config file, browse to select the config file. The one provided is SQLSyncIQDoc.xml (located in AppFiles folder)
   4. If syncing with more than one remote database, leave this blank and put all config files (named SQLSync*.xml) in the same folder as the IQBase. InfoQube will ask you which ones to sync.
       

1. Sync main field is IQDocNID.
2. If an item exists with book page node id, it is used else an item is created
3. The fields Item and HTML are updated with the doc content
4. There are a few Regexp substitutions made, as defined in the SQLSyncIQDoc.xml file
   1. Relative paths are converted to absolute ones
   2. Internal links (node:nodeid enclosed by [ ]) are converted to URLs and to an IQBase internal link (IQDocNID=nodeid)
5. You can add any other field values / tags and these will not change after a sync
6. New doc items will appear under the correct parent item. It's positional order may not match the web site though
7. The last line of the sync config file gives the date of the last sync (in ICal format). Only changes more recent than this date will sync. To re-sync with the whole user manual, remove that date:
   i.e. change <LastUpdate>20181120T011501</LastUpdate> to <LastUpdate></LastUpdate> and save the file.

The Online User Manual is nice, but having an updated copy right inside InfoQube is so much nicer to navigate, read, search, filter, etc.

Troubleshooting