Search found 24 matches

by Mark Casey
Wed Oct 02, 2024 8:38 am
Forum: Flows
Topic: Calculate Sum of Values with XML
Replies: 3
Views: 8298

Calculate Sum of Values with XML

HI Guys I'm looking at a way to Calculate the Sum of Values with an XML XML Below, I need the Sum of all the <No-Up> should come out at 15 Any ideas? <root> <record> <UKG-Product-Code>107033-0-1</UKG-Product-Code> <Card-Quantity>3000</Card-Quantity> <Material>BRAMPTONSTUC-280-FSC</Material> <Prnt>CC...
by Mark Casey
Fri Jun 14, 2024 4:56 pm
Forum: Flows
Topic: Attach multiple files, but not as zip-file
Replies: 9
Views: 46979

Re: Attach multiple files, but not as zip-file

Any answers to this, could do with attaching multiple CSV file to a email, rathe than sending Multiple Emails
by Mark Casey
Fri Jun 07, 2024 2:28 pm
Forum: Switch
Topic: Send or Recieve FTP
Replies: 2
Views: 5614

Send or Recieve FTP

Hi All Trying to check a FTP site within a Time Window Cant seem to connect to the Site Also tried setting up a sendFTP to the same site but wont login - Can't connect to the FTP server; error message: Unable to login to the server I have the same details in FileZilla FTP Client and that works fine ...
by Mark Casey
Thu Jun 06, 2024 9:51 am
Forum: Switch
Topic: Make JSON
Replies: 6
Views: 7882

Re: Make JSON

Hi Jan Still same Error JSON code failed SyntaxError: Unexpected token X in JSON at position 67 I did change the code to: { "items": [ { "orderReference": '[Metadata.Text:Dataset="Xml",Model="XML",Path="/Job/JobNo"]', "recipient": { "a...
by Mark Casey
Thu Jun 06, 2024 9:29 am
Forum: Switch
Topic: Make JSON
Replies: 6
Views: 7882

Re: Make JSON

Still same issue, although I notice another warning message os spaces as below ERROR - Spaces are not allowed in variable definition in 'JSON code' ERROR - JSON code failed SyntaxError: Unexpected token X in JSON at position 67 This is the start of the JSON Code { "items": [ { "orderR...
by Mark Casey
Thu Jun 06, 2024 8:32 am
Forum: Switch
Topic: Make JSON
Replies: 6
Views: 7882

Make JSON

Hi All I have recently upgraded my Switch installation from Spring 2020 to the latest Fall 2023 With that some of the Apps have been upgraded Since then I had a MAKE JSON command that no longer works, firstly is it possible to roll back the App Version? and if not can anyone identify whats wrong. Re...
by Mark Casey
Wed Jun 05, 2024 12:38 pm
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Re: Inject Wildcard

Perfect, its works, just need to rename the file by removing the Count Prefix, works a treat

Thank you :D
by Mark Casey
Mon Jun 03, 2024 11:28 am
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Re: Inject Wildcard

Hello Sander Thanks for your reply and example flow Close to perfect but I have a small issue We dont always have all the old versions in the repository Example file 543085-0-1_1.pdf 543085-0-1_4.pdf This then does not match the number of files so both are sent to lower folder We need to somehow kee...
by Mark Casey
Fri May 31, 2024 11:40 am
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Re: Inject Wildcard

Having amending the 'Amount of Jobs' on the Inject Wildcard I can can then Filter out the _insert files Now this causes a extra issue, I get files through as below: 543085-0-1_1.pdf 543085-0-1_2.pdf These are the Versions of the same Artwork So how do I remove the older (lower version number) file a...
by Mark Casey
Thu May 30, 2024 5:52 pm
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Re: Inject Wildcard

Good idea with the Filter out after the Inject, should of thought of that

Slight problem, not all files have a _insert file
If I set the newest files to '2' then the other cards would bring in two versions, can there be filter to sort this?

:roll:
by Mark Casey
Thu May 30, 2024 4:08 pm
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Re: Inject Wildcard

Hi Laurent Cant do that, reason been, the files have a version number on the end 728704-0-6_15. - This has Version Number of _15 If I put the .pdf then it does not find the files that have the _1 or _10 or _15 etc If I put [Job.NameProper]??.pdf, this will find the correct file as long as the Versio...
by Mark Casey
Thu May 30, 2024 3:00 pm
Forum: Switch
Topic: Inject Wildcard
Replies: 10
Views: 21052

Inject Wildcard

Hi All I have a Excel file listing files name that I use in the flow with the 'Inject Wildcard' App Example of Excel UKG Product Code 539143-0-1 558754-0-1 728704-0-6 748583-0-1 I can find these file within the repository folder but sometimes there are files like: 728704-0-6_15_Insert.pdf This is pi...
by Mark Casey
Tue May 28, 2024 2:21 pm
Forum: Flows
Topic: Using xlsx or csv file to pick up files
Replies: 6
Views: 12038

Re: Using xlsx or csv file to pick up files

HI LasseThid

Did this do the job? I'm looking for something similar

Thanks
Mark
by Mark Casey
Mon Mar 25, 2024 5:49 pm
Forum: Flows
Topic: SPLIT XML
Replies: 1
Views: 5712

SPLIT XML

HI Gus I have looked through a few other Posts/Topics but still very unfamiliar with XSLT Transform Example of Simple XML <?xml version="1.0" encoding="UTF-8"?> <CODES> <CARDCODE>552400-0-1</CARDCODE> <CARDCODE>553204-0-1</CARDCODE> <CARDCODE>561370-0-1</CARDCODE> <CARDCODE>56137...
by Mark Casey
Wed Nov 16, 2022 3:38 pm
Forum: Preflighting
Topic: Adjust Trim Box
Replies: 1
Views: 7273

Adjust Trim Box

Hello Is is possible with Preflight/Action lists to adjust the Trim box of a PDF I'm receiving PDFs with trim Boxes like 314.33 x 190.5 and I wish to Round Up/Down the trim box size to a full number 314 x 191 Not all files are this size, most are different so the actual size is not important its jus...