route data to indexes based on fields

[kittu26]

I have xml data which I want to route to different indexes based on the value of "Department" field.
Pasted below is the sample file and configurations that I am using..

Despite the configs, data keeps going to main index.
First I index field Department and then route data to indexes based on this field

Sample file:

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

  <address>
  <LogTime>02/22/2014 07:15:49 AM</LogTime>
<EventType>TRACE</EventType>
<Department>Department1</Department>
    <name>Joe Tester</name>
    <street>Baker street 5</street>
  </address>
   <address>
  <LogTime>02/22/2014 08:15:49 AM</LogTime>
<EventType>TRACE</EventType>
<Department>Department2</Department>
    <name>Joe Tester</name>
    <street>Baker street 5</street>
       </address> 
   <address>
  <LogTime>02/22/2014 09:15:49 AM</LogTime>
<EventType>TRACE</EventType>
<Department>Department3</Department>
    <name>Joe Tester</name>
    <street>Baker street 5</street>
      </address>
</addresses>

props.conf

[abc]
BREAK_ONLY_BEFORE = <address>
KV_MODE=XML
SHOULD_LINEMERGE = true
TRANSFROMS-identifyfields = Department
TRANSFORMS-route = Department1,Department2,Department3
pulldown_type = 1

transfroms.conf

[Department]
REGEX = (Department>(?<Department>)<.Department>)
WRITE_META = true
FORMAT = Department:$1

[Department1]
SOURCE_KEY = field:Department
DEST_KEY   = _MetaData:Index
REGEX      = Department1
FORMAT     = Department1

[Department2]
DEST_KEY   = MetaData:Index
REGEX      = (Department>(?<Department>)<.Department>)
FORMAT     = index:$1

[Department3]
SOURCE_KEY = field:Department
DEST_KEY   = MetaData:Index
REGEX      = Department3
FORMAT     = Department3

fields.conf

[Department]
INDEXED = True
INDEXED_VALUE = False

Please help

[lguinn2 · Accepted solution]

First and most important - Department should not be an indexed field. Remove the entry from fields.conf

Second, you need to be very careful with your spelling. I notice that you have misstyped TRANSFORMS in several places.

Finally, try replacing your transforms.conf with this:

[Department]
SOURCE_KEY = _raw
DEST_KEY   = _MetaData:Index
REGEX      = (?m)\<Department\>(Department1|Department2|Department3)\</Department\>
FORMAT     = $1

And your props.conf would have

[abc]
BREAK_ONLY_BEFORE = \<address>
KV_MODE=XML
SHOULD_LINEMERGE = true
TRANSFORMS-route = Department
pulldown_type = 1

Note that this will only work if the name of the department is the name of the index, as you showed in your example.
If the name of the index is not the same, then you would once again have to have 3 TRANSFORMS stanzas - the difference would be in the FORMAT.

HTH!