Search found 447 matches

by magnussandstrom
Thu Nov 07, 2024 11:03 am
Forum: Flows
Topic: Perform a 'contains' lookup in a spreadsheet?
Replies: 7
Views: 151

Re: Perform a 'contains' lookup in a spreadsheet?

The filename structure was only an example it can also be: Myfilename_that-look-like_this_ABCD_and-some-other_AB_stuff_12346_HELLOWORLD

I want to check if any of the values in column A could be found anywhere in the filename and return the value in column B from the same row.
by magnussandstrom
Thu Nov 07, 2024 8:47 am
Forum: Flows
Topic: Perform a 'contains' lookup in a spreadsheet?
Replies: 7
Views: 151

Re: Perform a 'contains' lookup in a spreadsheet?

Hi Thomas, I'm not sure if this is what I'm looking for. I cannot use the filer Column A = *_ABCD_* because _ABCD_ is "unknown". I need to compare the filename (example: Myfile_ABCD_1234.pdf) and see if it contains any of the values in column A and then get a value from column B if I get a...
by magnussandstrom
Tue Nov 05, 2024 1:07 pm
Forum: Flows
Topic: Perform a 'contains' lookup in a spreadsheet?
Replies: 7
Views: 151

Perform a 'contains' lookup in a spreadsheet?

I'm working with a spreadsheet that has two columns, and I need to create a flow to check if "nameProper" contains any of the values from column A. If a match is found, I want to output the corresponding value from column B (as private data). I'm aware of the Row2Variables app, but it only...
by magnussandstrom
Thu Oct 17, 2024 4:59 pm
Forum: Flows
Topic: Best Approach for Error Handling in Enfocus Switch Workflows?
Replies: 3
Views: 3048

Re: Best Approach for Error Handling in Enfocus Switch Workflows?

Using the connections I set up 'include these jobs' I use a combination of count and fail element to loop the file from Problem Jobs back to the flow to retry, if it fails again I use the count to push the file to the mail send vs retrying it again since I know it is an actual failure. Hope that he...
by magnussandstrom
Mon Oct 14, 2024 3:30 pm
Forum: Griffin
Topic: Keeping jobs apart
Replies: 3
Views: 3381

Re: Keeping jobs apart

I'm also having issues with Griffin Auto on a regular basis. There are too few options in the Griffin Auto app, and as far as I know, it's not possible to achieve the results you're aiming for in the example above. Interestingly, when reviewing the documentation here: https://docs.tilialabs.com/grif...
by magnussandstrom
Wed Oct 02, 2024 9:19 am
Forum: Flows
Topic: Calculate Sum of Values with XML
Replies: 3
Views: 2201

Re: Calculate Sum of Values with XML

Roberts' solution is clearly the superior choice between the two options. :)
by magnussandstrom
Wed Oct 02, 2024 8:58 am
Forum: Flows
Topic: Calculate Sum of Values with XML
Replies: 3
Views: 2201

Re: Calculate Sum of Values with XML

I would do this using XSLT (solved with a quick conversation with chatGPT): You can calculate the sum of the <No-Up> values in your XML using XSLT. Below is a simple XSLT stylesheet that will do this: XSLT: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0&...
by magnussandstrom
Mon Sep 30, 2024 9:24 am
Forum: Switch
Topic: Can i moove a newly created job to the problem job folder
Replies: 2
Views: 1596

Re: Can i moove a newly created job to the problem job folder

The easiest way to move a job to the problem job folder is to end the flow with an output rule that will never occur.

Example:
problem_jobs.png
problem_jobs.png (205.33 KiB) Viewed 1589 times
by magnussandstrom
Fri Sep 20, 2024 1:14 pm
Forum: Flows
Topic: Sending files to Sharepoint
Replies: 3
Views: 2325

Re: Sending files to Sharepoint

Yes, the flow I'm currently building is set up as follows: 1. Uploading the file to Azure Blob Storage using the Switch Azure Upload app. 2. Sending a JSON payload via the HTTP request app to trigger a Microsoft LogicApp flow. 3. The LogicApp flow downloads the file from Azure Blob and uploads it to...
by magnussandstrom
Thu Sep 19, 2024 1:11 pm
Forum: Flows
Topic: Sending files to Sharepoint
Replies: 3
Views: 2325

Sending files to Sharepoint

Have anyone built a flow that send files from Switch to Microsoft Sharepoint?
by magnussandstrom
Thu Sep 19, 2024 9:20 am
Forum: Flows
Topic: Archive hierarchy moving files to wrong folder
Replies: 3
Views: 2200

Re: Archive hierarchy moving files to wrong folder

Sorry, I'm not sure I understand your workflow and problem. When you say: I have files coming in, where in the metadata, a link to the location is saved when creating the files by a user. 1. How is this achieved? How are the files "coming in" and in what metadata are the location path stor...
by magnussandstrom
Tue Sep 17, 2024 3:29 pm
Forum: Flows
Topic: Archive hierarchy moving files to wrong folder
Replies: 3
Views: 2200

Re: Archive hierarchy moving files to wrong folder

3. I tried changing the Job.Hierachy metadata with string replace to fix the address, but it does nothing there. I tried both, dataset and private data options with (\;tb-fp02\;switch)=T: but nothing changed. In this scenario I would add Job.Hierarchy to a Private Data tag than use the app Private ...
by magnussandstrom
Fri Sep 13, 2024 9:49 pm
Forum: Flows
Topic: Trigger if folder contains files older then 15 minutes
Replies: 1
Views: 1692

Re: Trigger if folder contains files older then 15 minutes

Hotfolder Monitor in the free Folder Apps pack will do this for you.
by magnussandstrom
Tue Sep 10, 2024 1:34 pm
Forum: Griffin
Topic: 100 page limit?
Replies: 6
Views: 28553

Re: 100 page limit?

Last week I had a meeting with an Enfocus Customer Success representative. We covered a lot of topics, but one of the key discussions was about the absence of a user-driven feature request portal for Enfocus products. She informed me that a feature request portal is in development and should be laun...