Accessing A CSV file from LS

HCL Domino Domino Forum
1

Hi,

I have a problem with an agent in my application.

The agent initially used to open and read a CSV file across the network, and use each row of data to create a new Notes document. However, this ran into performance issues so we decided to try to put the CSV file directly on to the server and read it in from there.

The problem is, our users obviously don’t have access to the server directly, so instead I was allowing them to attach the CSV file to a document (which I don’t want to be saved) and then using NotesRichTextItem and the ExtractFile method to save the CSV file to the server. The problem now is, I get an error trying to access the server, and it appears that even though I have Administrative access through Notes to the server, and the agent is set to allow unrestricted operations, it still can’t extract the file to the server.

I apologise for the lengthy post, but if anybody could advise me if there’s maybe an easier/better way to go about this i’d really appreciate it…

2

Subject: Accessing A CSV file from LS

I’m not quite if i understand you right:

From the notes-Client the users fill out a form and attach a csv-file?

Unless this form is saved and by this producing a notes-document in the database on the server, the csv-file will never be available in the database and so an agent running on the server can’t acces the csv-file.

In order to detach the csv-file directly on to the server:

The users MUST save the document with the csv-attachment.

Create an server based agent (=running on the server ) who will detach the csv-file to (server-) disk and remove the document afterwards.

good luck axel

3

Subject: RE: Accessing A CSV file from LS

Yup…save the doc - then save the attachment - then delete the doc.