Question

Can I export the search results in Workflow Designer 8.0 to a csv?

Workflow Version 8 Version 9

Updated January 28, 2014

asked on January 28, 2014

We've upgraded to WF 9 but I've still got 100s of V8 WFs running. I was thinking of exporting the doc IDs to a table, stopping the V8 WFs and using that in a script to start V9 WFs for the documents. Is there a way of doing that?

John

0 0

Answer

SELECTED ANSWER

replied on January 28, 2014

I see. There is no way to export the search results from the 8.0 Designer. But you can get the same information directly from the SQL database.

The following query will give you a list of the starting entries in running workflows and the names of those workflows:

select se.[entry id], si.[workflow name]
from [Search Entry] se
inner join [Search Instance] si
on se.id = si.Id
where se.id in 
(select id from [Search Instance Status]
where Status = 0)
and se.[Activity Type Id]=2

0 0

Replies

replied on January 28, 2014

Why not leave the WF8.0 server running until those instances are completed? WF9 is designed to run side-by-side with WF 8.0. The migration wizard should give you projected dates for the completion of the running instances in 8.0.

0 0

replied on January 28, 2014

Would I be right in assuming this also happens when going between 9.0 and 9.1?

0 0

replied on January 28, 2014

No. Only WF 8.0 to 8.3 and higher is a side-by-side upgrade. Upgrades from 8.3 and any higher versions to the latest version (currently 9.1) are in-place upgrades.

0 0

replied on January 28, 2014

The main issue with keeping the V8 WFs running is that we have had a lot of problems with V8 WFs timing out. This does seem to have been resolved with V9 but I would need to check regularly to make sure no processes have got stuck because of the V8 problems.

A less serious issue is, presumably there is some server overhead with running both WF8 + 9. Our WF server is shared with the Application server and performance isn't particularly great.

0 0

SELECTED ANSWER

replied on January 28, 2014

I see. There is no way to export the search results from the 8.0 Designer. But you can get the same information directly from the SQL database.

The following query will give you a list of the starting entries in running workflows and the names of those workflows:

select se.[entry id], si.[workflow name]
from [Search Entry] se
inner join [Search Instance] si
on se.id = si.Id
where se.id in 
(select id from [Search Instance Status]
where Status = 0)
and se.[Activity Type Id]=2

0 0

You are not allowed to follow up in this post.

Question

Question

Can I export the search results in Workflow Designer 8.0 to a csv?

Answer

Replies

Sign in to reply to this post.