Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export from an embedded view

Posted on 2004-08-31
6
Medium Priority
?
295 Views
Last Modified: 2013-12-18
Hi all,

I have a little problem with the exporting embedded view feature.
I have an embedded view in a Form, to show only the documents which belongs to the a particular client (the client name is specified in the Form), though the view actually contains all clients' documents.

However, when I try to export data from the embedded view to Lotus 1-2-3 file & I specify "All documents", the Lotus 1-2-3 file contains all documents of all clients!

How can I just export the documents shown currently, instead of all documents?
Anybody know how to do it?

Thanks very much in advance!

~kspuea
0
Comment
Question by:kspuea
6 Comments
 
LVL 15

Expert Comment

by:Bozzie4
ID: 11950097
Ah.  Yes.  There are indeed some inconsistencies in the behaviour of embedded views.

I'd say, try first "select all" (Edit/Select All or CTRL-A), and then Export Selected.  If that doesn't work (still gives you all documents), then you'll have to manually select the documents in the embedded view.

cheers,

Tom
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 11950106
What version are you using ?  This behaviour differs a great deal from version to version !
(but I don't think this would be enough reason to upgrade to the latest Notes version :-) )

cheers,

Tom
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 11950788
U should be using Lotus Script code to export to Excel based on getallDocumentsbykey
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 300 total points
ID: 11952149
When you say "All Documents", it does export all docs ;-)

The work around is to select the documents in the embedded view and then do a file export.

~Hemanth
0
 

Author Comment

by:kspuea
ID: 12013183
Thanks very much for everyone who reply my question. :)

Hemanth, I used your method to select the docs in the embedded view and export, but got a little problem.

My first column is hidden, so fine, it won't be exported out. However, my 2nd column is a Categorised column, but when it gets exported out, the values do not get exported it out too.

Why? I'm using Notes R6.5.

Thanks again, everyone!

~kspuea
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 12017413
Export is not intelligent enought to extrapolate the data... it exports what it sees per row basis. That is why flat views are best for exports
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question