Importing fuel records from EcoModder Forum

[RankoKohime]

I do not believe this to be an issue with Lube Logger, but rather with the format of the CSV I am trying to import. If it turns out to be a genuine issue, I will make one.

The EcoModder Forum has a fuel efficiency tracking feature in it's garage, and I'm looking to import my records into Lube Logger, however I'm having a bit of difficulty with it.

The log page has a spreadsheet-friendly fuel log output, which is to say, not CSV, but something to be pasted into a spreadsheet. Luckily I have meticulously kept the odometer mileage for each fillup in the comments, as the input form only accepts the delta, not total odometer.

If I structure it exactly like the sample shown on the import page, so like the following:

2023/11/24,408,10.393,$2.819,37.33,TRUE,FALSE,Started from 20 miles
2023/11/30,650,6.482,$2.819,37.33,TRUE,FALSE,
2023/12/10,961,7.974,$2.669,39,TRUE,FALSE,

It does not want to import, and I get the following errors in the terminal:

info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
      Request starting HTTP/1.1 POST http://n100-1:5000/Vehicle/ImportToVehicleIdFromCsv - application/x-www-form-urlencoded;+charset=UTF-8 86
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
      Executing endpoint 'CarCareTracker.Controllers.VehicleController.ImportToVehicleIdFromCsv (CarCareTracker)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102]
      Route matched with {action = "ImportToVehicleIdFromCsv", controller = "Vehicle"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult ImportToVehicleIdFromCsv(Int32, CarCareTracker.Models.ImportMode, System.String) on controller CarCareTracker.Controllers.VehicleController (CarCareTracker).
fail: CarCareTracker.Controllers.VehicleController[0]
      Error Occurred While Bulk Inserting
      System.ArgumentNullException: Value cannot be null. (Parameter 's')
         at System.Decimal.Parse(String s, NumberStyles style)
         at CarCareTracker.Controllers.VehicleController.ImportToVehicleIdFromCsv(Int32 vehicleId, ImportMode mode, String fileName) in /build/source/Controllers/Vehicle/ImportController.cs:line 458
info: Microsoft.AspNetCore.Mvc.Infrastructure.SystemTextJsonResultExecutor[1]
      Executing JsonResult, writing value of type 'System.Boolean'.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105]
      Executed action CarCareTracker.Controllers.VehicleController.ImportToVehicleIdFromCsv (CarCareTracker) in 3.7431ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
      Executed endpoint 'CarCareTracker.Controllers.VehicleController.ImportToVehicleIdFromCsv (CarCareTracker)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
      Request finished HTTP/1.1 POST http://n100-1:5000/Vehicle/ImportToVehicleIdFromCsv - 200 - application/json;+charset=utf-8 4.1183ms

Is there anything I can do to make it import successfully?

[daMihe]

CSV is not really standardized format for fuelings but for tabular data. So to import your data from any other source you need to prepare a spreadsheet semi manually and export it into CSV for LubeLogger.

I've done this for Fuelio using Libreoffice Calc, where all the data was exportable, however columns need to be resorted and renamed, some removed, some date formats needed to be translated. This is for one time a bit of work (did not write a script), but it's possible and faster than entering everything again by hand.