Import Transactions (Page 3 of 7)

Look in the modules folder's sub-folder of the extension used. The name of the extension's folder path is listed in the installed_extensions.php file.

I seem to be having issues under 2.4.1 with regards to importing transactions.
When I try import the transactions I have the following:

An initial error pops up about the use_popup_window.
That line can be commented out and appears to have no impact.

Then on the actual import there is an error that references: mysql_fetch_assoc() expects parameter 1 to be resource, object given in file: /home/briteacc/public_html/gdp/modules/import_transactions/includes/import_transactions.inc at line 635

And followed up with: Call to undefined method references::exists() in /home/briteacc/public_html/gdp/modules/import_transactions/import_transactions.php on line 246

I have been using this module for about 3 years (since my previous posts) and its been great and all of a sudden I have this error under 2.4.1

Is it perhaps replacing sql with sqli in the opening lines of modules/import_transactions/includes/import_transactions.inc?

Will download the update and try and confirm that it works.

THanks.

After the above I replaced all modules with this contained in the folder FA24extensions-33822bf1787e1c92e59f44c298bf8c48b644dedf.

I also turned on debugging which shows:

include_once(../../includes/db/references_db.inc): failed to open stream: No such file or directory in file: /var/www/html/account/modules/import_transactions/import_transactions.php at line 39
include_once(): Failed opening '../../includes/db/references_db.inc' for inclusion (include_path='.:/usr/share/php') in file: /var/www/html/account/modules/import_transactions/import_transactions.php at line 39
include_once(../../includes/manufacturing.inc): failed to open stream: No such file or directory in file: /var/www/html/account/modules/import_transactions/includes/import_sales_order_ui.inc at line 14
include_once(): Failed opening '../../includes/manufacturing.inc' for inclusion (include_path='.:/usr/share/php') in file: /var/www/html/account/modules/import_transactions/includes/import_sales_order_ui.inc at line 14
Undefined variable: use_popup_windows in file: /var/www/html/account/modules/import_transactions/import_transactions.php at line 68

Any further suggestions please>

Hello your message at Today 04:06:52 pm (CAT) refers. "The file includes/db/references_db.inc was in FA 2.3.x but is not there in FA 2.4.x anymore."

Thank you but how do I fix it?

We need to find equivalents in the reflines class for the functions in the old file.

The popup problem has been sorted out.

All FA 2.4.x extensions are in my unofficial repo. Fork it and get your developers to work on them and submit pull requests to incorporate them in the upstream.

As FA 2.4.1 has just been released officially a few weeks ago, the extensions will need time to be tested for compatibility. My unofficial repo has the individual files only and they will need to be manually installed till they get into the official pkg repo.

There are other issues in getting this module to work in FA 2.4.x FA installs that are being worked upon. @braathwaate's fork of the unofficial FA24 extensions repo has some developments you may wish to partake of.

Those using FA 2.4.1+ please provide feedback on the latest import_transactions module in the unofficial GitHub FA 2.4 extensions  repo - this is a "fixed" version of the pkg in the official repo. This contains the mods / fixes by @braathwaate cleaned up for whitespace and spaced indentations.

You may not have applied the correct version of import_transactions/import_transactions.php.  Lines 63 to 68 of the said file should be:

all_delete($yes = false);
$js = "";
if ($SysPrefs->use_popup_windows) 
    $js .= get_js_open_window(800, 500);
$help_context = "Import General Journals  / Deposits / Payments / Bank Statements / Sales Orders / Sales Invoices  <a href='spreadsheet_headers.html'>Help: Formats</a>";
page(_($help_context), false, false, "", $js);

All modules must be unzipped into the <FA_WebRoot>/modules/ folder to be usable. When installed and activated, they must find an entry in the relevant installed_extensions.php files.

Clear the browser cache and try anew.

Oh I also made all the modules RW.