Archive for May, 2010

ProjectPier – Creating Task Lists Templates

Friday, May 28th, 2010

I just starting using ProjectPier after using Basecamp for so long and I LOVE IT! I can customize any or all of it easily. Check it here: Zen Web Development Evolve Project Management. In it, I’ve created an easy Payment Tab via Google Checkout or Paypal, and an easy Tab for my Ajax Chat room. I’ll talk about those later! All you need to know is php and CSS and a bit of MySQL.

Ok so, one thing I instantly missed from Basecamp was the Task List Templates so I cooked up a little recipe below on how to do it. As usual, PLEASE BACKUP YOUR DATABASE BEFORE DOING MY INSTRUCTIONS! Here are the steps!

#1 – You’ll need access to PhpMyAdmin for MySQL

#2 – You’ll need to create the task list in Projectpier (but not the tasks)

#3 – After creating the task list, look in the browser to determine the numeric code for the task list. It should look like this: http://yourdomain.com/index.php?c=task&a=view_list&id=9&active_project=13 for instance. The active project is 13 and the task list itself is 9. The active project # is not important. What we want is the number 9 which corresponds to the task list itself.

#4 Find out which company to assign these tasks to: Go into the project where you want to do this task list. Click on PEOPLE. Then click on the company name you want to assign this to. In the URL, it should look like this: http://yourdomain.com/index.php?c=company&a=view_client&active_project=3&id=7 The number we want here is 7 which is the ID # for this company.

#5 Find out who you want to assign these tasks to. While still on the company page, click on the name of the person to whom you want to assign this to. In the URL, it should look like this: http://yourdomain.com/index.php?c=user&a=card&active_project=3&id=4 The number we want here is 4 which is the ID # for this user.

#6 Create your tasks for this task list:  Pre-heat oven, Take out the dough, Knead the dough, Put it in a breadpan, Put in Oven, Set timer, Go watch TV, Remove pan from oven, Let Cool, Slice Bread, Eat Bread. I am not a cook so don’t yell at me if these bread making steps are wrong! :-D

#7 Assemble these into this format. If you have more tasks, add more lines just follow the pattern, the last number is important as it is the SORT ORDER. The lower numbers are first… :


INSERT INTO `project_tasks` (`id`, `task_list_id`, `text`, `assigned_to_company_id`, `assigned_to_user_id`, `completed_on`, `completed_by_id`, `created_on`, `created_by_id`, `updated_on`, `updated_by_id`, `order`) VALUES

(null, 9, ‘Pre-heat oven’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 10),

(null, 9, ‘Take out the dough’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 20),

(null, 9, ‘Knead the dough’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 30),

(null, 9, ‘Put it in a breadpan’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 40),

(null, 9, ‘Put in Oven’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 50),

(null, 9, ‘Set timer’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 60),

(null, 9, ‘Go watch TV’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 70),

(null, 9, ‘Remove pan from oven’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 80),

(null, 9, ‘Let Cool’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 90),

(null, 9, ‘Slice Bread’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 100),

(null, 9, ‘Eat Bread’, 7, 4, ‘null’, 0, ‘null’, 4, ‘null’, 4, 110);

#8 Insert the above code into PhpMyAdmin using the SQL tab. And PLEASE ONLY DO THE ABOVE if you REALLY UNDERSTAND IT. It is not too hard, but practice on a test site first to make sure you know what you are doing.

Using this, I just created a 38 line task list which I use over and over and over for build ZenCart eStores. I’ll be growing this list to be more precise on ALL of the tasks to do, so having this duplicatable task list is VITAL for me!

If there are others that REALLY want this to be an add-on for projectpier, I’ll consider developing it to make it basecamp-like.

-Tom

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

The Art of Science from Princeton

Friday, May 28th, 2010

This is some cool artwork from the Art of Science from Princeton University.

FOXNews.com – The Art of Science.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Unusually Cool Business Card Designs

Thursday, May 27th, 2010

Business Cards that look like cassette tapes! Do you remember cassettes?!

These are some really really cool business card designs. Try to make a unique impression the next time you want to update your card!

37 Unusual Examples of Business Card Design | FreelanceSwitch.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Google search page says Everything…and “More?”

Wednesday, May 26th, 2010

I hadn’t thought of this UI (user interface) decision for the Google Search results page… I agree this does seem weird…

kung fu grippe · Everything…and “More?” This strikes me as a….

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Steampunk Chopper

Monday, May 24th, 2010

Steampunk Chopper. This is a beautiful design to say the least!

Steampunk Chopper » Brass Goggles.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Google Fonts

Monday, May 24th, 2010

Google will now OWN the words on the screen…

Google Code Blog: Introducing the Google Font API & Google Font Directory.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

URL Shortener with a twist

Thursday, May 20th, 2010

Ok this is really interesting. It is a URL shortener with a password based on a CLUE that only your friends would know…  an INTERESTING twist in URL shorteners…

Trick.ly.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Kirk to Enterprise… come in Enterprise…

Monday, May 17th, 2010

Google’s android becoming a translation tool with Google Goggles…  looks neat… I should probably get an Android phone to try to keep up with all of this tech… oh wait… I never leave the office with programming all of the time… D’OH to me! :-D

Google Goggles Makes Android Devices Mobile Translators.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Unconventional speed tests for Chrome

Monday, May 17th, 2010

No standard tests for Google’s Chrome browser…  where are the MythBuster guys when they were CLEARLY needed… don’t they ALWAYS say to “NOT TRY THIS AT HOME!”  but… these are really cool… check the vid.

Google Chrome Blog: Potato gun, lightning, and sonic magic: Unconventional speed tests for the browser.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Cool Inspirational Photo

Friday, May 14th, 2010

Cool Photos and Artworks for Your Inspiration #11 | The Design Inspiration.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

The State of Web Development 2010

Friday, May 14th, 2010

Ajaxian » The State of Web Development 2010 – Web Directions.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Pencil vs. Camera

Thursday, May 13th, 2010

Pencil vs. Camera | 2dayBlog – Technology Journal, New Gadget everyday!.

LIKE:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay