=== ShipInfo Import Script ===
Start time: 2026-05-13 15:33:18

File found: /home/nmhdzhvc/public_html/parser/byStation/shipplotter_logs/shipinfo.txt
File size: 230,203 bytes

Database connected successfully

Starting import...
--------------------------------------------------------------------------------
Line 2: INSERT - MMSI: 304521000, Name: EIDER, Type: 79
Line 3: SKIP - MMSI exists (MMSI: 993686005, Name: ML)
Line 4: SKIP - MMSI exists (MMSI: 366978440, Name: MISSOURI)
Line 5: SKIP - MMSI exists (MMSI: 367313340, Name: VALERIE B)
Line 6: INSERT - MMSI: 538006351, Name: FEDERAL BEAUFORT, Type: 70
Line 7: SKIP - MMSI exists (MMSI: 316036228, Name: ALGOMA BUFFALO)
Line 8: SKIP - MMSI exists (MMSI: 366971370, Name: EDWIN H. GOTT)
Line 9: SKIP - MMSI exists (MMSI: 368317320, Name: SHIRLEY ANN)
Line 10: SKIP - MMSI exists (MMSI: 993683016, Name: RI)
Line 11: SKIP - MMSI exists (MMSI: 366999529, Name: CGC BUCKTHORN)
Line 12: SKIP - MMSI exists (MMSI: 367073840, Name: JAMES J. VERSLUIS)
Line 13: SKIP - MMSI exists (MMSI: 993672226, Name: DHBT)
Line 15: INSERT - MMSI: 338888000, Name: CLYDE S. VANENKEVORT, Type: 31
Line 16: INSERT - MMSI: 993682306, Name: 4, Type: 125
Line 19: INSERT - MMSI: 993682309, Name: 1, Type: 124
Line 20: INSERT - MMSI: 316002184, Name: CAPE DISCOVERY, Type: 51
Line 21: INSERT - MMSI: 366971350, Name: PHILIP R. CLARKE, Type: 70
Line 29: INSERT - MMSI: 368142030, Name: TALISMAN, Type: 49
Line 30: INSERT - MMSI: 366937490, Name: GL OSTRANDER, Type: 52
Line 32: INSERT - MMSI: 367046160, Name: ISLE ROYAL QUEEN IV, Type: 69
Line 44: SKIP - Navigation aid (MMSI: 338926283, Type: 0, Name: )
Line 65: SKIP - Navigation aid (MMSI: 368134280, Type: 0, Name: ELYSE NOELLE)
Line 72: SKIP - Navigation aid (MMSI: 367063240, Type: 0, Name: SUGAR ISLANDER II)
Line 117: SKIP - Navigation aid (MMSI: 316004055, Type: 0, Name: WILFRED M. COHEN)
Line 147: SKIP - Navigation aid (MMSI: 338010315, Type: 0, Name: NANCY D)
Line 188: SKIP - Navigation aid (MMSI: 366999402, Type: 0, Name: BILLMAIER)
Line 215: SKIP - Navigation aid (MMSI: 316011684, Type: 0, Name: COVE ISLE)
Line 248: SKIP - Navigation aid (MMSI: 367121010, Type: 0, Name: AMERICAN CENTURY)
Progress: 100 records inserted...
Line 264: SKIP - Navigation aid (MMSI: 369494413, Type: 0, Name: CG49413)
Line 292: SKIP - Navigation aid (MMSI: 367396130, Type: 0, Name: WILLIAM C)
Progress: 200 records inserted...
Progress: 300 records inserted...
Progress: 400 records inserted...
Progress: 500 records inserted...
Progress: 600 records inserted...
Progress: 700 records inserted...
Progress: 800 records inserted...
Progress: 900 records inserted...
Progress: 1000 records inserted...
Progress: 1100 records inserted...
Progress: 1200 records inserted...
Progress: 1300 records inserted...
Line 1710: WARNING - Invalid format (expected 10-11 fields, got 2) - Skipping malformed line
Progress: 1400 records inserted...
Progress: 1500 records inserted...
Progress: 1600 records inserted...
Progress: 1700 records inserted...
Progress: 1800 records inserted...
Progress: 1900 records inserted...
Progress: 2000 records inserted...
Progress: 2100 records inserted...
Progress: 2200 records inserted...
Progress: 2300 records inserted...
Progress: 2400 records inserted...
Progress: 2500 records inserted...
Progress: 2600 records inserted...
--------------------------------------------------------------------------------

=== Import Complete ===
End time: 2026-05-13 15:33:22

Summary:
  Total lines processed:     3,195
  Records inserted:          2,615
  Skipped (already exists):  447
  Skipped (navigation aids): 132
  Errors:                    1

Note: Only first 10 'already exists' messages shown
Note: Only first 10 'navigation aid' messages shown
Note: Only first 10 insert messages shown

Done!