Update Status via FTP - Forum - Rollbase - Progress Community

Update Status via FTP

 Forum

Update Status via FTP

  • I have a file i want to import via FTP, that file has a column called Stock #, i then have a status in my application not in that file that i want to update. But i only want to update records that have matching stock # to the ftp file. So if the import comes and sees that the numbers match than i want to change the status . Is this possible?
  • Yes, you'll need to learn about Triggers and the Server-side API to do this. The best approach is to write an Object Script trigger that finds the record(s) you want to update and then performs the update.



    See Chapter 6 for more info on Server-side API

    See Chapter 10 for more on Triggers



    https://www.rollbase.com/rollbaseinaction.shtml