• XSL.Join

    By Ralf Renken 1 decade ago

    Hi,



    first of all, congratulations to your tool. It's just great.



    I'm trying to do the following and just can't get it to work:



    There are two databases, Contacts and Contracts.



    In the Contacts-DB a Company-Document has an Item e. g. "myID",

    in the Contracts-DB is an item with the related Company-ID, e. g. "CompanyID".



    I want an Excel-Report wich looks something like this:



    ContractType (ContractDB) | Product (ContractDB) | CompanyType (ContactDB) etc.



    I tried to add an additional DataSource to my Contract-Report and

    a join-Process, but something is missing.



    In both reports I addes myID or CompanyID as Key (ExportField/Title),

    and 1 and 2 as Dataset. In the join-Process-Doc I added



    NotesReconn.Join.KEY=Key

    NotesReconn.Join.DataSource=Dataset



    But I still just get the fields of my initial Contracts-Report.



    Is this possible at all? Is there a tutorial for this?

    (Hope you get the problem ;) ).



    Thanks in advance.



    Ralf

    • We will put together a Tutorial

      By David Jeyachandran 1 decade ago

      Hi Ralf,



      You are right - getting a multi-source export working is tricky. It is an incredibly useful feature but it is not simple to setup. Johnny & I will put together a little tutorial on how to do this. It is a lot easier to follow with a few screenshots.



      Regards

      David

      • Thanks

        By Ralf Renken 1 decade ago

        Hi David,



        thanks for your response. I'm glad, it' not just me ;)



        A tutorial would be great.



        Regards.



        Ralf

    • RE:

      By Johnny Jiang 1 decade ago

      Hi Ralf,



      Firstly, I assume you have 2 profiles already. One for Contacts-DB, and the other one for Contracts-DB.



      In the profile for Contracts-DB, field and title lists could be like below:

      Field list: CompanyID, ContractType, Product, 1

      Title list: Key, Contract Type, Product, DataSet



      In the profile for Contacts-DB, field and title lists could be like below:

      Field list: myID, COmpanyType, 2

      Title list: Key, Company Type, DataSet



      Please note that the titles of the keys should be identical, and make sure there are matches between CompanyID and myID. For test purpose, you can simply put a string value (eg."key") in the field lists to replace CompanyID and myID to test the profiles.



      There is a demo profile for XSLT in the database demonstrating how to set up Join.



      Hope that makes sense. Please feel free to let us know if you have further questions and suggestions.



      Regards,

      Johnny

      • By Ralf Renken 1 decade ago

        Hi Johnny,



        sorry, still not working, seems i'm still missing something.



        What I did:



        First ReportConfig (Contracts):



        CompanyID|Key

        txtBaseProgramme|Programme

        Company|Company

        numTotalMonthlyServiceCosts|ServiceCosts

        1|Dataset



        Second ReportConfig (Contacts):



        myID|Key

        Company|Company

        AccountType|AccountType

        2|Dataset



        In the first ReportConfig (Contracts) I added a new Process (Join).

        There I just changed these two lines:



        Values: NotesReconn.Join.KEY=Key

            NotesReconn.Join.DataSource=DataSet<br/>
            <br/>
        

        When I run the Report (the first ReportConfig), I only get the

        columns for that Report (Key, Programme, Company, ServiceCosts, Dataset).



        Do I have to add the second Report as an additional DataSource (well, i tried

        both, with or without, it's not in the Demo-Profile)?



        When I run both Reports separately and check the keys, it looks OK (Contract-Keys

        match the Company-Keys).



        Any help would be great. Thanks for your patience :)



        Ralf

        • re:

          By Johnny Jiang 1 decade ago

          Hi Ralf,



          One thing I can think of is that after adding additional data sources or XSLT processes, you have to save and close, then reopen the profile. Your profiles look all right.



          The demo is demo case 05, which we deleted from the latest version, we will add it back, sorry.



          Let me know if it is still not working.



          Kind regards,

          Johnny

          • By Ralf Renken 1 decade ago

            Hi Johnny,



            ok, I tried it with two different databases and

            different keys and it works like a charm!



            So I guess you're out of this thing :)



            I'll go and figure out, what goes wrong with

            my first setup.



            So thank you for your help, patience and of

            course for your great tool.



            Ralf

            • Glad to hear

              By Johnny Jiang 1 decade ago

              Hi Ralf,



              Good on you, thanks for letting us know your solution.

              I think ending a thread by posting the final solution and result is the best thing to do, and we see it is

              lacking at most forums.

              You are welcome anytime, 8)

          • Solved

            By Ralf Renken 1 decade ago

            Hi again,



            just to let you know, I found my mistake.

            In the Category-Field I added a backslash

            to get some kind of hierarchy



            e. g. Admin\Databasename



            If I leave the backslash everything is working fine.



            Sorry for the inconvenience and thanks again.



            Ralf