Re: Projects/SDLC

2 views
Skip to first unread message

Sara Farmer

unread,
Apr 11, 2010, 12:35:51 PM4/11/10
to k8ch...@gmail.com, crisiscommo...@googlegroups.com
Hi Kate,

I've got the project spreadsheet from January, and am

- Splitting it into two sheets: projects and evergreens
- Checking that all the projects on the wiki are on the sheets
- Finding contact names for all the projects that don't have one yet

Plan is to parse the csv file and dump out a standard letter for each
project manager. We need to think about what to ask them for, but a start
list could be:

- Status of project: choose from
* not started
* ongoing
* completed
* providing maintenance
* abandoned

- Who you deliver the project results to: organisation (if any) and contact
details

- Where you keep the project deliverables
* github, wiki, local harddrive, other website etc

- Contact details that you're willing to share (email, twitter etc)

- Tasks that still need to be done to complete this project

- Resources that you need for this project
e.g. somewhere to store code, specific skillsets etc

A suggested 'next' to this activity is:
- Any project that we do get a response for will go onto the Projects/SDLC
lists and get management help from the projects WG.
- Any project that we don't get a response for will go into a "naughty bin".
We try again to contact the listed project manager, then we (carefully) try
to contact the customer about it, then we work out together how to handle
the project from here on (e.g. put it back into the "new projects list",
retire it etc).

It'll take me a while to get the lists together, so any comments on the
above in the meantime will be helpful!

Thanks,


Sj.

Sara Farmer

unread,
Apr 11, 2010, 2:52:24 PM4/11/10
to crisiscommo...@googlegroups.com
Okay, this is embarassing (and maybe the infrastructure people could help
with some how-to notes), but I'm not sure how to upload to Google
Spreadsheets so that everyone else in the group can see them. So... we have
the three files now:

* CCprojectmanagers - contact details (from wiki.crisiscommons) of everyone
who's been on a project management list
* CCEvergreens - all the evergreen projects in wiki.crisiscommons
* CCProjects - all the other projects in wiki.crisiscommons

Can someone upload these to google docs for me please? And once they're up
there, can people please send me contact details of project managers and
names of projects that we've missed from the list. We will soon be
contacting all the project managers directly to get things like the status
of each project and a list of tasks left to complete it.

Thanks,

Sj.

CCEvergreens_11_apr_2010.csv
CCProjects_11_apr_2010.csv
CCprojectmanagers.csv

Chris Foote (Spike)

unread,
Apr 11, 2010, 3:15:29 PM4/11/10
to crisiscommo...@googlegroups.com
Urm. I should be able to do this.

Give me a few moments please.

Spike

Chris Foote (Spike)

unread,
Apr 11, 2010, 3:35:55 PM4/11/10
to crisiscommo...@googlegroups.com
Ok.

I've combined these three files into one with three sheets - everyone
should be able to get to this file via
http://spreadsheets.google.com/ccc?key=0AhaaqXTF-_66dE9NVV9sNUZkblhsNkdZWUZKVGFMZFE&hl=en

Watch for line wrap.

Spike

Kate Chapman

unread,
Apr 11, 2010, 9:00:47 PM4/11/10
to Sara Farmer, crisiscommo...@googlegroups.com
I think that makes sense about the naughty bin. I'm not sure what
else we can do. I think everything you suggested we collect makes
sense. Let me know what additional assistance you need.

-Kate

Sara Farmer

unread,
Apr 12, 2010, 1:00:27 AM4/12/10
to crisiscommo...@googlegroups.com
Welllll.... I've got the lists of projects and owner contact details
together... help needed as the moment is to get the list below into a
friendly email form so we don't scare all the project managers away :-).

Sj.

Sara Farmer

unread,
Apr 12, 2010, 9:30:06 AM4/12/10
to G. Hussain Chinoy, crisiscommo...@googlegroups.com
Hello Hussain,
 
and thank you very much for volunteering!  Yes please to your offer...  it would be very helpful to have a tool like this, because we're going to need to do a lot of project mailshots over time!
 
Thank you,
 
 
 
Sara.


--- On Mon, 12/4/10, G. Hussain Chinoy <ghch...@gmail.com> wrote:

From: G. Hussain Chinoy <ghch...@gmail.com>
Subject: Re: [CrisisCommons Projects] Re: Projects/SDLC
To: sara....@btinternet.com
Date: Monday, 12 April, 2010, 14:26

Sara,

If you can bring the spreadsheet into Google docs, I think there's a way to create an e-mail to the individuals via a fairly simple script:

Also, you can create a form for them to fill out to collect the follow up survey info you want, also via google docs.

Please let me know if you need help!

H

--
To unsubscribe, reply using "remove me" as the subject.

Reply all
Reply to author
Forward
0 new messages