Excel Import & copy and paste to view

I have a db with the main forms called “NewContact” and “ExistingContact”. These two forms are identical.I made a copy from the “NewContact” form, called “ExcelImport”, and took off all the validation forumlas etc. as the import was erroring on the required fields.

I now have all the imported documents in a view called “ImportedDocs”. However, when I try to copy documents from this view and paste it in another view, the documents will not show up.

All the views (except the ImportedDocs view) are pulling from the “NewContact” & “ExistingContact” forms. I suspect this is why they are not showing anywhere but in the ImprtedDocs view. Is there a work around for this? how can I move these docs to another view?

Thanks in advance.

Helen

Subject: Excel Import & copy and paste to view

The contents of views are chosen purely programmatically. I’m guessing that you have views whose selection formulas specify a form (view A shows everything using the NewContract form, view B shows everything showing the ExistingContract form, and so on). What you need to do is to change the selection criteria of the views you want those documents to appear in so that they’ll include ExcelImport documents.

An important corallary here is that copy and paste won’t change the contents of a view. A view doesn’t actually contain documents; it selects them from the database as a whole according to certain conditions and displays them to you. When you copy and paste documents within a database, the data in the newly pasted documents is exactly the same as the source documents, so the views that didn’t show the old documents won’t show the new ones either, regardless of where you may happen to be when you paste. However, I’m reasonably sure you’ll have a lot of duplicate ExcelImport documents in your database.

Subject: Excel Import & copy and paste to view

If you have existing documents in view A that you want to move to another view B you should first figure out what conditions will cause them to appear in B and then write an action button or an agent to run on them to set this condition. This usually means changing the form name.

Check that the view’s QueryPaste event doesn’t have this line in it:

Continue = False

It’s also possible that the selection formulas on the other views - the ones that are supposed to show both forms - are messed up.