Invoice Software - Office 365 Or Purchase Software Suite?
-
@scottalanmiller Although the app is quite complicated the database schema is pretty straightforward, from reading your earlier notes you may be best off writing custom reports against the database. Note: this would only be possible using the self host version of the app.
If you have any questions I'm happy to help.
-
I am going to test it out. Signed up for my trail now.
-
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller Although the app is quite complicated the database schema is pretty straightforward, from reading your earlier notes you may be best off writing custom reports against the database. Note: this would only be possible using the self host version of the app.
If you have any questions I'm happy to help.
Was wondering if there was any way to access the DB, or better just an API, from the hosted version. The hosted pricing is so affordable it's hard to resist.
-
@Minion-Queen said in Invoice Software - Office 365 Or Purchase Software Suite?:
I am going to test it out. Signed up for my trail now.
On the trail of the trial. The spelling is the real trial.
-
I'm going to look at this self-hosted Invoice Ninja. I've never dabbled with PHP >= 5.5.9 and MySQL or even have a box with PHP on it. I'm going to examine and review all of the documentation and forums on the self-hosted Invoice Ninja and go from there.
-
@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:
I'm going to look at this self-hosted Invoice Ninja. I've never dabbled with PHP >= 5.5.9 and MySQL or even have a box with PHP on it. I'm going to examine and review all of the documentation and forums on the self-hosted Invoice Ninja and go from there.
PHP is surprisingly simple and reports are an excellent place to get started.
-
@scottalanmiller We have a REST API and a PHP SDK, more info here...
-
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller We have a REST API and a PHP SDK, more info here...
Awesome, even better. That would be the way to go! Stick with the hosted version, build a local reporting tool via the API.
-
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller We have a REST API and a PHP SDK, more info here...
Awesome, even better. That would be the way to go! Stick with the hosted version, build a local reporting tool via the API.
This, if it's an easy API, which most are, then developing your own reports against the it would be trivial. The missing fields may be a bit more difficult to overcome but that may be user training.
-
@coliver said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller We have a REST API and a PHP SDK, more info here...
Awesome, even better. That would be the way to go! Stick with the hosted version, build a local reporting tool via the API.
This, if it's an easy API, which most are, then developing your own reports against the it would be trivial. The missing fields may be a bit more difficult to overcome but that may be user training.
All still way above my skill level and time needed. Trying to collate all of this info and inform management so we can "sidetrack" from the requested "legacy" developer they wanted to hire.
-
@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@coliver said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller We have a REST API and a PHP SDK, more info here...
Awesome, even better. That would be the way to go! Stick with the hosted version, build a local reporting tool via the API.
This, if it's an easy API, which most are, then developing your own reports against the it would be trivial. The missing fields may be a bit more difficult to overcome but that may be user training.
All still way above my skill level and time needed. Trying to collate all of this info and inform management so we can "sidetrack" from the requested "legacy" developer they wanted to hire.
But WAY below the skill level needed to make and maintain the alternatives that were being proposed.
-
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@coliver said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
@scottalanmiller We have a REST API and a PHP SDK, more info here...
Awesome, even better. That would be the way to go! Stick with the hosted version, build a local reporting tool via the API.
This, if it's an easy API, which most are, then developing your own reports against the it would be trivial. The missing fields may be a bit more difficult to overcome but that may be user training.
All still way above my skill level and time needed. Trying to collate all of this info and inform management so we can "sidetrack" from the requested "legacy" developer they wanted to hire.
But WAY below the skill level needed to make and maintain the alternatives that were being proposed.
Agreed...just have to show management the time and resources needed for this project. But still going to enjoy my week off next week...
-
To keep things simple but flexible I'd suggest the following:
-
Use the self host version of our app with our automated Softaculous installer:
https://www.softaculous.com/apps/ecommerce/Invoice_Ninja -
Create reports using a graphical tool, there are some good options listed here:
https://www.quora.com/What-would-be-the-best-report-generator-tool-for-mySQL-DB-that-is-web-based-and-open-source
While you can create reports using our API it'd most likely be easier using the database.
-
-
@scottalanmiller said in Invoice Software - Office 365 Or Purchase Software Suite?:
@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:
I'm going to look at this self-hosted Invoice Ninja. I've never dabbled with PHP >= 5.5.9 and MySQL or even have a box with PHP on it. I'm going to examine and review all of the documentation and forums on the self-hosted Invoice Ninja and go from there.
PHP is surprisingly simple and reports are an excellent place to get started.
I am going to assume it would be best to put this on Linux correct? And if so, desktop or server edition?
-
@hillel369 said in Invoice Software - Office 365 Or Purchase Software Suite?:
To keep things simple but flexible I'd suggest the following:
-
Use the self host version of our app with our automated Softaculous installer:
https://www.softaculous.com/apps/ecommerce/Invoice_Ninja -
Create reports using a graphical tool, there are some good options listed here:
https://www.quora.com/What-would-be-the-best-report-generator-tool-for-mySQL-DB-that-is-web-based-and-open-source
While you can create reports using our API it'd most likely be easier using the database.
Great advice...thank you...
-
-
@garak0410 said in Invoice Software - Office 365 Or Purchase Software Suite?:
I am going to assume it would be best to put this on Linux correct? And if so, desktop or server edition?
Always Linux (or BSD) for "making it yourself" projects because you don't want to accidentally introduce any costly dependencies by accident.
Always server for non-GUI tasks. Developing on a Linux desktop, good. Developer for a Linux desktop, bad.
-
If you are going to host this yourself, you could put all of the components onto a tiny VM that you run internally. I assume that Invoice Ninja works well on CentOS 7, that's where I would look first.
-
Looks like CentOS 7 has too old of PHP to use without some extra work. But that's pretty easy if you do it from the beginning.
https://www.invoiceninja.com/self-host/
Good instructions there.
-
Testing a CentOS 7 install now.
-
Thank goodness for having a Scale cluster to test this stuff on
