{"action":"created","issue":{"url":"https://api.github.com/repos/energy-data/energydata.info/issues/148","repository_url":"https://api.github.com/repos/energy-data/energydata.info","labels_url":"https://api.github.com/repos/energy-data/energydata.info/issues/148/labels{/name}","comments_url":"https://api.github.com/repos/energy-data/energydata.info/issues/148/comments","events_url":"https://api.github.com/repos/energy-data/energydata.info/issues/148/events","html_url":"https://github.com/energy-data/energydata.info/issues/148","id":219034810,"number":148,"title":"CSV file is displayed in a single column","user":{"login":"ClaraIV","id":9391517,"avatar_url":"https://avatars1.githubusercontent.com/u/9391517?v=3","gravatar_id":"","url":"https://api.github.com/users/ClaraIV","html_url":"https://github.com/ClaraIV","followers_url":"https://api.github.com/users/ClaraIV/followers","following_url":"https://api.github.com/users/ClaraIV/following{/other_user}","gists_url":"https://api.github.com/users/ClaraIV/gists{/gist_id}","starred_url":"https://api.github.com/users/ClaraIV/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ClaraIV/subscriptions","organizations_url":"https://api.github.com/users/ClaraIV/orgs","repos_url":"https://api.github.com/users/ClaraIV/repos","events_url":"https://api.github.com/users/ClaraIV/events{/privacy}","received_events_url":"https://api.github.com/users/ClaraIV/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-03T19:19:54Z","updated_at":"2017-04-10T14:42:06Z","closed_at":null,"body":"We have a problem with Excel/CSV files that do not respect the standard format. It seems like there is some data parsing that detects headers and since the first header is composed out of a single column it merges the following columns (next rows) into one column.\r\nPlease see here the excel file: https://energydata.info/dataset/pakistan-solar-measurement-wbg-esmap/resource/38350b3c-677e-4fe5-9109-11915df7c18b\r\nPlease see here the excel file translated into csv: https://energydata.info/dataset/pakistan-solar-measurement-wbg-esmap/resource/5cf06dcb-9786-4234-8496-d32cd75005de \r\nAnd please see here a work-around that is not ideal:  https://energydata.info/dataset/pakistan-solar-measurement-wbg-esmap/resource/44505227-c184-457a-8b36-4e62068e0146\r\n\r\nCan you deactivate the parsing of the header or modify the preview so that it looks like a usual text editor?\r\n"},"comment":{"url":"https://api.github.com/repos/energy-data/energydata.info/issues/comments/292970459","html_url":"https://github.com/energy-data/energydata.info/issues/148#issuecomment-292970459","issue_url":"https://api.github.com/repos/energy-data/energydata.info/issues/148","id":292970459,"user":{"login":"Naigege","id":6911487,"avatar_url":"https://avatars2.githubusercontent.com/u/6911487?v=3","gravatar_id":"","url":"https://api.github.com/users/Naigege","html_url":"https://github.com/Naigege","followers_url":"https://api.github.com/users/Naigege/followers","following_url":"https://api.github.com/users/Naigege/following{/other_user}","gists_url":"https://api.github.com/users/Naigege/gists{/gist_id}","starred_url":"https://api.github.com/users/Naigege/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Naigege/subscriptions","organizations_url":"https://api.github.com/users/Naigege/orgs","repos_url":"https://api.github.com/users/Naigege/repos","events_url":"https://api.github.com/users/Naigege/events{/privacy}","received_events_url":"https://api.github.com/users/Naigege/received_events","type":"User","site_admin":false},"created_at":"2017-04-10T14:42:06Z","updated_at":"2017-04-10T14:42:06Z","body":"@olafveerman I remember we discussed the excel & csv preview is based on the header row. For example, only the first column will be shown on CKAN for excel workbook below: \r\n<img width=\"853\" alt=\"screenshot 2017-04-10 10 34 07\" src=\"https://cloud.githubusercontent.com/assets/6911487/24866937/adb39358-1dd9-11e7-9965-faac1a03ea84.png\">\r\n\r\nCould you help us to check if there is a way to preview the excel & csv files in a good format? @ClaraIV is working on data provider side. She can re-organize the header row to make it not perfect but visualized on platform. Please let us know the best solution. Thanks! "}}
{"actor":{"display_login":"Naigege"}}