Search found 142 matches

by laurentd
Fri Aug 19, 2022 12:27 pm
Forum: Switch
Topic: SQL Database query
Replies: 4
Views: 3157

Re: SQL Database query

This CASE example works fine: printed=[Database.Text:SQL="SELECT CASE WHEN PrintedOn IS NULL OR PrintedOn = ' ' THEN 'was not printed yet' ELSE 'was already printed' END FROM EnfocusTeam WHERE Initials = '[Metadata.Text:Dataset="Submit",Model="XML",Path="/field-list/fie...
by laurentd
Fri Aug 19, 2022 10:57 am
Forum: Switch
Topic: SQL Database query
Replies: 4
Views: 3157

Re: SQL Database query

Here is an example: name=[Database.Text:SQL="SELECT Name FROM EnfocusTeam WHERE Initials = '[Metadata.Text:Dataset="Submit",Model="XML",Path="/field-list/field[tag='Initials']/value"]'",Connection="SwitchPublishPrint"] email=[Database.Text:SQL="...
by laurentd
Wed Aug 17, 2022 9:13 am
Forum: Flows
Topic: Meta Data Interface
Replies: 4
Views: 2668

Re: Meta Data Interface

I would indeed go for private data.
Easy to define now in a folder properties, and easy to map when you get the XML file.
If the XML contains multiple subjobs, Variable XPath Repeater can loop into the XML to produce many jobs each with corresponding private data.
by laurentd
Tue Aug 16, 2022 3:38 pm
Forum: Flows
Topic: Database connect and more than one querry.
Replies: 1
Views: 1144

Re: Database connect and more than one querry.

Use the Data with log connection after each SQL query.
Define different dataset names on the outgoing connections.
by laurentd
Tue Aug 16, 2022 12:59 pm
Forum: Flows
Topic: %Current Document Name% with out the unique prefix
Replies: 4
Views: 2966

Re: %Current Document Name% with out the unique prefix

[Job.Name] is a Switch variable, is not recognized by PitStop Pro or Server, so using it in an action list will not work. Create a variable set in PitStop, and define a JobName Text variable. Use this variable in your action list. Go to Switch, use the PitStop Server element, select your action list...
by laurentd
Tue Aug 09, 2022 4:54 pm
Forum: Appstore
Topic: Inject Wildcard moves job to problem jobs, instead of error connection
Replies: 4
Views: 11657

Re: Inject Wildcard moves job to problem jobs, instead of error connection

Are you using v4 or higher?
The job repository check was added with v4.
I just tested it with v6 on Mac and Win, it works as expected.
by laurentd
Fri Aug 05, 2022 8:13 am
Forum: Switch
Topic: How to change work folder Enfocus Switch
Replies: 3
Views: 3281

Re: How to change work folder Enfocus Switch

You have to stop Switch Server and use the SwitchDataRootMove tool (renamed ApplicationDataRootTool with more recent versions of Switch).

More info here.
by laurentd
Tue Aug 02, 2022 4:30 pm
Forum: Preflighting
Topic: Extract PDF Annotations to Metadata or Private Data
Replies: 4
Views: 8532

Re: Extract PDF Annotations to Metadata or Private Data

You can use the report to count the comments.
nbComments=[Metadata.Integer:Dataset="PDFReviewCollectionReport",Model="XML",Path="count(/PDFReviewReport/Collection/file/stickynotes/contents)"]
by laurentd
Tue Jul 19, 2022 2:58 pm
Forum: Preflighting
Topic: Extract PDF Annotations to Metadata or Private Data
Replies: 4
Views: 8532

Re: Extract PDF Annotations to Metadata or Private Data

I have an out of the box "workaround". If you use Switch and the PDF Review module , the PDF Review module detects the TEXT annotations already in the pdf file. Then the reviewer can add annotations if needed. Maybe you don't need this step, but you will need to approve or reject the docum...
by laurentd
Tue Jul 12, 2022 9:28 am
Forum: Switch
Topic: Submit Hierarchy job count
Replies: 2
Views: 1581

Re: Submit Hierarchy job count

Well, you don't know in advance how many files will be added to a folder. In the Assemble Job properties, you can define a very large number of jobs to wait for (Every N jobs), (a number you will never reach), and an orphan timeout value. When the first file arrives, Switch will wait n minutes (the ...
by laurentd
Mon Jul 04, 2022 1:38 pm
Forum: Node.js scripting
Topic: XmlDocument class
Replies: 3
Views: 3578

Re: XmlDocument class

Hi Thomas,
Here is the trick:
const xpath = "string(/root/tag1)";
by laurentd
Wed Jun 22, 2022 12:15 pm
Forum: Flows
Topic: How to move only files from root in a hierarchy network path
Replies: 4
Views: 2143

Re: How to move only files from root in a hierarchy network path

Subfolder search levels: Root level only
Inject: files only
Injected jobs name filter: *
Name should: match filter
by laurentd
Wed Jun 22, 2022 10:36 am
Forum: Flows
Topic: How to move only files from root in a hierarchy network path
Replies: 4
Views: 2143

Re: How to move only files from root in a hierarchy network path

Yes, there is an app for that: Inject Wildcard.
It has even more possibilities, like filtering based on name, wildcard, regex, time, depth level.
You have to use a trigger with it, FireStarter is a good candidate.
by laurentd
Tue Jun 21, 2022 4:27 pm
Forum: Flows
Topic: Find all instances where "flow stage" is used
Replies: 2
Views: 2847

Re: Find all instances where "flow stage" is used

You can also document your flows.
It will create an html document of each flow.
In there you can also easily look for the flow stages.