Bookshelf Home | Contents | Index | Search | PDF

Upgrading and Migrating Siebel Janna Applications > Database Upgrade Tools > Database Upgrade Tools >

Step 2: Siebel Janna Upgrade Object Extraction Utility

---

Both Siebel Janna applications and Siebel applications allow users to associate spreadsheets, word processing documents, pictures, and other files with accounts and contacts. Siebel applications store pointers to files in their native format in a specific location in the file system. Siebel Janna applications also have this ability, but include another feature that stores these files as Binary Large Objects (BLOBs) in the database. The Siebel Janna Upgrade Object Extraction Utility migrates this file information to the Siebel database and is an executable file. To upgrade these objects saved within the Siebel Janna database, they must be extracted from their current state (BLOBs within the Siebel Janna database) and reconstituted into their original files. The extraction utility provides this process. Before using this utility, create new database tables using appropriate scripts.

Installing the Siebel Janna Upgrade Object Extraction Utility

Install the Siebel Janna Upgrade Object Extraction Utility on the computer that contains the Siebel Janna Windows client by running the setup.exe program.

Creating New Database Tables

Run the platform-specific SQL script—JUpg_<platform>.sql—against the Siebel Janna database to create the new database tables.

Running the Siebel Janna Upgrade Object Extraction Utility

To run the Siebel Janna Upgrade Object Extraction Utility

Run the ObjExtract.exe file on the appropriate computer.

The Siebel Janna Migration Object Extraction Utility window appears.

Enter the location of the destination root directory.

This location can be entered manually or by clicking the ellipsis button and selecting a folder from the Set Folder window.

Select the existing file handling options.

Users have the option to rename existing file names manually or to have them automatically renamed (by adding sequential numbers to the existing filename).

Optionally, check the Move unknown file types to exception directory check box, which moves any files whose extensions cannot be determined into an exception directory. If not checked, the files remain in the root directory specified. The ? button to the immediate left of the check box provides further information on this selection.
Optionally, check the Append Contact/User/Company name to beginning of filename check box, which results in fewer files requiring renaming. However, selecting this option creates a separate copy of the same file for each Contact/User/Company associated with it. The ? button to the immediate left of the check box provides further information on this selection.
Click Extract File to begin the extraction procedure.

The files are then pulled from the Siebel Janna database and copied to the file system. Appropriate feedback is provided to the user during the conversion procedure and on completion two log files are produced: a success log, ObjSuccessLog.txt and an exception log, ObjExceptionLog.txt.

The Siebel Janna Upgrade Object Extraction Utility populates a table with the files extracted for each user. It creates an exception report log file for any errors or for any files that were extracted without extensions. Any files created without extensions are moved into a temporary subfolder under the root extraction directory. The extensions of these files must be manually added before the table is updated through the Refresh Table button.

Users can fix any filenames without extensions and then run the Siebel Janna Upgrade Object Extraction Utility again, this time pressing the Refresh Table button. This button updates the internal table used for the Siebel import with the names of the files that were manually changed.

Folders and subfolders are not carried forward to Siebel from the Siebel Janna Document Manager or Siebel Janna Contact Journal. Instead, the filename contains the folder path up to a total length (path and filename) of 200 characters—folder names are separated by a hyphen (-). If the total length is greater than 200 characters, the right end of the folder path is truncated. Multiple contact documents with attachments are converted so the attached document is duplicated for all contacts.

Object Extraction Utility Delta Dialog

If the Object Extraction Utility has already run, a Delta dialog appears. To run the entire object extraction again, select No. If you are running a subsequent update and want to only extract the files that have changed since the last time you ran the Object Extraction Utility, then select Yes.

NOTE:  Perform an update only if you have already run the Object Extraction Utility and migrated the files to the Siebel file system. Running the update deletes the files in the extraction directory automatically, as only the new files added since the initial extraction will be imported to the Siebel file system. For the same reason, the update also deletes the existing records in the database table created to store the files.

Bookshelf Home | Contents | Index | Search | PDF