Hi,
Thanks for the time for heading me out to help me and others in a similar bind. Really trying to import line items in invoices from FreshBook with the possibility of adding time into the InvoiceNinja tasks (since the line items include that information).
Using the Freshbook import utility did not include invoice line items or tasks even though Freshbook has a table with all invoice line items. More of that is all the very bottom.
So to retrieve the column header names InvoiceNinja uses, I did an Export Data in InvoiceNinja, Selected, CSV, and marked “All” After a day all freshbook data was in the a 11 tabbed InvoiceNinja CSV. However, there is no import option to take the exported InvoiceNinja CSV data to do an import. It only allowed uploading individual CSVs Clients, Invoices, Products, Expenses and that method did not work out.
I have all data inserted as csv matching the InvoiceNinja CSV field names. What other options are available?
I was considering using zapier.com in hopes that it would transfer existing invoices. And if it doesn’t I was going to setup another freshbooks account and import all data from my existing and have it tied to zapier so it would run the action of new invoice creation and add to invoiceNinja. But I can’t figure out how to get a /api/v1 on my self-hosted install. Is it with the SDK? I uploaded the files to /InvoiceNinja/sdk-php but it doesn’t give me any option to install or configure when I access any of those php files from the browser.
One option maybe if it sounds possible :
Is there any function available within InvoiceNinja or outside of it, to allow me to generate a JSON from one CSV with 11 tabs? If not, what are maybe the fields in Json where so I can add all data from Freshbooks matching each column in Json to then do an import?
Another option if you know of one that could do this:
Export Freshbook into another system (Zoho, Hiveage, etc…) then use the InvoiceNinja to import from that platform?
I wouldn’t see how it’s not possible to export line items from Freshbook as it contains a table along with other details of line items.
I’ve exported all tables from Freshbooks and opened in Excel. They have a separate table called InvoiceLine containing fields to like InvoiceID, Name (In InvoiceNinja it is called a Task), Description (Invoice line item), Unit Cost (it includes dollar amount of anexpense, dollar amount of one set rate, or dollar amount of hourly rate), Qty, Type (Values are either Item, Time, or Expense), Client ID, InvoiceNumber, InvoiceAmount, Status (paid, sent, viewed, draft), Invoice amount, Invoice date (Created Date)