Import 123 worksheet as "response document"
Import 123 worksheet as "response document"
(OP)
I would like import 123 worksheet as "response document"
The problem is how to define the correct parent with each on my record ?
The system at this time pushes all my "response document" under the selected document in my view.
Have you an idea ?
thanks
The problem is how to define the correct parent with each on my record ?
The system at this time pushes all my "response document" under the selected document in my view.
Have you an idea ?
thanks
RE: Import 123 worksheet as "response document"
The regular Notes File Import option is incapable of doing that, for sure.
I would start by creating a key for the main documents that exist, and including that key for each document to import (each line in the worksheet).
Then I would save the worksheet in text format with a defined seperator.
After that, I would write an agent in script that would go line by line, get the main doc identified by the key, and create a response with the rest of the data.
A lot of work, but I do not see any other way to import responses reliably.
Pascal.
RE: Import 123 worksheet as "response document"
I have found another way to do it, I have first import my 123 file and after that I have change the $ref value.
thanks anyway for your idea..
cheers
Julie