search

crater-invoice / crater

Open Source Invoicing Solution for Individuals & Businesses
https://craterapp.com
GNU Affero General Public License v3.0
7.62k stars 1.53k forks source link

Bulk Data Import #1217

Open rigg77 opened 1 year ago

rigg77 commented 1 year ago

Describe the solution you'd like I would love to be able to import a CSV file for bulk ingestion. For example, importing expenses from a company card, or adding items in bulk instead of building one at a time. Basically you would be able to upload a CSV, define the relationship of CSV fields and SQL columns, and it would add each line/row as an item or expense.

Describe alternatives you've considered It might also be great to have bulk expense and item editing in-app as a spreadsheet. JSON or worst case YAML or XML would also be acceptable, but both the ease of access (export CSV from any spreadsheet app) and relative ease of translation of CSV to SQL make it ideal.

martindmtrv commented 1 year ago

Also looking for this feature!

As a temporary solution you could write a script and bulk import by making calls to the backend APIs