Erik,
Thanks for responding. You got the two questions right. I need to
populate the parts table, and assign each part to a category
(partsgroup) along the way. My accounting background is rather
slim..... should new income and expense accounts be created? Or, use
existing (eg, Sales 4010 and Purchases 5010)? There are no services at
this point for the company.
I'd be happy to write it with you. I'm also new to Perl; I've been
using Python for years and was going to write the load script using a
tool like SQLAlchemy.
Thanks.
Brian
------------------------------------------------------------------------
Brian Wolf
Activus Technologies
Phone: 410.367.2958
Email: br...@activustech.com
Try out Activus Secure Payments^(TM), our recurring payments application.
Demo at http://demo.activustech.com
------------------------------------------------------------------------
On 07/19/2012 04:49 PM, Erik Huelsmann wrote:
Hi Brian,
On Thu, Jul 19, 2012 at 3:09 PM, Brian Wolf <br...@activustech.com
<mailto:br...@activustech.com>> wrote:
What is the best way to insert an associated photo in the
file_part table? Meaning, is there a way of duplicating the
upload feature?
Looks like there are three account numbers that should be
supplied. How are these determined?
inventory_accno_id integer,
income_accno_id integer,
expense_accno_id integer,
Am I correct to read at least two questions here?
1. How can I upload multiple parts (or maybe: how can I create an
initially seeded parts table)?
2. Once I have a parts table filled, how can I insert the pictures
belonging to these parts into the file_part table?
In order to be able to do (1) you indeed need to identify the accounts
to book inventory, income and COGS on. These IDs correspond to the ID
column from the 'account' table. If you intend to set up services, you
don't need to fill the 'inventory_accno_id' column.
As far as the upload of pictures goes: that's a bit tough, because the
data is encoded before it's sent to the database. You'd need to
duplicate the encoding (I think it's base64, but not sure) and do the
upload yourself... But maybe it's more practical that we write the
upload script together to allow you to write a script to drive a web
based upload to achieve the same purpose, much like the CSV uploads
for gl accounts and some other items that I wrote for 1.4?
Bye,
Erik.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
