Why not just bring a programmer in ? Strip the raw data from the document, open Excel using VBA, and populate the spreadsheet ? And, as someone mentioned before, mayhap store the data in some sort of back in DB first, then export to Excel.
"Bryce K. Nielsen" <[EMAIL PROTECTED]> wrote: > We're trying to convert an inbound 830 into an excel spreadsheet. The > 830 is not mapped into the backend system, so it just comes into TLW. > We'd like to have an automated process whereby when the 830 comes in, > it is automatically converted to excel and emailed to a group of > people. Any ideas how to do this? Your help is appreciated! > xmlLinguist _may_ be a fit for you, as it will do what you need. I say "may" because it might seem like overkill, depending on what your other processes are, plus this is Windows dependant. xmlLinguist is a simple Text-to-Xml translator, so you can translate your 830 into XML, apply a stylesheet, and then using xmlLinguist, translate it back into CSV. All of this can be automated with VBScript, as demonstrated in one of our tutorials at http://www.sysonyx.com/xml-to-edi-850 . Or if you'd rather, SysOnyx is working on an EAI that can automate this process easier than using a VBScript, though we are in the early development stages now (see http://www.sysonyx.com/Products/xmlLynx/ for an idea of what we're working on). But again, this is really a "it depends" sort of answer. The best solution is probably seeing if your current EDI system can do this already. One thing I hate seeing in companies is multiple EDI platforms (and I see this a lot). It makes maintenance very difficult and a pain to train new guys on. The more consolidated you can get the better. Bryce K. Nielsen SysOnyx, Inc. (www.sysonyx.com) Makers of xmlDig, the XML-SQL Extractor http://www.sysonyx.com/products/xmldig . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L --------------------------------- YAHOO! GROUPS LINKS Visit your group "EDI-L" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less. [Non-text portions of this message have been removed] . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
