Title: | Original WSDRS FAA Data Import Instructions | |
---|---|---|
Owner: | Noreen Dertinger | |
Creator: | Noreen Dertinger | Jul 28, 2023 |
Last Changed by: | Noreen Dertinger | Jul 31, 2023 |
Tiny Link: (useful for email) | https://tcmarin.atlassian.net/wiki/x/AgDFrQ | |
Export As: | Word · PDF |
Incoming Links
BSD - Civil Aviation (1)
Importing FAA "SDR" Data to CAWIS |
Hierarchy
Children (33)
STEP 1 Empty the temp data table M70
STEP 2 Download the FAA data files
STEP 3 Extract the text files
STEP 4 Concatenate the Text files into a single file
STEP 5 Character replacement
STEP 6 EXCEL Processing
STEP 7 Make INSERT statements
STEP 8 Perform the Inserts
STEP 9 Parsing the Data
STEP 10 Allocating Standard CAWIS format SDR numbers
STEP 1 Empty the temp data table M70
STEP 2 Download the FAA data files
STEP 3 Extract the text files
STEP 4 Concatenate the Text files into a single file
STEP 5 Character replacement
STEP 6 EXCEL Processing
STEP 7 Make INSERT statements
STEP 8 Perform the Inserts
STEP 9 Parsing the Data
STEP 10 Allocating Standard CAWIS format SDR numbers
Labels
There are no labels assigned to this page.
Outgoing Links