Copy selected as table or File Export with multi-value fields...problem

HCL Domino Domino Forum
1

I feel like I’m missing something…any ideas are appreciated.

I have a view with two columns set to display multiple values as separate rows. No problem.

I can see 1 to n rows, each row has the data I expect, all’s well with the world.

Let’s say that I select one document in this view and 3 rows get the checkmark. Again, all good and expected.

Edit, copy selected as table.

Paste it into Excel,

I get row 1…not what I want.

Now I try and do an export of selected docs via File Export CSV or structured text.

Same deal, I only get one ‘row’ out of the three expected.

For now, I’m printing the view via a generic text printer, then pulling the text file into Excel and cleaning it up. This has its own set of problems in that I have to be careful with widths otherwise things start wrapping in the text file…

I know I can write an OLE routine but I’m just being lazy.

Am I missing something or is it not possible to do a copy as table for multivalue entries?

TIA

Doug

2

Subject: Copy selected as table or File Export with multi-value fields…problem

I think (and please correct me someone if I’m misinterpreting this) the confusion is coming from a key bit of information being omitted in the menus but included in your post. The Copy as Table and Export are copying and exporting documents. When you tick the single document, what you’re seeing in the view are three view entries. Indeed if you look at the help on Copy as Table it talks about copying documents as a table.

So the export and copy as table are only finding one document, which is all that’s being exported. Copy as Table wll get you multiple rows for you if you categorise the multi-value column, but this looks to be something to do with it appearing under multiple categories. However, this way you’ll need to select the category rows as well.

Your OLE routine would probably be a bit more complex because you cannot get selected view entries, only selected documents, so it would need to do loops based on the relevant multi-value fields.

3

Subject: RE: Copy selected as table or File Export with multi-value fields…problem

Paul,

And that makes total sense. Thank you. You are also spot on regarding the OLE routine hence the ‘lazy’ approach.

I’ll have to play with categories and see how that works. If it does what I expect, the ‘paste’ won’t give me clean rows/columns but something that looks like a categorized view meaning I’m going to be doing a bunch of copy/paste in Excel to fill in the blanks…easier to write the OLE routine…

Thanks for the reply, very much appreciated.

Doug