CyberArticle allows mutiple users to share documents at the same time (collect/manage documents simultaneously in the same book) through a database server (LAN or Internet)

1. Database server

Firstly, you need to have a database server. We recommend you to use Microsoft SQL Server 2000/2005 or higher versions / MySQL 5.1.  SQL Server / MySQL need to be installed on a computer in LAN / Internet.  For more details about the installation, please refer to the relevant documents concerning SQL Server / MySQL.
 

2. Create books with CyberArticle on database server

 
In CyberArticle, click "Main Menu -> File -> New -> Book" successively and then a dialog for creating a new book will be displayed.

i. Select "Remote book" in the "Type of new book" dialog.

ii. Set a name and a class for the book

iii. Set the database information

 
Database type: Select SQL Server or MySQL;
Server name: Enter the host name / IP address of Database server or the computer name in LAN;
Logon to the server: Select "This account";
User ID: sa;
Password: The password set by you for the user "sa" when SQL Server was installed;
Database Initialization: Select "Create database & tables"; 
Database name of book: Enter a database name, which will be used to save the data in the book, for example, enter CABookDatabase1. 
 
Click "Test Connection" so as to test whether the database server can be normally linked to. If an error is prompted, please check the relevant settings according to the error prompt. 
 
After the "Test Connection" is OK, click "Next" so as to complete the settings.
 
CyberArticle will create a database in the database server along with required tables.
If everything is OK, the new-created book will be shown in your CyberArticle.  You can try to save webpages in it so as to make a test.
 

3. Add a book on other computers

 
On other computers installed with CyberArticle, click "Main Menu -> File -> Open book" successively and then the "Open book" dialog will be diaplayed.  Select "Add remote book".

i. Database information dialog

 
Database type: Select SQL Server / MySQL;
Server name: Enter the IP address or host name of Database server or the computer name in LAN;
Logon to the server: Select "This account";
User ID: sa;
Password: The password set by you for the user "sa" when SQL Server was installed;
Database name of book: Enter the database name you just created.
 
Click "Test Connection" so as to test whether the database server can be normally linked to.  If an error is prompted, please check the relevant settings according to the error prompt. 
 
After the "Test Connection" is OK, click "Next" so as to complete the settings.
 
CyberArticle will open the books in the database server.  At the same time, the remote book will be shown in your CyberArticle.  You can try to save webpages in it so as to make a test.
 
 
 

4. How to use

 
After the settings on all the computers are completed, all of the users can save and modify the webpages in the remote CyberArticle book.  When other users have saved information and you need to re-open the book, right click on the related folder node and select "Refresh" in the contxt menu so that the new-saved webpages by other users can be shown in the folder list.
 

5. Advanced

i. Users

In the above example, "sa" is used as a user, which is the administrator in SQL Server.  We suggest you adding new users and assigning them appropriate permission after SQL Server is installed.  You may set the following two permission: 
  • The permission of creating databases.  Here, users need to have the permission of connecting to the master database as it is required to connect to the master database when databases are created.
  • Without the permission of creating databses but have the permission of using databases and creating tables.  Users may have no permission of creating databases.  Under such circumstance, an empty database need to be created manually in the databse server and users are assigned the permission of creating tables in the database.
When creating books and setting the server, you can use a new-created user.  The above two users's permissions can be set as the followings:
  • Users with the permission of creating databases: 
    • Database initialization: Create both databases and tables
    • Database name: A new database name.  CyberArticle will create the database and the required tables.
  • Users without the permission of creating databases:
    • Database initialization: Create only tables
    • Database name: An empty database.  The database includes the users created and set by you manually, who are possessed of the permission of creating tables in the database. CyberArticle will create the required tables in the database.

ii. Add books

You can export a book list on the computer on which remote books have been created, and then copy the list file to other computers, and import the book list in CyberArticle "Open book" dialog.  This operation can avoid you entering the database settings information repeatedly.
 

See also