Jason Rodrigues wrote:
> On Wednesday 03 January 2007 10:36, Charley Tiggs wrote:
>> Hello,
>> Have I left anything out? I don't have multiple warehouses so the
>> inventory table doesn't seem to come into play. Shipping/receiving is
>> not involved at this point, either.
>
> Genrally, you should avoid directly inserting/updating putting stuff right
> into the database.
>
> When you turn on the statement logging, you can get a pretty complete picture
> of what's going on, but it's not really the 'best' way right.
>
> We will be adding stored procedures to do many of the manipulations you
> describe, right in the db layer. Once that's togeather and working, You can
> connect directly to the database and use those SP's to manipulate the data.
>
> For now, I'd use the Chris' CLI tool in svn, (trunk/utils/cli) or the web
> api, where you just GET/POST urls to oe.pl. (I can get you an example later,
> don't have one handy right now)
>
> If you insert/update directly into the database, you'll have to carefully
> watch schema changes when you upgrade to ensure you continue to set the
> correct data. If you don't, you may find that one day you'll have a bunch of
> inconsistent data in your database. :(
>
> Also, in the next month or two, a REST API is coming, where you should be able
> to simply POST XML Sales order documents.
Jason,
Thanks for the response. But several things are putting me on this path:
1) I'm not all that savvy with Perl, though I'm learning lots while
working with LSMB;
2) I don't always understand how the code works within LSMB but I'm
slowly learning;
3) Because of 1 and 2, I sometimes spend up to 6 hours determining
whether it's user error (me) or a bug within LSMB.
At least, in reverting to using tools I know best (PHP, Postgres) for
the short term, I can at least program these pieces in such a way that I
can revert to using the "right way" when I finally figure out why using
the web api doesn't work for me in certain instances (I spent 4 hours
plugging at this last night without success and I still don't know if
it's a bug or user error.) or until v1.2 becomes stable.
Charley
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel