From: ExsonQu <hex...@gm...> - 2014-01-25 00:40:58
|
*Hi, gilberto dos santos alves,* Thank you for your reply. My purpose is to provide a daily job solution for weberp users to transfer PO from another company's webERP system to their own SO. It should be as simple as operate another feature in webERP instead of data migration which need other expertise such as sql. I'm not sure your solution is workable for this purpose? Thanks and best regards! Exson gilberto dos santos alves wrote > on this link [1] i put some spreadsheet used for migrations and for build > rules for source and target environments. > > Examples: > > PeopleSoft to SAP; > > SAP to legacy-Local-Home-system > > See that we map table,colum,attrib, (left side) (rule-number) on center > and > (target or to) (rigth side). > > Based on this all spreadsheet we build all sql need. > > All commands are ansi sql that could run on any ansi-sql-92 compliant. > > Data files may be .txt or .xml or .json transmitted by ftp or sftp or any > webservice. we use curl / wget for send and receive operations. > > On windows command (AT) and on linux CRONTAB > > regards > > Please if any doubts we should discuss or explain. > > > > [1] > https://docs.google.com/spreadsheet/ccc?key=0ArRGseydrhtydHRkdFFKcUJkaFVfeVkzU1BqOWI1MWc&usp=sharing > > > 2014/1/24 ExsonQu < > hexinfans@ > > > >> *Dear all:* >> >> Thank you very much for your feedback. >> >> After discuss with Steven, we bring out a proposal for >> this: >> >> 1. Add a QR code for PO pdf file, which contains all the >> information of the PO. (The QR code will be configurable of course) >> >> 2. Create a script to convert the QR code data to SO. One >> solution is use a QR reader of mobile device, another one is a QR code >> decoder(Not investigate yet) to parse QR code in the pdf file. >> >> Any comments are highly appreciated for this. >> >> Thanks and best regards! >> >> Exson >> >> >> >> >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657190.html >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> CenturyLink Cloud: The Leader in Enterprise Cloud Services. >> Learn Why More Businesses Are Choosing CenturyLink Cloud For >> Critical Workloads, Development Environments & Everything In Between. >> Get a Quote or Start a Free Trial Today. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> > Web-erp-developers@.sourceforge >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > -- > gilberto dos santos alves > +55.11.98646-5049 > sao paulo - sp - brasil > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@.sourceforge > https://lists.sourceforge.net/lists/listinfo/web-erp-developers -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Convert-PO-to-SO-tp4657164p4657192.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |