Transaction CSV Import issue

Self-Hosted | v5
1

Hello,

When I try to import transactions from my bank, I got the error message “wrong_file_extension”:
image

I tried with the file extension in upper letter, open it and export it again in csv, but nothing works.
Also, there is nothing in laravel.log for this issue.

I’m in the web version of the app (cannot install app from Microsoft Store).

Any ideas to solve this issue?
Inside the CSV, the column are separated by ;

Many thanks in advance!
Nicolas

2

Hi,

The app expects the file to use a comma as a seperator, it may explain the issue.

Are you seeing an error trying to install the app from the Microsoft store?

3

Hi,

Thanks for your reactivity!

I tried to replace ; with , in the file, but same error message. I also tried to change the GUI language, but it is not linked to the translation.

No error, but nothing happen when I try to download the app in the Microsoft Store. It’s not linked to Invoice Ninja install, but an issue with the store (I tried everything seen on internet to solve it, but nothing.) I saw that ppl already asked if a .msi would exist in the near future for the app, is it planned or not enought user need it?

4

What’s the name of the file you’re importing?

It may help to change to the Flutter web app.

We’re looking into making the Windows app available outside the store in the future.

5

I tried with:

  • ubs.csv
  • UBS.CSV
  • export.csv

I switched to the Flutter web app and the issue remain.

To import the transactions in the web app, I went to Transactions > Import.
I tried in Android App, but this option isn’t possible. So in Android, I went to Options>Import/Export and tried to import my CSV → it worked.

6

Thanks for the details! This could be a bug in the React app. cc @david @ben

Note: if it worked in the mobile app I’d expect it to also work in the Flutter app since they’re basically the same app.

7

In fact, the Import/export menu in Settings is not available in the web app:

image
image671×1083 29.4 KB

In the Android App, I imported the csv directly from the settings > Import/export

image
image258×520 27.4 KB

8

If you switch to the Flutter web app you’ll see the same Import/Export option in the settings.

9

Perfect. In Flutter that’s work. The problem only occurs in React. Thanks!

Edit: for those who need to switch back to Flutter → You need to change set_react_as_default_ap to “0” in the accounts table.

10

Hi,
I installed the docker App version of Invoice Ninja to give it a trial.
Like others before I get wrong_file_extension when trying to import transactions via CSV.

My details :
PHP
web: 8.3.9cli:
PHP 8.3.9 (cli) (built: Jul 5 2024 12:04:09) (NTS)
Memory: 128M
API: 5.10.8

11

@managedtechconz which browser were you using? We haven’t found the exact combination to recreate this issue. I believe it may only be impacting some firefox browsers.

12

Yes firefox. Latest version.

Ive allowed popups etc.

Noverrors except for the one referenced

13

Thanks, and out of interest, is there any special encoding on the .csv file or is it utf-8?

14

@david Is there any chance that such low memory could be causing the error depending on the size of the CSV file? I’ve used other PHP based web apps and if memory is too low, it throws an incorrect file extension and or other errors.

15

I think the issue is in the react application parsing the file.

We’ve had some others raise this one, but we have not been able to consistently replicate the issue.

The only hints are that it impacts some version of Firefox, but apart from that, we have no other hints.

1 Like
16

Same problem here, but switching to the Flutter app or Desktop app or from Firefox to Chrome did NOT solve it for me.