Search found 13 matches

by wkopp
Fri May 05, 2023 5:22 pm
Forum: Flows
Topic: Creating a list from multiple xml files
Replies: 7
Views: 7154

Re: Creating a list from multiple xml files

Your flow will be much smaller and simpler! (10 elements including folders) On top of it, all the job info will be saved into a Google sheet, also available online and from a smartphone or tablet. You can also share that sheet with your customer. Sure you can do something with that, and extend the ...
by wkopp
Thu Apr 27, 2023 7:53 pm
Forum: Flows
Topic: Creating a list from multiple xml files
Replies: 7
Views: 7154

Re: Creating a list from multiple xml files

I was able to get this working by spreading out the xml files, grabbing an html template, and using string replace to add in the tracking links. After a few minute wait, I use the html template to send the email, then delete it. If anyone has a similar need, PM me and I'll send you a copy of the flow.
by wkopp
Thu Apr 27, 2023 2:18 pm
Forum: Flows
Topic: Creating a list from multiple xml files
Replies: 7
Views: 7154

Re: Creating a list from multiple xml files

Thanks for the input. The number of items will vary. Sometimes it's one box, sometimes it's 20. But they'll all be done at the same time, so I figure waiting for 10-15 minutes should give enough time for all items to process. I can filter by the Order ID so that part is pretty straight forward. I'm ...
by wkopp
Wed Apr 26, 2023 6:45 pm
Forum: Flows
Topic: Creating a list from multiple xml files
Replies: 7
Views: 7154

Re: Creating a list from multiple xml files

Here's a sample of the xml file. Underlined info will change for each package, other info will be common for each order. Number of packages per order will vary. <?xml version="1.0"?> <order_status_message> <internal_order_id>12345678</internal_order_id> <partner_order_id>OrderID</partner_o...
by wkopp
Wed Apr 26, 2023 3:09 pm
Forum: Flows
Topic: Creating a list from multiple xml files
Replies: 7
Views: 7154

Creating a list from multiple xml files

Hello all,

We get xml shipping notifications for each package of an order. I'd like to take the tracking numbers from each of those xml's and include them in a single email notification to the customer. Not sure how to get started on this one. Any ideas?
by wkopp
Mon Mar 13, 2023 2:09 pm
Forum: Flows
Topic: Mail receive with OAuth 2.0
Replies: 2
Views: 855

Re: Mail receive with OAuth 2.0

We had a similar issue when we installed this app. (Using v2.0 with Switch 2021 Fall) Reached out to the dev and they suggested we check our Switch preferences. You can set Switch to retry after an error. Under [Error handling > Retry failed external processes after (minutes)], make sure you've got ...
by wkopp
Thu Mar 02, 2023 1:38 am
Forum: Applications
Topic: Pitstop Server Action List Multi-line Text With Variables Defined
Replies: 6
Views: 9631

Re: Pitstop Server Action List Multi-line Text With Variables Defined

Sorry, I haven't used the remote designer so I don't know the limitations. Have you tried using a direct path to the .eal file?
by wkopp
Wed Mar 01, 2023 4:07 pm
Forum: Applications
Topic: Pitstop Server Action List Multi-line Text With Variables Defined
Replies: 6
Views: 9631

Re: Pitstop Server Action List Multi-line Text With Variables Defined

I believe this is what you're looking for. Under Action List(s), choose 'Select Many from Library.' Select Many from Library.png In the Pitstop Server Configurator window, click the Plus button at the bottom right corner. Click Plus.png This will bring up the list of actions for you to choose from. ...
by wkopp
Fri Feb 17, 2023 5:11 pm
Forum: Flows
Topic: Searching for link in XML/JDF file [SOLVED]
Replies: 3
Views: 1052

Re: Searching for link in XML/JDF file

loicaigon wrote: Fri Feb 17, 2023 9:17 am Try this:

Code: Select all

/additional-files/additionalFiles/url[contains(text(), '-all.pdf')]
Loic
Excellent! That did it. Thank you so much!
Very helpful piece of code. Is there a reference somewhere for this kind of thing?
by wkopp
Thu Feb 16, 2023 5:33 pm
Forum: Flows
Topic: Searching for link in XML/JDF file [SOLVED]
Replies: 3
Views: 1052

Searching for link in XML/JDF file [SOLVED]

I've got an xml with multiple entries for file links. The list could include one entry or up to ten, and the target won't be always in the same position. I need to use the link that's name ends in "-all.pdf" to download my file. I am trying to store the url as a Private Data Key. All the v...
by wkopp
Mon Feb 13, 2023 7:52 pm
Forum: Flows
Topic: Converting Epoch time to Date Time
Replies: 4
Views: 1726

Re: Converting Epoch time to Date Time

It sounds like the variable error will be coming from the square brackets around your stored procedure name Try changing the database variable to: [Database.Date:SQL="EXEC DPI_ConvertEpochTime [Job.PrivateData:Key="EpochTime"]",Connection="Tharstern",TimeZone="UTC...
by wkopp
Mon Feb 13, 2023 5:41 pm
Forum: Flows
Topic: Converting Epoch time to Date Time
Replies: 4
Views: 1726

Re: Converting Epoch time to Date Time

Thanks for the tip jan_suhr. I use that app but didn't think about it for this.

I converted the seconds to days and used that number to add to 1970-01-01. Works like a charm!

Still would like to know what that error is all about though... ;)
by wkopp
Mon Feb 13, 2023 3:06 pm
Forum: Flows
Topic: Converting Epoch time to Date Time
Replies: 4
Views: 1726

Converting Epoch time to Date Time

Hello all, I'm trying to convert an Epoch time stamp to a standard date time and add that as a Private Data Key to the job. I am using a database call to send the Epoch value and convert it using a stored procedure in SQL Server. I get the correct date returned, but I am getting an 'unknown variable...