Skip to main content
J
jeevikashreea0001
May 26, 2021
Question

need to export first name and last name using a!exportDataStoreEntityToExcel

  • May 26, 2021
  • 5 replies
  • 0 views

Hello,

we are exporting DB data to excel where we have one column for Appian user id .we are using a!exportDataStoreEntityToExcel to export whioch igives all the columns as it is which are in DB but we want to convert Appian user id to first name and last name before dumping to excel.

Is there any way I can do it using a!exportDataStoreEntityToExcel without saving first name and last name in DB.

Any pointer will be helpful.

Thanks in Advance.

    5 replies

    vinitaj0002
    vinitaj0002
    May 26, 2021

    Hi Jeevika,

    I don't think there is a way to manipulate your data in Appian before exporting to excel using this function a!exportDataStoreEntityToExcel. You can try to use the export to excel smart service to pass your data from Appian UI to the smart service and on the UI you can use the user function to fetch your first Name and last name and save the in a dummy CDT and pass that CDT value to your smart service to export the data through link.

    Regards,

    Vinita 

    J
    jeevikashreea0001Author
    May 26, 2021

    Hai vinita,

    i hope you are aware that a!exportDataStoreEntityToExcel doesn't allow to export data from CDT here you can directly export from DB using entity

    vinitaj0002
    vinitaj0002
    May 26, 2021

    Jeevika,

    That is what i have told in the first line and hence suggested an alternate approach requesting you to go through and see if that works for you.

    Vinita

    danny.verb
    danny.verb
    May 26, 2021

    I recommend using records. With a!gridField() using a record type, you can export all data to excel and it will keep the format of the grid columns

      csteward
      csteward
      May 26, 2021

      We will typically do this with a view on the database which joins the user ID to a "Users" table containing the names, and concatenate them in the view, then you can smoothly use a!exportDataStoreEntityToExcel() on the view.

      Also to note, the Export CDT to Excel service has been deprecated - although many of us are still forced to use it in production since no matching functionality exists OOTB.

      Terms & ConditionsAccessibility statement