Post it here for a good discussion. Mantis participation is sparse but technical. Github is for accepted code after peer review.
https://github.com/apmuthu/FA24extensions/pull/7
@apmuthu
I did those fixes It might still have other issues. in the end, this extension couldnt do what I wanted so I didnt use it to fully test it.
]]>Thanks you
]]>Check out plaid here
https://plaid.com
We should make a plaid banking plugin. I was thinking and looking into it but didn't feel like doing the work lol!
The import goes through and shows me the journal entries, but when I check the GJ reports none of the transactions are there. Debug mode shows no errors.
Any idea why the transactions are not getting written?
]]>Yes it did. For me it did not make sense as the error was coming from outside the Module and I think it is from the core. If you look at it the insert fields do not tally with what is in the csv file. Here is the error:
10-Nov-2023 01:31:32 Europe/Berlin] <b>DATABASE ERROR :</b> order Cannot be Added<br>error code : 1265<br>error message : Data truncated for column 'prep_amount' at row 1<br>sql that failed was : INSERT INTO 0_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date, order_type, ship_via, deliver_to, delivery_address, contact_phone, freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount) VALUES ('9','0','1', '30','1', '009/2017','auto','','2017-12-20', '1', '1','Donald Easter LLC','N/A', '', '0', 'DEF', '2017-12-20','4','70','')<br><br><br>And here's the contents of the csv file
customer_id,branch_No,reference,date,payment_id,sales_type_name,dimension_id,dimension2_id,item_code,item_description,quantity,unit,price,discountpercentage,freightcost,delfrom,deldate,delto,deladdress,contactphone,email,custref,shipvia,comments,ex_rate 1,1,009/2017,2017/12/20,4,Retail,,,202,Maintenance,2,Each,35,0,,DEF,2017/12/20,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,, 1,1,010/2017,2017/12/21,4,Retail,,,202,Maintenance,2,Each,15,0,,DEF,2017/12/21,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,,
Dunno if this is resolved yet...
That error is a DB column type issue or the column value exceeds the max length. Check database structure?
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
]]>10-Nov-2023 01:31:32 Europe/Berlin] <b>DATABASE ERROR :</b> order Cannot be Added<br>error code : 1265<br>error message : Data truncated for column 'prep_amount' at row 1<br>sql that failed was : INSERT INTO 0_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
order_type, ship_via, deliver_to, delivery_address, contact_phone,
freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount)
VALUES ('9','0','1', '30','1', '009/2017','auto','','2017-12-20', '1', '1','Donald Easter LLC','N/A', '', '0', 'DEF', '2017-12-20','4','70','')<br><br><br>And here's the contents of the csv file
customer_id,branch_No,reference,date,payment_id,sales_type_name,dimension_id,dimension2_id,item_code,item_description,quantity,unit,price,discountpercentage,freightcost,delfrom,deldate,delto,deladdress,contactphone,email,custref,shipvia,comments,ex_rate
1,1,009/2017,2017/12/20,4,Retail,,,202,Maintenance,2,Each,35,0,,DEF,2017/12/20,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,,
1,1,010/2017,2017/12/21,4,Retail,,,202,Maintenance,2,Each,15,0,,DEF,2017/12/21,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,,