Hi,
I'm Getting the following errors, when running an import on two seperate imports.
Warning: Missing argument 15 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186
( ! ) Warning: Missing argument 16 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186
( ! ) Warning: Missing argument 17 for Import::process(), called in /var/mydbr/lib/import.php on line 91 and defined in /var/mydbr/lib/import.php on line 186
------------------------------
DROP PROCEDURE IF EXISTS sp_DBR_Import_Receipt_Bank
$$
CREATE PROCEDURE `sp_DBR_Import_Receipt_Bank`()
BEGIN
select 'dbr.import.options', 'format', 'csv';
select 'dbr.import.options', 'csv_delimiter', ',';
select 'dbr.import.options', 'csv_enclosure', '"';
select 'dbr.import.options', 'skip_header', 1;
select 'dbr.import', 'sp_DBR_Import_Receipt_Bank_Data_do' ,'https://reports.shopaardvark.com/user/receipts.csv', 'now';
END
$$
------------------------------
DROP PROCEDURE IF EXISTS sp_DBR_Import_Receipt_Bank_Data_do
$$
CREATE PROCEDURE `sp_DBR_Import_Receipt_Bank_Data_do`(
receipt_bank_id varchar(100),
invoice_type varchar(20),
invoice_date datetime,
invoice_due_date datetime,
invoice_number varchar(100),
supplier varchar(100),
category_nominal varchar(100),
client_sage_supplier_code varchar(100),
project_t_code varchar(100),
payment_method varchar(100),
bank_account varchar(100),
vat decimal(10,2),
net decimal(10,2),
total decimal(10,2),
currency varchar(10),
vat_gbp decimal(10,2),
net_gbp decimal(10,2),
total_gbp decimal(10,2),
rb_status varchar(20),
notes varchar(20),
description varchar(20)
)
begin
SET max_sp_recursion_depth = 15;
/* Do some checking / modifications here */
INSERT INTO c93_icon_live.aardvark_purchase_invoices (receipt_bank_id, invoice_type, invoice_date, invoice_due_date, invoice_number, supplier, category_nominal, client_sage_supplier_code, project_t_code, payment_method, bank_account, vat, net, total, currency, vat_gbp, net_gbp, total_gbp, rb_status, notes, description)
VALUES (receipt_bank_id, invoice_type, invoice_date, invoice_due_date, invoice_number, supplier, category_nominal, client_sage_supplier_code, project_t_code, payment_method, bank_account, vat, net, total, currency, vat_gbp, net_gbp, total_gbp, rb_status, notes, description)
ON DUPLICATE KEY UPDATE
receipt_bank_id=VALUES(receipt_bank_id),
invoice_type=VALUES(invoice_type),
invoice_date=VALUES(invoice_date),
invoice_due_date=VALUES(invoice_due_date),
invoice_number=VALUES(invoice_number),
supplier=VALUES(supplier),
category_nominal=VALUES(category_nominal),
client_sage_supplier_code=VALUES(client_sage_supplier_code),
project_t_code=VALUES(project_t_code),
payment_method=VALUES(payment_method),
bank_account=VALUES(bank_account),
vat=VALUES(vat),
net=VALUES(net),
total=VALUES(total),
currency=VALUES(currency),
vat_gbp=VALUES(vat_gbp),
net_gbp=VALUES(net_gbp),
total_gbp=VALUES(total_gbp),
rb_status=VALUES(rb_status),
notes=VALUES(notes),
description=VALUES(description);
end
$$
------------------------------
Any help is appreciated.
Best Regards
John
