Ben Langhinrichs

Photograph of Ben Langhinrichs
E-mail address - Ben Langhinrichs






January, 2017
SMTWTFS
01 02 03 04 05 06 07
08 09 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31

Search the weblog





























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.


Export directive form

Copyright © 2014 Genii Software Ltd.

What has been said:

No documents found