I am setting up a data file transfer between 2 database applications - the remote application being a non-domino database. The data file arrives as a pipe delimited flat file .txt attachment in an email based on a schedule of, for the moment, lets say twice a day.
My thoughts are that the email will be delivered to a database, an LS agent will run on the “when new mail arrives” event, it will read the .txt file attachment, parse the data and save it to fields either on existing documents or create new documents in the database.
Firstly is it possible to read a .txt file in the body of an email using LS without detaching the file to the filesystem?
If so any hints on how its done? If not any suggestions?
I will also have to do the same in reverse - ie. generate a .txt file from document fields and email it to an address set up on a schedule.