Response Doc values to Document values

Hello Samir,

this is all not a problem, but please clarify first some circumstances.

First question is: do a main document has only ONE child document of those three child types (max three childs all different type)?
Second question: does any of the fields intersect between main and any of the three child types?
Third question: does any of the child fields has multiple values?

Last question: is a good idea to have for every child type a list of possible field names to avoid unnecessary fields (like $Revisions, and so on)?


Please answer this.

So long,
zvonko

Most important question: is any of the child fields a RichTextItem field :)

Zvonko,

The main document can have multiple response docs.  For example, I have one Main form that has 23 Mainframe response docs, 14 Distributed response docs and 3 Dependency response docs.

I do have a couple of fields
AppExDate
BGForNote
BUForNote

That inherit values from the Main form.  

I plan on copying and pasting the Main "document" form and then running an agent on each response document to move its value to corresponding pasted Main form.


Also there are several fields that have multiple values and also the same for rich text.

Samir

All you need to do is create a view that selects only the response documents. With the Selection formula selecting these three forms only.

Make sure that the documents display in this view first.

After that write an agent that will run on all these documents to change the form name to the main form and remove the "$Ref" Field.

To do this

FIELD Form := "MainForm"
FIELD $Ref := @Unavailable;

Should be the agent code.  None of the computed or inherited values will change by doing so.

You can run on all the documents in this view in one shot.

Hi Bro!
Arun.

Thanks Arun,

I need to clarify one point.  I need to put the response document values inside of the document form (main).  I do not want to convert the form name but to take the values and insert them in the main form.

samir

Thanks Samir, and when you tell me now there are also attachments in those RichText fields, then I tell you: this is impossible to be done.

Arun, I believe you are all the time on the trip of converting child documents to main documents, aren't you :)

The number of main documents is after Samir's action the same; only the content of the childs has to be merged into mains, and this is impossible for RichText fields with attachments.

Or am I on wrong track? Tell me Samir, after your action on this one Main form that has 23 Mainframe response docs, 14 Distributed response docs and 3 Dependency response docs, how many main documents are present afterwards? 40, 41 or one?

Or am I on wrong track? Tell me Samir, after your action on this one Main form that has 23 Mainframe response docs, 14 Distributed response docs and 3 Dependency response docs, how many main documents are present afterwards? 40, 41 or one?

Zvo,

You are on the right track more than Michael Johnson.

After thinking....I don't need to send over attachements.

If I need them I can paste them in manually.  The number of Main document will be 40.  What I plan on doing is copying and pasting the main document 40 times and then I will individually run this agent for each child.  I have to make sure each document converts and I know it is lots of manual work.

Zvo you are on the right track and it seems Arun wants to convert the form from response to document.  I guess that can work if I inherit the values of the Main document into each child and then change the form type.

Samir

Whatever !!!

Do i get the pts or not ???

LOL !

;-)

How crazy is this idea?????

Export all the values on the main form to excel, if i need forty I will add forty and then export all the response docs and then match them up manually and import them to the main form.  

Lots of work but that is the only solution I could come up with....

"Keep the mic warm with message...."

Samir

Oh Boy... But will it work for you ? The RichText Contents as well if it has attachments ?

Arun,

I am not going to transfer rich text fields.  I hope that helps anyone trying to solve this question.....

Samir

Samir, your idea is great!

You do not need no Excel. Do like this:
1.) Make a copy of your database. Best do DesignOnly
2.) Transfer some of the main and response documents to this new copy.
3.) In menu select this option: File->Export
FileName: All.log
Filetype: StructuredText
Export: AllDocuments
DocumentDelimeter: char(12)
LineWrap: 75

4.) Open All.log in your favorite editor (notepad.exe :) and change all items like you want.
5.) Change
FORM: Response
to something like:
FORM: MainDoc
and all variable names like you want to have it on the form.
6.) Delete all documents from this test database and import this All.log as StructuredText
7.) Check the fields for correct content and delete all documents for next changed import until all match your needs.

This is the biggest typing effort but best results for filigran changes. Afterwards you can easily transfer attachments or pictures from old database to new documents.

Yea ! Thats a good option since you can Find Form:Response and replace with Form:Main in one shot

Zvonko is great but i would like to share the points with him ....

LOL !

I can't use that method.....How do I relay the information to an existing Main form.

Samir

Method is: by eyes and hands :-)

I mean, either you work three days on several agents producing a mess of documents, or you invest the time and investigate which data you have to move to which field names (across different documents)

Send me a design copy of this database with the 41 documents or a few more and I explain to you on real world variables what I am talking about, ok?
My email address is: paunoski@freenet.de

zip it if too big.

So long,
zvonko

And send a unzipped copy to my Bro :-)

Aaah Forget it.  All I need is points here and not zipped or unzipped stuff !

LOL !

:-)
Arun.

That's why we are Bro's! I do the same :)

Send it to me Samir. I am sure there is a simple hint about solving your trouble.

I will send the file by weeks end....


Samir

Sorry, Today is the day :)

On Thursday I go on Holiday and will be back on 9th of September.

Wow, that is a long vacation.....I hope the floods of Europe won't effect your trip and good time.  That is no problem, I don't need to do this til then cause I want to build the ASP part first.

"Keep the mic warm with message" - Slug

Samir

Hello Samir, you where true, the floods keep me from plans to go to Italy. I was for one week in Bavarian Forest (on hills :) and perhaps I will go for another week of the rest of three weeks now.

In the mean time you could send me a copy of this database so I can try to give you some suggestions how to make this document transformation easier.

So long,
zvonko

Sorry for the delay....Please excuse my horrible respone time....will email soon.

Samir

I have not forgotten about this posting...

Samir

cool... and the points go to me without fail. Right ?