Solved

Is there any method of "exporting" specified Notes/Domino fields

Posted on 2011-02-21
7
354 Views
Last Modified: 2013-11-17
I currently use the File Export option coded behind a button to create an RTF document. The resultant document needs to be cleaned up, deleting the unecessary texts that outputs with the export. Is there any way to programmatically export only the required Notes fields within the document to a file or to the clipboard perhaps?
0
Comment
Question by:dpeadmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

by:mbonaci
ID: 34949539
Of course there is, why don't you post the code.
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 167 total points
ID: 34949595
You can do programmed exports to (just naming a few):
- OpenOffice
- Word
- Excel
- SWING
- .csv file

You can prepare high quality prints using
- Notes2Paper
- Midas tools
and several others.

Take your pick!
0
 

Author Comment

by:dpeadmin
ID: 34958909
I'm interested in the option to output to clipboard as a preferred option , with output to Word as the 2nd choice. I attach the current code behind the Export button,
FIELD Export_File := Export_File;
T1 := @Subset(@DbLookup("" : "No Cache"; ""; "System\\Lookup by Export File"; Export_File; 3); 1);
T := @Right(T1; "@");
Temp_Next := @If(T = ""; "A"; T = "A"; "B"; T = "B"; "C"; T = "C"; "D"; T = "D"; "E"; T = "E"; "F"; T = "F"; "G"; T = "G"; "H"; T = "H"; "I"; T = "I"; "J"; T = "J"; "K"; T = "K"; "L"; T = "L"; "M"; T = "M"; "N"; T = "N"; "O"; T = "O"; "P"; T = "P"; "Q"; T = "Q"; "R"; T = "R"; "S"; T = "S"; "T"; T = "T"; "U"; T = "U"; "V"; T = "V"; "W"; T = "W"; "X"; T = "X"; "Y"; T = "Y"; "Z"; "Z");
TempPathRefNo := Path + Export_File + RTF_ext;
TempNextPathRefNo := Path + Export_File + Temp_Next + RTF_ext;
@If(@IsError(T1); @PostedCommand([MailForward]) + @PostedCommand([FileExport]; "Microsoft RTF"; TempPathRefNo) + @PostedCommand([FileCloseWindow]); @Prompt([Ok]; "FILE " + @Left(T1; "@") + @Right(T1; "@") + " ALREADY CREATED!"; "Cannot overwrite file, answer may have commenced.  A new file will be exported with name " + Export_File + Temp_Next + RTF_ext + " (NOTE: you can rename this file as " + Export_File + RTF_ext + " using My Computer or Windows NT Explorer, but be careful not to overwrite the answer)") + @SetField("Export_Ext"; Temp_Next) + @PostedCommand([MailForward]) + @PostedCommand([FileExport]; "Microsoft RTF"; TempNextPathRefNo) + @PostedCommand([FileCloseWindow]));
FIELD Distributed := "Yes";
@PostedCommand([FileSave]);
@All

Open in new window

FIELD Export_File := Export_File;
T1 := @Subset(@DbLookup("" : "No Cache"; ""; "System\\Lookup by Export File"; Export_File; 3); 1);
T := @Right(T1; "@");
Temp_Next := @If(T = ""; "A"; T = "A"; "B"; T = "B"; "C"; T = "C"; "D"; T = "D"; "E"; T = "E"; "F"; T = "F"; "G"; T = "G"; "H"; T = "H"; "I"; T = "I"; "J"; T = "J"; "K"; T = "K"; "L"; T = "L"; "M"; T = "M"; "N"; T = "N"; "O"; T = "O"; "P"; T = "P"; "Q"; T = "Q"; "R"; T = "R"; "S"; T = "S"; "T"; T = "T"; "U"; T = "U"; "V"; T = "V"; "W"; T = "W"; "X"; T = "X"; "Y"; T = "Y"; "Z"; "Z");
TempPathRefNo := Path + Export_File + RTF_ext;
TempNextPathRefNo := Path + Export_File + Temp_Next + RTF_ext;
@If(@IsError(T1); @PostedCommand([MailForward]) + @PostedCommand([FileExport]; "Microsoft RTF"; TempPathRefNo) + @PostedCommand([FileCloseWindow]); @Prompt([Ok]; "FILE " + @Left(T1; "@") + @Right(T1; "@") + " ALREADY CREATED!"; "Cannot overwrite file, answer may have commenced.  A new file will be exported with name " + Export_File + Temp_Next + RTF_ext + " (NOTE: you can rename this file as " + Export_File + RTF_ext + " using My Computer or Windows NT Explorer, but be careful not to overwrite the answer)") + @SetField("Export_Ext"; Temp_Next) + @PostedCommand([MailForward]) + @PostedCommand([FileExport]; "Microsoft RTF"; TempNextPathRefNo) + @PostedCommand([FileCloseWindow]));
FIELD Distributed := "Yes";
@PostedCommand([FileSave]);
@All

Open in new window

0
Independent Software Vendors: 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 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 167 total points
ID: 34959311
Far better results can be obtained using a programmed solution in LotusScript. The standard export facilities are powerful yet limited.

Some examples:
- http://searchdomino.techtarget.com/tip/A-flexible-data-export-agent-for-Lotus-Notes?track=Top10LStip
- http://www.openntf.org/projects/codebin/codebin.nsf/0/6D1C8B9FDFD0CB51862570DE0048611F
0
 
LVL 22

Assisted Solution

by:mbonaci
mbonaci earned 83 total points
ID: 34959316
0
 

Author Closing Comment

by:dpeadmin
ID: 35140225
Solutions were more convuluted than expected.
0
 

Author Comment

by:dpeadmin
ID: 35140232
Thanks for your responses.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

710 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