i need to import data from sql server and cassandra
first, get user ids from sql server
then get one user's characters from cassandra by user id
last, save the users characters doc into solr
one user have multi charcters
and i need to save the doc like 

1040.txt
<row uniqueid="10031016578048" passportid="1040" character="Ranea"/>
<row uniqueid="10031016578049" passportid="1040" character="assinissa"/>
<row uniqueid="1005101793120" passportid="1040" character="AmmSmashYous"/>
<row uniqueid="1005101793121" passportid="1040" character="Dangless"/>
<row uniqueid="1007102768032" passportid="1040" character="sees"/>
<row uniqueid="10131031905" passportid="1040" character="Loopz"/>
<row uniqueid="10131031907" passportid="1040" character="MyLongName"/>
<row uniqueid="10141031680" passportid="1040" character="Rawr"/>
<row uniqueid="10261043118" passportid="1040" character="Firebald"/>
<row uniqueid="10191054480" passportid="1040" character="salt"/>

19734880.txt
<row uniqueid="10091011208112" passportid="19734880" character="3Negreteo"
/>
<row uniqueid="10091011208113" passportid="19734880" character="3BlaKin" />

field uniqueid is  character id
field passportid is user id
field character is character name

i write the DIH config like the following

<dataConfig>
        <dataSource name="mssql"
                driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
                url="jdbc:sqlserver://localhost:1433;databaseName=pw_account;" 
/>
    <dataSource name="url" type="URLDataSource" />
    <dataSource name="reader" type="FieldReaderDataSource" />
    <document>
        <entity name="user" dataSource="mssql"
            query="SELECT top 100 id FROM pw_account..account">
            <entity name="line" dataSource="url"
processor="LineEntityProcessor"
                url="http://localhost/${user.id}.txt";
                format="text" encoding="UTF-8" connectionTimeout="5000"
readTimeout="100000">
                <entity name="xml" dataSource="reader"
processor="XPathEntityProcessor" 
                    dataField="line.rawLine" forEach="/row"
rootEntity="false">
                    <field column="id" name="id" xpath="/row/@uniqueid" />
                    <field column="character" name="character"
xpath="/row/@character" />
                    <field column="passportid" name="passportid"
xpath="/row/@passportid" />
                </entity>
            </entity>
        </entity>
    </document>
</dataConfig>


but it doesn't work

i got the result in csv format like this

id,passportid,character
1,1040,Ranea
2,,
3,,
4,,

only user_1040 's first character's is imported, and the imported ids are
all wrong

how to write the correct DIH config?

regards


--
View this message in context: 
http://lucene.472066.n3.nabble.com/how-to-import-product-of-entity-date-with-DIH-tp3990694.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to