Input tool for multiple .txt files error in gallery

Question

Hi all,

I need to publish a workflow in the gallery to be run by the end user, however, I'm getting errors with the input tool. I used that tool to upload all the txt files saved in a folder, and it worked fine on the desktop but when I tried to save it in the gallery, and received a bellow error. Is there a way to resolve this issue? I would like to avoid the manual work for the end user uploading many files.

error.JPG

alexnajm · Answer

The same requirement remains - if you are publishing to Gallery, the Server needs to have access to the SharePoint folder / the shared folder in order for this to work! Like @danilang said I would ask your Server Admin about this.

Gloria_Loaisiga · Answer

Hi,

Thanks both for replying to my issue.

The process is performed for a partner, we are in the same organization, hence we have access to Sharepoints and teams, but not sure if this is the network you're referring to.

The process is to look for some documents that were not posted into SAP in different txt files (downloaded from WinsCP). After she finds the document number, she needs to extract the portion of that document and paste into a new txt file to be sent via email to the team in charge of posting the documents. This process is consuming a lot of time for the team, hence we were requested to automate it.

My idea was to create WF in Alteryx to be posted in the Gallery, so the person in charge of running this process can access and just run it. Thinking of the idea of reducing the manual work, I tried to use the input tool to call all txt files at the same time, but it was not possible to publish in the gallery. Otherwise, she will need to include around 15 txt. files. In the test (running it on my computer) it worked because I was using my :c folder.

Should be possible to use a SP or from a shared folder in Teams?

Thanks in advance!

danilang · Answer

Hi @Gloria_Loaisiga

As @alexnajm mentioned, the user account that runs the Gallery needs to have access to the path.   Contact your Alteryx server admin to find out the name of the user that runs the Alteryx service and then work with your network team to get access to the files.

Another thing to look at is the format of the path.  It's difficult to tell with scribble but it looks like path starts with a drive letter, i.e. c:\dir\subdir.  Paths have to be in UNC format( \\Server\Share\dir\subdir) to be accessed from the Gallery.

It looks like the path actually might start with "c:".  If that's the case, this is telling the Gallery to look in c:\ on the gallery server for a specific path.  This is guaranteed to not exist.   If the intent is to have the Gallery workflow read from the c:\ drive on the user's own computer, this can't be done, unless there is a share on that computer that the server account has access to.

Can you give us more details on the process you're trying to accomplish?

Dan