{"action":"created","issue":{"url":"https://api.github.com/repos/NAVADMC/ADSM/issues/513","labels_url":"https://api.github.com/repos/NAVADMC/ADSM/issues/513/labels{/name}","comments_url":"https://api.github.com/repos/NAVADMC/ADSM/issues/513/comments","events_url":"https://api.github.com/repos/NAVADMC/ADSM/issues/513/events","html_url":"https://github.com/NAVADMC/ADSM/issues/513","id":70516237,"number":513,"title":"CSV and XML import of same data results in different data in the program","user":{"login":"casesp","id":6764142,"avatar_url":"https://avatars.githubusercontent.com/u/6764142?v=3","gravatar_id":"","url":"https://api.github.com/users/casesp","html_url":"https://github.com/casesp","followers_url":"https://api.github.com/users/casesp/followers","following_url":"https://api.github.com/users/casesp/following{/other_user}","gists_url":"https://api.github.com/users/casesp/gists{/gist_id}","starred_url":"https://api.github.com/users/casesp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/casesp/subscriptions","organizations_url":"https://api.github.com/users/casesp/orgs","repos_url":"https://api.github.com/users/casesp/repos","events_url":"https://api.github.com/users/casesp/events{/privacy}","received_events_url":"https://api.github.com/users/casesp/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/NAVADMC/ADSM/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/NAVADMC/ADSM/labels/High%20Priority","name":"High Priority","color":"eb6420"},{"url":"https://api.github.com/repos/NAVADMC/ADSM/labels/User%20Testing","name":"User Testing","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"missyschoenbaum","id":6644604,"avatar_url":"https://avatars.githubusercontent.com/u/6644604?v=3","gravatar_id":"","url":"https://api.github.com/users/missyschoenbaum","html_url":"https://github.com/missyschoenbaum","followers_url":"https://api.github.com/users/missyschoenbaum/followers","following_url":"https://api.github.com/users/missyschoenbaum/following{/other_user}","gists_url":"https://api.github.com/users/missyschoenbaum/gists{/gist_id}","starred_url":"https://api.github.com/users/missyschoenbaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/missyschoenbaum/subscriptions","organizations_url":"https://api.github.com/users/missyschoenbaum/orgs","repos_url":"https://api.github.com/users/missyschoenbaum/repos","events_url":"https://api.github.com/users/missyschoenbaum/events{/privacy}","received_events_url":"https://api.github.com/users/missyschoenbaum/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/NAVADMC/ADSM/milestones/30","html_url":"https://github.com/NAVADMC/ADSM/milestones/Quality%20Assurance","labels_url":"https://api.github.com/repos/NAVADMC/ADSM/milestones/30/labels","id":947497,"number":30,"title":"Quality Assurance","description":"","creator":{"login":"josiahseaman","id":2256148,"avatar_url":"https://avatars.githubusercontent.com/u/2256148?v=3","gravatar_id":"","url":"https://api.github.com/users/josiahseaman","html_url":"https://github.com/josiahseaman","followers_url":"https://api.github.com/users/josiahseaman/followers","following_url":"https://api.github.com/users/josiahseaman/following{/other_user}","gists_url":"https://api.github.com/users/josiahseaman/gists{/gist_id}","starred_url":"https://api.github.com/users/josiahseaman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/josiahseaman/subscriptions","organizations_url":"https://api.github.com/users/josiahseaman/orgs","repos_url":"https://api.github.com/users/josiahseaman/repos","events_url":"https://api.github.com/users/josiahseaman/events{/privacy}","received_events_url":"https://api.github.com/users/josiahseaman/received_events","type":"User","site_admin":false},"open_issues":18,"closed_issues":30,"state":"open","created_at":"2015-01-22T20:33:30Z","updated_at":"2015-05-25T15:32:15Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2015-04-23T21:21:11Z","updated_at":"2015-05-25T16:50:27Z","closed_at":null,"body":"[For a quick explanation of this issue, see the **_Results_** section at the bottom of this report.]\r\n\r\n**Category:** Advanced Population Import\r\n**Test Name:** Comparison between CSV and XML data\r\n**Software version:** ADSM 3.2.22-RC6 (2d85671)\r\n**Machine:** Win7ProVMWare11\r\n\r\n**Description**\r\nThis test verifies that the program will import the CSV and XML file data exactly in the same manner for the same data located in those two different formats.\r\n\r\n**Expected Outcomes**\r\n1)  There should be no difference in the data stored in or displayed by the GUI between the CSV and XML files data, (provided they both contained the same information)\r\n\r\n**Steps to run/create this test**\r\n1)  Run ADSM by double clicking the adsm.exe filename\r\n2)  Create a new scenario by selecting \"new\" from the menu.\r\n3)  Navigate to the population form by selecting the \"Population\" tab on the left navigation pane\r\n4)  Select \"choose files\" and open the file:  \"ADSM Simple Units.csv\"\r\n5)  Select \"Import a Population\"\r\n6)  Observe the two units imported and make a record of the way the data is displayed.  (Screenshot works)\r\n7)  Repeat 2 through 6 using the file:  \"Simple Units.xml\" instead (An exact copy of the csv file data)\r\n8)  Observe and record any differences in the data.\r\n\r\n\r\n**_Results_**\r\n1)  The imported data is different.\r\n2)  The CSV data has the column \"User notes\" filled with \"herdid=1\", \"herdid=2\", while the XML file resulted in a column \"User notes\" with \"1\", \"2\" in them.\r\n3)  The XML imported data is an exact match to the exported XML, but the imported CSV is different in that column.\r\n\r\n![csv import data comparison-2015-04-23-15-15-57](https://cloud.githubusercontent.com/assets/6764142/7307857/c7366244-e9cc-11e4-8ea7-f7b9a051541a.png)\r\n\r\n![xml import data comparison-2015-04-23-15-16-29](https://cloud.githubusercontent.com/assets/6764142/7307861/cd880ab2-e9cc-11e4-8a18-192d6b00cb0b.png)\r\n"},"comment":{"url":"https://api.github.com/repos/NAVADMC/ADSM/issues/comments/105266806","html_url":"https://github.com/NAVADMC/ADSM/issues/513#issuecomment-105266806","issue_url":"https://api.github.com/repos/NAVADMC/ADSM/issues/513","id":105266806,"user":{"login":"casesp","id":6764142,"avatar_url":"https://avatars.githubusercontent.com/u/6764142?v=3","gravatar_id":"","url":"https://api.github.com/users/casesp","html_url":"https://github.com/casesp","followers_url":"https://api.github.com/users/casesp/followers","following_url":"https://api.github.com/users/casesp/following{/other_user}","gists_url":"https://api.github.com/users/casesp/gists{/gist_id}","starred_url":"https://api.github.com/users/casesp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/casesp/subscriptions","organizations_url":"https://api.github.com/users/casesp/orgs","repos_url":"https://api.github.com/users/casesp/repos","events_url":"https://api.github.com/users/casesp/events{/privacy}","received_events_url":"https://api.github.com/users/casesp/received_events","type":"User","site_admin":false},"created_at":"2015-05-25T16:50:27Z","updated_at":"2015-05-25T16:50:27Z","body":"CSV File below:\r\n=======================\r\n\r\nUnitID,ProductionType,UnitSize,Lat,Lon,Status,DaysLeftInState\r\n1, Cattle, 100, 40.422521, -104.947553, S, -1\r\n2, Cattle, 200, 40.422521, -104.841915, S, -1\r\n\r\n\r\nXML File below:  (be sure to save as UTF-16)\r\n=======================\r\n\r\n<?xml version=\"1.0\" encoding=\"UTF-16\" ?>\r\n<herds\r\n  xmlns:naadsm=\"http://www.naadsm.org/schema\"\r\n  xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\r\n  xmlns:gml=\"http://www.opengis.net/gml\"\r\n  xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n\r\n  <herd>\r\n    <id>1</id>\r\n    <production-type>Cattle</production-type>\r\n    <size>100</size>\r\n    <location>\r\n      <latitude>40.42252</latitude>\r\n      <longitude>-104.94755</longitude>\r\n    </location>\r\n    <status>Susceptible</status>\r\n  </herd>\r\n\r\n  <herd>\r\n    <id>2</id>\r\n    <production-type>Cattle</production-type>\r\n    <size>200</size>\r\n    <location>\r\n      <latitude>40.42252</latitude>\r\n      <longitude>-104.84192</longitude>\r\n    </location>\r\n    <status>Susceptible</status>\r\n  </herd>\r\n\r\n</herds>"}}