image
image

Go Back   macosx.com > Scripts > Apple Scripts

Reply
 
LinkBack Thread Tools
  #1  
Old June 14th, 2009, 12:17 PM
Registered User
 
Join Date: Jan 2008
Posts: 12
Thanks: 0
Thanked 2 Times in 2 Posts
djp_phillips is on a distinguished road
moving files if they are in a list

I run a community based website and up until now it has only been half dynamic, sometimes i would manually upload files to my server, anyway, in my database I have a table with for each row the file name of the image on disk, i have around 2400 unique files in that table, my problem is that on disk I have 2973 on my local machine, and for some reason i have around 3100 on my server.

What I would like to do is download the folder from the server to my desktop, then query the entire list of unique file names from the database to populate a list, then I want to use the list in an apple script to select each file and move it to a separate folder, at the end of the process i should end up with a folder "up_to_date" containing only the files that are referenced in the database.

Is this possible in applescript? I could produce a list with the file names separated by commas in form of text which i could copy into an applescript?
Reply With Quote
Reply

Bookmarks

Tags
applescript, file, folder, move, mysql

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump


All times are GMT -5. The time now is 01:43 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 RC1
Copyright 2000-2010 DigitalCrowd, Inc.