search

AlfHou / hammond

Self hosted vehicle and expense management system. Like Clarkson, but better
GNU Affero General Public License v3.0
142 stars 19 forks source link

Help needed - CSV import always fails #91

Open thehijacker opened 10 months ago

thehijacker commented 10 months ago

Hello,

This looks like a well maintained project and would like to self-host it. Got it up and running using docker image, but now I wish to import from some site I was using before (poraba.com).

I have all the data in csv but everytime I try to import I get an error (There was some issue with importing the file. Please check the error message). But log shows no error.

Can you provide a sample CSV that actually imports so I can edit mine with same column names, delimiter and proper values?

Find my latest csv attempt that failes to import here:

dataExport_4.csv

Thank you.

alienp4nda commented 10 months ago

v0.0.21 has an import issue and v0.0.22 has a ui build issue. As soon as #89 gets merged this will be fixed.

I will double check this is true with your file later today.

thehijacker commented 10 months ago

Great. I hope merging will work and I can soon start using it. What are the needed columns for CSV file?

If I understand correctly, my wife can also create an account to use it to track her cars fuel consumption?

Also I kindly ask if you can add Slovenian translation. Made it for her as her English is not that good and I want it to be as easy as possible for her.

Thank you!

alienp4nda commented 10 months ago

This in reference to using the generic importer. The name of the fields in your csv doesn't matter so long as they can map to the corresponding fields listed below. The ones with required next to them must have a corresponding field in your csv, again name of the field doesn't matter.

fuelQuantity required perUnitPrice required totalAmount required odoReading required isTankFull required missedFillup comments fillingStation fillupDate fuelSubType (i.e. Octane)