Forum » Scripting / Automation »

Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: trying to move files within subfolders without taking the subfolders

@jwatson151: I'm not aware of any such problems with .NET assembly. Are you?
Anyway, the link I've posted shows a solution using plain scripting and a batch file.
jwatson151

trying to move files within subfolders without taking the subfolders

@Martin. Thanks. I generally stay away from .NET assembly..as it may leave a process running at the database level. My task is to import pdf files. They are being dropped in a /test folder. File A.pdf is within /test/A, file b.pdf is in /test/B and so on. So I'm trying to get the pdf's from within the unknown folders that will be dropped in /test then delete. In order not to get dup's or delete files I have not received yet, I am using a staging folder to move the folders within /test to then move the pdfs out of and then delete the folders and files.
jwatson151

trying to move files within subfolders without taking the subfolders

Trying to get PDF's only, from unknown folders being created and placed on the FTP. I was successful using -filemask but it transfers the folders as well which I do not want. I am currently trying this syntax but it does nothing and returns no errors. Your help is greatly appreciated. 
cd /Test/Exports/
mv * /Staging/
cd /Staging/
get -filemask="*.pdf|*\"  *.* "X:\Workflow\Scans\Documents\Generic"
cd /Staging/
rm *.*
exit

attempted these others as well:
I get no pdf's found error on this one... 
cd /Test/Exports/
mv * /Staging/
cd /Staging/
lcd \\1.2.3.4\Data\Workflow\Scans\Documents\Generic
mget */*.pdf
cd /Staging/
rm *.*
exit

**this one executes but no files move and errors are generated. 
cd /Test/Exports/
mv * /Staging/
cd /Staging/
get *.pdf "X:\Workflow\Scans\Documents\Generic"
cd /Staging/
rm *.*
exit

**this one executes but no files move and errors are generated. 
cd /Test/Exports/
mv * /Staging/
cd /Staging/
get -filemask="*.pdf|*\" -delete *.* 
exit
martin

An easy way is to select only *.csv files for the transfer (this assumes you subfolder names don't have .csv extension): 

get -delete *.csv C:\Users\hash\Desktop\BI\

Or you can explicitly exclude subfolders: 
get -filemask="*.csv|*\" -delete *.* C:\Users\hash\Desktop\BI\

See How do I transfer (or synchronize) directory non-recursively?
Hushham

Dear Martin,

Thanks for the reply, actually I want the files only and not the folders.
Is there a command who can pick '.csv' files only and not the subfolder?

right now I am getting the subfolders as well.
martin

Hushham wrote:

It copied the folder named 1 & 2 as well.

Sorry, I got lost.
This is what you wanted, isn't it?

Previously your wrote:
I am using 5.13.6 & I am using below command to get csv file from the listed folder & its subfolder but it only gets file from the specified folder.

What sounds like the files in subfolders were not downloaded, but you wanted them to. So it seems like now you have what you wanted.
Hushham

I forgot to tell you, I used the most latest version 5.13.7
Hushham

Dear Martin,

Thanks for the reply, the log of the below command is attached privately to you. Please check.
Command used is as below. It copied the folder named 1 & 2 as well. 
get -filemask="*.csv" -delete *.* C:\Users\hash\Desktop\BI\

Thanks
martin

Hushham wrote:

get -filemask="*.csv" -delete *.* C:\Users\hash\Desktop\BI\

result = it transferred the complete folder including subfolder.

This is correct. If it does not work for you, please attach a full session log file showing the problem (using the latest version of WinSCP).

To generate the session log file, use /log=path_to_log_file command-line argument. Submit the log with your post as an attachment. Note that passwords and passphrases not stored in the log. You may want to remove other data you consider sensitive though, such as host names, IP addresses, account names or file names (unless they are relevant to the problem). If you do not want to post the log publicly, you can mark the attachment as private.
Hushham

Referring to your below post, I have tried this as well but it didn't work as well:
Get files from subfolders
I tried 
get * C:\Users\hash\Desktop\BI\ -filemask="*.csv"

result = it copied all complete folder again.
Hushham

Just to tell you, I have used all below 
get -delete "*.csv" C:\Users\hash\Desktop\BI\

result = No file matching '*.csv' found 
get -delete "*\*.csv" C:\Users\hash\Desktop\BI\

result = No file matching '*\*.csv' found 
get -filemask="*.csv" -delete *.* C:\Users\hash\Desktop\BI\

result = it transferred the complete folder including subfolder.
Hushham

Getting specific file extension from all subfolders

Hi Martin,
You have explained everything wonderfully but I am having a trouble in getting specific file from all subfolders.
I am using 5.13.6 & I am using below command to get csv file from the listed folder & its subfolder but it only gets file from the specified folder. 
get -delete *.csv C:\Users\hash\Desktop\BI\

I have checked all changes like */*.csv etc.
I have also checked 
get -filemask="*.csv" -delete *.*  C:\Users\hash\Desktop\BI\

but of no use.
I want to take all .csv files from folder/subfolder & delete it later on.
Thanks
plubarj2

Thank you @martin
Apparently, the version I was running 4.3.9 doesn't like the filemask switch:
Unknown switch 'filemask'

I installed the 5.1 and it works great!

Thanks once more for the project and your support. I will donate.
martin

Re: Get including subfolders

What version of WinSCP are you using? Make sure, you have the latest one.

Use just simple mask *.txt.
Also note that you should use -filemask switch instead of the option include (although it is still supported for backwards compatibility). 
get -delete -resume -preservetime -filemask="*.txt" /data/* C:\temp\

If it does not help, please attach a complete log file.
Guest

Get including subfolders

First: thx a lot for that great tool! It works fine except a little problem I cannot manage.

I'm getting in trouble using mask and it seems that I got the exact opposite problem that other reported.

Using a shell command, I just need to download all files of some type from an FTP folder, including its subfolders.
But I can't get the files located in the subfolders.

Acc. to the doc:
Path Mask
When the mask selects files and it makes sense to select them based on directory, you can extend the mask with a path mask. You should separate the path mask from the filename mask by a slash. For example mask /home/martinp/*.txt matches all text files within the directory. To match all text files within subtree, use mask /home/martinp/*.txt; /home/martinp/*/*.txt.

I tried many configuration like this: 
/command "option batch abort" "option confirm off" "option include /*/*.txt" "open ftp://myftp.com" "get -delete -resume -preservetime /data/* C:\temp\" "exit"

or that: 
/command "option batch abort" "option confirm off" "option include */; *.txt" "open ftp://myftp.com" "get -delete -resume -preservetime /data/* C:\temp\" "exit"

Or without using the mask: 
/command "option batch abort" "option confirm off" "open ftp://myftp.com" "get /data/*/*.txt C:\temp\" "exit"

But I cannot get it working.

What I'm I doing wrong?
Thanks in advance

Documentation

Support

Associations

Follow Us