search

powerpaul17 / nc_money

Nextcloud app for finance management
GNU Affero General Public License v3.0
97 stars 9 forks source link

Importing CSV - value's not imported #12

Closed pinkysworld closed 1 year ago

pinkysworld commented 1 year ago

Hi, importing is not working for values. It imports everything but the value is not stored.

image

Could add more fields or integrate the option to add more fields?

powerpaul17 commented 1 year ago

That's a bit difficult to debug without more information. Did you set the correct decimal separator? Can you provide me with a line from your CSV file. You can of course strip out any private information, I just want to see how it's formatted.

pinkysworld commented 1 year ago

Yes, I selected the correct decimal separator. I attached it for you. ums.CSV

powerpaul17 commented 1 year ago

Ok, thanks for the file. I tried it and it works, I get a value of 200.00. Did you choose the "Betrag" column for both "Haben" and "Soll"? Because then the value would be 200-200=0 again...

pinkysworld commented 1 year ago

Haha yes I did.

powerpaul17 commented 1 year ago

Ok, good.. 😅 But I will definitely think about improving the import dialog/workflow since there can be some confusion..