Workbook with existing datasets

To use a port or TCP/IP address instead of a computer name, follow the steps in "Empty template with no datasets".

  1. Ensure the database structure on the new server is identical to the database structure on the original server. It is important that the unique member names are the same.
  2. Ensure the old and new servers have identical data sources, especially the data source ID. Data sources are defined in the CBRData sources.xml file in the \ComshareWeb\Services\CBRService default directory.

    If you copy the data source from one server to another, you may need to change the Data source, Catalog, and Schema parameters.

  3. Open a command prompt and run these commands from the appropriate directory, or wherever the cell-based template resides.
  4. If you want to keep the original workbook in the original environment and make a copy for the new environment, run this command. Replace original workbook with the full name and file extension of your existing workbook and replace copied workbook with the full name and file extension of the copied workbook. 
    copy /y original workbook copied workbook
  5. To update the original workbook to point to a new server, run this command. Replace server with the new server name and workbook name with the full name and file extension of the workbook; for secure connections, replace http with https. The entire command should be on one line. For example: 
    CBRServerEditor -w workbook name -d http://0/comshareweb/cbrworkbook/cbrworkbook.application -s http://server/comshareweb/services/cbrservice/cbrservice.asmx