Search found 142 matches
- Fri Aug 19, 2022 12:27 pm
- Forum: Switch
- Topic: SQL Database query
- Replies: 4
- Views: 3147
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...
- Fri Aug 19, 2022 10:57 am
- Forum: Switch
- Topic: SQL Database query
- Replies: 4
- Views: 3147
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="...
- Wed Aug 17, 2022 9:13 am
- Forum: Flows
- Topic: Meta Data Interface
- Replies: 4
- Views: 2656
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.
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.
- 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.
Define different dataset names on the outgoing connections.
- Tue Aug 16, 2022 12:59 pm
- Forum: Flows
- Topic: %Current Document Name% with out the unique prefix
- Replies: 4
- Views: 2962
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...
- Tue Aug 09, 2022 4:54 pm
- Forum: Appstore
- Topic: Inject Wildcard moves job to problem jobs, instead of error connection
- Replies: 4
- Views: 11576
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.
The job repository check was added with v4.
I just tested it with v6 on Mac and Win, it works as expected.
- Fri Aug 05, 2022 8:13 am
- Forum: Switch
- Topic: How to change work folder Enfocus Switch
- Replies: 3
- Views: 3276
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.
More info here.
- Tue Aug 02, 2022 4:30 pm
- Forum: Preflighting
- Topic: Extract PDF Annotations to Metadata or Private Data
- Replies: 4
- Views: 8511
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)"]
nbComments=[Metadata.Integer:Dataset="PDFReviewCollectionReport",Model="XML",Path="count(/PDFReviewReport/Collection/file/stickynotes/contents)"]
- Tue Jul 19, 2022 2:58 pm
- Forum: Preflighting
- Topic: Extract PDF Annotations to Metadata or Private Data
- Replies: 4
- Views: 8511
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...
- 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 ...
- Mon Jul 04, 2022 1:38 pm
- Forum: Node.js scripting
- Topic: XmlDocument class
- Replies: 3
- Views: 3574
Re: XmlDocument class
Hi Thomas,
Here is the trick:
const xpath = "string(/root/tag1)";
Here is the trick:
const xpath = "string(/root/tag1)";
- Mon Jun 27, 2022 9:18 am
- Forum: PitStop Pro
- Topic: PitStop tutorial for beginners
- Replies: 3
- Views: 2762
- 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: 2133
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
Inject: files only
Injected jobs name filter: *
Name should: match filter
- 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: 2133
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.
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.
- Tue Jun 21, 2022 4:27 pm
- Forum: Flows
- Topic: Find all instances where "flow stage" is used
- Replies: 2
- Views: 2826
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.
It will create an html document of each flow.
In there you can also easily look for the flow stages.