Tip:
Highlight text to annotate it
X
This is Ben Langhinrichs of Genii Software with
Out of Notes Part 10: To SQL or DB2
We have customers who want to take data and use it in a relational database
such as SQL Server or DB2.
I'm going to show you how to do this with Midas and our new Roadmap.
This is the Mini-Lessons.info site, and
it runs off a database. Each lesson is a separate document with complex data inside it.
So, if we go into the Export to CSV database and create an Export Directive,
all we have to do is pick the database.
We're going to export everything from the database.
We'll go to the c:\export\ directory, use all the forms and all the fields.
We'll save it, and then we can run the agent.
You don't need a developer for this.
There's the c:\export\ directory.
Click this and switch over and we'll see there is now a Lessons subdirectory and there's the CSV file.
Every item in the Lessons is now represented by a separate column.
The first row has the titles.
Down here (in a subdirectory) we have the additional images and attachments.
Similarly, we can take the Lotusphere Sessions database from a couple years back
In this case we don't want everything, we don't want those people and things like that,
we just want the sessions, and we just want some of the fields.
We're going to create a new Directive, pick the Sessions database
and this time we're going to select the JournalEntry form, which is what stores the Session,
and then we'll just put a few of the fields in.
The idea here is to take some Notes data, and without having to have a Notes developer at all,
because not everybody has those anymore,
you can just specify the information you want and export a high fidelity version of that.
In this case, there's no rich text, so when we look at the CSV file
what we're going to find is just the items that we specified,
the session id, session title and session abstract.
We can pull that into DB2 or SQL Server and use that as we need it.
I've provided some links in the description below about how to take that CSV file
and easily put it into SQL Server or DB2.
Thank you for joining us, and visit us again at Mini-Lessons.info