Action Tool Formula Fill/Concat Error

The error I am getting is:
The object "dropfolder/export/campaigns/In_67f7c26031160000fa0030ae%5C1a_Account.csv" does not exist.

How do I prevent this ln_... string?

The function of the "action tool" and "file browse tool" is so that users can browse/select files and append that into the s3 object path used by the "S3 connector tool" - allowing gallery access users to run the workflow on the full size files in s3, without aws access. We host have a scheduler pulling samples of the larger files into the server, so users can browse/select from a list of filenames as they are uploaded to s3.

The issue - is a non-specified string being passed to the s3 object path, which I assume is caused by the formula used in the action tool? How should the formula be setup to concatenate the filename into the object path?

This is the Action Tool formula (#1 is the file selected in file browser):
IF [#2] = "Campaigns" THEN
"dropfolder/export/campaigns/"+[#1] ELSE
"dropfolder/export/launches/"+[#1]
ENDIF

Screenshot workflow.png

action_tool_formula.png

Gallery

Connectors

Interface Tools

Accepted answers

apathetichell

you can do that in the action tool - but that's skipping what I think is your issue:

You are trying to build a file selector -> do this to x file.

You are using a file picker -> upload a file - not a file selector.

What you are seeing is that instead of selecting an existing file on your server - your server is looking for the file that the user uploaded via filebrowse. that's not bad - but it won't be at the location you are looking for. That filename you see ties into the TEMP location created by uploading the file via the file browse tool - not the static location your are looking for.

solution - don't use a filebrowse tool here. use a text dropdown matched to the locations of the files on your share drive (or wherever) - user picks that - text goes to action tool - not temp file location.

All comments

apathetichell

hey - are you configuring dropdown 1 dynamically - and is it using a name/value key pair? your formula looks fine - and I believe [#2] is fine - so the question is why is

In_67f7c26031160000fa0030ae%5C1a_Account.csv - showing up as a value in #1. Keep in mind that your drop down may have two fields a name and a value field - and what is passed in #1 would be the value - not the name.

suarezr

. Hi,

#1 is a "File Browse" tool, and is configured per the below. Is there a way to view/edit the value once the file is selected in the file browse tool? Seems like that would be the best way to handle the file picking set up.

apathetichell

you can do that in the action tool - but that's skipping what I think is your issue:

You are trying to build a file selector -> do this to x file.

You are using a file picker -> upload a file - not a file selector.

apathetichell

Did you swap tools from File Browse to Dropdown? and if so - can you accept my answer as a solution?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703