Databases
StackOverflow2013
Postsdbo
POFileZilla and applescript
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFileZilla and applescript
    primarykey
    data
    text
    <p>I am making an applescript that converts a folder of flv and f4v files to mp4 files and then uploads the to a server via filezilla. How would I use applescript to upload to a server through Filezilla? Here is my code:</p> <pre><code>--Install handbrakecli into /usr/bin/ --on adding folder items to this_folder after receiving these_items with timeout of (720 * 60) seconds tell application "Finder" --Get all flv and f4v files that have no label color yet, meaning it hasn't been processed set allFiles to every file of entire contents of ("Macintosh HD:Users:Chase:auto_convert:nope" as alias) whose ((name extension is "flv" or name extension is "f4v") and label index is 0) --Repeat for all files in above folder repeat with i from 1 to number of items in allFiles set currentFile to (item i of allFiles) try --label to indicate processing set label index of currentFile to 3 --Assemble original and new file paths set origFilepath to quoted form of POSIX path of (currentFile as alias) set newFilepath to (characters 1 thru -5 of origFilepath as string) &amp; "mp4'" --Start the conversion tell application "Terminal" do shell script "HandBrakeCLI -i " &amp; origFilepath &amp; " -o " &amp; newFilepath end tell --Set the label to red because this is the file that has been converted set label index of currentFile to 6 --Remove the old file on error errmsg --Set the label to red to indicate failure set label index of currentFile to 2 end try end repeat set extensionToFind to "mp4" set topLevelFolder to "Macintosh HD:Users:Chase:auto_convert:nope" as text set pathCount to count of topLevelFolder set mp4Files to files of entire contents of folder topLevelFolder whose name extension is extensionToFind if mp4Files is {} then return set mp4Folder to "Macintosh HD:Users:Chase:auto_convert:yep" move mp4Files to mp4Folder end tell end timeout --end adding folder items to </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChase
    1. USChase
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

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