Migrate FusuionInvoice1.3.5 to InvoicePlane 1.2.2

gistfile1.txt

First Step: Migrate Tool
Second Step: Setup of InvoicePlane

Additional SQL Commands:

ALTER TABLE `ip_invoices` ADD `invoice_status_id` TINYINT(2) NOT NULL DEFAULT '1' AFTER `client_id`;
ALTER TABLE `ip_quotes` ADD `quote_status_id` TINYINT(2) NOT NULL DEFAULT '1' AFTER `client_id`;

set all invoices to status "paid" (sent=2):

UPDATE `ip_invoices` SET `invoice_status_id` = 4;

as some tables were not created, rerun the insert sql script and replace CREATE TABLES by CREATE TABLE IF NOT EXISTS to prevent errors if tables were already created:

# wget https://raw.githubusercontent.com/InvoicePlane/InvoicePlane/master/application/modules/setup/sql/000_1.0.0.sql
# wget https://github.com/InvoicePlane/InvoicePlane/raw/master/application/modules/setup/sql/003_1.1.0.sql
# sed -i "s/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g" 000_1.0.0.sql 
# mysql -u user -p YOURDB < 000_1.0.0.sql

also run 003_1.1.0.sql command by command and ignore errors