1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
.create table MachinesTable ingestion csv mapping 'MachinesMapping'
```[
{"column":"GUID", "datatype":"string", "ordinal":0},
{"column":"LAST_UPDATED", "datatype":"datetime", "ordinal":1},
{"column":"SERIAL_NUMBER", "datatype":"string", "ordinal":2},
{"column":"NAME", "datatype":"string", "ordinal":3},
{"column":"PRODUCTION_DATE", "datatype":"datetime", "ordinal":4},
{"column":"ORGANIZATION_GUID", "datatype":"string", "ordinal":5},
{"column":"SITE_GUID", "datatype":"string", "ordinal":6},
{"column":"MACHINE_VERSION_GUID", "datatype":"string", "ordinal":7},
{"column":"CONFIGURATION_GUID", "datatype":"string", "ordinal":8},
{"column":"DEFAULT_RML_GUID", "datatype":"string", "ordinal":9},
{"column":"LOADED_RML_GUID", "datatype":"string", "ordinal":10},
{"column":"TARGET_JOB_TYPES", "datatype":"string", "ordinal":11},
{"column":"TARGET_COLOR_SPACE_CODES", "datatype":"string", "ordinal":12},
{"column":"DEFAULT_COLOR_SPACE_GUID", "datatype":"string", "ordinal":13},
{"column":"DEFAULT_SEGMENT_LENGTH", "datatype":"real", "ordinal":14},
{"column":"DEFAULT_SPOOL_TYPE_GUID", "datatype":"string", "ordinal":15},
{"column":"OS_KEY", "datatype":"string", "ordinal":16},
{"column":"AUTO_LOGIN", "datatype":"bool", "ordinal":17},
{"column":"AUTO_CHECK_FOR_UPDATES", "datatype":"bool", "ordinal":18},
{"column":"SETUP_ACTIVATION", "datatype":"bool", "ordinal":19},
{"column":"SETUP_REMOTE_ASSISTANCE", "datatype":"bool", "ordinal":20},
{"column":"SETUP_UWF", "datatype":"bool", "ordinal":21},
{"column":"SETUP_FIRMWARE", "datatype":"bool", "ordinal":22},
{"column":"SETUP_FPGA", "datatype":"bool", "ordinal":23},
{"column":"IS_DEMO", "datatype":"bool", "ordinal":24},
{"column":"SUSPEND_VERSION_UPDATE", "datatype":"bool", "ordinal":25},
{"column":"FORCE_VERSION_UPDATE", "datatype":"bool", "ordinal":26},
{"column":"PERFORM_SCHEMA_UPDATE_ON_DATA_UPDATE", "datatype":"bool", "ordinal":27},
{"column":"DEVICE_COM_PORT", "datatype":"string", "ordinal":28},
{"column":"IS_DEVICE_REGISTERED", "datatype":"bool", "ordinal":29},
{"column":"DEVICE_ID", "datatype":"string", "ordinal":30},
{"column":"DEVICE_NAME", "datatype":"string", "ordinal":31},
{"column":"HEAD_TYPE", "datatype":"int", "ordinal":32},
{"column":"ACTIVATION_KEY", "datatype":"string", "ordinal":33},
{"column":"LIGHT_INKS_INSTALLED", "datatype":"bool", "ordinal":34},
{"column":"BTSR_INSTALLED", "datatype":"bool", "ordinal":35},
{"column":"VERSION_TAG", "datatype":"string", "ordinal":36},
{"column":"MACHINE_TYPE", "datatype":"int", "ordinal":37},
{"column":"ALLOW_SMS_NOTIFICATIONS", "datatype":"bool", "ordinal":38},
{"column":"ENVIRONMENT", "datatype":"string", "ordinal":39}
]```
|
