{"action":"closed","issue":{"url":"https://api.github.com/repos/HabitatFramework/HLUTool/issues/37","labels_url":"https://api.github.com/repos/HabitatFramework/HLUTool/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/HabitatFramework/HLUTool/issues/37/comments","events_url":"https://api.github.com/repos/HabitatFramework/HLUTool/issues/37/events","html_url":"https://github.com/HabitatFramework/HLUTool/issues/37","id":14306472,"number":37,"title":"CR17 (Exporting date fields)","user":{"login":"AndyFoy","id":2052242,"avatar_url":"https://avatars.githubusercontent.com/u/2052242?v=3","gravatar_id":"","url":"https://api.github.com/users/AndyFoy","html_url":"https://github.com/AndyFoy","followers_url":"https://api.github.com/users/AndyFoy/followers","following_url":"https://api.github.com/users/AndyFoy/following{/other_user}","gists_url":"https://api.github.com/users/AndyFoy/gists{/gist_id}","starred_url":"https://api.github.com/users/AndyFoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AndyFoy/subscriptions","organizations_url":"https://api.github.com/users/AndyFoy/orgs","repos_url":"https://api.github.com/users/AndyFoy/repos","events_url":"https://api.github.com/users/AndyFoy/events{/privacy}","received_events_url":"https://api.github.com/users/AndyFoy/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HabitatFramework/HLUTool/labels/Change+Request","name":"Change Request","color":"eb6420"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/HabitatFramework/HLUTool/milestones/17","labels_url":"https://api.github.com/repos/HabitatFramework/HLUTool/milestones/17/labels","id":811473,"number":17,"title":"Batch 3 Portion C","description":"","creator":{"login":"AndyFoy","id":2052242,"avatar_url":"https://avatars.githubusercontent.com/u/2052242?v=3","gravatar_id":"","url":"https://api.github.com/users/AndyFoy","html_url":"https://github.com/AndyFoy","followers_url":"https://api.github.com/users/AndyFoy/followers","following_url":"https://api.github.com/users/AndyFoy/following{/other_user}","gists_url":"https://api.github.com/users/AndyFoy/gists{/gist_id}","starred_url":"https://api.github.com/users/AndyFoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AndyFoy/subscriptions","organizations_url":"https://api.github.com/users/AndyFoy/orgs","repos_url":"https://api.github.com/users/AndyFoy/repos","events_url":"https://api.github.com/users/AndyFoy/events{/privacy}","received_events_url":"https://api.github.com/users/AndyFoy/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":5,"state":"open","created_at":"2014-10-02T14:26:44Z","updated_at":"2015-01-21T13:38:40Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2013-05-14T12:06:43Z","updated_at":"2015-01-21T13:38:40Z","closed_at":"2015-01-21T13:38:40Z","body":"##### Description #####\r\nNatural England’s Memorandum of Agreement (MoA) for LRCs states that updates to the national habitat inventories must be supplied in a fixed format where some fields are mandatory and some are optional. One of the mandatory fields relates to the date of each of the sources (e.g. S1captdate).  This field is a Date field in the format ‘dd/mm/yyyy’.\r\n\r\nSource dates can currently only be exported by the tool as the three separate component fields (date_start, date_end, date_type). Therefore if a user needs to present the dates in a different format they must amend the GIS layer manually following the export to add the new date field and then calculate the field value.\r\n\r\n##### Proposed Solution #####\r\nEnable all source dates to be exported in vague date format, either by providing new options in the export_fields table for each date field or by providing an option for all source date fields on the export form.\r\n\r\nGive the user the choice of:\r\ni. which date(s) they wish to use in the export (e.g. start date, end date or date range)\r\nii. which date format to use (e.g. based on the date_type value or by overriding with a fixed date format such as ‘dd/mm/yyyy’)\r\n\r\nThis functionality will provide full flexibility to users and will enable them to export dates in any format including in Natural England’s specific date format.\r\n\r\nIf necessary, and possible, include a SQL script with the installation setup.exe program that automatically amends any database table (where changes are required) within the database selected by the user when prompted by the script (e.g. in a similar manner to how the tool installation process prompts the user for the database when configuring the tool)."}}