Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Colin Law]

On 22 February 2018 at 18:36, Fran_3 via gnucash-user <
gnucash-user at gnucash.org> wrote:

>  Scott,
> Thanks for your comments. As I mentioned to Adrien, I don't think I'm
> going to charge off and start developing my own gnuCash queries using any
> tool. We are going to just use it out of the box and develop work-arrounds
> where necessary
>

In that case I don't think there is any point doing anything other than
sticking to the default XML format.

Colin


> We are still learn the application but so far really like it.
> Thanks again for the help.
> Fran3
>
>     On Thursday, February 22, 2018, 10:31:02 AM EST, Derek Atkins <
> warlord at MIT.EDU> wrote:
>
>  Hi,
>
> Fran_3 via gnucash-user <gnucash-user at gnucash.org> writes:
>
> >  Re: Converting to MySQL...
> > When I develop in MySQL on Windows I install IIS localhost server and
> MySQL... but that is not practical on other office computers.
> > 1 - I'm not familiar with sqLite but a quick Google makes me think it is
> a way to run MySQL on a local PC without running server software like
> IIS... right?
> > 2 - Or is sqLite a desktop version of MySQL that requires no server?
> > 3 - Also, it looks like PieCash is a collection of Python programs...
> right?
> > 4 - And if so then you simply have to have the Python interrupter
> installed on your machine and then run the appropriate PieCash program
> after editing in the name and path to the gnuCash file... right?
> > Thanks again Adrien.
> > Fran3
>
> SQLite is not MySQL.  And MySQL is not IIS.
>
> SQLite is a software library than implements a SQL-based DB within a
> local file.  So from a USER'S perspective, you get a single file (just
> like you get a single file with the current XML backend).  However
> internally the data is stored and accessed like a SQL datastore.
>
> Down the road, I expect SQLite to become the "default" storage
> mechanism, because you get all the benefits of SQL (save-on-commit, etc)
> without the drawbacks of requiring a DBA or running server that you need
> to configure.
>
> For #3/#4, yes, PieCash is a python library that re-implements a bunch of
> gnucash functionality.  Note that it does NOT use the GnuCash API, so
> it's quite possible that using PieCash could destroy your data.  YMMV.
> You are safe using it for read-only purposes.
>
> The GnuCash developers always say that the only supported means to
> manipulate your GnuCash data is via the GnuCash API.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/   PP-ASEL-IA    N1NWH
>       warlord at MIT.EDU                        PGP key available
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>