COPYING or MOVING an xlsx file from S3 to a shared drive

[LBCoEnterprises]

I basically just need to copy (or move) the FILE (not the data inside the file) from the S3 bucket, and then paste it into the shared drive folder. This way all the source formatting from the xlsx will remain intact.

I have used the download tool several times to open data from a csv or xlsx file on a shared drive and then do something with it during the rest of the workflow.

This scenario is a little different. I just want to copy or move a file from a S3 bucket to a location on a shared drive. I don't need to open it.

I have already tried the previous set up using the download tool and then an output tool following, but this brings the data into the desktop and then saves it to a new location, thereby removing all the formatting in the xlsx source file (column widths, font, filters, sheet names, etc.)

I am not even sure if the download tool is the way to go here.

I do have all the S3 bucket names, credentials, secret keys, etc. and I have the name of the shared folder.

Thanks

[jrlindem]

Assuming you have access to both locations, I tend to use the Run Command Tool and configure the Batch Command instructions in a Formula Tool. 

The Batch Command syntax follows this format:  [move "source\path\filename.ext" "destination\path\"] but without the brackets.

-Jay

[LBCoEnterprises]

I do have access to both. I can understand how this would work for a shared drive to shared drive, but S3 to shared drive?? Where would I enter the S3 access and secret keys?

Can you provide a more detailed example??

[jrlindem]

I think you are coming up to the point, right?  I think you'll need to have your IS support map the S3 server as a shared drive so that you can access its contents.  -Jay

[LBCoEnterprises]

Okay, was hoping to avoid that if I could. Currently I can use the S3 Amazon download tool to pull the data out of the file, but if I want to pull the actual file out of the S3 bucket and download it I use WinSCP. 

Its a shame there's not an easier way.

Next step I guess is to pull the data out of the file like I can already do, save it to a xlsx, the have the command tool run a vba script to format the file back to its original formatting.

__PRESENT

__PRESENT

__PRESENT

[jrlindem · Accepted solution]

I agree that it's annoying it can't be simpler.  Also, if you're going to use the Run Command anyway, then I'd recommend building out a template of the file with the formatting and then just populate the data into that template from your workflow.  You shouldn't need VBA unless you're doing specific cell-shading, etc.

Anyway, thanks for considering my responses.  Best of luck, -Jay

[apathetichell]

you should have an aws identity outside of alteryx. If this is on an ec2 --- your ec2 should have a role. if this is your local ---- you need an aws role. you should get a policy attached to the role granting access to the s3 objects --- and then use aws s3 cp {{s3_address}} {{local-address}} --- options {{recursive/etc}}

Don't map the S3. Don't use key/pair to access. Use a role.