Search Results

Search found 5 results on 1 pages for 'keefer'.

Page 1/1 | 1 

• How to Map a CSV or Tab Delimited File to MySQL Multi-Table Database [migrated]

  - by Keefer

  I've got a pretty substantial XLS file a client provided 830 total tabs/sheets. I've designed a multi table database with PHPMyAdmin (MySQL obviously) to house the information that's in there, and have populated about 5 of those sheets by hand to ensure the data will fit into the designed database. Is there a piece of software or some sort of tool that will help me format this XLS document and map it to the right places in the database?

  Read the article

• How can I replicate Google Page Speed's lossless image compression as part of my workflow?

  - by Keefer

  I love that Google's Page Speed is able to losslessly compress a lot of my images, but I'd love to make it part of my workflow, prior to uploading a site and making it live. Is there anything I can run locally to give me the same lossless compression? I currently export images from Export For Web from Photoshop, and use a little application called PNGCrusher to reduce file size of PNGs. I'd love to find a faster way though than saving out and replacing the individual images from Page Speed's results.

  Read the article

• Multimedia PDF (Audio, Video and Links) That works on Desktop and iOS

  - by Keefer

  We've got a client that wants to have a PDF that has embedded audio, video and links. Using Acrobat Pro 9.x I've been able to embed all three no problem. They all work/playback if I use Acrobat Pro/Acrobat Reader. But don't show up in OS X's Preview at all. They also don't show up in iOS. Links work everywhere, but no multimedia. So I tried creating a similar document via Apple's iBooks Author, then exported as a PDF. Links work, but multimedia doesn't seem to work anywhere. Is there any way to make a PDF that works universally with embedded links and multimedia?

  Read the article

• Redirect all requests to a subdirectory

  - by Karl Keefer

  I have a drupal site install at example.com/drupal but now that the site is built I want to forward all requests to that directory, without it ever showing "drupal" in url. I think this can be done with .htaccess, but I didn't know if that was a hack-y answer. I'm using mediatemple's GridServer so I don't have complete control over apache settings and stuff, although I do have SSH.

  Read the article

• MySQL Sub-query.. Doesn't provide proper information after 3 entries into table.

  - by Chris Keefer

  After I get 3 rows in my forum_threads table this no longer does it's job; to organize a list of active forum threads and put the most recently responded-to thread at the top of the list, followed by second most recent posted-to thread, followed by third, fourth, etc. Like I said, the query works wonders up until there is a fourth row added to forum_threads. SELECT forum_threads.*, forum_posts.thread_id FROM forum_threads INNER JOIN (SELECT MAX(id) AS id, thread_id as thread_id FROM forum_posts group by thread_id order by id DESC) forum_posts ON forum_threads.id = forum_posts.thread_id

  Read the article

1