Home
TeamSite
MS Access interface to iManage DeskSite
System
I am an independent consultant and a newbie to iManage. A client of mine uses iManage DeskSite Integrated Desktop 6.05.00 SP1a for document management. They also use a Microsoft Access database application to manage certain of their customers. They need to link the customer in the MS Access database to documents in iManage.
The user interface would be such that a command button in MS Access would launch iManage and open either a specific document or a folder of documents related to the customer. I expect that some sort of iManage information would have to be stored in the MS Access database in order to make the link.
I have scoured the Interwoven web site, and it appears that the iManage COM Reference Manual may be what I need to figure out how to do this. Is this correct? If not, I would appreciate someone pointing me in the right direction. Also, any advice on developing such an interface would be very welcome.
Mike Pace
M. L. Pace Computer Consulting
Mobile, Alabama
Find more posts tagged with
Comments
jny
I strongly recommend that you purchase a copy of the WorkSite iToolkit SDK. DeskSite 6.0 is a few versions back as there are later versions, 6.5, 6.6, and the latest, 8.0.
The SDK has the COM Object Type Libraries (DLL's) that would be useful to you in hooking into most of the commands in DeskSite. The imanage.dll is one of the type libraries to use (which is documented in the imanagecommanual.pdf) but this is not the one that has the automated objects you may create to use in your application, e.g., a commnad to open a document. This is a low-level dll that is used to make direct calls to the back-end server -- aka a middle-tier server dll.
Documentation (with code examples) development support, and training are all included in the SDK. I recommend taking the training course for first-time users to get familiarized with the Object Model architecture and version compatibility.
Contact your local sales representative to inquire the WorkSite iToolkit purchase.
Migrateduser
Can anyone help? Please see below...
I have inherited an nrs that we used with a previous version of iManage infoRite, 5.3. The author no longer works with us so we lost the knowldge on how to further modify the script to comply with future versions - figures.
We used a nrs, called EditProf.nrs to catch user input when editing a document's profile. We are moving to Desksite 6.06 on XP and the nrs no longer works. I have debugged and DesSite does not seem to recognize the call to "EditProfileDlg_OnOK(dlg)" see code extract below...
msgbox("I am being called 1") <--- this is displayed so it tells me the nrs is recognized and processing starts
Sub EditProfileDlg_OnOK(dlg) <--- this is where is fails with no error
msgbox("I am being called 2")<--- my debug line to tell me if it entered the subroutine, never displays this message box
Dim objDoc, strCustom1, strCustom2, strcustom3, strcustom4, strcustom5, Strdb
Dim strcustom6, strNum, strnm, cline, strcustom7
Dim Individ
strNum = Dlg.GetAttributeByID(nrDocNum)
strnm = Dlg.GetAttributeByID(nrDocNm)
strCustom1 = Dlg.GetAttributeByID(nrCustom1)
strCustom2 = Dlg.GetAttributeByID(nrCustom2)
strCustom3 = Dlg.GetAttributeByID(nrCustom3)
Strdb = Dlg.GetAttributeByID(nrdatabase)
...
Can someone tell me why DeskSite 6.06 fails recognize "Sub EditProfileDlg_OnOK(dlg)"?
thank you,
Jason
jny
This has been reported as a bug in DeskSite6.6/FileSite4.1 and Worksite 8.0 HF4.
It looks like the code is collecting the profile input user has entered before the dialog closes. If so, you should be able to put the same implementation code in the EditProfileCmd_PreOnOK or EditProfileCmd_PostOnOK event instead, as the command events are fired successfully.
Migrateduser
Thanks jny.
I tried modifying the code as you suggested but it is behaving no different. I have attempted using both EditProfileCmd_PostOnOk(dlg) and EditProfileCmd_PreOnOk(dlg).
Could this be due to the reported bug with Desksite 6.6?
Could it be that I am using inappropriate naming conventions for these events? Unfortunatelly, I don't have the appropriate documentation to use as reference.
jny
That's strange. I tested them beforehand and they fired successfully in both 6.0/4.a and 8.0. Could you include the script you used?