{"action":"created","issue":{"url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144","repository_url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker","labels_url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144/labels{/name}","comments_url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144/comments","events_url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144/events","html_url":"https://github.com/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144","id":187463866,"number":144,"title":"Food Data CSV Upload","user":{"login":"rsial2","id":5807576,"avatar_url":"https://avatars.githubusercontent.com/u/5807576?v=3","gravatar_id":"","url":"https://api.github.com/users/rsial2","html_url":"https://github.com/rsial2","followers_url":"https://api.github.com/users/rsial2/followers","following_url":"https://api.github.com/users/rsial2/following{/other_user}","gists_url":"https://api.github.com/users/rsial2/gists{/gist_id}","starred_url":"https://api.github.com/users/rsial2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rsial2/subscriptions","organizations_url":"https://api.github.com/users/rsial2/orgs","repos_url":"https://api.github.com/users/rsial2/repos","events_url":"https://api.github.com/users/rsial2/events{/privacy}","received_events_url":"https://api.github.com/users/rsial2/received_events","type":"User","site_admin":false},"labels":[{"id":350732951,"url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/labels/Round%2012","name":"Round 12","color":"f9d0c4","default":false}],"state":"open","locked":false,"assignee":{"login":"coderReview","id":5925442,"avatar_url":"https://avatars.githubusercontent.com/u/5925442?v=3","gravatar_id":"","url":"https://api.github.com/users/coderReview","html_url":"https://github.com/coderReview","followers_url":"https://api.github.com/users/coderReview/followers","following_url":"https://api.github.com/users/coderReview/following{/other_user}","gists_url":"https://api.github.com/users/coderReview/gists{/gist_id}","starred_url":"https://api.github.com/users/coderReview/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coderReview/subscriptions","organizations_url":"https://api.github.com/users/coderReview/orgs","repos_url":"https://api.github.com/users/coderReview/repos","events_url":"https://api.github.com/users/coderReview/events{/privacy}","received_events_url":"https://api.github.com/users/coderReview/received_events","type":"User","site_admin":false},"assignees":[{"login":"coderReview","id":5925442,"avatar_url":"https://avatars.githubusercontent.com/u/5925442?v=3","gravatar_id":"","url":"https://api.github.com/users/coderReview","html_url":"https://github.com/coderReview","followers_url":"https://api.github.com/users/coderReview/followers","following_url":"https://api.github.com/users/coderReview/following{/other_user}","gists_url":"https://api.github.com/users/coderReview/gists{/gist_id}","starred_url":"https://api.github.com/users/coderReview/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coderReview/subscriptions","organizations_url":"https://api.github.com/users/coderReview/orgs","repos_url":"https://api.github.com/users/coderReview/repos","events_url":"https://api.github.com/users/coderReview/events{/privacy}","received_events_url":"https://api.github.com/users/coderReview/received_events","type":"User","site_admin":false}],"milestone":null,"comments":8,"created_at":"2016-11-05T00:15:00Z","updated_at":"2016-11-30T15:02:06Z","closed_at":null,"body":"When importing a new food data.csv file, automatically delete the old version first. We are having too many issues with duplicate food items appearing after importing a new food data file.  We will always be uploading a complete data.csv file and never just a few foods at a time.  Also, take away the function of the column in the data.csv file that indicates Deleted=YES or NO.\r\n"},"comment":{"url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/comments/263895111","html_url":"https://github.com/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144#issuecomment-263895111","issue_url":"https://api.github.com/repos/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144","id":263895111,"user":{"login":"szwart","id":11872594,"avatar_url":"https://avatars.githubusercontent.com/u/11872594?v=3","gravatar_id":"","url":"https://api.github.com/users/szwart","html_url":"https://github.com/szwart","followers_url":"https://api.github.com/users/szwart/followers","following_url":"https://api.github.com/users/szwart/following{/other_user}","gists_url":"https://api.github.com/users/szwart/gists{/gist_id}","starred_url":"https://api.github.com/users/szwart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szwart/subscriptions","organizations_url":"https://api.github.com/users/szwart/orgs","repos_url":"https://api.github.com/users/szwart/repos","events_url":"https://api.github.com/users/szwart/events{/privacy}","received_events_url":"https://api.github.com/users/szwart/received_events","type":"User","site_admin":false},"created_at":"2016-11-30T15:02:06Z","updated_at":"2016-11-30T15:02:06Z","body":"Thanks Paulo. OK, I think we are hesitantly ok with this plan…we will need to test this one quite a bit to make sure we know all of the nuances to uploading new food databases.\r\n\r\n\r\nFrom: Paulo Vitor Magacho [mailto:notifications@github.com]\r\nSent: Tuesday, November 29, 2016 1:50 PM\r\nTo: NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker <NTL-ISS-Food-Intake-Tracker@noreply.github.com>\r\nCc: Zwart, Sara (JSC-SK)[WYLE LABORATORIES, INC.] <sara.zwart-1@nasa.gov>; Mention <mention@noreply.github.com>\r\nSubject: Re: [NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker] Food Data CSV Upload (#144)\r\n\r\n\r\n@szwart<https://github.com/szwart> The amount of items won't be an issue. But I can keep the database wipe out when you want to restart from scratch (will need to reinstall the app).\r\n\r\nBut my proposal is to keep the delete food functionality and I work with you to get it running correctly.\r\n\r\nWhat did you think of the procedure I've sent. I can even make step 1 automatic. When you upload a new file, I will mark all existing food as deleted, if you want to keep it in the App, the new file being sent must have that food. Even if it name does not match exactly the existing food, you won't get duplicated records. I think this is a good solution.\r\n\r\nYou won't have to worry about the deleted flag. You only sent in the CSV file the food you want to show in the app.\r\n\r\n—\r\nYou are receiving this because you were mentioned.\r\nReply to this email directly, view it on GitHub<https://github.com/NASA-Tournament-Lab/NTL-ISS-Food-Intake-Tracker/issues/144#issuecomment-263678598>, or mute the thread<https://github.com/notifications/unsubscribe-auth/ALUpUtnmabpUoFZXny3_XrxUQtKxXgwHks5rDIHLgaJpZM4KqGrn>.\r\n"}}
{"actor":{"display_login":"szwart"}}