"Stumbaum, Rainer" wrote: > Problem now with the data take-on is now, how to create the sales order using the >command line interface from within the customer and as well the already in reality >existing invoices. >
I don't know if this is helpful, or if you haven't already looked at it, but see the save_order function in SL/OE.pm and the post_invoice function in SL/IS.pm. If you can write the script to reproduce what's committed to the db as an "order" or "invoice", you should be set. This does involve multiple tables with links, so you'll want to understand what constitutes a "transaction". Watch your id's also- that needs to work the same as if someone sat down and typed each transaction in from the screen. I guess you're original question was has anyone done this. I haven't seen anything posted about it, but this is where I would start. HTH, Steve > > Hope it got clear now... > > Cheers > Rainer Stumbaum > > > -----Original Message----- > > From: Dr Default [mailto:[EMAIL PROTECTED]] > > Sent: Friday, July 05, 2002 1:34 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [SL] Data upload customer/sales order > > > > > > There MIGHT be a way to import the notes to payment condition fields, > > otherwiese I suggest to NOT import the notes and manually enter the > > payment conditions in the proper way, being as a payment condition > > rather than as a note? > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] On Behalf Of > > Rainer Stumbaum > > Sent: donderdag 4 juli 2002 22:50 > > To: [EMAIL PROTECTED] > > Subject: [SL] Data upload customer/sales order > > > > > > Hi, > > > > unfortunately the customer base I have to upload is > > quite big, so I already created the following script > > to upload a �-separated file: > > --- > > #!/bin/sh > > USER=bla > > PASSWD=blablabla > > export IFS=� > > cat KundenSQL.csv | while read NAME FIRMA STRASSENO > > PSTLZORT LAND CONTACT TELNO FAXNO EMAIL NOTES > > do > > echo ${NAME} > > ./ct.pl > > "login=${USER}&path=bin/mozilla&password=${PASSWD}&action=save_c > > ustomer&name=${NAME}&addr1=${FIRMA}&addr2=${STRASSENO}&addr3=${P > > STLZORT}&addr4=${LAND}&contact=${CONTACT}&phone=${TELNO}&fax=${F > > AXNO}&email=${EMAIL}¬es=${NOTES}&taxaccounts=1775&tax_1775=1" > > done > > --- > > This worked out fine, but now I have a problem with > > creating the already existing sales orders in SL: > > The notes in the customer contain the info on how the > > payment has to be done. As soon as I create a sales > > order from within the customer this is automatically > > copied to the sales order and from there into the > > invoice, where it then appears on the printout. This > > actually means I have to modify my script so it not > > only creates the customer, but within the same process > > as well creates the salesorder with maybe more than > > one line item. > > > > Has anyone done this before??? > > I am a little bit stuck right now... > > > > Best regards > > Rainer Stumbaum > > > > > > __________________________________________________________________ > > > > Gesendet von Yahoo! Mail - http://mail.yahoo.de > > Yahoo! pr�sentiert als offizieller Sponsor das Fu�ball-Highlight des > > Jahres: - http://www.FIFAworldcup.com > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Caffeinated soap. No kidding. > > http://thinkgeek.com/sf > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Bringing you mounds of caffeinated joy. > > http://thinkgeek.com/sf > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Bringing you mounds of caffeinated joy. > http://thinkgeek.com/sf ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Bringing you mounds of caffeinated joy. http://thinkgeek.com/sf
