Import simpleinvoices data

I know this is a long shot but hoping someone may have encountered this. I have been using simpleinvoices for about 4 years and looking to witch to invoiceplane. Has anyone attempted to import data from simpleinvoices? Not that I am shy of being first, but if someone blazed that trail, I would love the feedback.

Thanks

@davidcrown I wonder if you got an anwer to this question as it has been a while now. I am in the same juncture now.

@kenyatopup can you export simpleinvoices to csv files?

Yes I can. I can dump the entire DB into CSV or select specific tables and export to CSV.

This eill be your starting point:

https://wiki.invoiceplane.com/en/1.6/system/importing-data

It will show a couple of files you can use to import data.
If that’s not good enough:

  • empty InvoicePlane database
  • simpleinvoice database

open them up in phpmyadmin side by side
insert into ip_database.(table_name) select (fields from simpleinvoice)

You’ll have to match InvoicePlane’s table structure, so i always export the structure of the table to the screen and then find the fields of the other database’s table (hope that makes sense)

I understand what you mean. It just looks quite onerous for a rookie like me.

As soon as you have the proper files from that link i gave you the steps are easy.

The biggest step ks tl get the information from simpleinvoice into the files from the link i gave you.

I would use ms excel.
That way you can easily cut out the columns that cannot be imported.