Skip to main content
S
swayangp408335
Inspiring
August 18, 2022
Question

Extract Document,Store it ,Delete from DB

  • August 18, 2022
  • 19 replies
  • 0 views

I have data saved in Appian DB ,

I want to export all the data into an excel   and store in a location ,and the data need to be deleted from DB,  

But before deletion I need to send an EMAIL   (after a week ) as kind of reminder that Data will be deleted  .

Then I have to remove all the DATAS from DB .

And this process need to be performed on the starting of every month .

 

Is it the correct approach ? 

I am getting 2 files from 2 tables , but Encryption node allwos one document to be protected with password .how will they be passed  to get encrypted 

19 replies

stefanhelzle0001
stefanhelzle0001
Brainy
August 18, 2022

Looks OK to me. I am missing the delay for this reminder email. And the start node need to be scheduled.

S
swayangp408335Author
Inspiring
August 18, 2022

Start Node should be scheduled to 1st of every month and the EMAIL should be scheduled to 7th of every month . Is it correct 

D
deepakg681722
August 18, 2022

Few questions:

1) from how many tables you have to export the data?

2) On which loation you have to store the files?

Few suggestions:

1) You have to make your start node as a timer node. To do this, right click on the start event-> go to trigger-> select timer. Configure the timer properties.

2) Between Excrypt excel node and send email node, user timer node to delay it for 7 for days.

Rest looks good.

S
swayangp408335Author
Inspiring
August 18, 2022

For 2 tables I have to extract the data . The location is out of APPIAN .

D
deepakg681722
August 18, 2022

then you have to use integration to store the file into outside of the Appian if you want to do it automatically. But from process model side, it looks good once you made the necessary changes.

Terms & ConditionsAccessibility statement