Upload file then create new docs

HCL Domino Domino Forum
1

I am a complete noob with LotusScript so any help is appreciated!

I am uploading a tab delimited file from the web and want to be able to read the contents of the file and create a new document based on each line.

Does anyone have a sample script they can share that will do that? I have searched but found nothing that seems to apply.

2

Subject: RE: Upload file then create new docs

In case nobody has exactly what you want, I’ll tell you in broad terms what you need to do. You will have to detach the file to disk (this requires an agent with special privileges – discuss with the server admin). Then you can use the Open statement to open the file and read the data, and db.CreateDocument, assign the items, save. Make sure to pay attention to your datatypes – don’t store a number or date as a text value.

3

Subject: Upload file then create new docs

Thanks - I understand the concept of what I need to do I just don’t have enough script experience to write it.

4

Subject: RE: Upload file then create new docs

As I don’t have time to write it for you, I suggest you take a stab at it – use a local NSF first and run the agent in foreground reading a file on your disk. Take it in small bites – open the file and read lines one at a time, to begin. See Line Input # statement, Split function. Input # may also be helpful depending how your file is formatted.

5

Subject: RE: Upload file then create new docs

Thanks! The line input # pointed me in the right direction and I am working on it now.