Sample CWS (C#) code to perform wildcard search in CS 16

Hello,

We are in the process of migrating from CS 10.0 to CS 16 and the domain in our application URL is changing.

We have a lot of PDF documents all over in different folders and these PDFs have links (absolute URLs) in them that point to other documents within our CS 16 application.

We now have a need to update the links in those PDF documents to use the new domain in the URL.

I need to write a C# script to :

1) find all such PDF documents in our application

2) Loop through them, use their Object IDs & Download each

3) Find an replace the URL in them with the new one (probably I guess create a new PDF)

4) Upload it back to CS as the new version

So experts, how do I accomplish this? I found CWS Code Samples that show how I can Authenticate, Download & Upload documents. But nothing that shows how I can perform a search (I need to search all documents of type PDF).

Any pointers will be appreciated.

Find more posts tagged with

Comments

AKropp

Hi,

I can chime in with a few things:

-Try to avoid the searchservice. It’s not great. It may be buggy and hasn’t really seen any active development in some few years. It’s not as flexible or easy to deal with as the alternatives, at least in my opinion. There’s an old sample for it kicking around on the SDK KC pages under the “Getting Started” area IIRC .

-Search XML API is the next option. The programming guide is here:

https://knowledge.opentext.com/knowledge/llisapi.dll/Open/46051853

For a practical, albeit extremely simple sample I’ve written one that is available here:

https://knowledge.opentext.com/knowledge/llisapi.dll/Open/60894938

I haven’t had a chance to update it/make a new version but as of 10.5 2015-03 or higher the XML API will also accept the CS REST authentication token. The sample there uses the more traditional cookie approach. Output, as you might expect, will be in XML format for parsing.

-CS REST API is option two, but only if your application runs against CS16. It should follow essentially the same conventions as the XML API for specifying criteria.

Downside is it’s not yet well documented. In fact if you look at the posted API reference it doesn’t look like you can initiate a search with it yet at all. Thankfully one of our developers posted some excellent info on how to use it here:

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=63704665&objAction=viewincontainer&ShowReplyEntry=64803399#forum_topic_64803399

***

And now that I’ve written all of that is search really necessary? If you wanted to go after ALL PDF docs then you could invoke a LiveReport (or do a direct DB query in the application) to get your IDs based on MimeType or FileType columns in DVersData? Some smarter folks around here may have some better ideas along those lines.

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, November 23, 2016 5:00 PM
To: eLink Recipient
Subject: Sample CWS (C#) code to perform wildcard search in CS 16

Sample CWS (C#) code to perform wildcard search in CS 16

Posted by Karia, K On 11/23/2016 04:57 PM

Hello,

We are in the process of migrating from CS 10.0 to CS 16 and the domain in our application URL is changing.

We have a lot of PDF documents all over in different folders and these PDFs have links (absolute URLs) in them that point to other documents within our CS 16 application.

We now have a need to update the links in those PDF documents to use the new domain in the URL.

I need to write a C# script to :

1) find all such PDF documents in our application

2) Loop through them, use their Object IDs & Download each

3) Find an replace the URL in them with the new one (probably I guess create a new PDF)

4) Upload it back to CS as the new version

Any pointers will be appreciated.

[To post a comment, use the normal reply function]
Forum:	Content Web Services Forum
Content Server:	Knowledge Center CS16

K_Karia

Thanks a lot for all these great pointers. And it's an excellent idea to get IDs directly by querying the data in DB! I would definitely by all possible means avoid doing search from within my code.

Thanks once again, hopefully this should be straight-forward now.

AKropp

Don’t get me wrong there… searching in code is definitely doable! It’s just the searchservice webservice specifically that has some drawbacks that makes it better to avoid using at this point. Its continued existence is mostly to support older applications that used it until such time as they can be refactored to use one of the newer APIs. Even it won’t be going anywhere any time soon, to my knowledge, for that very reason.

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, November 23, 2016 6:05 PM
To: eLink Recipient
Subject: RE Sample CWS (C#) code to perform wildcard search in CS 16

RE Sample CWS (C#) code to perform wildcard search in CS 16

Posted by Karia, K On 11/23/2016 06:03 PM

Thanks a lot for all these great pointers. And it's an excellent idea to get IDs directly by querying the data in DB! I would definitely by all possible means avoid doing search from within my code.

Thanks once again, hopefully this should be straight-forward now.

[To post a comment, use the normal reply function]
Topic:	Sample CWS (C#) code to perform wildcard search in CS 16
Forum:	Content Web Services Forum
Content Server:	Knowledge Center CS16

Kevin_Bailey

I used Aspose libraries for a java app to do what you are asking. Sadly, it uses LAPI so is not applicable. I used a csv file for getting do doc ID’s needed that satisfies the search for mimetype of ‘application/pdf’

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, November 23, 2016 5:34 PM
To: eLink Recipient
Subject: RE Sample CWS (C#) code to perform wildcard search in CS 16

RE Sample CWS (C#) code to perform wildcard search in CS 16

Posted by Kropp, Alex On 11/23/2016 05:33 PM

Hi,

I can chime in with a few things:

-Search XML API is the next option. The programming guide is here:

https://knowledge.opentext.com/knowledge/llisapi.dll/Open/46051853

For a practical, albeit extremely simple sample I’ve written one that is available here:

https://knowledge.opentext.com/knowledge/llisapi.dll/Open/60894938

-CS REST API is option two, but only if your application runs against CS16. It should follow essentially the same conventions as the XML API for specifying criteria.

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=63704665&objAction=viewincontainer&ShowReplyEntry=64803399#forum_topic_64803399

***

Sample CWS (C#) code to perform wildcard search in CS 16

Posted by Karia, K On 11/23/2016 04:57 PM

Hello,

We are in the process of migrating from CS 10.0 to CS 16 and the domain in our application URL is changing.

We have a lot of PDF documents all over in different folders and these PDFs have links (absolute URLs) in them that point to other documents within our CS 16 application.

We now have a need to update the links in those PDF documents to use the new domain in the URL.

I need to write a C# script to :

1) find all such PDF documents in our application

2) Loop through them, use their Object IDs & Download each

3) Find an replace the URL in them with the new one (probably I guess create a new PDF)

4) Upload it back to CS as the new version

Any pointers will be appreciated.

[To post a comment, use the normal reply function]
Forum:	Content Web Services Forum
Content Server:	Knowledge Center CS16

[To post a comment, use the normal reply function]
Topic:	Sample CWS (C#) code to perform wildcard search in CS 16
Forum:	Content Web Services Forum
Content Server:	Knowledge Center CS16