Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The FTP methods don't support downloading of folders, or recursion, by themselves, so there's no other way I can think of doing this but what I've suggested below.</p> <p>Change the method so you can differentiate between files and directories and handle them accordingly.</p> <p>Change <code>$ftprequest.Method = [System.Net.WebRequestMethods+Ftp]::ListDirectory</code> to <code>$ftprequest.Method = [System.Net.WebRequestMethods+Ftp]::ListDirectoryDetails</code></p> <p>Which will list in this format:</p> <pre><code>-rwxrwxrwx 1 owner group 277632 Mar 4 17:15 xml_socket.log.rar </code></pre> <p>Directories will have a <code>d</code> in place of the <code>-</code> at the start of the line.</p> <p>Here is an amended <code>try</code> block that will match only files so you can pass to the <code>downloadFtp</code> function:</p> <pre><code> try { if(!($filename -match '^d')){if((Test-Path ("C:\emsdropbox\"+$filename.Split(" ")[8])) -ne $true) { downloadFtp(($filename -split '\s+')[8]) }} $filename = $FTPReader.ReadLine() } </code></pre> <p>If you want to then get a list of directories, use the following <code>try</code> block against the same ftpresponse stream and for each, <code>ListDirectoryDetails</code> to get the list of files in each directory to process them:</p> <pre><code> try { if($filename -match '^d'){if((Test-Path ("C:\emsdropbox\"+$filename.Split(" ")[8])) -ne $true) { listdir(($filename -split '\s+')[8]) }} $filename = $FTPReader.ReadLine() } </code></pre> <p>You may also have to create the local directories too which you can do in powershell as follows:</p> <pre><code>New-Item c:\emsdropbox\newdir -type directory </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POfolders downloading as files in ftp
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGraham Gold
    1. USGraham Gold
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POfolders downloading as files in ftp
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis is a huge step in the right direction thanks! One issue though when I change it to ListDirectoryDetails I get this: 07-03-13 01:59PM 0 hmm.odd there is no file attributes at the front
      singulars
      1. PO
      1. USstaticFlow
    2. COnever mind I found a work around.
      singulars
      1. PO
      1. USstaticFlow
    3. COIt may depend upon the FTP server software/config - glad you found a workaround though :-)
      singulars
      1. PO
      1. USGraham Gold
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload