An application was running in my office but i have made many changes to it even many new fields i have added some of them are editable and some computed.there is a bulk of data in previos application.now i want to import all the data in new application.is it possible? One idea i have is first i export all the data from previous application to microsoft Excel and then import from Excel to new application.But i don’t know how to export to Excel And how to import from Excel.Could anyone help me please. is any other simple method whch i can use ?thanx
Subject: Export to Excell
I get the Agent to Import and Export between Notes View and MS-Excel from Sandbox. It works.
You can get it and change code a little for your work. Go to Sandbox and search “Excel”.
Good Luck,
SuperPorn
Subject: Export to Excell
Hi Sukhvinder,
Maybe I can save you some work.
Sounds to me like you want to have the old data in the new design. Why not make a new copy of the previous application and run a design replace on the copy with the new design.
If you want to have the newly added computed fields calculated run an agent with @Command([ToolsRefreshAllDocs]).
Also simply copying the documents from the old database into the new database might work.
Think import/export action is not needed in this case, please correct me if I’m wrong.
HTH,
Bas
Subject: Try this tool
Hi,
Try this free tool: A.N.D.I. at http://bpjl.netfirms.com
It’s a nice tool for exporting, importing and synchronizing data with Lotus Notes.
Excel format is not directly supported but you can use text file or csv file or even ODBC with Excel
Subject: Export to Excell
Hi
This is definitely a possibility. Two ways of doing it, either by creating views and using the inbuilt file\export, and then file\import, or by using OLE. To use OLE search this (and the notes 5) forum for Excel and OLE, there are loads of examples. The file\export option is maybe quicker but can take a bit of trial and error to get it right, if you know lotusscript OLE gives more flexibility.
hth
Dan
Subject: Export to Excell
File->Export(choose Lotus 1-2-3 for best results)
File->Import
(to import the Lotus 1-2-3 worksheet)
The lotus 1-2-3 worksheet can even been opened from Excell as saved as .xls
Yours,
J R