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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
