In questo articolo
The GPT is only experimental: it might be subject to changes and improvements.
This GPT was created using ChatGPT and is designed to generate extensions for importing transactions from CSV files into Banana Accounting Plus. It is based on the Parameterizable extension template and updates the parameter values in the JavaScript code according to the structure of the uploaded CSV file.
Requirements
To use this GPT, you must have a ChatGPT Plus subscription. Without it, you can try the service for free for up to ten requests. After that, you’ll need to either upgrade to ChatGPT Plus or wait some hours before making additional requests.
How it works
- Open the Banana GPT from this link:
- In+the Message field at the bottom, enter the CSV file containing the transactions you want to import. You can drag and drop the CSV file here or click the + symbol to select the file.
- GPT will:
- Analyze the CSV file.
- Extract the necessary parameters.
- Column separator character.
- Text delimiter character for strings.
- Decimal separator character used for amounts.
- Line number where the column headers start.
- Line number where the data starts.
- Column name for the transaction date.
- Date format.
- Column name for the transaction description.
- Column name for the income amount.
- Column name for the expense/outcome amount.
- Column name for the external reference of the transaction.
- Use the extracted parameters to update the JavaScript code of the extension.
- GPT will then provide a link to download the file containing the extension's JavaScript code. The generated code should always be reviewed.
- Download the file, open it with a text editor, and copy all the code.
