Closed Bug 650838 Opened 14 years ago Closed 14 years ago

mdn developer engagement calendar

Categories

(developer.mozilla.org Graveyard :: Wiki pages, defect)

Product:
developer.mozilla.org Graveyard
Component:
Wiki pages
Platform:
All
Other
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: cheilmann, Unassigned)

References

(
URL
)

Details

Attachments

(1 file)

screenshot
344.70 KB, image/png
Details
In the engagement team we want to release a calendar of events where you can meet Mozilla folk. I need a place to put the code for this (see url). Right now all the thing does is read a spreadsheet from Google docs and convert it using PHP and Curl.
Assignee: server-ops → phong
Dropping severity to stop paging on call, this is not in the current plan of engagement sites (that I have been given) so it needs to go through proper channels. Can you file out a project init at https://intranet.mozilla.org/webtools/webdev thanks!
Assignee: phong → cshields
Severity: critical → normal
This is actually on my list of projects on the engagement etherpad that was shared with the webdev team. Chris: Can you please complete the webdev project init form Corey linked to so we can get things kicked off? Thanks.
Chris, have you had a chance to meet with Corey? We can't make progress on this until you do ...
This will have to be in line after webifyme unless I'm directed otherwise.. We are spread thin right now. And no, I haven't seen any documentation on this yet aside from what is here in the bug.
Christian, can you meet up with Corey while you are in Mountain View this trip?
The code is now on github: https://github.com/codepo8/wheresmozilla
Assignee: cshields → nobody
Group: infra
Component: Server Operations: Web Content Push → Website
Product: mozilla.org → Mozilla Developer Network
QA Contact: mrz → website
Target Milestone: --- → 0.9.6
Version: other → MDN
Summary: Need hosting for a web site on Mozilla.org → mdn developer engagement calendar
Updated the product/component and assigned to Luke to investigate. We need to check with the security team to figure out the best way to import event info from a Google spreadsheet (which is what the devengage team will be using to update with new events and speaker info). The current plan is to find a safe way to get that data and port Chris's php code to django so we can host the calendar/map at http://developer.mozilla.org/events
Assignee: nobody → lcrouch
mcoates: can you guide us on using data from a google spreadsheet in our django app? Looks like we will load its data as csv to generate table elements and contents.
A few things: 1. Connect to the site over HTTPS 2. Ensure your code connecting to the site will fail if any certificate errors are encountered 3. Grab the data from the google doc in whatever method you prefer 4. Set reasonable limits on how much data should be grabbed. E.g. what happens if that cell is 5mb of data or the whole document is over 1 gig? 5. Perform strong input validation on the data you receive. Define what types of data you expect to receive and ensure the received data matches this. You can likely create a regex consisting of numbers, letters, spaces and a few special characters. 6. Be careful where you use this data. If its a SQL statement then make sure its a parameterized query. If its a web doc, then use HTML entity output encoding. I can give more info if you let me know where the data is going.
Can we also grab the data from the wiki Events page? https://wiki.mozilla.org/Events
(In reply to comment #10) > Can we also grab the data from the wiki Events page? > https://wiki.mozilla.org/Events Not so easily. Maybe in another release but I doubt initially. The Google Spreadsheet is easy because it's csv already.
Assignee: lcrouch → nobody
Luke: Is this doable for 0.9.6 for 6/14? Or do we need to push this out to 0.9.7?
Is https://wiki.mozilla.org/MDN/MDNv09x/v096 still accurate? If so we probably can't do the kuma wiki, home + demo studio redesigns, AND the dev calendar by 6/14. Will have to drop one of them.
(In reply to comment #13) > Is https://wiki.mozilla.org/MDN/MDNv09x/v096 still accurate? If so we > probably can't do the kuma wiki, home + demo studio redesigns, AND the dev > calendar by 6/14. Will have to drop one of them. No, that's why I was asking. I updated the wiki yesterday and moved it to https://wiki.mozilla.org/MDN/MDNv09x/v097 already. Was just checking with you before removing it from 0.9.6. ;-)
Bumping to MDN 0.9.7 release with target date of 6/30. Luke is investigating how we're going to import the events data and will port the code to django so we can host the page on developer.mozilla.org/events.
Target Milestone: 0.9.6 → 0.9.7
Assignee: nobody → lcrouch
Just a friendly note that this is now on Agile Bench.
John, Let's do this in the new bugzilla+etherpad agile method. So, how do we do that? ;)
Jay, To where should we link the "let us know" text of the last sentence, "If you are a Mozillian speaking at an event that's not listed here, let us know!" ?
up on stage9
Assignee: lcrouch → mozbugs.retornam
Status: NEW → RESOLVED
Closed: 14 years ago
Keywords: qawanted
Resolution: --- → FIXED
Luke: The data is missing in the calendar. The new /events URL and mailto: link look good, but there are no events listed.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Depends on: 667894
cron job is on so now there's data.
Status: REOPENED → RESOLVED
Closed: 14 years ago → 14 years ago
Resolution: --- → FIXED
This looks so cool now! Thanks!
thanks go to craig for the looks.
Christian, you might take the markup out of the Monash University conference cell as it carries over into the map page. :(
Fixed now - always a good idea NOT to allow HTML :)
Yeah that's the last changes to make :( - security stuff. I need to put a limit on the data size, and I need to know if this data comes from trusted sources, or should I escape all of it? So far I'm allowing html in "people" and "description". Should I tighten those up, or do we trust the data in this spreadsheet?
Well it is not public, so for now I'd say trust the data. I can share it with an admin here in case there are quick fixes to be made?
good idea. I'll email you.
Attached image screenshot —
The dates are currently not sorted properly
Status: RESOLVED → REOPENED
Keywords: qawanted
Resolution: FIXED → ---
Comment on attachment 542877 [details] screenshot Yeah Robert has been messing with this - there is no sorting, it just comes in the order of the spreadsheet.
right, if we want to sort we have to enforce a date format standard on the spreadsheet. we should treat that as a separate bug/enhancement for the future, right Jay?
Status: REOPENED → RESOLVED
Closed: 14 years ago → 14 years ago
Resolution: --- → FIXED
Wait that is weird... It seems your code doesn't properly check for the "done" column being yes or no... Events we proposed at shouldn't be in there, so let me delete those to see if that fixes it.
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(In reply to comment #32) > right, if we want to sort we have to enforce a date format standard on the > spreadsheet. we should treat that as a separate bug/enhancement for the > future, right Jay? Agreed. It should not be hard to keep that clean in the spreadsheet.
(In reply to comment #34) > (In reply to comment #32) > > right, if we want to sort we have to enforce a date format standard on the > > spreadsheet. we should treat that as a separate bug/enhancement for the > > future, right Jay? > > Agreed. It should not be hard to keep that clean in the spreadsheet. We can consider enforcing a date format that will work for the team in bug 668322
I'm doing: done = event_line[7] == 'yes' give me an example of a record that is wrong?
I deleted the ones that were wrong... Odd. Do you sort the array or something?
The order is different from the one in the spreadsheet. https://img.skitch.com/20110629-1m7u2uwtghyrp59f1dk4pu3q24.jpg
We use a python list which has arbitrary order. (something to do with python list optimization) sounds like we can use the spreadsheet data to change/fix stuff for release tomorrow until we can enhance/refine via bug 668322
Now that is pretty stupid from python isn't it? All we need is the order of the sheet to be reflected - it is in the right one.
well now that I look I'm using list conversion which says it SHOULD preserve the order of the iterable that csv reader returns. ... odd.
Christian, would you block the page from release for the issue you mentioned? Or is it something we can fix with the spreadsheet for now and maybe enhance in another iteration?
There is no way to fix it in the spreadsheet when the script randomly rearranges the order. However, this is not a show stopper. I'd rather have this out and fix the order later
marking r.fixed since we have good data on stage9. the order isn't ideal, but we can sort that out in bug 668322.
Status: REOPENED → RESOLVED
Closed: 14 years ago → 14 years ago
Resolution: --- → FIXED
verified fixed https://developer.mozilla.org/en-US/events
Status: RESOLVED → VERIFIED
Version: MDN → unspecified
Component: Website → Landing pages
Assignee: mozbugs.retornam → nobody
Product: developer.mozilla.org → developer.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: