docs.datacontroller.io/docs/dcu-fileupload.md

# Data Controller for SAS: File Uploads

Files can be uploaded via the Editor interface - first choose the library and table, then click "Upload".  Currently only CSV files are supported, although these can be provided with non standard delimiters (such as semicolon).

<img src="/img/dcu-files1.png" height="350" style="border:3px solid black" >

The following should be considered when uploading data in this way:

 - A header row (with variable names) is required
 - Variable names must match the target (not case sensitive).  An easy way to ensure this is to download the data from Viewer and use this as a template.
 - Duplicate variable names are not permitted
 - Missing columns are not permitted
 - Additional columns are ignored
 - The order of variables does not matter
 - The delimiter is extracted from the header row - so for `var1;var2;var3` the delimeter would be assumed to be a semicolon
 - The above assumes the delimiter is the first special character! So `var,1;var2;var3` would fail
 - The following characters should not be used as delimiters
    - doublequote
    - quote
    - space
    - underscore

When loading dates, be aware that the data controller makes use of the `ANYDTDTE` and `ANYDTDTTME` informats.
This means that uploaded date / datetime values should be unambiguous (eg `01FEB1942` vs `01/02/42`) to avoid confusion - as the latter could be interpreted as `02JAN2042` depending on your locale and options `YEARCUTOFF` settings.

!!! tip
    To get a copy of a file in the right format for upload, use the [file download](/dc-userguide/#usage) feature in the Viewer tab
file upload docs 2018-09-28 12:12:32 +00:00			`# Data Controller for SAS: File Uploads`

adding use case diagram and bitemporal section to userguide 2018-10-19 19:14:31 +00:00			`Files can be uploaded via the Editor interface - first choose the library and table, then click "Upload". Currently only CSV files are supported, although these can be provided with non standard delimiters (such as semicolon).`
file upload docs 2018-09-28 12:12:32 +00:00
improved guide for file uploads 2018-09-28 12:24:32 +00:00			`<img src="/img/dcu-files1.png" height="350" style="border:3px solid black" >`
file upload docs 2018-09-28 12:12:32 +00:00
			`The following should be considered when uploading data in this way:`

			`- A header row (with variable names) is required`
adding use case diagram and bitemporal section to userguide 2018-10-19 19:14:31 +00:00			`- Variable names must match the target (not case sensitive). An easy way to ensure this is to download the data from Viewer and use this as a template.`
file upload docs 2018-09-28 12:12:32 +00:00			`- Duplicate variable names are not permitted`
			`- Missing columns are not permitted`
			`- Additional columns are ignored`
			`- The order of variables does not matter`
adding use case diagram and bitemporal section to userguide 2018-10-19 19:14:31 +00:00			- The delimiter is extracted from the header row - so for `var1;var2;var3` the delimeter would be assumed to be a semicolon
			- The above assumes the delimiter is the first special character! So `var,1;var2;var3` would fail
			`- The following characters should not be used as delimiters`
			`- doublequote`
			`- quote`
			`- space`
			`- underscore`
file upload docs 2018-09-28 12:12:32 +00:00
			When loading dates, be aware that the data controller makes use of the `ANYDTDTE` and `ANYDTDTTME` informats.
			This means that uploaded date / datetime values should be unambiguous (eg `01FEB1942` vs `01/02/42`) to avoid confusion - as the latter could be interpreted as `02JAN2042` depending on your locale and options `YEARCUTOFF` settings.
improved guide for file uploads 2018-09-28 12:24:32 +00:00
			`!!! tip`
			`To get a copy of a file in the right format for upload, use the [file download](/dc-userguide/#usage) feature in the Viewer tab`