Solved

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

Posted on 2011-02-21
7
347 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

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

Accepted Solution

by:
Sjef Bosman earned 167 total points
Comment Utility
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
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 167 total points
Comment Utility
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
Comment Utility
0
 

Author Closing Comment

by:dpeadmin
Comment Utility
Solutions were more convuluted than expected.
0
 

Author Comment

by:dpeadmin
Comment Utility
Thanks for your responses.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Lotus notes 3 293
Notes > Exchange calendar issues 5 56
Lotus Notes transfer mail box problem 6 88
Counting documents in a Domino View 3 31
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…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now