Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Import 123 worksheet as "response document"

Import 123 worksheet as "response document"

Import 123 worksheet as "response document"

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 ?


RE: Import 123 worksheet as "response document"

I do not think you can do that without programming an agent.
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.


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..



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close