Pull an Excel dump from Network drive

ravinoors0001 over 6 years ago

Hi,

I have a use case, wherein i will get an excel dump daily on our shared network location which i then need to dump into Appian Database table.

Can anyone provide the best way to handle this scenario?

Appreciate any help on this.

Discussion posts and replies are publicly visible

Parents

0 ammireddys
A Score Level 1
over 6 years ago

Hi,
If i understand you question correctly then I can see below options
1) Create a batch process to run on certain intervals
2) Configure "Receive file over FTP" smart service to receive file from your shared drive
3) Parse the received document and store them in respective process variables
4) And write them to data base
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ammireddys
A Score Level 1
over 6 years ago

Hi,
If i understand you question correctly then I can see below options
1) Create a batch process to run on certain intervals
2) Configure "Receive file over FTP" smart service to receive file from your shared drive
3) Parse the received document and store them in respective process variables
4) And write them to data base
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data