Genii Weblog

Help needed in Lanes 1 and 2

Thu 20 Mar 2014, 10:01 AM



by Ben Langhinrichs
Yesterday, I laid out a roadmap for Genii Software, defining three lanes that we see companies fall into and how we aim to address the needs of those companies. Over the next few days, I will post a few examples to illustrate our goals.

Lanes 1 and Lane 2:Taking data from a Notes database to SQL server without Notes development

Problem: a company has a Notes database, and they need to take a number of fields of a specific form and put them into SQL Server tables. They may be migrating (Lane 1) or simply need it for a specific purpose (Lane 2), but have no Notes developers and don't want to hire consultants for a one-off need.

Solution: using the Midas LSX 5, a customer could download the Export to CSV sample database. All they would need to do is fill out an Export Directive form (see below) with the database and specify which forms and fields to export (or all of them, if they didn't know which are needed), then click the button. Importing the CSV into SQL server is easy, using a technique such as How to create and populate a table in a single step as part of a CSV import. There is no need for Notes developers, and the entire process can be done in an afternoon. This example includes a rich text field, which is rendered by default to high fidelity HTML.

Video demo

Export directive form

Copyright © 2014 Genii Software Ltd.

What has been said:

No documents found