Cognos Controller

IBM Controller

Software that supports the close, consolidate and report process

 View Only
Back to discussions
Expand all | Collapse all

How to import Movement Extensions from Excel file ?

  • 1.  How to import Movement Extensions from Excel file ?

    Posted Fri March 28, 2025 03:38 PM

    Hi Community,

    Is there a way to import Movement extensions into IBM Cognos Controller from an Excel file ? 

    There are about 1000 of them, and I don't want to enter them manually.

    Is there a known safe method to import them directly into SQL tables in the IBM Cognos Controller database ?



    ------------------------------
    Adam
    ------------------------------


  • 2.  RE: How to import Movement Extensions from Excel file ?

    Posted Thu April 10, 2025 09:56 AM

    Hi!

    I have done something similar.

    I uploaded the file into a temporary table and created a script that looped through the temporary table and copied the data into the xdb24-table in the Controller-database.

    Regards,

    Willem



    ------------------------------
    Willem Noble Stibolt
    ------------------------------

    Original Message