Home > Domino Tips > Developer > Agent > How to export data from a Lotus Notes database to a CSV file
Domino Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

AGENT

How to export data from a Lotus Notes database to a CSV file


Glen Wheeler
11.13.2007
Rating: -3.05- (out of 5)


Lotus Notes and Domino tips, tutorials and how-to articles
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


This Lotus Notes Domino agent will export all of the data in a Lotus Notes database into CSV (comma separated values) files that can in turn be imported into Microsoft Excel, Microsoft Access, SQL (structured query language) and most other platforms.

It will produce one CSV file for each form in the Lotus Notes database. The CSV file will contain data for each of the fields on the form from any document in the database using that form. It can easily be modified to export Lotus Notes data from a single form.

MEMBER FEEDBACK TO THIS TIP

I've made two changes to this code:

  1. I've added "\" after the c: in fileName$ string (on or about line 23).

  2. I've added support for forms that have aliases.
My corrected version of the code follows. This was a good snippet once I got those things sorted out.
—John P.

*************************...


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Agent
Run or restart Notes/Domino agents via text messages
Approve Lotus Notes documents using a BlackBerry mobile device
LotusScript agent indexes Lotus Notes/Domino databases
Open documents in Lotus Notes from the Web without a UNID
Fix and update Lotus Notes documents with limited access
Verify scheduled agent status with Domino Extensible Language (DXL)
Enable or disable scheduled agents without opening the Lotus Notes database design
Creating custom views in Lotus Notes databases
Editing fields in a Lotus Notes view with Ajax
How to automatically create a backup copy of your Domino Directory

Lotus Notes Domino Agents
How the Agent Profiler tool improves Notes/Domino performance
Run or restart Notes/Domino agents via text messages
Calculating results for a column in a Lotus Notes view
Approve Lotus Notes documents using a BlackBerry mobile device
LotusScript agent indexes Lotus Notes/Domino databases
Top 10 Lotus Notes/Domino coding and development tips of 2008
Open documents in Lotus Notes from the Web without a UNID
Fix and update Lotus Notes documents with limited access
Verify scheduled agent status with Domino Extensible Language (DXL)
Top 10 Lotus Notes Domino programming and development tips of 2007

Lotus Notes Domino Deployment and Migration Advice
Build your own Domino multi-server test environment
IBM Lotus to end Notes/Domino 7.x support
How to upgrade to Lotus Notes 8 and retain Lotus Notes 7
Resolve Notes 8 migration error: 'Database has not been opened yet'
Understanding a Lotus Notes Smart Upgrade rollout
How to install Lotus Notes on Linux CentOS-4
How to install Lotus Domino Server on SUSE Linux
How to perform an in-place upgrade of Lotus Domino server hardware
Moving a remote user mail database to new Lotus Domino server
Top 10 Notes/Domino administration tips of 2006

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


*****************

For this code to work, the form name shouldn't have any aliases.
—Karel Y.

******************************************

This is a great tip! I'm new to Lotus Notes/Domino, but I still have to deal with installation, development and administration stuff. This code saved me a lot of work. Thanks for sharing!
—Osberto J.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Glen Wheeler. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Rate this Tip
To rate tips, you must be a member of SearchDomino.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Domino & Lotus Notes Security Solutions: Authentication, Antispam, Encryption and Antivirus
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts