| Back | Main view

Product:	IMiS/Notes interface, IMiS/ARChive
Release:	*
Date:	02/15/2010

Case:

With release of Microsoft Office 2007 Microsoft introduced new "xml" like document formats. Versions 6.x of IMiS/ARChive and prior were not configured to store these document types by default so a minor configuration change must be applied to extend the support for archiving of mentioned content.

Description:

NOTE: Adding custom, user-defined Content Types is possible and they will work but only until next binary upgrade so customers are NOT ADVISED to add their own custom MIME types with custom defined IDs. You should only apply MIME type patches issues by Imaging Systems!

Versions 6.x of IMiS/ARChive and before were built prior to introduction of these document types and its supported MIME configuration prevents it from storing documents with the following extensions:

.docm .docx .dotm .dotx .ppsm .ppsx .pptm .pptx .xlsb .xlsm .xlsx

application/vnd.ms-word.document.macroEnabled.12 application/vnd.openxmlformats-officedocument.wordprocessingml.document application/vnd.ms-word.template.macroEnabled.12 application/vnd.openxmlformats-officedocument.wordprocessingml.template application/vnd.ms-powerpoint.slideshow.macroEnabled.12 application/vnd.openxmlformats-officedocument.presentationml.slideshow application/vnd.ms-powerpoint.presentation.macroEnabled.12 application/vnd.openxmlformats-officedocument.presentationml.presentation application/vnd.ms-excel.sheet.binary.macroEnabled.12 application/vnd.ms-excel.sheet.macroEnabled.12 application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

In order to provide the ability to archive Content with types mentioned above System Administrator should perform the following procedures:

IMiS/ARChive with Oracle Embedded / Berkeley Database Configuration change:
(you can tell if your server uses Oracle Embedded by the presence of /iarc/db/__db.xxxxx files)

1. Shutdown IMiS/ARC service
iarc:/ # /etc/init.d/iarcd stop

2. BACKUP YOUR DATABASE FILES!
Depending on your setup files from /iarc/db should be temporarily copied to a safe location.

3. Export the database:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/dbtool -A exp"

4. Download any copy attached objtype.txt file to the Database directory overwriting the old one:
iarc:/ # sudo su - iarc -s /bin/bash -c "cp -f <file-location>/objtype.txt /iarc/db"

5. Initialize the database:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/dbtool -A init"
(answer yes to the questions)

6. Import the database files:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/dbtool -A imp"
(this can take a while depending on the database record count and h/w)

7. Start the IMiS/ARC service
iarc:/ # /etc/init.d/iarcd start


IMiS/ARChive with Birdstep Raima Database Manager (rdm) Configuration change:
(you can tell if your server uses Raima Database Manager by the presence of /iarc/db/iarc.key.xxxxx files)

1. Shutdown IMiS/ARC service
iarc:/ # /etc/init.d/iarcd stop

2. BACKUP YOUR DATABASE FILES!
Depending on your setup files from /iarc/db should be temporarily copied to a safe location.

3. Export the database:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/dbexp iarc"

4. Download and copy attached objtype.txt file to the Database directory overwriting the old one:
iarc:/ # sudo su - iarc -s /bin/bash -c "cp -f <file-location>/objtype.txt /iarc/db"

5. Initialize the database:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/initdb iarc"
(answer yes to the question)

6. Import the database files:
iarc:/ # sudo su - iarc -s /bin/bash -c "cd /iarc/db && /opt/IS/imisarc/dbimp -n iarc.imp"
(this can take a while depending on the database record count and h/w)

7. Start the IMiS/ARC service
iarc:/ # /etc/init.d/iarcd start




IMiS/Administration database update:
(Optional and required if IMiS is used with conjunction of IMiS/NSF Design Template (IBM Lotus Notes/Domino solutions))

See details how to add content types in mime type/extension mapping table here:
http://www.imaging4notes.com/imisman.nsf/1fb0c0e150b410dac125682b002c54d2/d6e67447cdb293d6c1256cd0004259b8?OpenDocument

Since there is an IMiS/ARC Database limitation on MIME type length custom mime types were used to enable Microsoft Office 2007 documents to be correctly archived. So MIME types below are not typing mistakes but rather transformed MIME types which fit into IMiS/ARChive Database schema.
Use the following combination to add support for Microsoft Office 2007 Document types (you can copy/paste the values appending the old ones):

Description (for selection by user)	Document type extension	Document MIME type
MS Office 2007 Word Document (w/h macros) MS Office 2007 Word Document MS Office 2007 Word Template (w/h macros) MS Office 2007 Word Template MS Office 2007 PowerPoint Slideshow (w/h macros) MS Office 2007 PowerPoint Slideshow MS Office 2007 PowerPoint Presentation (w/h macros) MS Office 2007 PowerPoint Presentation MS Office 2007 Excel Sheet - Binary (w/h macros) MS Office 2007 Excel Sheet (w/h macros) MS Office 2007 Excel Sheet	docm docx dotm dotx ppsm ppsx pptm pptx xlsb xlsm xlsx	application/vnd.ms-word.document.macroEnabled.12 application/vnd.openxmlformats-officedocument.docx application/vnd.ms-word.template.macroEnabled.12 application/vnd.openxmlformats-officedocument.dotx application/vnd.ms-powerpoint.slideshow.macroEnabled.12 application/vnd.openxmlformats-officedocument.ppsx application/vnd.ms-powerpoint.presentation.macroEnabled.12 application/vnd.openxmlformats-officedocument.pptx application/vnd.ms-excel.sheet.binary.macroEnabled.12 application/vnd.ms-excel.sheet.macroEnabled.12 application/vnd.openxmlformats-officedocument.xlsx

Related Documents:



| Back | Main view