Skip navigation

Monthly Archives: November 2008

“Para” turned up a nice list of listening fun. You’re right, I should go ahead and get the rest of Coldplay’s Parachutes.

After much testing, it’s starting to look like creating JLT’s through Yours Truly might be our only decent option right now.  XMPie’s uDirect worked great to create the .ps file and a multipage PDF, but our ESKO system took literally hours to process it.  We’re hoping that creating a press-ready JLT file directly from Yours Truly will speed things up.

In my dealings with MySQL, I’ve typically relied on a combo of Terminal and the MySQL Administration package from MySQL.  I know many people rely on PHPMyAdmin and we’ve toyed with Navicat before.  In my web rummaging this morning, I came across Sequel Pro from mjmedia.  Sequel Pro is the leftovers from CocoaMySQL and looks to be a promising database administration/browsing program for the mac. 

Will Snow Leopard (Mac OS X 10.6) be out in the first quarter of next year?

I had some success today finishing up a small project I had been wanting to work on whenever I had time.  I wanted to be able to transfer uploaded artwork from our website directly to a file server via FTP.  We have been using built-in PHP functions to create and move the uploaded files into folders, but it was residing on our webserver.  I wanted to connect to a file server so that our site gets a little more portable (I could run the site elsewhere and the files should show up here) and to reduce the number of people who need access to the webserver itself.  Here’s what I came up with:

//FTP connection
$conn = ftp_connect(“serverAddress”) or die(“Could not connect”);
ftp_login($conn,”FTPUser”,”FTPPass”);
//make directory
ftp_mkdir($conn,$FolderName);
//change directory to newly created one
ftp_chdir($conn,$FolderName);
//put temp PHP files in new folder
ftp_put($conn,$_FILES[‘FileField’][‘name’],$_FILES[‘FileField’][‘tmp_name’],FTP_BINARY);
ftp_close($conn);

Seems simple enough, I just had doubts to if the FTP functions could extract the $FILES information. 

I’m starting to like Automator more and more.  You can’t do as much as you can with Applescript, but it’s very handy for coming up with quick workflows to help you do tasks, especially repetitive ones. 

Just recently, I came up with a workflow to connect to a server, look for a folder the user asks for, copy it to their desktop and then disconnect from the server.  It isn’t a true file server I’m connecting to, only a webserver where some uploaded content resides (we’ve been too lazy to tie it into the file server).  It didn’t take very long and seems to work pretty well.  It helps speed up the work for the people retrieving the customer’s files.

In essence, I connect to a specified server (afp://serverAddress/Share), display the “Find Finder Items” step to get user input, get the mounted volume from the connected server, then eject that volume.