• From: USA, WI, Balsam Lake
  • Registered: 04/26/2022
  • Posts: 6

Topic: Import Transactions

I've been using "Version 2.4.5 Build 16.03.2020" since 2016 on a computer running an End of Life version of Linux.  I recently built a new computer with a more recent version of Linux and installed "Version 2.4.18 Build 03.04.2024" of FA.  I exported the entire database from the old computer and imported it into the new one using PHPAdmin.  Everything seemed fine.

However, when I attempt to "Import Transactions" the "Import Settings" screen will not changes the "Control Accounts" when switching the "Import Type" (drop down list) from "General Journal Processing" to any of the following:
- Deposit Processing
- Payment Processing
- Sales Order Processing
- Direct Sales Invoice Processing

Instead, it continues to show "Receivable Account Default" and "Payable Account Default"

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,227

Re: Import Transactions

Use the bleeding edge FA v2.4.18+ available at:
https://github.com/FrontAccountingERP/FA/archive/refs/heads/master.zip
as it has the latest fixes.

Check your PHP versions across the installs.
Check the DB Structure changes since then.

Also checkout the fixes in the Import Transactions extension module files from
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_transactions

apmuthu's Website

  • From: USA, WI, Balsam Lake
  • Registered: 04/26/2022
  • Posts: 6

Re: Import Transactions

On the new Linux computer, the version of PHP is 8.2.28.  On the old Linux computer, the version of PHP is 5.6.40.

Where do I check for DB Schema changes?

  • From: USA, WI, Balsam Lake
  • Registered: 04/26/2022
  • Posts: 6

Re: Import Transactions

I have installed the very latest FA v2.4.18.... and still I get the same results.

The "Import Type" changes to "Deposit Processing", but it will not change the "Control Accounts".

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,227

Re: Import Transactions

DB Schema changes can be gleaned from DB Structure backup (phpMyAdmin, SQLyog or any MySQL Client) of old and new installs and compared say using WinMerge, Diff, ExamDiff, etc.

Check for "Deposit Processing" and "Control Accounts" strings in the core module files.

Try to install PHP 5.6.40 in the new one and see if it works.
https://askubuntu.com/questions/761713/how-can-i-downgrade-from-php-7-to-php-5-6-on-ubuntu-16-04
https://stackoverflow.com/questions/59781992/how-can-i-downgrade-or-use-php-7-2-without-uninstalling-php-7-4-is-it-possible

apmuthu's Website

  • From: USA, WI, Balsam Lake
  • Registered: 04/26/2022
  • Posts: 6

Re: Import Transactions

It does not appear that there have been any schema changes from "Version 2.4.5 Build 16.03.2020" to  "Version 2.4.18 Build 03.04.2024".

  • From: USA, WI, Balsam Lake
  • Registered: 04/26/2022
  • Posts: 6

Re: Import Transactions

I did a test of the "Version 2.4.18 Build 03.04.2024" on the old Linux computer:
1. created a "accounting_test" database
2. copied the entire "FA-master.zip" to the web server "root" directory and unzipped it
3. Changed the permissions accordingly on directory levels
4. Ran the "Install" and indicated "accounting_test" as the database [my production database name is "accounting"]
5. Installed and Activated the same list of Extensions - including the "Import Transactions" program
6. Updated the "Access Setup" for the user to include the "Import Transactions" program
7. Ran the "Import Transactions" program on the "Version 2.4.18 Build 03.04.2024" on the old Linux computer
8. Changed the "Import Type" (drop down list) to "Deposit Processing"
RESULT-> successfully displayed the "Bank Accounts" and the drop down list to display/choose a bank account

I then repeated the above steps on the new Linux computer.
RESULT-> Failure.  It would NOT display the "Bank Accounts" and drop down list

CONCLUSION:
There must be an issue with in the "import_transactions.php" code that doesn't work in PHP 8.2.28.  Looking back in the "CHANGELOG.txt" file that was included with "Version 2.4.18 Build 03.04.2024" and I noticed a few references to "Fixed more php 8.2 deprecation bugs" and "Additional fix for php=>8.2".  I suspect this may be the issue with this module.

It is not an option to install PHP 5.6.40 on the new Linux computer.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,227

Re: Import Transactions

Compile and install PHP 5.6.40 from scratch. What is the linux version on your old and new computer? As MySQL versions too would have changed, check out the differences between the installs.

apmuthu's Website