CoolStateLA/Technical Development Timetable

From CSWiki

Cool State LA Technical Development Timetable V. 1.0

Note that this is a work in progress. If you have been involved in this project, and have been supplied a user name and password to access this site, you are encouraged edit and re-edit this page as often as you like. If the times and deadlines seem unreasonably short, edit the document to the point where it meets your expectations, and others will do the same.

In most instances, the date listed is the date by which we expect to have the activity following it completed and operable. It is NOT assumed that all problems will have been worked out by most of these dates, but rather that they serve as our best-effort deadlines.

If you have to significantly change a date (more than 1 week) please communicate that information to me as soon as you can.

In all cases, we are asking you to add more detail to this sketchy road map. By all means, enter sub-deadlines, or intermediate

Contents 1 Timetable 2 Status Report 2.1 Week 5 - February 1, 2008 2.1.1 Dhaval 2.1.2 Farrukh 2.1.3 MK 2.1.4 Mark 2.1.5 Ren 2.1.6 Sepideh 2.2 Week 6 - February 8, 2008 2.2.1 Chhun 2.2.2 Dhaval 2.2.3 Farrukh 2.2.4 Josef 2.2.5 MK 2.2.6 Mark 2.2.7 Ren 2.2.8 Sepideh 2.3 Week 7 - February 15, 2008 2.3.1 Chhun 2.3.2 Dhaval 2.3.3 Farrukh 2.3.4 Josef 2.3.5 MK 2.3.6 Mark 2.3.7 Ren 2.3.8 Sepideh 2.4 Week 8 - February 22, 2008 2.4.1 Chhun 2.4.2 Dhaval 2.4.3 Farrukh 2.4.4 Josef 2.4.5 MK 2.4.6 Mark 2.4.7 Ren 2.4.8 Sepideh 2.5 Week 9 - February 29, 2008 2.5.1 Chhun 2.5.2 Dhaval 2.5.3 Farrukh 2.5.4 Josef 2.5.5 MK 2.5.6 Mark 2.5.7 Ren 2.5.8 Sepideh 2.6 Week 10 - March 7, 2008 2.6.1 Chhun 2.6.2 Dhaval 2.6.3 Farrukh 2.6.4 Josef 2.6.5 MK 2.6.6 Mark 2.6.7 Ren 2.6.8 Sepideh 2.7 March 22, 2008 2.7.1 Muhammad 2.7.2 Kaleem 2.7.3 Ishani 2.7.4 Diedre 2.7.5 MK 2.7.6 Dhaval 2.8 March 29, 2008 2.8.1 Chhun 2.8.2 Dhaval 2.8.3 Farrukh 2.8.4 Josef 2.8.5 MK 2.8.6 Mark 2.8.7 Sepideh

[edit] Timetable

Date due	Person responsible	Task/product/event
Feb 8, 2008	Joshi	Cool State “2nd Pages” (Video, News, Audio) soft launch
Feb 9, 2008	Sepideh	Workflow, (prototype)
Feb 9, 2008	Ren	ER diagrams for projected full system to accompany use cases, v1.0. Assist MK with project info, and Sepideh with Use Cases as necessary.
Feb 9, 2008	Farrukh	Fedora front end for entering items, (prototype)
Feb 9, 2008	MK	Fedora version of STORI system, (prototype)
Feb 9, 2008	Mark	RSS Feed search engine stores feeds in Fedora.
Feb 22, 2008	Joshi	remaining Cool State “2nd Pages” (Photo, Culture, Email, Events, 1st Person, People, Contacts) soft launch
Feb 23, 2008	Sepideh	Work flow system linked to RSS Feed search leads stored in Fedora.
Feb 29, 2008		CS “third” and “fourth” pages prototypes installed and operable on Coolstatela.com.
Mar 8, 2008	Dhaval, Farrukh, Ren, Sepideh, MK.	Initial version of system installed on computers accessible to CSUT staff. Dhaval and Farrukh: installation of software Ren (with the assistance of Sepideh and MK): prepare draft training materials Sepideh: deliver version of workflow system that uses feeds stored in Fedora MK: deliver version of Fedora-based STORI system
Mar 17, 2008		Enterprise-wide ‘Fix-List’ established for everyone to use. This entity should be a repository for technical documentation and the multiple lists of things that need to be fixed, revised, or adjusted on the system before going public with the work.
Mar 21, 2008	Ren (with the assistance of Sepideh and MK)	Brief CSUT staff on how Fedora CMS prototype will work. That Phase I needs to be ready for Beta testing in CSUT office.
Mar 24 – Apr 4, 2008		Phase I system functionality testing
Apr 12, 2008 10:30 AM		Phase I system functionality evaluation conference, E&T 223
Apr 15, 2008		soft-launch of CoolState.LA

[edit] Status Report

Hey All:

Remember that starting this week we need reports on all the extra-journalism projects you are working on. This weekly report need not be long or tedious, just a half page or less describing the status of the project. Here are the guidelines:

1. General status of the project in a sentence or two
2. Next steps in the project: specific and deadline or completion oriented
3. Commitment dates: by what date will the next significant step of the project be completed? Be specific and do your best to achieve that next step by those dates.

Please complete these Status Reports by Friday morning, 11:00 am.

[edit] Week 5 - February 1, 2008

[edit] Dhaval

[edit] Farrukh

A Prototype System to store and retrieve a story from fedora.

Current Status:
- Built JavaBeans to use webservices API and coardinate with Fedora application.
- Currently working on the architecture of my application, for example, what framework to use , frontend and how the different part of application would fit together.

[edit] MK

User Interface: Fedora version of STORI

Current Status:

-- I just joined the project and I am trying to understand the requirement for the project; I am meeting with Ren to discuss the requirement this Saturday. In the mean time, I am reading project docs.

[edit] Mark

I am down to annoying little bugs in the news item submission, as well as reworking the way I handle duplicate items. Also there is another bug that when processing feeds, the main information table is dropped and never restored. I am 90% done with this project, I hope to have these annoying bugs fixed soon and to show the demo to the team.

The work that Farrukh has done with regards to creating objects through the APIM has been invaluable.

[edit] Ren

1. I have written the ER diagrams on paper, and will convert it to a database schema next week. I can't find an open source application that can create an ER diagram, and not only a database schema. I've looked at StarUML, Power Architect, Open System Architect, and DBVisualizer. I may need to use Visio to have an electronic copy of the ER diagrams.
2. I emailed printscreens of the current STORI to MK on Tuesday. We'll meet this Saturday to discuss the project.

[edit] Sepideh

1. Add a part to make a choice to send the job to different users.
2. Add more fields for fork flow manger
3. Add a new Search for work flow but it is not complete yet.
4. Design a new user interface for the work flow that can be used work whole patrol.

[edit] Week 6 - February 8, 2008

CoolStateLA Meeting, Saturday 2/9/08, 11:30 am, ET A223 Conference room

Hi all,

After talking to most of you, here is our following tentative schedule:

1. Ren: 11:30 - 11:45
2. Dhaval: 11:45 - 12:00
3. Farrukh: 12:00 - 12:15
4. Mark: 12:15 - 12:30
5. MK: 12:30 - 12:45
6. Sepideh: 12:45 - 1:00

[edit] Chhun

[edit] Dhaval

[edit] Farrukh

[edit] Josef

[edit] MK

[edit] Mark

Not much to report yet. I am still working out a mechanism to prevent duplicate items from being sent to the Fedora system. It is pretty simple in design, but it will take some time to actually develop (the map is not the road...)

[edit] Ren

1. I have the database schema in Visio.
2. I've been in contact with Dr. Abbott and the Fedora mailing list to find out how to create a Content Model based on the database schema. Carol from Fedora wrote that detailed documentation on the Content Model won't be available until 6-8 weeks. Fortunately Steve Bayliss, a Fedora developer, has started to share his experiences regarding content models for his application. I'll follow-up with him, and will research Fedora's Resource Index (to query the content model) the coming week.
3. I met with MK last Saturday. We discussed that he can put STORI in JSPs and temporarily use MySQL until he can use Farrukh's middleware to Fedora.
4. I spoke to most of the team for an update, and then set-up a tentative meeting schedule.

[edit] Sepideh

1. Add a part to make a choice to send the job to different users.
2. Add more fields for work flow manger.
3. Add a new Search for work flow but it is not complete yet.
4. Design a new user interface for the work flow that can be use by whole patrol.

[edit] Week 7 - February 15, 2008

[edit] Chhun

[edit] Dhaval

1]I installed the video component on the video page.I have view Issues with extensions available but joomla Forums are help full to solve those problems.
2]The next components,Modules that i plan to install are for the Audio page and other pages.
3]I would have a meeting with jon for the other pages.I Hope that we are ready for the soft launch by end of the next week.If Every Thing goes according to the plan.

[edit] Farrukh

1. Wrote some code to generate our own metadata and generate FOXML in much easier way. The XML tags won't be hardcoded and can be added/removed just by one simple java statement.

cElements celem = new cElements();
		celem.addElement("Slug", "String", "S111");
		celem.addElement("slug22", "String", "12312");
		celem.addElement("editor", "string", "jon");
				
		Element mdata = celem.createFOXML(xmldoc);

2. Tested the REST API for fedora.

3. Finally made a successful SOAP call to findObject method.

4. Working on batch import and a simpler content model.

[edit] Josef

[edit] MK

I am working on the user interface and I should be able to show something by next week.

[edit] Mark

I am still developing the duplicate elimination system. I plan on increasing my efforts over the next week.

[edit] Ren

1. Revised the database schema to have separate tables (or entities) of a Story, Metadata, Text, Image, Audio, Video, Feed, and User. The Story links the other entities together.
2. Going through Steve's directions on constructing a Fedora BDef, BMech, CModel, and sample Data Object. The Resource Index will use the CModel to (for example) search for stories linked to certain images.

[edit] Sepideh

1. Make a join query for search in order to view title and users by name instead of Id
2. Add sign out for all pages.
3. Add another item status for search.

[edit] Week 8 - February 22, 2008

CoolStateLA Meeting, Saturday 2/23/08, 11:30 am, ET A223 Conference room

1. Ren: 11:30 - 11:45
2. Dhaval: 11:45 - 12:00
3. Farrukh: 12:00 - 12:15
4. MK: 12:15 - 12:30
5. Sepideh: 12:30 - 12:45

[edit] Chhun

[edit] Dhaval

I am waiting for Jon to get me the designs for the other pages.
I am working on other pages haven't able to find a good component/module
for audio pages and needs content to be made more organized.

[edit] Farrukh

[edit] Josef

[edit] MK

[edit] Mark

[edit] Ren

1. Revised the database schema to include StaffMembers table and necessary junction tables.
2. Doing research to transform this database schema to a Content Model.
3. Will use RDQL or ITQL to query the Resource Index.

[edit] Sepideh

Write a trigger which can be called with the fedora and load all new data in Work flow system from RSS Feed search stored in Fedora.

[edit] Week 9 - February 29, 2008

CoolStateLA Meeting, Saturday 3/1/08, 11:30 am, ET A223 Conference room

• Tentative schedule:

1. Ren: 11:30 - 11:45
2. Dhaval: 11:45 - 12:00
3. Farrukh: 12:00 - 12:15
4. Mark: 12:15 - 12:30
5. MK: 12:30 - 12:45
6. Sepideh: 12:45 - 1:00

[edit] Chhun

[edit] Dhaval

i am working on the audio page, jon saw the home audio video photo pages
today in the meeting suggested many changes and also told me to give the design
for other pages.

[edit] Farrukh

[edit] Josef

[edit] MK

[edit] Mark

[edit] Ren

1. Revised the database schema to version 1.8.
   1. Redesigned story metadata to appropriate objects/tables.
      1. Metadata common to the entire story is in StoryMetadatas (e.g. Slug, RunDate, KillDate, etc.).
      2. Metadata unique to Text, Image, Audio, and Video are now separately contained (e.g. ProducerID, CreationDate, etc.).
      3. Metadata unique to the story and media type are now also separately contained in StoriesImages, StoriesAudios, and StoriesVideos (e.g. EditorID, PriorityID, StatusID, etc.).
      4. Text objects don't have a format attribute because Fedora can generate the required format (HTML, PDF, etc.) on the fly.
      5. A Text object is associated to only one Story object. A follow-up story will be another Text object associated to new Story object. This is in contrast to an Image, Audio, or Video object that can be part of multiple Story objects.
      6. Added Version attribute to Text, Image, Audio, and Video objects. Fedora maintains versions automatically. This is a general model, and not necessarily implemented in Fedora.
      7. Added ContentURL attribute. Fedora will use this for content that is stored remotely (e.g. videos).
      8. Added secondary objects/tables - Priorities and Statuses.
      9. Note - ProducerID and EditorID are StaffMemberIDs.
   2. Organized table layout into columns of categories.
   3. Added Tasks table.
   4. To model related stories, added RelatedStories object and StoriesRelatedStories bridge entity.

[edit] Sepideh

1. Make a join query for Preference Manager in order to view users by First name and Last name instead of Id.
2. Change the status in order to coordinate them to Use cases.
3. Changes in trigger in order to save Date and Status.

[edit] Week 10 - March 7, 2008

CoolStateLA Meeting, Saturday 3/8/08, 11:30 am, ET A223 Conference room

1. Ren: 11:30 - 11:45
2. Farrukh: 11:45 - 12:00
3. MK: 12:00 - 12:15
4. Sepideh: 12:15 - 12:30
5. Mark: 12:30 - 12:45
6. Dhaval: 12:45 - 1:00
7. Jon: 1:00 - 1:15

[edit] Chhun

[edit] Dhaval

[edit] Farrukh

[edit] Josef

[edit] MK

[edit] Mark

[edit] Ren

[edit] Sepideh

1. Complete Search, so now it can search over jobs (STORIs) with title, user, status and description.
2. Fix the Registration part

[edit] March 22, 2008

[edit] Muhammad

1. Get together with Ren and learn about the overall use cases.
2. Revise architecture diagram.
3. Revise schema.

[edit] Kaleem

1. Get together with Farrukh and learn the Fedora interface code.
2. Be prepared to explain the calls that others will use to access (put stuff into and get stuff out of) Fedora.

[edit] Ishani

1. Get together with Sepideh and learn her code and database schema.

[edit] Diedre

1. Get together with Dhaval and learn Joomla!

[edit] MK

1. Get together with Fernando and Farrukh and learn the state of the server. Understand how to access the system from off campus.

[edit] Dhaval

• I was working on fixing the coolstate buttons this week so that it could be work and look same on each and every platform.
• other then this i am waiting to get people page done and also found few joomla extensions which will be helpfull to our website.I will email you these exensions later.
• I think we have template ready for our website as there are no more edits in the template for our website.

[edit] March 29, 2008

CoolStateLA Meeting, Saturday 3/29/08, 1:30 pm, ET A223 Conference room

[edit] Chhun

[edit] Dhaval

• i am working on embeding the clock to our webpage.

The module to have video on the front page is working.I installed the All-in -one plug in called Mambot.

• The video component that installed this week is the

updated video component.but its still not the bug free release.

• i will have the meeting with jon to have a coolstate

user account and the password for every user who uploads the video to the webpage.

[edit] Farrukh

[edit] Josef

[edit] MK

[edit] Mark

[edit] Sepideh