I have an app that updates a lookup table from a saved search each night. The app is going to be updated periodically via a deployment server.
How can I keep the deployment server from overwriting the current lookup (.csv) files? If I leave them out of the deployment package, it will end up deleting them altogether.
Is it possible that the lookup files can reside in another app dedicated to housing the lookups and still be able to be called from the other app?
Yes, it is possible to have lookup CSV files in other app. You have to edit serverclass.conf file to include that app also to be deployed to your node.
We generally follow this design: Keep all the common files in a common app and push that app to all nodes. In our case lookups are also part of this common app.
One more thing, the data for all lookups might be the same on all servers you're deploying it, right?! if that's the case you might decide to use a NFS or Samba share to store this file instead of re-create it on all servers each night.
I have something similar. I've create a "core" app with my important and shared lookups so I can play with the other apps without worrying about it. Just make sure you configure the permissions for the lookup file and definitions to "all apps"