coldfusion - Notes database to MySQL (with CF?) / or how to get the NSF-datastructure -

-

I have a professional ColdFusion application that is running on a MySQL database. A potential new customer has contacted me, they are now working in a Lotus Notes environment (and their database) for many years. At all they want to migrate their data in their application before this step.

I am trying to get a hold of the complete data, structure and interdependencies in my current database - the application There is a tool to look at the database structure of an NSF-file (such as in RDBMS), or any method that can dump the structure using Coldfusion etc. .... I have Lotus Notes (In the meantime A local Lotus client and their database).

I need a good starting point to be able to determine that I can find a way to migrate data.

Any ideas ?? To get the data in the notes, a good option is to use NotesSQL

Notes A quick overview of the data structure is this: Note is a document-centric database, which includes non-relational data within each document Notes in any of the notes in database (NSF) There are also a number of documents, which can include data in turn. Each notes document can have a separate group of items, and thus different data in it. Although it seems like a terrible mess, usually there is similar data on the basis of the form used to make documents documents.

It all goes forward why there is no easy way to get data from Lotus Notes, there are some other options that can be useful or based on how many data you can migrate to Are there.

I personally want to use XML to remove data from Lotus Notes. You can do this by creating an XML view inside a Notes database

Using Java or LotusScript, you can extract data from documents in any format you want (CSV, XML, TXT, etc.) Can write code for

If this is not too much data, you have the easy mediator step to get the data in Excel format. Long ago I wrote an add-in tool that can help you or you can use the "Edit> Copy Selected Table" feature in the Lotus Notes client to copy appearing in the Notes view on the clipboard, And then paste in Excel. In that scenario, you want to edit ideas so that they can show all the data you need.

I hope it helps!


Comments

Post a Comment