Data Import - Technical Congress 2019 Hands-On Lab
- Jason Hoekstra
- Chris Moffatt (Deactivated)
Overview
The Data Import solution is a project to simplify the loading of CSV data to the Ed-Fi ODS / API. The solution loads data for domains where vendor integration to the Ed-Fi APIs is inchoate or non-existent, for example, from legacy data sources such as transportation systems. It does so by providing methods to extract and transform information from spreadsheet-based data (CSV files) for loading to the Ed-Fi ODS / API.
Data Import is a C# .NET solution with a web administration panel in ASP.NET to view data and job status, and server components as .NET command-line applications to process data. Data Import is intended to be used by system IT administrators and technical data analysts, in service of Local Education Agency (LEA) and State Education Agency (SEA) needs where directly integrated API solutions do not exist.
Resources and Pre-Requisites
You will need access to Ed-Fi ODS / API 2.5 instance for this lab
- It is preferred that you use your instance if available: /wiki/spaces/ODSAPI25/overview
- (lab API instance information removed)
Lab Exercises
- Exercise #1 - Install and Setup Data Import
- Exercise #2 - Setup Bootstrap Data
- Exercise #3 - Create Sample Data Map
- Exercise #4 - Add an Agent File Handler for the CSV File
- Exercise #5 - Run the Transform Load Job to Import CSV Data
The following link is a ZIP archive containing executables for the Data Import tool