8.11.2009

Naming Conventions and Other Various Animals

I've had to do various small tasks here lately to get the new web site up & running - and since we changed platforms completely there was a lot transferring I ran across some cool utilities & thought I'd share...


Exporting from SQL to CSV
The old database was SQL 2000 and the new has the option of importing CSV files, so instead of writing the SQL to transfer from old to new I found a handy program on Download.com called MS SQL Data Wizard. It was very easy to use with only a small amount of code to write so that I could generate a separate CSV for each product category. Kudos to the folks at SQL Maestro for a program that's easy to work with & very powerful.


Renaming Images to All Lowercase
Right now I'm trying to find a program to convert about 5-10,000 images to all lowercase file names. I know that Photoshop will do this but I'm pretty rusty - guess I might have to go dig thru help files at Adobe...

8.10.2009

More hours in the day please

I've just launched a new version of the web site for the company I work for & everything is new and exciting - on the flip side, everyone is freaking out because we also moved to a new hosting company. Live & learn I suppose but I think (hope) I've learned my lesson on doing both tasks at the same time.


There are SO many things I would love to do, new things I want to learn and so LITTLE time!


Definitely time to get a priority list together for work & home...


I'm horrible at managing time & this weekend was no exception (understatement). I did manage to make a little time for just hanging out with a friend & going to see a movie. We watched Julie & Julia - and I have to admit it's not something I would have probably chosen but I really enjoyed it a LOT more than I thought I would have. Actually I laughed my ass off but I don't want to spoil it for anyone.