Data Locations

The Data Locations setting determines how R.O. Writer DVI Suite connects to the R.O. Writer database to retrieve updates, images, videos, and documents.

There are two data location setups: Non-SQL (R.O. Writer Gen 1) and SQL (R.O. Writer Gen 2, Version 3, and higher).

WARNING! R.O. Writer Gen 1 data locations have not been supported since the release of R.O. Writer 2.3. Users are advised to update to the latest R.O. Writer version to avoid critical issues.

SQL Setup in Set Data Location

If you are using R.O. Writer Gen 2, Version 3, or higher, check R.O. Writer Version 2.0 or higher. The settings appear on the window.

Set Data Location window with settings configured for R.O. Writer Version 2 or higher

The following table describes the settings for R.O. Writer Version 2.0 or higher.
Setting	Description
R.O. Writer Version	Select 2.0 or Higher to connect to a SQL database, which is used by R.O. Writer Gen 2, Version 3, or higher.
SQL Server	The location of the R.O. Writer database. R.O. Writer DVI Suite uses the same database as R.O. Writer.
Database	The name of the database.
Store Number	Your R.O. Writer license number.
Images Path	The server location of the image files. This is usually the image directory within the R.O. Writer data directory. This directory also stores documents and checklist images used in checklists.
Update Server	R.O. Writer DVI Command retrieves files to update itself from this server. Leave this field blank to use the default update server (Recommended).
Video Server	R.O. Writer DVI Command retrieves videos from this server. Leave this field blank to use the default server (Recommended).
Public Video Server	R.O. Writer DVI Command stores videos on this server. These videos are shown in checklists sent to customers. Leave this field blank to use the default public video server (Recommended).
Touch URL	The URL of the R.O. Writer DVI Command installation on your machine or network.
Test Data Connection button	Click to test the connection to the database and servers. A message displays if the connection has succeeded or not.
Save button	Click to save the data location information.

Non-SQL Setup in Set Data Location

If you are using R.O. Writer Gen 1, set the data location to a non-SQL database by checking R.O. Writer Version 1.X.

The Gen 1 Data Location settings.

WARNING! Since the release of R.O. Writer 2.3, Gen 1 data locations are no longer supported. This option will be removed in a future update. Please upgrade to the latest R.O. Writer version to avoid critical issues.

The following table describes the settings for R.O. Writer Version 1.X.
Setting	Description
R.O. Writer Version	Select 1.X to connect to a non-SQL database, which is used for R.O. Writer Gen 1.
Data Path	The data server where the R.O. Writer database is stored.
Images Path	The server location of the image files. This is usually the image directory within the R.O. Writer data directory. This directory also stores documents and checklist images used in checklists.
Update Server	R.O. Writer DVI Command retrieves files to update itself from this server. Leave this field blank to use the default update server (Recommended).
Video Server	R.O. Writer DVI Command retrieves videos from this server. Leave this field blank to use the default server (Recommended).
Public Video Server	R.O. Writer DVI Command stores videos on this server. These videos are shown in checklists sent to customers. Leave this field blank to use the default public video server (Recommended).
Touch URL	The URL of the R.O. Writer DVI Command installation on your machine or network.
Save	Click to save the data location information.