# Issue in selecting file type when import bank statements in OFX format

**URL:** https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786
**Category:** User
**Tags:** accounting
**Created:** [February 9, 2021, 8:35am UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786 "2021-02-09T08:35:58Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![chrisexner](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/c/7ba0ec/32.png) [@chrisexner](https://discuss.tryton.org/u/chrisexner)
#### Post date: [February 9, 2021, 8:35am UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786/1 "2021-02-09T08:35:59Z")

</div>

In Release 5.8.x I would like to Import Bank Statement in OFX-Format.  
All the accounting\_statement\_xxx Modules are activated in the Instance.

Problem:  
Often but not always the Dropdown to select the type of file (aeb, ofx,…) to import only contains one “empty” option for selection.

In Windows client the Dropdown contains the correct set of Filetypes as long as there is not selected a File to import. After selecting the file, I experience the behavior described above.

In sao-Client I always experience the behavior described above.

In general selecting type of file before selecting file to import using the windows client can be used as a workaround. File with Bank Statement will then be imported properly.

Any hints to me, if I am doing something wrong?

Thanks…  
Chris

---

<div class="post-metadata">

### Author: ![udono](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/udono/32/2114_2.png) [@udono](https://discuss.tryton.org/u/udono)
#### Post date: [February 9, 2021, 9:08am UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786/2 "2021-02-09T09:08:35Z")

</div>

Hi,  
Can you reproduce the issue with the [demo server](https://demo5.8.tryton.org)?  
How did you install Tryton?  
Did you restart the server after the module installation?  
Did you install all other Python dependencies like ofxparse, lxml \>=2.0, \< 4.4; python\_version == “3.4”  
S.a. [https://hg.tryton.org/modules/account\_statement\_ofx/file/tip/setup.py#l48](https://hg.tryton.org/modules/account_statement_ofx/file/tip/setup.py#l48)

---

<div class="post-metadata">

### Author: ![chrisexner](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/c/7ba0ec/32.png) [@chrisexner](https://discuss.tryton.org/u/chrisexner)
#### Post date: [February 9, 2021, 10:53am UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786/3 "2021-02-09T10:53:52Z")

</div>

Uhh, sorry - looks like I failed massively in installing tryton.

Demo Server is working well. Can choose from two File Formats regardless of whether a file was previously selected.

Server is installed by myself in venv. All Tryton Components installed using pip3. Executed by uwsgi. Separate worker and cron processes.

Server process was restarted after module installation.

I checked the modules dependencies but ignored the version numbers. Thought, setup will check for that.

So actually running python 3.7.3 in venv with lxml 4.6.2 and ofxparse 0.2

---

<div class="post-metadata">

### Author: ![chrisexner](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/c/7ba0ec/32.png) [@chrisexner](https://discuss.tryton.org/u/chrisexner)
#### Post date: [February 9, 2021, 11:59am UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786/4 "2021-02-09T11:59:53Z")

</div>

Python 3.7.3 seems not to be problematic in this case.

Downgrading lxml from 4.6.2 down to 4.4 solved my issue.

Thanks @udono for your helpful hints.  
Chris

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [March 11, 2021, 12:00pm UTC](https://discuss.tryton.org/t/issue-in-selecting-file-type-when-import-bank-statements-in-ofx-format/3786/5 "2021-03-11T12:00:03Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
