如何从 iManage/Desksite 获取信息 [英] How to get information out of iManage / Desksite

问题描述

我有一位客户使用了交织系统 Desksite 版本 8.0.我需要运行一个查询或导出，以便我可以获得文档 ID，其中comments = X，对于任意值X.或者，这两个字段的任何导出都可以工作.我只需要一个所有 ID 的列表，评论.我必须根据 ID、评论对迭代更新另一个系统.在这一点上，即使只是直接导出文档也是有益的.

I have a customer with an interwoven system Desksite Version 8.0. I need to run a query or export such that I can get the document ID where comments = X, for an arbitrary value X. Alternatively any export of those two fields would work. I just need a list of all ID, Comment. I have to iteratively update another system based on the ID, Comment pairs. Even just a straight up document export would be beneficial at this point.

推荐答案

这种查询既可以直接使用 SQL 查询到 Worksite 的后端，也可以使用 Worksite API

This kind of query can be performed by using either SQL queries directly to Worksite's backend or using Worksite API

我认为最好使用 API，因为数据库布局会随着不同的 Worksite 版本而变化.

In my opinion using API is preferable since DB layout can change with different Worksite versions.

假设您打开了到 Worksite 的连接并登录了一个会话，使用此功能，您可以执行文档搜索(包括您想要的搜索类型):

Assuming you have a connection to Worksite opened and a session logged in, using this function, you can perform document searches (including the type of search that you want) :

    private IManDMS mainDMS;
    private IManDatabase currentDatabase;


    public IManDocument[] SearchDocuments(Dictionary<imProfileAttributeID, string> dictProfleSearchParameters)
    {
        List<IManDocument> foundDocuments = new List<IManDocument>();
        IManProfileSearchParameters searchParams = mainDMS.CreateProfileSearchParameters();

        foreach (KeyValuePair<imProfileAttributeID, string> kvp in dictProfleSearchParameters)
            ((IManProfileSearchParameters)searchParams).Add((IManage.imProfileAttributeID)kvp.Key, kvp.Value);

        IManContents foundDocs = currentDatabase.SearchDocuments(searchParams, true);

        foreach (IManDocument document in foundDocs)
            foundDocuments.Add(document);

        return foundDocuments.ToArray();
    }

这篇关于如何从 iManage/Desksite 获取信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！