Skip to main content
K
kirans0126
April 30, 2023
Question

Export Cdt to excel

  • April 30, 2023
  • 11 replies
  • 0 views

Hi All,

I wanted to transfer the data from cdt to Excel, but earlier the Export cdt to excel smart service was thr but recently it is showing as deprecated, how to handle this now?

Thanks in Advance

    11 replies

    shikhat
    shikhat
    May 1, 2023

    Hi , 

    Check this out.

    https://docs.appian.com/suite/help/23.1/Export_To_Excel_Smart_Service.html

    K
    kirans0126Author
    May 1, 2023

    Thanks for the suggestion Shikha,but

    My requirement is before storing to the database the cdt process variable need to hold the value & that details i need to get in excel.

    shikhat
    shikhat
    May 1, 2023

    As you need to store the data in the database , why not use the above service to get the excel after writing to Database and can also truncate the table data after excel generation , if needed.

    tushark6475
    tushark6475
    May 1, 2023

    Hi Kiran, 
    I believe there is no way to export cdt to Excel without writing it into the database.

    gopalk2865
    gopalk2865
    Participating Frequently
    May 1, 2023

    HI Kiran, Can you please let us know your use case why you want to use export data from cdt and why not from table?

    K
    kirans0126Author
    May 1, 2023

    Hi Gopal,

    I have scenario like i need to share the details of data by excel before updating to db and get approval, after approval only i need to write to db.

    S
    sanchitg0002
    May 1, 2023

    FWIW, Export CDT to Excel service is deprecated from quite a long time now(4 or may be 5 years) but it is still working as expected afaik. So you can continue to use it and wait for the arrival of something similar as a replacement.

    As it has been deprecated, recommended approach from Appian is to persist data in the database and use OOTB Export DSE to Excel which do has it's own limitations of inability to create a new file from a base template (atleast with the OOTB features) and ofcourse in your case requiring to store the data in a database table (for which I agree with the solution Former member has provided that you can delete the data after exporting).

      K
      kirans0126Author
      May 1, 2023

      Thanks for the suggestion [mention:2773a0b2dec7409a8eee377b9fc57b88:e9ed411860ed4f2ba0265705b8793d05]

      Terms & ConditionsAccessibility statement