DataMine allows you to run custom queries which allows you to easily access and manipulate your raw data. As your write each query, everything is saved dynamically to our servers which allows you to pick up where you left off from any device. Results will be available for up to 7 days after running a query.
Note Queries are unique to each user and not shared across organizations.
To add a query:
To edit a query:
To delete a query:
To download your results:
Note You can select the dropdown next to DOWNLOAD to select to download as either CSV or Excel. Excel exports are limited to one million rows.
Data Mine uses the following CSV format for exporting data from the system.
;are all escaped by
\N(backslash capital n). Any column type can be
|string | int | int||valid||rule||comment|
|Yes.||5||Column data types are correct.|
|Yes.||1||The first column is a string and is allowed to be empty.|
|No.||1||The second column is an int and is not allowed to be empty.|
The second column is an int and is set to |
|Yes.||3||More columns in row than in table is ok.|
Less columns in row than in table is ok. The tailing columns will have the value of |
The second column value |
The comma in the string column is escaped by |
|No||9||Fields can not be quoted.|
|No||5,10||The leading space in column two is not allowed.|
|array | int||valid||rule||comment|
|Yes.||6,1||The array elements are checked for validity. Since the array is a string an empty array element is valid.|
The semicolon is escaped by |
|array | string||valid||rule||comment|
|No.||6,5||Array elements are type enforced as well.|
|No.||6,1||The second element in the array can not be empty because the array is of type int.|
The second element in the array is represented as |