-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathTurtle Transformation Updated.ktr
421 lines (418 loc) · 17.7 KB
/
Turtle Transformation Updated.ktr
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>DataCube Transformation</name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>/</directory>
<parameters>
</parameters>
<log>
<trans-log-table><connection/>
<schema/>
<table/>
<size_limit_lines/>
<interval/>
<timeout_days/>
<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STATUS</id><enabled>Y</enabled><name>STATUS</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name><subject/></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name><subject/></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name><subject/></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name><subject/></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name><subject/></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name><subject/></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>STARTDATE</id><enabled>Y</enabled><name>STARTDATE</name></field><field><id>ENDDATE</id><enabled>Y</enabled><name>ENDDATE</name></field><field><id>LOGDATE</id><enabled>Y</enabled><name>LOGDATE</name></field><field><id>DEPDATE</id><enabled>Y</enabled><name>DEPDATE</name></field><field><id>REPLAYDATE</id><enabled>Y</enabled><name>REPLAYDATE</name></field><field><id>LOG_FIELD</id><enabled>Y</enabled><name>LOG_FIELD</name></field></trans-log-table>
<perf-log-table><connection/>
<schema/>
<table/>
<interval/>
<timeout_days/>
<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>SEQ_NR</id><enabled>Y</enabled><name>SEQ_NR</name></field><field><id>LOGDATE</id><enabled>Y</enabled><name>LOGDATE</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STEPNAME</id><enabled>Y</enabled><name>STEPNAME</name></field><field><id>STEP_COPY</id><enabled>Y</enabled><name>STEP_COPY</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>INPUT_BUFFER_ROWS</id><enabled>Y</enabled><name>INPUT_BUFFER_ROWS</name></field><field><id>OUTPUT_BUFFER_ROWS</id><enabled>Y</enabled><name>OUTPUT_BUFFER_ROWS</name></field></perf-log-table>
<channel-log-table><connection/>
<schema/>
<table/>
<timeout_days/>
<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>LOG_DATE</id><enabled>Y</enabled><name>LOG_DATE</name></field><field><id>LOGGING_OBJECT_TYPE</id><enabled>Y</enabled><name>LOGGING_OBJECT_TYPE</name></field><field><id>OBJECT_NAME</id><enabled>Y</enabled><name>OBJECT_NAME</name></field><field><id>OBJECT_COPY</id><enabled>Y</enabled><name>OBJECT_COPY</name></field><field><id>REPOSITORY_DIRECTORY</id><enabled>Y</enabled><name>REPOSITORY_DIRECTORY</name></field><field><id>FILENAME</id><enabled>Y</enabled><name>FILENAME</name></field><field><id>OBJECT_ID</id><enabled>Y</enabled><name>OBJECT_ID</name></field><field><id>OBJECT_REVISION</id><enabled>Y</enabled><name>OBJECT_REVISION</name></field><field><id>PARENT_CHANNEL_ID</id><enabled>Y</enabled><name>PARENT_CHANNEL_ID</name></field><field><id>ROOT_CHANNEL_ID</id><enabled>Y</enabled><name>ROOT_CHANNEL_ID</name></field></channel-log-table>
<step-log-table><connection/>
<schema/>
<table/>
<timeout_days/>
<field><id>ID_BATCH</id><enabled>Y</enabled><name>ID_BATCH</name></field><field><id>CHANNEL_ID</id><enabled>Y</enabled><name>CHANNEL_ID</name></field><field><id>LOG_DATE</id><enabled>Y</enabled><name>LOG_DATE</name></field><field><id>TRANSNAME</id><enabled>Y</enabled><name>TRANSNAME</name></field><field><id>STEPNAME</id><enabled>Y</enabled><name>STEPNAME</name></field><field><id>STEP_COPY</id><enabled>Y</enabled><name>STEP_COPY</name></field><field><id>LINES_READ</id><enabled>Y</enabled><name>LINES_READ</name></field><field><id>LINES_WRITTEN</id><enabled>Y</enabled><name>LINES_WRITTEN</name></field><field><id>LINES_UPDATED</id><enabled>Y</enabled><name>LINES_UPDATED</name></field><field><id>LINES_INPUT</id><enabled>Y</enabled><name>LINES_INPUT</name></field><field><id>LINES_OUTPUT</id><enabled>Y</enabled><name>LINES_OUTPUT</name></field><field><id>LINES_REJECTED</id><enabled>Y</enabled><name>LINES_REJECTED</name></field><field><id>ERRORS</id><enabled>Y</enabled><name>ERRORS</name></field><field><id>LOG_FIELD</id><enabled>N</enabled><name>LOG_FIELD</name></field></step-log-table>
</log>
<maxdate>
<connection/>
<table/>
<field/>
<offset>0.0</offset>
<maxdiff>0.0</maxdiff>
</maxdate>
<size_rowset>10000</size_rowset>
<sleep_time_empty>50</sleep_time_empty>
<sleep_time_full>50</sleep_time_full>
<unique_connections>N</unique_connections>
<feedback_shown>Y</feedback_shown>
<feedback_size>50000</feedback_size>
<using_thread_priorities>Y</using_thread_priorities>
<shared_objects_file/>
<capture_step_performance>N</capture_step_performance>
<step_performance_capturing_delay>1000</step_performance_capturing_delay>
<step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
<dependencies>
</dependencies>
<partitionschemas>
</partitionschemas>
<slaveservers>
</slaveservers>
<clusterschemas>
</clusterschemas>
<created_user>-</created_user>
<created_date>2016/04/14 13:05:36.554</created_date>
<modified_user>-</modified_user>
<modified_date>2016/04/14 13:05:36.554</modified_date>
</info>
<notepads>
</notepads>
<order>
<hop> <from>CSV file input</from><to>TurtleGenerator</to><enabled>Y</enabled> </hop> <hop> <from>TurtleGenerator</from><to>Text file output</to><enabled>Y</enabled> </hop> </order>
<step>
<name>CSV file input</name>
<type>CsvInput</type>
<description/>
<distribute>Y</distribute>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<filename>C:\Users\Convidado\Desktop\TurtleGenerator_Kettle_Plugin\example.csv</filename>
<filename_field/>
<rownum_field/>
<include_filename>N</include_filename>
<separator>;</separator>
<enclosure>"</enclosure>
<header>Y</header>
<buffer_size>50000</buffer_size>
<lazy_conversion>Y</lazy_conversion>
<add_filename_result>N</add_filename_result>
<parallel>N</parallel>
<encoding/>
<fields>
<field>
<name>Cultura</name>
<type>String</type>
<format/>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>20</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>Ano</name>
<type>Integer</type>
<format>#</format>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>15</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>tipoAgrotoxico</name>
<type>String</type>
<format/>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>17</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>valorAgrotoxico</name>
<type>Number</type>
<format>#.#</format>
<currency>R$</currency>
<decimal>.</decimal>
<group>,</group>
<length>15</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>classeAgrotoxico</name>
<type>String</type>
<format/>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>41</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>areaCultivada</name>
<type>Number</type>
<format>#.#</format>
<currency>R$</currency>
<decimal>.</decimal>
<group>,</group>
<length>15</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>quantidadeColhida</name>
<type>Date</type>
<format>yyyyMMdd</format>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>valorColhido</name>
<type>Number</type>
<format>#.#</format>
<currency>R$</currency>
<decimal>.</decimal>
<group>,</group>
<length>15</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
<field>
<name>quantidadeAgrotoxico</name>
<type>Integer</type>
<format>#</format>
<currency>R$</currency>
<decimal>,</decimal>
<group>.</group>
<length>15</length>
<precision>-1</precision>
<trim_type>none</trim_type>
</field>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>223</xloc>
<yloc>56</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>Text file output</name>
<type>TextFileOutput</type>
<description/>
<distribute>Y</distribute>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<separator/>
<enclosure/>
<enclosure_forced>N</enclosure_forced>
<enclosure_fix_disabled>N</enclosure_fix_disabled>
<header>N</header>
<footer>N</footer>
<format>DOS</format>
<compression>None</compression>
<encoding/>
<endedLine/>
<fileNameInField>N</fileNameInField>
<fileNameField/>
<file>
<name>C:\Users\Convidado\Desktop\TurtleGenerator_Kettle_Plugin\file</name>
<is_command>N</is_command>
<do_not_open_new_file_init>N</do_not_open_new_file_init>
<extention>txt</extention>
<append>N</append>
<split>N</split>
<haspartno>N</haspartno>
<add_date>N</add_date>
<add_time>N</add_time>
<SpecifyFormat>N</SpecifyFormat>
<date_time_format/>
<add_to_result_filenames>Y</add_to_result_filenames>
<pad>N</pad>
<fast_dump>N</fast_dump>
<splitevery>0</splitevery>
</file>
<fields>
</fields>
<cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>647</xloc>
<yloc>53</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>TurtleGenerator</name>
<type>TurtleGeneratorPlugin</type>
<description/>
<distribute>Y</distribute>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<DATA_ROOT_NODE><map>
<entry>
<string>MAP_TABLE</string>
<DataTable>
<Name>MAP_TABLE</Name>
<Header>
<string>MAP_TABLE_DIMENSIONS_FIELD_NAME</string>
<string>MAP_TABLE_LABELS_FIELD_NAME</string>
<string>MAP_TABLE_URI_FIELD_NAME</string>
<string>MAP_TABLE_URI_TYPE_FIELD_NAME</string>
</Header>
<Data>
<Row>
<MAP__TABLE__DIMENSIONS__FIELD__NAME>Ano</MAP__TABLE__DIMENSIONS__FIELD__NAME>
<MAP__TABLE__LABELS__FIELD__NAME>Ano</MAP__TABLE__LABELS__FIELD__NAME>
<MAP__TABLE__URI__FIELD__NAME></MAP__TABLE__URI__FIELD__NAME>
<MAP__TABLE__URI__TYPE__FIELD__NAME>http://www.w3.org/2002/07/owl#Ano</MAP__TABLE__URI__TYPE__FIELD__NAME>
</Row>
<Row>
<MAP__TABLE__DIMENSIONS__FIELD__NAME>Cultura</MAP__TABLE__DIMENSIONS__FIELD__NAME>
<MAP__TABLE__LABELS__FIELD__NAME>Cultura</MAP__TABLE__LABELS__FIELD__NAME>
<MAP__TABLE__URI__FIELD__NAME></MAP__TABLE__URI__FIELD__NAME>
<MAP__TABLE__URI__TYPE__FIELD__NAME>http://aims.fao.org/aos/agrovoc/c_2018</MAP__TABLE__URI__TYPE__FIELD__NAME>
</Row>
<Row>
<MAP__TABLE__DIMENSIONS__FIELD__NAME>classeAgrotoxico</MAP__TABLE__DIMENSIONS__FIELD__NAME>
<MAP__TABLE__LABELS__FIELD__NAME>Classe</MAP__TABLE__LABELS__FIELD__NAME>
<MAP__TABLE__URI__FIELD__NAME></MAP__TABLE__URI__FIELD__NAME>
<MAP__TABLE__URI__TYPE__FIELD__NAME>http://aims.fao.org/aos/agrovoc/c_5739</MAP__TABLE__URI__TYPE__FIELD__NAME>
</Row>
<Row>
<MAP__TABLE__DIMENSIONS__FIELD__NAME>valorAgrotoxico</MAP__TABLE__DIMENSIONS__FIELD__NAME>
<MAP__TABLE__LABELS__FIELD__NAME>Custo Agrotóxico</MAP__TABLE__LABELS__FIELD__NAME>
<MAP__TABLE__URI__FIELD__NAME></MAP__TABLE__URI__FIELD__NAME>
<MAP__TABLE__URI__TYPE__FIELD__NAME>http://dbpedia.org/resource/Real</MAP__TABLE__URI__TYPE__FIELD__NAME>
</Row>
</Data>
</DataTable>
</entry>
<entry>
<string>VERSION</string>
<int>1</int>
</entry>
<entry>
<string>MAP_TABLE2</string>
<DataTable>
<Name>MAP_TABLE2</Name>
<Header>
<string>MAP_TABLE_HIERARCHY_FIELD_NAME</string>
<string>MAP_TABLE_HIERARCHY_DE_FIELD_NAME</string>
<string>MAP_TABLE_HIERARCHY_LABEL_FIELD_NAME</string>
<string>MAP_TABLE_HIERARCHY_PARA_FIELD_NAME</string>
</Header>
<Data>
<Row>
<MAP__TABLE__HIERARCHY__FIELD__NAME></MAP__TABLE__HIERARCHY__FIELD__NAME>
<MAP__TABLE__HIERARCHY__DE__FIELD__NAME></MAP__TABLE__HIERARCHY__DE__FIELD__NAME>
<MAP__TABLE__HIERARCHY__LABEL__FIELD__NAME></MAP__TABLE__HIERARCHY__LABEL__FIELD__NAME>
<MAP__TABLE__HIERARCHY__PARA__FIELD__NAME></MAP__TABLE__HIERARCHY__PARA__FIELD__NAME>
</Row>
</Data>
</DataTable>
</entry>
<entry>
<string>PREFIXES</string>
<list>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@base</string>
<string>http://meu.exemplo/</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix owl:</string>
<string>http://www.w3.org/2002/07/owl#</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix rdf:</string>
<string>http://www.w3.org/1999/02/22-rdf-syntax-ns#</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix rdfs:</string>
<string>http://www.w3.org/2000/01/rdf-schema#</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix dc:</string>
<string>http://purl.org/dc/elements/1.1/</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix skos:</string>
<string>http://www.w3.org/2004/02/skos/core#</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix obo:</string>
<string>http://purl.obolibrary.org/obo#</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix ex:</string>
<string>http://meu.exemplo/</string>
</a>
</java.util.Arrays_-ArrayList>
<java.util.Arrays_-ArrayList>
<a class="string-array">
<string>@prefix exProp:</string>
<string>http://meu.exemplo/properties/</string>
</a>
</java.util.Arrays_-ArrayList>
</list>
</entry>
<entry>
<string>MAP_TABLE1</string>
<DataTable>
<Name>MAP_TABLE1</Name>
<Header>
<string>MAP_TABLE_MEASURE_FIELD_NAME</string>
<string>MAP_TABLE_MEASURE_LABEL_FIELD_NAME</string>
<string>MAP_TABLE_MEASURE_URI_FIELD_NAME</string>
<string>MAP_TABLE_MEASURE_URI_TYPE_FIELD_NAME</string>
</Header>
<Data>
<Row>
<MAP__TABLE__MEASURE__FIELD__NAME></MAP__TABLE__MEASURE__FIELD__NAME>
<MAP__TABLE__MEASURE__LABEL__FIELD__NAME></MAP__TABLE__MEASURE__LABEL__FIELD__NAME>
<MAP__TABLE__MEASURE__URI__FIELD__NAME></MAP__TABLE__MEASURE__URI__FIELD__NAME>
<MAP__TABLE__MEASURE__URI__TYPE__FIELD__NAME></MAP__TABLE__MEASURE__URI__TYPE__FIELD__NAME>
</Row>
</Data>
</DataTable>
</entry>
<entry>
<string>OUTPUT_UNITY_FIELD_NAME</string>
<string>Consumo de agrotóxicos por lavoura e ano no Brasil</string>
</entry>
</map></DATA_ROOT_NODE> <cluster_schema/>
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
<xloc>411</xloc>
<yloc>68</yloc>
<draw>Y</draw>
</GUI>
</step>
<step_error_handling>
</step_error_handling>
<slave-step-copy-partition-distribution>
</slave-step-copy-partition-distribution>
<slave_transformation>N</slave_transformation>
</transformation>