[SOLVED] Move files with appended date using SCP

trickydba · 12-15-2016, 01:26 PM

Let's say I have these files in a folder:

File1_2016_12_15.xlsx
File2_2016_12_15.xlsx

and I want to move them to a different location (using a wildcard of course) using SCP, how can this be done?

Turbocapitalist · 12-15-2016, 01:33 PM

How far does this get you?

https://www.linuxquestions.org/quest...ml#post5642523

trickydba · 12-15-2016, 01:53 PM

I can do that for one file, but I have several files that are in this format:

name_name_20161215.xlsx

I tried scp *$(date -d today +"_%Y%m%d'xlsx") username@hostname://dir1/home/eric/reports/AUDITS

with no success

Turbocapitalist · 12-15-2016, 01:56 PM

Try with a dot.

Code:

scp *_$(date -d today +"%Y%m%d").xlsx username@hostname:/dir1/home/eric/reports/AUDITS/

Also, be sure to identify the last part of the path as a directory.

trickydba · 12-15-2016, 01:59 PM

I solved it! Here is my code:

scp -p filename*.xlsx filename2*.xlsx username@hostname://dir/dir2

Thank you for all the help!!!

trickydba · 12-15-2016, 02:04 PM

@Turbocapitalist............your code works too!!!! Thank you!!!!!!!! Think I'll use yours, it looks cleaner and makes me look smarter! LOL

Turbocapitalist · 12-15-2016, 10:17 PM

Excellent. Be sure to skim the manual pages for the parts you used. Over time you'll pick up more.

Code:

man 7 glob
man date
man scp
man ssh_config

TheEzekielProject · 12-15-2016, 10:31 PM

Maybe I am misunderstanding exactly what you're trying to do but you should be able to accomplish this with rsync as well, e.g.

rsync /source* username@hostname:/destination/

trickydba · 12-16-2016, 08:17 AM

@The_EzekielProject & TurboCapitalist..............both of your solutions works, in command line BUT when I use it in a script (with Except, which is basically command line) it doesn't work. Now if the file does not have an appended date, it works beautifully in a script. I'm thinking ahead now and what would be better is to first create a folder named with the current date, then move all files with extension 'xlsx' into that folder

michaelk · 12-16-2016, 08:47 AM

expect is an extension of tcl which does not have wildcard expansion. You can use the glob command but it has been long time since I've used tcl/expect except for simple scripts. Your workaround might be the easiest at the moment to keep from learning another language.

Turbocapitalist · 12-16-2016, 09:00 AM

Try it with keys instead rather than "expect", that way you can use a regular shell (bash) script.

trickydba · 12-16-2016, 09:08 AM

@Turbocapitalist....when you say keys you are talking about putting in the script something like hostkey="ssh-rsa 2048 00:44:22:11:1f:11 etc etc or are you talking about a file in a certain location that has the key in it?

Turbocapitalist · 12-16-2016, 09:24 AM

You'd make a key using ssh-keygen and then copy it to the server with ssh-copy-id (or a manual transfer). Then you can log in with the key and do not need expect any more.

Code:

cd ~/.ssh/
ssh-keygen -f hostname_ed25519 -t ed25519 -C "username's script"
ssh-copy-id -i hostname_ed25519 user@hostname

That generates a key and copies it to the remote host. Then you can connect by pointing ssh or scp to it.

Code:

ssh-add ~/.ssh/hostname_ed25519
scp -i ~/.ssh/hostname_ed25519 \
    *_$(date -d today +"%Y%m%d").xlsx \
    username@hostname:/dir1/home/eric/reports/AUDITS/

That's the gist, but there are a lot of tutorials on the topic. Do use a strong passphrase for the key.

schneidz · 12-16-2016, 09:27 AM

https://linuxconfig.org/passwordless-ssh

trickydba · 12-16-2016, 09:29 AM

@Turbocapitalist.......what is the 'ed25519' for?