Ok I think I'm getting somewhere finally. Aerodonkey thanks so much for the extra logging tip. It's failing because it's not finding my customer ID. So I assumed that the customer_id in the spreadsheet was the debtor number. Is this correct? Or is there some other customer ID.
1 03/16/2024 04:58:39 pm
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
2 11/30/2023 01:47:49 am
Re: Random timeout issue (5 replies, posted in Installation)
I'm having the same issue. If you can provide some guidance on how to configure a cron job to do this, I'd really appreciate it. I know how to setup a cron job and I know the syntax, but an idea of what the cron job is supposed to do would be super helpful.
3 11/27/2023 02:55:36 am
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
I don't get any errors. Even with one record, just nothing happens when I press the button.
I do however get an error in my sales orders (when I go and check after wards)
processing_end(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "import_sales_cart" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide an autoloader to load the class definition in file: /share/MD0_DATA/Web/frontaccounting/sales/includes/sales_ui.inc at line 32
4 11/08/2023 01:39:34 am
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
Thanks @poncho1234, I have thousands of transactions to import, I'm just testing with the first 5 to see if I can make it happen. So far not working. I've checked my import file so many times now. The dates are correct format, the codes are all correct in all the columns. My only remaining question is am I supposed to include the column titles in the csv?
I've tried everything I can think of and nothing is working.
5 11/06/2023 02:06:46 pm
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
Ok so I managed to get PHP 7.4 working on my NAS. So the import transaction module seems to be working, sort of. However, no transactions are imported and nothing happens with dry run.
I'm trying to import my transaction history from years back. I'm thinking could this be the problem? Do I need to open accounting years back in history? Is this even possible to import historical transactions?
6 11/06/2023 01:16:34 am
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
Ok, here's an example: /modules/import_transactions/includes/import_sales_order_entry.inc
PHP 8.2 produces deprecation warning for line #11. The constant must be moved to the end. Moving $freightcost=0 to the end removes the warning:
function can_process($line, $customer_id, $branchNo, $reference, $date, $dimension_id, $dimension2_id, $delfrom, $deldate, $delto, $deladdress, $contactphone, $email, $custref, $shipvia, $comments, $exrate, $freightcost=0) {
There are other instances of this throughout this file.
7 11/06/2023 01:13:00 am
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
Hmm not sure what you mean by first constant. There are suggestions of commenting out:
function preventHijacking()
{
if (!isset($_SESSION['IPaddress']) || !isset($_SESSION['userAgent']))
return false;
// if ($_SESSION['IPaddress'] != $_SERVER['REMOTE_ADDR'])
// return false;
if ( $_SESSION['userAgent'] != @$_SERVER['HTTP_USER_AGENT'])
return false;
return true;
}
I tried that and it makes it worse. It logs me out and then I can't log back in.
I'm on VPS Centos7 with WHM/Cpanel. I have SSL setup but just can't seem to click on anything without getting logged out. When I log back in, it takes me to what I clicked on, but clicking on anything else, logs me out again.
8 11/04/2023 05:30:01 pm
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
thanks @kvvardha I'm finding all kinds of deprecations with 8.2. I've fixed a bunch in my installations. Should I post them on Github or Manits? or Here? How is the best way to communicate these kinds of code changes to the dev team? Most of them are minor. I just changed a bunch of variables in functions where the required variable has to go last in 8.2 ie: function_name( $a, $b=5, $c) needs to be function_name ($a, $c, $b=5) type of thing. I fixed a bunch of those.
9 11/02/2023 11:10:36 pm
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
I'm on PHP 8.2 but I also tried on 7.4 and 8.1
I just can't seem to make any headway. On my webserver, it keeps kicking me out every 10 seconds or so and I have to login again.
The version installed on my NAS seems to work much better but I can only use PHP 8.2. Neither work to import the sales transactions.
I've read the instructions, they seem kind of sparse. Is there any tips? I have all the right headers, my chart of accounts are created, my debtor master is populated, just nothing happens when I try to import transactions. I installed the import transactions module directly from inside FA. Is there more updated or better version on Github?
10 10/30/2023 09:01:37 pm
Re: Import Transactions not working (26 replies, posted in Modules/Add-on's)
Thanks @kvvaradha, I suspected that, so I also installed it on my webserver which I can downgrade the PHP version. I tried PHP 7.4 That had the same result.
11 10/29/2023 06:11:34 pm
Re: Is FrontAccounting right for me? (8 replies, posted in Installation)
Thanks for you input. I've spent all weekend trying to import Sales Invoices. I exported from QB, formatted all the data but when I click import, nothing happens. (I opened another thread for that).
When I try to enter a Sales Invoice manually I get...
Unhandled exception [0]: The script tried to modify a property on an incomplete object. Please ensure that the class definition "import_sales_cart" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide an autoloader to load the class definition. in file: /share/MD0_DATA/Web/frontaccounting/sales/includes/sales_ui.inc at line 32
I have it installed on my local QNAP webserver. Sometimes this can be wonky, So I also installed it on my cpanel webserver for testing. Everytime I try and save a setting it logs me out and timeout pops up (even though I managed to edit the timeout settings)???
So far I haven't been able to do anything but import my customers and items directly in the database.
Am I doing something wrong? Are others using this successfully in a production environment?
(Sorry, not trying to be critical, just frustrated at the moment).
12 10/29/2023 04:41:59 pm
Topic: Import Transactions not working (26 replies, posted in Modules/Add-on's)
I'm on the latest version (oct 2023). I'm trying to use the import transactions feature. I have about 5 sales transactions to import. I've formatted my data like the example. However after I select the file and click process transactions (with or without the trial run selected) the spinner comes up on the screen and nothing happens.
I am getting some warnings in the log but I don't think they are fatal. I also tried uploading a document, so I don't think it's a permission problem for upload (BTW where do these files upload to?)
Can anyone help or give me ideas what to try next. I'm trying to move stuff over from QB and this is my first hurdle!
[30-Oct-2023 00:10:27 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_repgen::$path is deprecated
[30-Oct-2023 00:10:27 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_items::$path is deprecated
[30-Oct-2023 00:10:27 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_multijournalentries::$path is deprecated
[30-Oct-2023 00:11:36 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_transactions::$path is deprecated
[30-Oct-2023 00:11:36 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_repgen::$path is deprecated
[30-Oct-2023 00:11:36 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_items::$path is deprecated
[30-Oct-2023 00:11:36 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_multijournalentries::$path is deprecated
[30-Oct-2023 00:11:37 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_transactions::$path is deprecated
[30-Oct-2023 00:11:37 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_repgen::$path is deprecated
[30-Oct-2023 00:11:37 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_items::$path is deprecated
[30-Oct-2023 00:11:37 Asia/Taipei] 1::hooks.inc:245:[before upgrade] Creation of dynamic property hooks_import_multijournalentries::$path is deprecated
[30-Oct-2023 00:14:51 Asia/Taipei] 1:admin:frontaccounting.php:66: Creation of dynamic property front_accounting::$renderer is deprecated
This is the relevant function: (line 245 is the last nine before the first closing bracket.
// install hooks provided by active extensions
if (isset($installed_extensions) && !empty($installed_extensions)) {
foreach($installed_extensions as $ext) {
$hook_class = 'hooks_'.$ext['package'];
if ($ext['active'] && class_exists($hook_class)) {
$Hooks[$ext['package']] = new $hook_class;
$Hooks[$ext['package']]->path = $ext['path'];
}
}
}
}
13 10/24/2023 01:09:08 am
Topic: Is FrontAccounting right for me? (8 replies, posted in Installation)
I've been doing a bit of research on FrontAccounting, I've installed it on my sever and have been playing with it for a few months.
I currently use Quickbooks but am kind of fed up being tied to them and their ever increasing prices. Also I have the desktop version so the idea of a web based solution is kind of good for me.
I was hoping some members could comment if this is a good fit before I start trying to migrate all my data. First, I'm experienced in developing in PHP, MySQL, HTML, CSS, and a bit of JS. I build WP websites, I use SuiteCRM and develop in that so I'm thinking FrontAccounting would be a good fit. Who knows I might be able to contribute.
My business is in Canada.
Does FA work well with GST/HST and keeping track of remittances to the Government?
I have some clients in the US, does it work well with multi-currency?
I have two employees, I currently do payroll transactions manually in QB, is this fairly easy to replicate in FA?
One great feature of QB is to download and reconcile bank transactions. Does this work similar in FA?
Is there anything else I should know before diving in?
Any guidance would be greatly appreciated.