IFKA

<accesscontrol>Main:MyGroup</accesscontrol>

Introduction

This is about my task working for Production. Converting data of 15 years from access db from IFKA into CG. And then, import data from CG back to ifka access db.

From IFKA into CG

1. Convert from access db into SQL server

Dennis helped me out of this. He restructures into CG format of table names and column names.

2. Generate data

In order to generate data in CG format, we need 2 things: SQL data and a data map excel file. Data: Contains the original data of ifka Data map file: Define mapping between values of ifka and values in CG.

Once we have them in hand, run the QSLGenerator to generate excel files. Which are then used to import into CG.

You should have a look at code of QSLGenerator, get the code here: \\catproc\share\IFKA

I did make the code however it was not in good shape of user usage. But it is fine and easy for a developer to use it.

3. Import into CG

The easiest part of the process. Use Import module of Data for a specific questionnaire.

THE MOST IMPORTANT IS THE MAPPING FILE.

From CG back to IFKA

Sometimes, Client wants to import data of a specific period of time to use their access program again.

Here are the steps you need to do:

1. Open the access db using access 95. Which is done in a virtual machine
2. Create a new survey for that period.
3. Base on mapping file, add questions for the survey using feature: Survey questions in access db
4. Use QSL Generator to generate the data file.
5. Once you have data, you can add each answer at one time, or import directly into db.