/database/metadata_dev/layer_index_link_analysis.ktr

http://alageospatialportal.googlecode.com/ · Unknown · 792 lines · 773 code · 19 blank · 0 comment · 0 complexity · 50c67ca82bdf28d6b7b58d0b85eb981d MD5 · raw file 

    

  1. <?xml version="1.0" encoding="UTF-8"?>

    2. 

  2. <transformation>

    3. 

  3.   <info>

    4. 

  4.     <name>layer_index_link_analysis</name>

    5. 

  5.     <description/>

    6. 

  6.     <extended_description/>

    7. 

  7.     <trans_version/>

    8. 

  8.     <trans_type>Normal</trans_type>

    9. 

  9.     <directory>&#47;</directory>

    10. 

  10.     <parameters>

    11. 

  11.     </parameters>

    12. 

  12.     <log>

    13. 

  13. <trans-log-table><connection/>

    14. 

  14. <schema/>

    15. 

  15. <table/>

    16. 

  16. <size_limit_lines/>

    17. 

  17. <interval/>

    18. 

  18. <timeout_days/>

    19. 

  19. <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>

    20. 

  20. <perf-log-table><connection/>

    21. 

  21. <schema/>

    22. 

  22. <table/>

    23. 

  23. <interval/>

    24. 

  24. <timeout_days/>

    25. 

  25. <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>

    26. 

  26. <channel-log-table><connection/>

    27. 

  27. <schema/>

    28. 

  28. <table/>

    29. 

  29. <timeout_days/>

    30. 

  30. <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>

    31. 

  31. <step-log-table><connection/>

    32. 

  32. <schema/>

    33. 

  33. <table/>

    34. 

  34. <timeout_days/>

    35. 

  35. <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>

    36. 

  36.     </log>

    37. 

  37.     <maxdate>

    38. 

  38.       <connection/>

    39. 

  39.       <table/>

    40. 

  40.       <field/>

    41. 

  41.       <offset>0.0</offset>

    42. 

  42.       <maxdiff>0.0</maxdiff>

    43. 

  43.     </maxdate>

    44. 

  44.     <size_rowset>10000</size_rowset>

    45. 

  45.     <sleep_time_empty>50</sleep_time_empty>

    46. 

  46.     <sleep_time_full>50</sleep_time_full>

    47. 

  47.     <unique_connections>N</unique_connections>

    48. 

  48.     <feedback_shown>Y</feedback_shown>

    49. 

  49.     <feedback_size>50000</feedback_size>

    50. 

  50.     <using_thread_priorities>Y</using_thread_priorities>

    51. 

  51.     <shared_objects_file/>

    52. 

  52.     <capture_step_performance>N</capture_step_performance>

    53. 

  53.     <step_performance_capturing_delay>1000</step_performance_capturing_delay>

    54. 

  54.     <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>

    55. 

  55.     <dependencies>

    56. 

  56.     </dependencies>

    57. 

  57.     <partitionschemas>

    58. 

  58.     </partitionschemas>

    59. 

  59.     <slaveservers>

    60. 

  60.     </slaveservers>

    61. 

  61.     <clusterschemas>

    62. 

  62.     </clusterschemas>

    63. 

  63.   <created_user>-</created_user>

    64. 

  64.   <created_date>2011&#47;07&#47;29 11:22:48.970</created_date>

    65. 

  65.   <modified_user>-</modified_user>

    66. 

  66.   <modified_date>2011&#47;07&#47;29 11:22:48.970</modified_date>

    67. 

  67.   </info>

    68. 

  68.   <notepads>

    69. 

  69.   </notepads>

    70. 

  70.   <connection>

    71. 

  71.     <name>ALA_DA_9</name>

    72. 

  72.     <server>127.0.0.1</server>

    73. 

  73.     <type>POSTGRESQL</type>

    74. 

  74.     <access>Native</access>

    75. 

  75.     <database>ala_da</database>

    76. 

  76.     <port>15432</port>

    77. 

  77.     <username>postgres</username>

    78. 

  78.     <password>Encrypted 2be98afc86ad7c297bf1ebc75cdad9cfb</password>

    79. 

  79.     <servername/>

    80. 

  80.     <data_tablespace/>

    81. 

  81.     <index_tablespace/>

    82. 

  82.     <attributes>

    83. 

  83.       <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>

    84. 

  84.       <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>

    85. 

  85.       <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>

    86. 

  86.       <attribute><code>PORT_NUMBER</code><attribute>15432</attribute></attribute>

    87. 

  87.       <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>

    88. 

  88.       <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>

    89. 

  89.       <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>

    90. 

  90.     </attributes>

    91. 

  91.   </connection>

    92. 

  92.   <order>

    93. 

  93.   <hop> <from>Table input</from><to>Sort licence_link</to><enabled>Y</enabled> </hop>  <hop> <from>Table input</from><to>Sort metadatapath</to><enabled>Y</enabled> </hop>  <hop> <from>Table input</from><to>Sort source_link</to><enabled>Y</enabled> </hop>  <hop> <from>Filter licence_link</from><to>drop blank licence_link</to><enabled>Y</enabled> </hop>  <hop> <from>Sort licence_link</from><to>Filter licence_link</to><enabled>Y</enabled> </hop>  <hop> <from>Select id + ll</from><to>Group by licence_link</to><enabled>Y</enabled> </hop>  <hop> <from>Filter licence_link</from><to>Select id + ll</to><enabled>Y</enabled> </hop>  <hop> <from>Group by licence_link</from><to>XML licence_link</to><enabled>Y</enabled> </hop>  <hop> <from>Filter mdp</from><to>drop blank mdp</to><enabled>Y</enabled> </hop>  <hop> <from>Filter mdp</from><to>Select id + mdp</to><enabled>Y</enabled> </hop>  <hop> <from>Select id + mdp</from><to>Group by mdp</to><enabled>Y</enabled> </hop>  <hop> <from>Group by mdp</from><to>XML mdp</to><enabled>Y</enabled> </hop>  <hop> <from>Sort metadatapath</from><to>Filter mdp</to><enabled>Y</enabled> </hop>  <hop> <from>Filter sl</from><to>drop blank sl</to><enabled>Y</enabled> </hop>  <hop> <from>Filter sl</from><to>Select id + sl</to><enabled>Y</enabled> </hop>  <hop> <from>Select id + sl</from><to>Group by sl</to><enabled>Y</enabled> </hop>  <hop> <from>Group by sl</from><to>XML sl</to><enabled>Y</enabled> </hop>  <hop> <from>Sort source_link</from><to>Filter sl</to><enabled>Y</enabled> </hop>  </order>

    94. 

  94.   <step>

    95. 

  95.     <name>Table input</name>

    96. 

  96.     <type>TableInput</type>

    97. 

  97.     <description/>

    98. 

  98.     <distribute>N</distribute>

    99. 

  99.     <copies>1</copies>

    100. 

  100.          <partitioning>

    101. 

  101.            <method>none</method>

    102. 

  102.            <schema_name/>

    103. 

  103.            </partitioning>

    104. 

  104.     <connection>ALA_DA_9</connection>

    105. 

  105.     <sql>SELECT

    106. 

  106.   id

    107. 

  107. , &quot;name&quot;

    108. 

  108. , description

    109. 

  109. , &quot;type&quot;

    110. 

  110. , &quot;source&quot;

    111. 

  111. , &quot;path&quot;

    112. 

  112. , extents

    113. 

  113. , minlatitude

    114. 

  114. , minlongitude

    115. 

  115. , maxlatitude

    116. 

  116. , maxlongitude

    117. 

  117. , notes

    118. 

  118. , enabled

    119. 

  119. , displayname

    120. 

  120. , displaypath

    121. 

  121. , &quot;scale&quot;

    122. 

  122. , environmentalvaluemin

    123. 

  123. , environmentalvaluemax

    124. 

  124. , environmentalvalueunits

    125. 

  125. , lookuptablepath

    126. 

  126. , metadatapath

    127. 

  127. , classification1

    128. 

  128. , classification2

    129. 

  129. , uid

    130. 

  130. , mddatest

    131. 

  131. , citation_date

    132. 

  132. , datalang

    133. 

  133. , mdhrlv

    134. 

  134. , respparty_role

    135. 

  135. , licence_level

    136. 

  136. , licence_link

    137. 

  137. , licence_notes

    138. 

  138. , source_link

    139. 

  139. FROM &quot;public&quot;.vwsp_layers_live

    140. 

  140. </sql>

    141. 

  141.     <limit>0</limit>

    142. 

  142.     <lookup/>

    143. 

  143.     <execute_each_row>N</execute_each_row>

    144. 

  144.     <variables_active>N</variables_active>

    145. 

  145.     <lazy_conversion_active>N</lazy_conversion_active>

    146. 

  146.      <cluster_schema/>

    147. 

  147.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    148. 

  148.       <xloc>41</xloc>

    149. 

  149.       <yloc>130</yloc>

    150. 

  150.       <draw>Y</draw>

    151. 

  151.       </GUI>

    152. 

  152.     </step>

    153. 

  153. 

    154. 

  154.   <step>

    155. 

  155.     <name>Sort licence_link</name>

    156. 

  156.     <type>SortRows</type>

    157. 

  157.     <description/>

    158. 

  158.     <distribute>N</distribute>

    159. 

  159.     <copies>1</copies>

    160. 

  160.          <partitioning>

    161. 

  161.            <method>none</method>

    162. 

  162.            <schema_name/>

    163. 

  163.            </partitioning>

    164. 

  164.       <directory>%%java.io.tmpdir%%</directory>

    165. 

  165.       <prefix>out</prefix>

    166. 

  166.       <sort_size>1000000</sort_size>

    167. 

  167.       <free_memory/>

    168. 

  168.       <compress>N</compress>

    169. 

  169.       <compress_variable/>

    170. 

  170.       <unique_rows>N</unique_rows>

    171. 

  171.     <fields>

    172. 

  172.       <field>

    173. 

  173.         <name>licence_link</name>

    174. 

  174.         <ascending>Y</ascending>

    175. 

  175.         <case_sensitive>N</case_sensitive>

    176. 

  176.       </field>

    177. 

  177.       <field>

    178. 

  178.         <name>id</name>

    179. 

  179.         <ascending>N</ascending>

    180. 

  180.         <case_sensitive>N</case_sensitive>

    181. 

  181.       </field>

    182. 

  182.     </fields>

    183. 

  183.      <cluster_schema/>

    184. 

  184.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    185. 

  185.       <xloc>201</xloc>

    186. 

  186.       <yloc>50</yloc>

    187. 

  187.       <draw>Y</draw>

    188. 

  188.       </GUI>

    189. 

  189.     </step>

    190. 

  190. 

    191. 

  191.   <step>

    192. 

  192.     <name>Sort metadatapath</name>

    193. 

  193.     <type>SortRows</type>

    194. 

  194.     <description/>

    195. 

  195.     <distribute>Y</distribute>

    196. 

  196.     <copies>1</copies>

    197. 

  197.          <partitioning>

    198. 

  198.            <method>none</method>

    199. 

  199.            <schema_name/>

    200. 

  200.            </partitioning>

    201. 

  201.       <directory>%%java.io.tmpdir%%</directory>

    202. 

  202.       <prefix>out</prefix>

    203. 

  203.       <sort_size>1000000</sort_size>

    204. 

  204.       <free_memory/>

    205. 

  205.       <compress>N</compress>

    206. 

  206.       <compress_variable/>

    207. 

  207.       <unique_rows>N</unique_rows>

    208. 

  208.     <fields>

    209. 

  209.       <field>

    210. 

  210.         <name>metadatapath</name>

    211. 

  211.         <ascending>Y</ascending>

    212. 

  212.         <case_sensitive>N</case_sensitive>

    213. 

  213.       </field>

    214. 

  214.       <field>

    215. 

  215.         <name>id</name>

    216. 

  216.         <ascending>N</ascending>

    217. 

  217.         <case_sensitive>N</case_sensitive>

    218. 

  218.       </field>

    219. 

  219.     </fields>

    220. 

  220.      <cluster_schema/>

    221. 

  221.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    222. 

  222.       <xloc>201</xloc>

    223. 

  223.       <yloc>164</yloc>

    224. 

  224.       <draw>Y</draw>

    225. 

  225.       </GUI>

    226. 

  226.     </step>

    227. 

  227. 

    228. 

  228.   <step>

    229. 

  229.     <name>Sort source_link</name>

    230. 

  230.     <type>SortRows</type>

    231. 

  231.     <description/>

    232. 

  232.     <distribute>Y</distribute>

    233. 

  233.     <copies>1</copies>

    234. 

  234.          <partitioning>

    235. 

  235.            <method>none</method>

    236. 

  236.            <schema_name/>

    237. 

  237.            </partitioning>

    238. 

  238.       <directory>%%java.io.tmpdir%%</directory>

    239. 

  239.       <prefix>out</prefix>

    240. 

  240.       <sort_size>1000000</sort_size>

    241. 

  241.       <free_memory/>

    242. 

  242.       <compress>N</compress>

    243. 

  243.       <compress_variable/>

    244. 

  244.       <unique_rows>N</unique_rows>

    245. 

  245.     <fields>

    246. 

  246.       <field>

    247. 

  247.         <name>source_link</name>

    248. 

  248.         <ascending>Y</ascending>

    249. 

  249.         <case_sensitive>N</case_sensitive>

    250. 

  250.       </field>

    251. 

  251.       <field>

    252. 

  252.         <name>id</name>

    253. 

  253.         <ascending>N</ascending>

    254. 

  254.         <case_sensitive>N</case_sensitive>

    255. 

  255.       </field>

    256. 

  256.     </fields>

    257. 

  257.      <cluster_schema/>

    258. 

  258.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    259. 

  259.       <xloc>190</xloc>

    260. 

  260.       <yloc>265</yloc>

    261. 

  261.       <draw>Y</draw>

    262. 

  262.       </GUI>

    263. 

  263.     </step>

    264. 

  264. 

    265. 

  265.   <step>

    266. 

  266.     <name>XML licence_link</name>

    267. 

  267.     <type>XMLOutput</type>

    268. 

  268.     <description/>

    269. 

  269.     <distribute>Y</distribute>

    270. 

  270.     <copies>1</copies>

    271. 

  271.          <partitioning>

    272. 

  272.            <method>none</method>

    273. 

  273.            <schema_name/>

    274. 

  274.            </partitioning>

    275. 

  275.     <encoding>UTF-8</encoding>

    276. 

  276.     <name_space/>

    277. 

  277.     <xml_main_element>Rows</xml_main_element>

    278. 

  278.     <xml_repeat_element>Row</xml_repeat_element>

    279. 

  279.     <file>

    280. 

  280.       <name>C:\Bryn\ala\spatial portal\layer_index_links_licence</name>

    281. 

  281.       <extention>xml</extention>

    282. 

  282.       <do_not_open_newfile_init>N</do_not_open_newfile_init>

    283. 

  283.       <split>N</split>

    284. 

  284.       <add_date>N</add_date>

    285. 

  285.       <add_time>N</add_time>

    286. 

  286.       <SpecifyFormat>Y</SpecifyFormat>

    287. 

  287.       <omit_null_values>N</omit_null_values>

    288. 

  288.       <date_time_format>.yyyyMMdd</date_time_format>

    289. 

  289.       <add_to_result_filenames>N</add_to_result_filenames>

    290. 

  290.       <zipped>N</zipped>

    291. 

  291.       <splitevery>0</splitevery>

    292. 

  292.     </file>

    293. 

  293.     <fields>

    294. 

  294.       <field>

    295. 

  295.         <name>licence_link</name>

    296. 

  296.         <element/>

    297. 

  297.         <type>String</type>

    298. 

  298.         <format/>

    299. 

  299.         <currency/>

    300. 

  300.         <decimal/>

    301. 

  301.         <group/>

    302. 

  302.         <nullif/>

    303. 

  303.         <length>-1</length>

    304. 

  304.         <precision>-1</precision>

    305. 

  305.       </field>

    306. 

  306.       <field>

    307. 

  307.         <name>ids</name>

    308. 

  308.         <element/>

    309. 

  309.         <type>String</type>

    310. 

  310.         <format/>

    311. 

  311.         <currency/>

    312. 

  312.         <decimal/>

    313. 

  313.         <group/>

    314. 

  314.         <nullif/>

    315. 

  315.         <length>-1</length>

    316. 

  316.         <precision>-1</precision>

    317. 

  317.       </field>

    318. 

  318.     </fields>

    319. 

  319.      <cluster_schema/>

    320. 

  320.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    321. 

  321.       <xloc>701</xloc>

    322. 

  322.       <yloc>70</yloc>

    323. 

  323.       <draw>Y</draw>

    324. 

  324.       </GUI>

    325. 

  325.     </step>

    326. 

  326. 

    327. 

  327.   <step>

    328. 

  328.     <name>Filter licence_link</name>

    329. 

  329.     <type>FilterRows</type>

    330. 

  330.     <description/>

    331. 

  331.     <distribute>Y</distribute>

    332. 

  332.     <copies>1</copies>

    333. 

  333.          <partitioning>

    334. 

  334.            <method>none</method>

    335. 

  335.            <schema_name/>

    336. 

  336.            </partitioning>

    337. 

  337. <send_true_to>Select id + ll</send_true_to>

    338. 

  338. <send_false_to>drop blank licence_link</send_false_to>

    339. 

  339.     <compare>

    340. 

  340. <condition>

    341. 

  341.  <negated>N</negated>

    342. 

  342.  <leftvalue>licence_link</leftvalue>

    343. 

  343.  <function>&lt;&gt;</function>

    344. 

  344.  <rightvalue/>

    345. 

  345.  <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition>

    346. 

  346.     </compare>

    347. 

  347.      <cluster_schema/>

    348. 

  348.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    349. 

  349.       <xloc>321</xloc>

    350. 

  350.       <yloc>50</yloc>

    351. 

  351.       <draw>Y</draw>

    352. 

  352.       </GUI>

    353. 

  353.     </step>

    354. 

  354. 

    355. 

  355.   <step>

    356. 

  356.     <name>drop blank licence_link</name>

    357. 

  357.     <type>Dummy</type>

    358. 

  358.     <description/>

    359. 

  359.     <distribute>Y</distribute>

    360. 

  360.     <copies>1</copies>

    361. 

  361.          <partitioning>

    362. 

  362.            <method>none</method>

    363. 

  363.            <schema_name/>

    364. 

  364.            </partitioning>

    365. 

  365.      <cluster_schema/>

    366. 

  366.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    367. 

  367.       <xloc>512</xloc>

    368. 

  368.       <yloc>18</yloc>

    369. 

  369.       <draw>Y</draw>

    370. 

  370.       </GUI>

    371. 

  371.     </step>

    372. 

  372. 

    373. 

  373.   <step>

    374. 

  374.     <name>Select id + ll</name>

    375. 

  375.     <type>SelectValues</type>

    376. 

  376.     <description/>

    377. 

  377.     <distribute>N</distribute>

    378. 

  378.     <copies>1</copies>

    379. 

  379.          <partitioning>

    380. 

  380.            <method>none</method>

    381. 

  381.            <schema_name/>

    382. 

  382.            </partitioning>

    383. 

  383.     <fields>      <field>        <name>id</name>

    384. 

  384.         <rename/>

    385. 

  385.         <length>-2</length>

    386. 

  386.         <precision>-2</precision>

    387. 

  387.       </field>      <field>        <name>licence_link</name>

    388. 

  388.         <rename/>

    389. 

  389.         <length>-2</length>

    390. 

  390.         <precision>-2</precision>

    391. 

  391.       </field>        <select_unspecified>N</select_unspecified>

    392. 

  392.     </fields>     <cluster_schema/>

    393. 

  393.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    394. 

  394.       <xloc>441</xloc>

    395. 

  395.       <yloc>70</yloc>

    396. 

  396.       <draw>Y</draw>

    397. 

  397.       </GUI>

    398. 

  398.     </step>

    399. 

  399. 

    400. 

  400.   <step>

    401. 

  401.     <name>Group by licence_link</name>

    402. 

  402.     <type>GroupBy</type>

    403. 

  403.     <description/>

    404. 

  404.     <distribute>Y</distribute>

    405. 

  405.     <copies>1</copies>

    406. 

  406.          <partitioning>

    407. 

  407.            <method>none</method>

    408. 

  408.            <schema_name/>

    409. 

  409.            </partitioning>

    410. 

  410.       <all_rows>N</all_rows>

    411. 

  411.       <ignore_aggregate>N</ignore_aggregate>

    412. 

  412.       <field_ignore/>

    413. 

  413.       <directory>%%java.io.tmpdir%%</directory>

    414. 

  414.       <prefix>grp</prefix>

    415. 

  415.       <add_linenr>N</add_linenr>

    416. 

  416.       <linenr_fieldname/>

    417. 

  417.       <give_back_row>N</give_back_row>

    418. 

  418.       <group>

    419. 

  419.         <field>

    420. 

  420.           <name>licence_link</name>

    421. 

  421.         </field>

    422. 

  422.       </group>

    423. 

  423.       <fields>

    424. 

  424.         <field>

    425. 

  425.           <aggregate>ids</aggregate>

    426. 

  426.           <subject>id</subject>

    427. 

  427.           <type>CONCAT_STRING</type>

    428. 

  428.           <valuefield>,</valuefield>

    429. 

  429.         </field>

    430. 

  430.       </fields>

    431. 

  431.      <cluster_schema/>

    432. 

  432.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    433. 

  433.       <xloc>561</xloc>

    434. 

  434.       <yloc>70</yloc>

    435. 

  435.       <draw>Y</draw>

    436. 

  436.       </GUI>

    437. 

  437.     </step>

    438. 

  438. 

    439. 

  439.   <step>

    440. 

  440.     <name>XML mdp</name>

    441. 

  441.     <type>XMLOutput</type>

    442. 

  442.     <description/>

    443. 

  443.     <distribute>Y</distribute>

    444. 

  444.     <copies>1</copies>

    445. 

  445.          <partitioning>

    446. 

  446.            <method>none</method>

    447. 

  447.            <schema_name/>

    448. 

  448.            </partitioning>

    449. 

  449.     <encoding>UTF-8</encoding>

    450. 

  450.     <name_space/>

    451. 

  451.     <xml_main_element>Rows</xml_main_element>

    452. 

  452.     <xml_repeat_element>Row</xml_repeat_element>

    453. 

  453.     <file>

    454. 

  454.       <name>C:\Bryn\ala\spatial portal\layer_index_links_mdpath</name>

    455. 

  455.       <extention>xml</extention>

    456. 

  456.       <do_not_open_newfile_init>N</do_not_open_newfile_init>

    457. 

  457.       <split>N</split>

    458. 

  458.       <add_date>N</add_date>

    459. 

  459.       <add_time>N</add_time>

    460. 

  460.       <SpecifyFormat>Y</SpecifyFormat>

    461. 

  461.       <omit_null_values>N</omit_null_values>

    462. 

  462.       <date_time_format>.yyyyMMdd</date_time_format>

    463. 

  463.       <add_to_result_filenames>N</add_to_result_filenames>

    464. 

  464.       <zipped>N</zipped>

    465. 

  465.       <splitevery>0</splitevery>

    466. 

  466.     </file>

    467. 

  467.     <fields>

    468. 

  468.       <field>

    469. 

  469.         <name>metadatapath</name>

    470. 

  470.         <element/>

    471. 

  471.         <type>String</type>

    472. 

  472.         <format/>

    473. 

  473.         <currency/>

    474. 

  474.         <decimal/>

    475. 

  475.         <group/>

    476. 

  476.         <nullif/>

    477. 

  477.         <length>-1</length>

    478. 

  478.         <precision>-1</precision>

    479. 

  479.       </field>

    480. 

  480.       <field>

    481. 

  481.         <name>ids</name>

    482. 

  482.         <element/>

    483. 

  483.         <type>String</type>

    484. 

  484.         <format/>

    485. 

  485.         <currency/>

    486. 

  486.         <decimal/>

    487. 

  487.         <group/>

    488. 

  488.         <nullif/>

    489. 

  489.         <length>-1</length>

    490. 

  490.         <precision>-1</precision>

    491. 

  491.       </field>

    492. 

  492.     </fields>

    493. 

  493.      <cluster_schema/>

    494. 

  494.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    495. 

  495.       <xloc>703</xloc>

    496. 

  496.       <yloc>190</yloc>

    497. 

  497.       <draw>Y</draw>

    498. 

  498.       </GUI>

    499. 

  499.     </step>

    500. 

  500. 

    501. 

  501.   <step>

    502. 

  502.     <name>Filter mdp</name>

    503. 

  503.     <type>FilterRows</type>

    504. 

  504.     <description/>

    505. 

  505.     <distribute>Y</distribute>

    506. 

  506.     <copies>1</copies>

    507. 

  507.          <partitioning>

    508. 

  508.            <method>none</method>

    509. 

  509.            <schema_name/>

    510. 

  510.            </partitioning>

    511. 

  511. <send_true_to>Select id + mdp</send_true_to>

    512. 

  512. <send_false_to>drop blank mdp</send_false_to>

    513. 

  513.     <compare>

    514. 

  514. <condition>

    515. 

  515.  <negated>N</negated>

    516. 

  516.  <leftvalue>metadatapath</leftvalue>

    517. 

  517.  <function>&lt;&gt;</function>

    518. 

  518.  <rightvalue/>

    519. 

  519.  <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition>

    520. 

  520.     </compare>

    521. 

  521.      <cluster_schema/>

    522. 

  522.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    523. 

  523.       <xloc>323</xloc>

    524. 

  524.       <yloc>170</yloc>

    525. 

  525.       <draw>Y</draw>

    526. 

  526.       </GUI>

    527. 

  527.     </step>

    528. 

  528. 

    529. 

  529.   <step>

    530. 

  530.     <name>drop blank mdp</name>

    531. 

  531.     <type>Dummy</type>

    532. 

  532.     <description/>

    533. 

  533.     <distribute>Y</distribute>

    534. 

  534.     <copies>1</copies>

    535. 

  535.          <partitioning>

    536. 

  536.            <method>none</method>

    537. 

  537.            <schema_name/>

    538. 

  538.            </partitioning>

    539. 

  539.      <cluster_schema/>

    540. 

  540.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    541. 

  541.       <xloc>509</xloc>

    542. 

  542.       <yloc>145</yloc>

    543. 

  543.       <draw>Y</draw>

    544. 

  544.       </GUI>

    545. 

  545.     </step>

    546. 

  546. 

    547. 

  547.   <step>

    548. 

  548.     <name>Select id + mdp</name>

    549. 

  549.     <type>SelectValues</type>

    550. 

  550.     <description/>

    551. 

  551.     <distribute>N</distribute>

    552. 

  552.     <copies>1</copies>

    553. 

  553.          <partitioning>

    554. 

  554.            <method>none</method>

    555. 

  555.            <schema_name/>

    556. 

  556.            </partitioning>

    557. 

  557.     <fields>      <field>        <name>id</name>

    558. 

  558.         <rename/>

    559. 

  559.         <length>-2</length>

    560. 

  560.         <precision>-2</precision>

    561. 

  561.       </field>      <field>        <name>metadatapath</name>

    562. 

  562.         <rename/>

    563. 

  563.         <length>-2</length>

    564. 

  564.         <precision>-2</precision>

    565. 

  565.       </field>        <select_unspecified>N</select_unspecified>

    566. 

  566.     </fields>     <cluster_schema/>

    567. 

  567.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    568. 

  568.       <xloc>443</xloc>

    569. 

  569.       <yloc>190</yloc>

    570. 

  570.       <draw>Y</draw>

    571. 

  571.       </GUI>

    572. 

  572.     </step>

    573. 

  573. 

    574. 

  574.   <step>

    575. 

  575.     <name>Group by mdp</name>

    576. 

  576.     <type>GroupBy</type>

    577. 

  577.     <description/>

    578. 

  578.     <distribute>Y</distribute>

    579. 

  579.     <copies>1</copies>

    580. 

  580.          <partitioning>

    581. 

  581.            <method>none</method>

    582. 

  582.            <schema_name/>

    583. 

  583.            </partitioning>

    584. 

  584.       <all_rows>N</all_rows>

    585. 

  585.       <ignore_aggregate>N</ignore_aggregate>

    586. 

  586.       <field_ignore/>

    587. 

  587.       <directory>%%java.io.tmpdir%%</directory>

    588. 

  588.       <prefix>grp</prefix>

    589. 

  589.       <add_linenr>N</add_linenr>

    590. 

  590.       <linenr_fieldname/>

    591. 

  591.       <give_back_row>N</give_back_row>

    592. 

  592.       <group>

    593. 

  593.         <field>

    594. 

  594.           <name>metadatapath</name>

    595. 

  595.         </field>

    596. 

  596.       </group>

    597. 

  597.       <fields>

    598. 

  598.         <field>

    599. 

  599.           <aggregate>ids</aggregate>

    600. 

  600.           <subject>id</subject>

    601. 

  601.           <type>CONCAT_STRING</type>

    602. 

  602.           <valuefield>,</valuefield>

    603. 

  603.         </field>

    604. 

  604.       </fields>

    605. 

  605.      <cluster_schema/>

    606. 

  606.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    607. 

  607.       <xloc>581</xloc>

    608. 

  608.       <yloc>190</yloc>

    609. 

  609.       <draw>Y</draw>

    610. 

  610.       </GUI>

    611. 

  611.     </step>

    612. 

  612. 

    613. 

  613.   <step>

    614. 

  614.     <name>XML sl</name>

    615. 

  615.     <type>XMLOutput</type>

    616. 

  616.     <description/>

    617. 

  617.     <distribute>Y</distribute>

    618. 

  618.     <copies>1</copies>

    619. 

  619.          <partitioning>

    620. 

  620.            <method>none</method>

    621. 

  621.            <schema_name/>

    622. 

  622.            </partitioning>

    623. 

  623.     <encoding>UTF-8</encoding>

    624. 

  624.     <name_space/>

    625. 

  625.     <xml_main_element>Rows</xml_main_element>

    626. 

  626.     <xml_repeat_element>Row</xml_repeat_element>

    627. 

  627.     <file>

    628. 

  628.       <name>C:\Bryn\ala\spatial portal\layer_index_links_source</name>

    629. 

  629.       <extention>xml</extention>

    630. 

  630.       <do_not_open_newfile_init>N</do_not_open_newfile_init>

    631. 

  631.       <split>N</split>

    632. 

  632.       <add_date>N</add_date>

    633. 

  633.       <add_time>N</add_time>

    634. 

  634.       <SpecifyFormat>Y</SpecifyFormat>

    635. 

  635.       <omit_null_values>N</omit_null_values>

    636. 

  636.       <date_time_format>.yyyyMMdd</date_time_format>

    637. 

  637.       <add_to_result_filenames>N</add_to_result_filenames>

    638. 

  638.       <zipped>N</zipped>

    639. 

  639.       <splitevery>0</splitevery>

    640. 

  640.     </file>

    641. 

  641.     <fields>

    642. 

  642.       <field>

    643. 

  643.         <name>source_link</name>

    644. 

  644.         <element/>

    645. 

  645.         <type>String</type>

    646. 

  646.         <format/>

    647. 

  647.         <currency/>

    648. 

  648.         <decimal/>

    649. 

  649.         <group/>

    650. 

  650.         <nullif/>

    651. 

  651.         <length>-1</length>

    652. 

  652.         <precision>-1</precision>

    653. 

  653.       </field>

    654. 

  654.       <field>

    655. 

  655.         <name>ids</name>

    656. 

  656.         <element/>

    657. 

  657.         <type>String</type>

    658. 

  658.         <format/>

    659. 

  659.         <currency/>

    660. 

  660.         <decimal/>

    661. 

  661.         <group/>

    662. 

  662.         <nullif/>

    663. 

  663.         <length>-1</length>

    664. 

  664.         <precision>-1</precision>

    665. 

  665.       </field>

    666. 

  666.     </fields>

    667. 

  667.      <cluster_schema/>

    668. 

  668.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    669. 

  669.       <xloc>714</xloc>

    670. 

  670.       <yloc>312</yloc>

    671. 

  671.       <draw>Y</draw>

    672. 

  672.       </GUI>

    673. 

  673.     </step>

    674. 

  674. 

    675. 

  675.   <step>

    676. 

  676.     <name>Filter sl</name>

    677. 

  677.     <type>FilterRows</type>

    678. 

  678.     <description/>

    679. 

  679.     <distribute>Y</distribute>

    680. 

  680.     <copies>1</copies>

    681. 

  681.          <partitioning>

    682. 

  682.            <method>none</method>

    683. 

  683.            <schema_name/>

    684. 

  684.            </partitioning>

    685. 

  685. <send_true_to>Select id + sl</send_true_to>

    686. 

  686. <send_false_to>drop blank sl</send_false_to>

    687. 

  687.     <compare>

    688. 

  688. <condition>

    689. 

  689.  <negated>N</negated>

    690. 

  690.  <leftvalue>source_link</leftvalue>

    691. 

  691.  <function>&lt;&gt;</function>

    692. 

  692.  <rightvalue/>

    693. 

  693.  <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>Y</isnull><mask/></value> </condition>

    694. 

  694.     </compare>

    695. 

  695.      <cluster_schema/>

    696. 

  696.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    697. 

  697.       <xloc>334</xloc>

    698. 

  698.       <yloc>292</yloc>

    699. 

  699.       <draw>Y</draw>

    700. 

  700.       </GUI>

    701. 

  701.     </step>

    702. 

  702. 

    703. 

  703.   <step>

    704. 

  704.     <name>drop blank sl</name>

    705. 

  705.     <type>Dummy</type>

    706. 

  706.     <description/>

    707. 

  707.     <distribute>Y</distribute>

    708. 

  708.     <copies>1</copies>

    709. 

  709.          <partitioning>

    710. 

  710.            <method>none</method>

    711. 

  711.            <schema_name/>

    712. 

  712.            </partitioning>

    713. 

  713.      <cluster_schema/>

    714. 

  714.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    715. 

  715.       <xloc>516</xloc>

    716. 

  716.       <yloc>264</yloc>

    717. 

  717.       <draw>Y</draw>

    718. 

  718.       </GUI>

    719. 

  719.     </step>

    720. 

  720. 

    721. 

  721.   <step>

    722. 

  722.     <name>Select id + sl</name>

    723. 

  723.     <type>SelectValues</type>

    724. 

  724.     <description/>

    725. 

  725.     <distribute>N</distribute>

    726. 

  726.     <copies>1</copies>

    727. 

  727.          <partitioning>

    728. 

  728.            <method>none</method>

    729. 

  729.            <schema_name/>

    730. 

  730.            </partitioning>

    731. 

  731.     <fields>      <field>        <name>id</name>

    732. 

  732.         <rename/>

    733. 

  733.         <length>-2</length>

    734. 

  734.         <precision>-2</precision>

    735. 

  735.       </field>      <field>        <name>source_link</name>

    736. 

  736.         <rename/>

    737. 

  737.         <length>-2</length>

    738. 

  738.         <precision>-2</precision>

    739. 

  739.       </field>        <select_unspecified>N</select_unspecified>

    740. 

  740.     </fields>     <cluster_schema/>

    741. 

  741.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    742. 

  742.       <xloc>454</xloc>

    743. 

  743.       <yloc>312</yloc>

    744. 

  744.       <draw>Y</draw>

    745. 

  745.       </GUI>

    746. 

  746.     </step>

    747. 

  747. 

    748. 

  748.   <step>

    749. 

  749.     <name>Group by sl</name>

    750. 

  750.     <type>GroupBy</type>

    751. 

  751.     <description/>

    752. 

  752.     <distribute>Y</distribute>

    753. 

  753.     <copies>1</copies>

    754. 

  754.          <partitioning>

    755. 

  755.            <method>none</method>

    756. 

  756.            <schema_name/>

    757. 

  757.            </partitioning>

    758. 

  758.       <all_rows>N</all_rows>

    759. 

  759.       <ignore_aggregate>N</ignore_aggregate>

    760. 

  760.       <field_ignore/>

    761. 

  761.       <directory>%%java.io.tmpdir%%</directory>

    762. 

  762.       <prefix>grp</prefix>

    763. 

  763.       <add_linenr>N</add_linenr>

    764. 

  764.       <linenr_fieldname/>

    765. 

  765.       <give_back_row>N</give_back_row>

    766. 

  766.       <group>

    767. 

  767.         <field>

    768. 

  768.           <name>source_link</name>

    769. 

  769.         </field>

    770. 

  770.       </group>

    771. 

  771.       <fields>

    772. 

  772.         <field>

    773. 

  773.           <aggregate>ids</aggregate>

    774. 

  774.           <subject>id</subject>

    775. 

  775.           <type>CONCAT_STRING</type>

    776. 

  776.           <valuefield>,</valuefield>

    777. 

  777.         </field>

    778. 

  778.       </fields>

    779. 

  779.      <cluster_schema/>

    780. 

  780.  <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>

    781. 

  781.       <xloc>586</xloc>

    782. 

  782.       <yloc>312</yloc>

    783. 

  783.       <draw>Y</draw>

    784. 

  784.       </GUI>

    785. 

  785.     </step>

    786. 

  786. 

    787. 

  787.   <step_error_handling>

    788. 

  788.   </step_error_handling>

    789. 

  789.    <slave-step-copy-partition-distribution>

    790. 

  790. </slave-step-copy-partition-distribution>

    791. 

  791.    <slave_transformation>N</slave_transformation>

    792. 

  792. </transformation>
    793.