Difference between revisions of "Excel Addin"

From OpenKM Documentation
Jump to: navigation, search
 
Line 1: Line 1:
 
Office Addins are compatible from version 2000 to version 2007.
 
Office Addins are compatible from version 2000 to version 2007.
  
After installing Excel Adding it'll appears new "OpenKM" toolbar menu options.  
+
After installing the Excel add-in, a new menu item "OpenKM" will appear in Excel .  
  
  
Line 18: Line 18:
  
 
== Configure OpenKM AddIn ==
 
== Configure OpenKM AddIn ==
First you must select OpenKM tool bar option to setting your configurations values for remote OpenKM accessing from client computer. If you've got other OpenKM AddIn yet installed it's not needed.
+
First you must select the OpenKM tool bar option to set your configuration values to access OpenKM from the client computer. If you've got other OpenKM Add-Ins already installed, this may not be needed.
  
  
Line 24: Line 24:
  
  
When you setting your configuration values is created '''OpenKM folder''' in your user '''My documents folder'''. Into OpenKM folder is created a configuration file called '''openkm.xml''' and other file called '''document.xml''' that OpenKM Addin uses to store some document editing information, you might not editing or deleting this file.
+
When you set your configuration values, a folder called '''OpenKM''' is created in your user '''My documents folder'''. In this OpenKM folder, a configuration file called '''openkm.xml''' and another file called '''document.xml''' are created that the OpenKM Add-in uses to store some document editing information. You should not edit or delete these files.
  
  
Line 31: Line 31:
  
 
== Uploading a new file ==
 
== Uploading a new file ==
After making a click in [[File:Add_document.gif]] adding new document button, it'll appears a tree browser view. You must select the folder where you want to uploading the file.
+
After clicking on the [[File:Add_document.gif]] add new document button, a folder tree view will appear. You must select the folder where you want to upload the file.
  
  
Line 37: Line 37:
  
  
Click on '''Send''' Button, and after document it'll be uploaded to OpenKM it'll appears a notification message.
+
Click on the '''Send''' Button and after that the document will be uploaded to OpenKM and a notification message will appear.
  
  
Line 43: Line 43:
  
  
== Edit OpenKM document ==
+
== Editing an OpenKM document ==
After making a click in [[File:Checkout.gif]] document edit button, it'll appear a navigator browser. You must navigate across folders and select a document that you want to edit.
+
After clicking on the [[File:Checkout.gif]] document edit button, a folder navigator will appear. You must navigate across folders and select a document that you want to edit.
  
  
Line 51: Line 51:
  
  
When you've got some OpenKM document opened, it'll be enabled [[File:Checkin.gif]] '''Upload modified document''' (check-in) and [[File:Cancel_checkout.gif]] '''Cancel document edit''', toolbar option.
+
When you've got some OpenKM document opened, the [[File:Checkin.gif]] '''Upload modified document''' (check-in) and [[File:Cancel_checkout.gif]] '''Cancel document edit''' toolbar options will be enabled.
  
 
* '''To upload modified document''', use the [[File:Checkin.gif]] Upload modified document (check-in) toolbar button.
 
* '''To upload modified document''', use the [[File:Checkin.gif]] Upload modified document (check-in) toolbar button.
Line 57: Line 57:
 
* '''To cancel document editing''', use the [[File:Cancel_checkout.gif]] Cancel document edit toolbar button.
 
* '''To cancel document editing''', use the [[File:Cancel_checkout.gif]] Cancel document edit toolbar button.
  
{{Warning|After editing your local document copy will be deleted to prevent user confusion.}}
+
{{Warning|After editing, your local document copy will be deleted to prevent user confusion.}}
  
{{Note|OpenKM Excel Addin runs with OpenKM 4.1 or upper.}}
+
{{Note|OpenKM Excel Add-in runs with OpenKM 4.1 or higher.}}
  
 
[[Category: User Guide]]
 
[[Category: User Guide]]

Latest revision as of 12:52, 31 October 2011

Office Addins are compatible from version 2000 to version 2007.

After installing the Excel add-in, a new menu item "OpenKM" will appear in Excel .


Okm user guide 080.jpg


Detail of the functions according to their icons:

  • Okm user guide 084.jpg → Addin configuration
  • Add document.gif → Add new document
  • Checkout.gif → Document edit ( check-out )
  • Checkin.gif → Upload modified document (check-in)
  • Cancel checkout.gif → Cancel document edit
  • Okm user guide 085.jpg → Help


Configure OpenKM AddIn

First you must select the OpenKM tool bar option to set your configuration values to access OpenKM from the client computer. If you've got other OpenKM Add-Ins already installed, this may not be needed.


Okm user guide 077.jpeg


When you set your configuration values, a folder called OpenKM is created in your user My documents folder. In this OpenKM folder, a configuration file called openkm.xml and another file called document.xml are created that the OpenKM Add-in uses to store some document editing information. You should not edit or delete these files.


Okm user guide 078.jpeg


Uploading a new file

After clicking on the Add document.gif add new document button, a folder tree view will appear. You must select the folder where you want to upload the file.


Okm user guide 081.jpg


Click on the Send Button and after that the document will be uploaded to OpenKM and a notification message will appear.


Okm user guide 082.jpg


Editing an OpenKM document

After clicking on the Checkout.gif document edit button, a folder navigator will appear. You must navigate across folders and select a document that you want to edit.


Okm user guide 083.jpg


When you've got some OpenKM document opened, the Checkin.gif Upload modified document (check-in) and Cancel checkout.gif Cancel document edit toolbar options will be enabled.

  • To upload modified document, use the Checkin.gif Upload modified document (check-in) toolbar button.
  • To cancel document editing, use the Cancel checkout.gif Cancel document edit toolbar button.

Nota advertencia.png After editing, your local document copy will be deleted to prevent user confusion.


Nota clasica.png OpenKM Excel Add-in runs with OpenKM 4.1 or higher.