DGCA require all crew members to upload their flight log to eGCA online portal
If you have entered all the information into LogTen Pro, you will be able to extract all the information, paste it to the eGCA file, and upload it to the system. Please follow the steps below
1. Download eGCA Bulk Excel file
After logging in to the online portal, please go to
Fill E-Log Book >> Scheduled/ Non-Scheduled/General Aviation >> Previous Entry >> Next >> Bulk Excel Upload
Select "Click here to download template" to download the BulkUpload_eLogbookExcelLayout_V2.xlsm file
Note: The file contains formulas that do not work on Microsoft Excel on Mac or Apple Numbers
2. Install eGCA custom report for LogTen Pro
Click here to go to the install page
Related Articles: Custom Reports / Report FAQ's / Spreadsheet Export
Once installed, you will find the custom report under Reports >> My Reports
You will then be able to generate a spreadsheet file in TXT simple format. You can open up the file in any spreadsheet application.
3. Copy and Paste your flight logs to eGCA spreadsheet file
Open up the "Export Flights - India DGCA (Tab).txt" file using any spreadsheet application.
Open up the "BulkUpload_eLogbookExcelLayout_V2.xlsm" using the same spreadsheet application.
Copy all the flight log entries to the BulkUpload_eLogbookExcelLayout_V2 file.
4. Verify your copied data
Because this XLSM file format is not supported by Apple apps, all the buttons like "Validate" and "Add New Row" do not work. They simply just shown as a text box.
Use the first line of entry to verify your data is correctly formatted. Click through each box to ensure nothing is missed. For the column of Class of Aircraft, you should see a box on the side with a triangle. This means it is a drop-down list with specific options.
Here is an example:
Under the Flight Type column >> Click on the triangle >> Drop-Down List showed for selection
Here is a list of the column with Drop-Down List:
- Column B - Performed On
- Column E - Class of Aircraft
- Column F - Category of Aircraft
- Column G - Pilot Function
- Column I - Flight type
- Column J - Purpose
- Column S - I.F.
- Column V - Shift time
5. Set correct Dates and Times format
eGCA bulk file requires a specific format for Dates and Times. When you open up the TXT file, the dates and times format may be changed due to the spreadsheet application default format.
Date Format
- DD-MMM-YYYY is the correct format
Time Format
- HH:MM is the correct format
Change the format cell on Microsoft Excel
Note: Other spreadsheet applications should have a similar feature
Comments
validation creating an error
Hello captainsaurabhgoel
Please create a support ticket and our team can help out. I would also suggest attaching the file to the ticket.
Please sign in to leave a comment.