Search found 249 matches

by Terkelsen
Fri Sep 18, 2020 11:31 am
Forum: Flows
Topic: SQL statement to update boolean field
Replies: 5
Views: 310

Re: SQL statement to update boolean field

Well, it turned out that 0 and 1 indeed were the triggers to use, so I finally got this statement to turn the check box on:

UPDATE Webshop
SET Produktionsklar=1
WHERE OrdreID='[Metadata.Text:Path="/Impleo_JobTransaction/TopOrderID",Dataset="Xml",Model="XML"]'
by Terkelsen
Fri Sep 18, 2020 10:57 am
Forum: Flows
Topic: Get print size from PDF's name?
Replies: 2
Views: 99

Re: Get print size from PDF's name?

You could use a Regular Expression to extract the part of the filename you need and write these into Private Data. Then use the Private Data as your variable.
by Terkelsen
Wed Sep 16, 2020 10:19 am
Forum: Flows
Topic: SQL statement to update boolean field
Replies: 5
Views: 310

Re: SQL statement to update boolean field

Hi Jan,

Sorry for my late response.

These were my first thought too, but none of them seems to work.
by Terkelsen
Fri Sep 11, 2020 2:09 pm
Forum: Flows
Topic: SQL statement to update boolean field
Replies: 5
Views: 310

SQL statement to update boolean field

I'm using the database module of Switch to update an Access database, which works just fine. However, the database has a boolean field (a checkbox). Any idea what would be the sql statement to toggle that field?

UPDATE Webshop (Produktionsklar)
VALUES ('????')
by Terkelsen
Mon Aug 31, 2020 1:25 pm
Forum: Preflighting
Topic: Select Dieline and Convert to spot
Replies: 5
Views: 700

Re: Select Dieline and Convert to spot

Ahh, you might need a PitStop Pro to do this. Apparently you can't create a new spot color from within PitStop Server. I wasn't aware of that :roll:
You can however create the action in PitStop Pro and run it in PitStop Server.
by Terkelsen
Mon Aug 31, 2020 10:33 am
Forum: Preflighting
Topic: Select Dieline and Convert to spot
Replies: 5
Views: 700

Re: Select Dieline and Convert to spot

Just hit the button next to "User Swatch"
...and then create an new spot color called "Knife".
by Terkelsen
Mon Aug 31, 2020 8:34 am
Forum: Preflighting
Topic: Select Dieline and Convert to spot
Replies: 5
Views: 700

Re: Select Dieline and Convert to spot

You can change 100 % Magenta to "Knife" in PitStop as well. Use the Remap Color Action.
by Terkelsen
Wed Jun 24, 2020 3:33 pm
Forum: Flows
Topic: Updating file triggers flow
Replies: 2
Views: 784

Re: Updating file triggers flow

I think you should make your Illustrator input as a Submit Hierarchy. As you mention, set "Ignore updates: No" and "Leave originals in place: Yes". This way you will only get a copy of an Illustrator file each time there is an update or a new file. Use the copy of the AI file to trigger the injectio...
by Terkelsen
Tue Jun 02, 2020 5:02 pm
Forum: PDF Creation
Topic: Trim box and bleed
Replies: 3
Views: 1261

Re: Trim box and bleed

I'm not sure but I think what you are referring to is the media box. If you want the media box to be the same size at the bleed box just add "Change media box to bleed box size" at the end of the action.
by Terkelsen
Tue May 19, 2020 2:20 pm
Forum: Flows
Topic: Checkpoint pushing metadata forward
Replies: 2
Views: 729

Re: Checkpoint pushing metadata forward

Are you aware that unless you have changed the default you will get two different "Data set names" from Submit Point and Check Point? If you look for the External Metadata Dataset you will have one called "Submit" and one called "Check".
by Terkelsen
Wed May 13, 2020 12:14 pm
Forum: PitStop Server
Topic: Trim Box Sizes?
Replies: 3
Views: 1106

Re: Trim Box Sizes?

Make an action like this:
Change the trim box to the size of the crop box
Change the trim box by -0.125 inch in all directions
Add page marks
by Terkelsen
Thu Apr 16, 2020 3:38 pm
Forum: Action Lists
Topic: Select spot color by regular expression
Replies: 3
Views: 2067

Re: Select spot color by regular expression

If you like to play around with regular expressions, thats fine, but there is already a standard action in PitStop that will let you select spot colours from a list and it can even be case insensitive :-)
Skærmbillede 2020-04-16 kl. 15.33.32.png
Skærmbillede 2020-04-16 kl. 15.33.32.png (39.77 KiB) Viewed 1057 times
by Terkelsen
Thu Apr 16, 2020 3:26 pm
Forum: Switch
Topic: Assemble Job
Replies: 3
Views: 1285

Re: Assemble Job

OK. Then you can just set the number of files to be assembled to 2 and the the "After N minutes" also to 2. This way those with two pages will be assembled as soon as there are two pages with the same name before the last dash and those with only one page will be sent through after two minutes becau...
by Terkelsen
Wed Apr 15, 2020 1:50 pm
Forum: Switch
Topic: Assemble Job
Replies: 3
Views: 1285

Re: Assemble Job

You could use a variable like this [Job.NameProper:Search="(.*)\-"] to assemble jobs with same name before the last dash. The problem, however, is how to know how many files to assemble. If jobs belonging together are coming in more or less at the same time, you could use "After N minutes".
by Terkelsen
Wed Apr 08, 2020 9:27 am
Forum: Flows
Topic: Sorting and duplicating pages in PDF
Replies: 2
Views: 923

Re: Sorting and duplicating pages in PDF

You could:
• Split the front PDF into single files
• Use Inject Job to retrieve the back PDF for each file
• Use assemble job to place the front and the back in a folder
• Use Merge PDF to merge front and back into one file.