Skip to Content

Repeatable File Import Process

Introduction

This video will review creating a repeatable front-end flat file import process that can be initiated from a Vinyl app.

Process Overview

  • If it doesn't already exist, create a table to store the final import data.
  • If it doesn't already exist, create a session table to manage the user's import session and import file.
  • Create a staging table that matches the import file.
  • Register a Local File System for the Import and Complete folders for pre- and post-processing.
  • Create a page to manage the import process.
  • Create Import and Merge Events to move and normalize the data.