julien-nc / cospend-nc

💰 💲hared budget manager Nextcloud app
GNU Affero General Public License v3.0
235 stars 29 forks source link

Import invoice date from csv file #122

Open YannickV29 opened 2 years ago

YannickV29 commented 2 years ago

Hello, I'm a new user to Cospend. I was used to use Tricount and I would like to keep the histroy. I've exported my data from Tricount and manage to import them into Cospend but the date is incorrect. I've converted the Tricount date field in Cospend date (with "-" as separator). I didn't know what to put in timestamp field so I just copied from an existing line and the expected date where not taken into account. Instead, it was the existing line date. How can I import the correct invoice date into Cospend? Thank you in advance for your help Yannick Nextcloud version : 23, Cospend version : 1.4.4 (not sure), database type : cloud Nextcloud via Zaclys, browser name and version : Firefox 97.0

julien-nc commented 2 years ago

Hey, If you want the "date" column to be used, the "timestamp" column must not exist. Timestamp in used in priority.

If you provide some tricount (dummy/anonymized) test data, we could make it possible to directly import such files in Cospend.

YannickV29 commented 2 years ago

Thank you Julien! It worked well. I manage to upload all my file with proper dates in Cospend 🙂

Le sam. 19 mars 2022 à 04:20, Julien Veyssier @.***> a écrit :

Hey, If you want the "date" column to be used, the "timestamp" column must not exist. Timestamp in used in priority.

If you provide some tricount (dummy/anonymized) test data, we could make it possible to directly import such files in Cospend.

— Reply to this email directly, view it on GitHub https://github.com/eneiluj/cospend-nc/issues/122#issuecomment-1072928343, or unsubscribe https://github.com/notifications/unsubscribe-auth/AX3H5EVKUNI5OD2ZK3BH23DVAVBW7ANCNFSM5O24NI4A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>