Spaces
Apps
Templates
Create
BSD - Civil Aviation
All content
Space settings
Shortcuts
How-to articles
How-to articles
This trigger is hidden
Content
Results will update as you type.
Civil Aviation IT Portfolio
Applications
•
Files for testing various types of attachment in CIVAV Apps
•
Server Paths
•
CLASSIC ASP apps in Civil Aviation
Decommissioned Applications
2FA - A2F
•
2FA Web Proxy - Proxy Web A2F
•
AASFTD - DEVSAA
•
AIRA External - RIAA Externe
•
AIRA Internal - RIAA Interne
AMES - STEA
•
AP FCL - PA LMEC
•
APPORG - ORGACC
APSD - PAPS
•
ARASS - SNARA
•
BSIS External - RIOM Externe
BSIS Internal - RIOM Interne
•
CADLIS - SILDAC
CADORS - SCRQEAC
•
CAETAS - SAFAC
•
CAME Search - Recherche MEAC
CAMIS - SIMAC
CAOAR
CAPMS - SGPMC
•
CARAC NPA Ext - CCRAC APM Ext
•
CARAC NPA Int - CCRAC APM Int
•
CARS Exemption - Exemption RAC
•
CAS
•
CATS - STAC
CAWIS Int - SWIMN Int
•
CAWIS_DBRESX
•
CAWIS_PasswordCycler
•
CAWIS_TFS14402
CAWIS - DATA ELEMENTS
Importing FAA "SDR" Data to CAWIS
•
Manual preparation of WSDRS-FAA data
Original WSDRS FAA Data Import Instructions
•
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 11 Text field Cleanups
•
STEP 12 Check for NON-American tail marks
•
STEP 13 INCOMPLETE MANUFACTURER/MODEL DATA
•
STEP 14 AIRCRAFT MANUFACTURER/MODEL
•
STEP 15 AIRCRAFT SERIAL NUMBER
•
STEP 16 AIRCRAFT MANUFACTURER AND MODEL CONVERSION
•
STEP 17 ENGINE MANUFACTURER AND MODEL CONVERSION
•
STEP 18 PROPELLER MANUFACTURER AND MODEL CONVERSION
•
STEP 19 UPDATE MANUFACTURER TEXT
•
STEP 20 EQUIPMENT/COMPONENT DATA CONVERSION
•
STEP 21 SDR_PRODUCT_CODE
•
STEP 22 REGION CODE
•
STEP 23 ATA/JASC CODES
•
STEP 24 NATURE CODES
•
STEP 25 ACTION TAKEN CODES
•
STEP 26 WHEN_DISCOVERED and HOW_DISCOVERED
•
STEP 27 CARRIER CODES
•
STEP 28 AIRCRAFT-ID
•
STEP 29 REVIEW ALL MODELS
•
STEP 30 SDR TEXT
•
STEP 31 SDR INSERT ROUTINES
•
STEP 32 DATA VERIFICATION
•
STEP 33 BACKOUT ?
Transport Canada (TC) / Federal Aviation Administration (FAA) Web Service Difficulty Reporting System (CAWIS/WSDRS) Data Export Procedures
Transport Canada Continuing Airworthiness Web Information System (CAWIS) Weekly Annual Airworthiness Information Report (AAIR) Data Extract Procedure
•
Transport Canada Continuing Airworthiness Web Information System (CAWIS) Monthly Annual Airworthiness Information Report (AAIR) Data Extract Procedure
CAWIS 5008/FLIGHT-HOURS DATA EXTRACTION/CORRECTION REQUESTS
CAWIS SDR DATA EXTRACTION REQUESTS
CAWIS/WSDRS USERID MAINTENANCE GUIDELINES
•
CAWIS TEST REGIONS - Data Refresh Procedures
•
CAWIS 5008 FILE MAINTENANCE
CAWIS MANUFACTURER/MODEL TABLE STANDARDS
CAWIS NOTIFICATIONS
CAWIS (AD) AIRWORTHINESS DIRECTIVE MODULE
CAWIS (AAIR) ANNUAL AIRWORTHINESS INFORMATION REPORTING
CAWIS (AMOC) ALTERNATIVE MEANS OF COMPLIANCE MODULE
•
X CAWIS (MDM) MAILING AND DISTRIBUTION MODULE
CAWIS (PTS) PROJECT TRACKING SYSTEM MODULE
•
CAWIS (SIGS) SPECIAL INTEREST GROUPS MODULE
CAWIS (TSB) TRANSPORTATION SAFETY BOARD PROJECTS MODULE
•
X CAWIS (WSDRS) WEB SERVICE DIFFICULTY REPORTING SYSTEM
•
X CAWIS REPORTS MENU
•
X CAWIS DAILY CCARCS/CAWIS SYNCHRONIZATION JOB
•
CAWIS RESOURCE MONITOR - SYSTEM MESSAGING AND LABELING
•
X CAWIS MULTIPLE FUNCTIONS OF Z980_TERM_CONVERSION
•
CAWIS Internal - interface not properly displayed.
•
CAWIS - configuration settings for Dev and Acc (TR47_CAWIS_GENERAL_PROPS and web.config)
•
CAWIS not picking up .pdf files from tctestmaster
•
CAWIS/AAIR Notification maintenance
•
AAIR custom report for Last Hours and Report Dates flown by aircraft
•
CAWIS Letter distribution bug
•
Publishing CAWIS External and Internal
CAWIS Ext - SWIMN Ext
CAWIS EDM - SWIMN MDE
CAWIS MDM - SWIMN MDC
CCAR Web - Web RACC
CCARCSE - RIACC
DAPLS - SDLPA
DAPLS-MPDIS - SDLPA-SDDPM
DIS - SID
eMER - eREM
•
EMS - SIGAL
EPLI
FOAEA - AEOEF
FTAE - FVEA
GALRO - AGLIE
•
GALRO Admin - AGLIE Admin
•
INMAGIC
•
MD-M - RM-M
MMEL - LPEM
•
MPM - MPC
•
Multitrans (MTS)
NACIS - SINCA
NAPA - SNAPA
•
NASD - BDNSA
NASD-NET External - BDNSA-NET Externe
•
NASD Admin - BDNSA Admin
NASIMS - SGINSA
Show more below
Blogs
BSD - Civil Aviation
/
/
Original WSDRS FAA Data Import Instructions
/
STEP 8 Perform the Inserts
Summarize
STEP 8 Perform the Inserts
kurt.martin
Owned by
kurt.martin
Last updated:
Aug 10, 2021
1 min read
Loading data...
Paste the INSERT statements (or drag Data.txt) into Sql developer or TOAD execute and commit.
{"serverDuration": 12, "requestCorrelationId": "864d4a2b299144ffb29ac8142c5077c8"}