{"action":"opened","issue":{"url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues/issues/269","repository_url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues","labels_url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues/issues/269/labels{/name}","comments_url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues/issues/269/comments","events_url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues/issues/269/events","html_url":"https://github.com/kcigeospatial/sha_oed_issues/issues/269","id":158368573,"number":269,"title":"QA Toolkit - Data Export - Generate List of Project Representatives","user":{"login":"slmessier","id":4098544,"avatar_url":"https://avatars.githubusercontent.com/u/4098544?v=3","gravatar_id":"","url":"https://api.github.com/users/slmessier","html_url":"https://github.com/slmessier","followers_url":"https://api.github.com/users/slmessier/followers","following_url":"https://api.github.com/users/slmessier/following{/other_user}","gists_url":"https://api.github.com/users/slmessier/gists{/gist_id}","starred_url":"https://api.github.com/users/slmessier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slmessier/subscriptions","organizations_url":"https://api.github.com/users/slmessier/orgs","repos_url":"https://api.github.com/users/slmessier/repos","events_url":"https://api.github.com/users/slmessier/events{/privacy}","received_events_url":"https://api.github.com/users/slmessier/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/kcigeospatial/sha_oed_issues/labels/QA%20Toolkit","name":"QA Toolkit","color":"006b75"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-06-03T13:35:02Z","updated_at":"2016-06-03T13:35:02Z","closed_at":null,"body":"# List Project Representatives \r\n[exportqpd.xlsx](https://github.com/kcigeospatial/sha_oed_issues/files/297649/exportqpd.xlsx)\r\n\r\n## Original Request & Email Chain\r\n\r\nFrom: Scott Messier \r\nSent: Friday, June 03, 2016 9:16 AM\r\nTo: 'Tad Daniel'\r\nCc: Viji Selvamani (viji.selvamani@ecointegration.com)\r\nSubject: RE: data dump\r\n\r\nHi Tad,\r\nViji was able to produce the following list.\r\nI believe it contains the information you’ve requested, and Aimee should be able to work from this export to produce a list of users to process.\r\nPlease confirm or advise.\r\nThank you!\r\nFrom: Tad Daniel [mailto:tdaniel@sha.state.md.us] \r\nSent: Thursday, June 02, 2016 1:53 PM\r\nTo: Scott Messier\r\nCc: Viji Selvamani (viji.selvamani@ecointegration.com)\r\nSubject: RE: data dump\r\n\r\nYep \r\n \r\nTad Daniel\r\n \r\nEnvironmental Programs Division\r\nRegional Environmental Coordinator Team Leader\r\n410-365-0164\r\n \r\n________________________________________\r\nFrom: Scott Messier [Scott.Messier@kci.com]\r\nSent: Thursday, June 02, 2016 1:06 PM\r\nTo: Tad Daniel\r\nCc: Viji Selvamani (viji.selvamani@ecointegration.com)\r\nSubject: RE: data dump\r\nThanks Tad – I think I’m following, can you confirm?\r\nYou would like an exported list of all names that appear within any of the 3 fields below, for all active projects in the system. From this initial list Aimee can sort to generate a list of distinct user names and add new users and/or YC information on a case-by-case basis. Can you please confirm?\r\n![image](https://cloud.githubusercontent.com/assets/4098544/15780182/69e27b90-296e-11e6-9062-bd69cdd1bc17.png)\r\n\r\nFrom: Tad Daniel [mailto:tdaniel@sha.state.md.us] \r\nSent: Thursday, June 02, 2016 11:18 AM\r\nTo: Scott Messier\r\nCc: Viji Selvamani (viji.selvamani@ecointegration.com)\r\nSubject: RE: data dump\r\n \r\nXLS format would be great.  Over time Aimee has been putting the Yellow Card # and Expiration date all in the name field. Now that you guys have developed the tracking system I am looking to make it easier for her to populate the new fields manually.\r\n \r\nThe attributes are the 3 original fields (Project Rep, ESC Manager, Superintendent)\r\n \r\n \r\nTad Daniel\r\n \r\nEnvironmental Programs Division\r\nRegional Environmental Coordinator Team Leader\r\n410-365-0164\r\n \r\n________________________________________\r\nFrom: Scott Messier [Scott.Messier@kci.com]\r\nSent: Thursday, June 02, 2016 10:53 AM\r\nTo: Tad Daniel\r\nCc: Viji Selvamani (viji.selvamani@ecointegration.com)\r\nSubject: RE: data dump\r\nHi Tad,\r\nSure! In general terms, we should be able to run an SQL query on the projects table to export records to file.\r\nHowever, I would like to understand a bit more of what you’re looking for before assigning to Viji for development. \r\n1.       I assume XLS format is preferred for the output?\r\n2.       What types of project attributes would you need? (perhaps use an annotated screencap to identify the attributes?) This will help us to define the query that would be utilized to extract the records.\r\n3.       Will Aimee use the project information to manually populate the YC information herself through the web app? If you were envisioning some sort of automated load routine, we might need to get together to discuss the details with Viji as it could represent a more complex effort.\r\nPlease let me know your thoughts – thank you!\r\nFrom: Tad Daniel [mailto:tdaniel@sha.state.md.us] \r\nSent: Thursday, June 02, 2016 10:13 AM\r\nTo: Scott Messier\r\nSubject: data dump\r\n \r\nScott\r\n \r\nIs there a way for you guys to do a data dump for me. I am looking the current information contained in the name fields of the project record.  This will help Aimee fill in the YC information in the new tracking system.\r\n \r\nThanks\r\n"}}
{"actor":{"display_login":"slmessier"}}