eGCA Online Flight Log Upload

Follow

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

eGCA_Portal_download_template.png

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.

Copy_and_Paste.gif

 

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:

drop-down_list.png

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.png  Screenshot_2021-01-03_at_6.53.13_PM.png

Date Format

  • DD-MMM-YYYY is the correct format

Time Format

  • HH:MM is the correct format 

 

Change the format cell on Microsoft Excel

Format_Cell_on_Excel.png

Note: Other spreadsheet applications should have a similar feature

0 out of 0 found this helpful

Comments

2 comments
  • validation creating an error

    0
    Comment actions Permalink
  • Hello captainsaurabhgoel

    Please create a support ticket and our team can help out. I would also suggest attaching the file to the ticket.

    0
    Comment actions Permalink

Please sign in to leave a comment.