Search found 297 matches

by Terkelsen
Tue Nov 17, 2020 10:37 am
Forum: Flows
Topic: Calculate amount
Replies: 5
Views: 5397

Re: Calculate amount

Just for your information, I solved this using Jan's app called "Take Note". With this app I can add a specific dataset unique to each Submit Point and still keep the dataset "Submit_1", which is the same for all Submit Points. After assembling the files I then end up with metada...
by Terkelsen
Tue Nov 10, 2020 12:03 pm
Forum: Flows
Topic: Calculate amount
Replies: 5
Views: 5397

Re: Calculate amount

@ Jan. As mentioned giving the datasets different names is not an option because the Data set name is later used to add text to a PDF. If the Submit Points have different names I would need to make different variable sets for every Submit Point and as there will be maybe 50 different Submit Points, ...
by Terkelsen
Tue Nov 10, 2020 9:56 am
Forum: Flows
Topic: Calculate amount
Replies: 5
Views: 5397

Calculate amount

I have 8 to 10 dummy-files coming in from different Submit Points, that submits data only. Each of these files contain a metadata tag, that is an amount selected from at drop-down in the Submit point. I need to make a calculation that adds the numbers in the tag "amount" from all thes file...
by Terkelsen
Fri Sep 18, 2020 11:31 am
Forum: Flows
Topic: SQL statement to update boolean field
Replies: 5
Views: 5659

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: 3961

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: 5659

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: 5659

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: 6
Views: 10066

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: 6
Views: 10066

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: 6
Views: 10066

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: 4037

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 ...
by Terkelsen
Tue Jun 02, 2020 5:02 pm
Forum: PDF Creation
Topic: Trim box and bleed
Replies: 3
Views: 8531

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: 3728

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: 4860

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: 6254

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 5244 times