Path: csiph.com!usenet.pasdenom.info!news.redatomik.org!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.003 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'url:sourceforge': 0.03; 'xml,': 0.05; 'automate': 0.07; 'great.': 0.07; 'wrong,': 0.09; 'xml.': 0.09; 'python': 0.11; 'random': 0.14; 'adam': 0.16; 'from:addr:awilliam': 0.16; 'from:addr:whitemice.org': 0.16; 'from:name:adam tauno williams': 0.16; 'given,': 0.16; 'gpg': 0.16; 'missing?': 0.16; 'rarely': 0.16; 'receive.': 0.16; 'received:72.14.190': 0.16; 'received:72.14.190.87': 0.16; 'received:mail.wmmi.net': 0.16; 'received:wmmi.net': 0.16; 'reply- to:addr:awilliam': 0.16; 'reply-to:addr:whitemice.org': 0.16; "someone's": 0.16; 'subject:XML': 0.16; 'subject:when': 0.16; 'url:py': 0.16; 'xslt,': 0.16; 'all.': 0.16; 'so.': 0.16; 'wrote:': 0.18; 'trying': 0.19; 'developer,': 0.19; 'url:default': 0.19; 'club': 0.24; 'stick': 0.24; 'williams': 0.24; 'file.': 0.24; 'push': 0.26; 'tables': 0.26; 'header:In-Reply-To:1': 0.27; 'url:code': 0.29; 'xml': 0.29; 'database,': 0.30; 'work.': 0.31; 'usually': 0.31; '-0700,': 0.31; 'file': 0.32; 'text': 0.33; 'everyone': 0.33; 'checking': 0.33; 'received:72.14': 0.33; 'maybe': 0.34; 'basic': 0.35; 'problem.': 0.35; 'no,': 0.35; 'operations': 0.35; 'usual': 0.35; 'there': 0.35; 'largely': 0.36; 'doing': 0.36; 'subject:?': 0.36; 'wrong': 0.37; 'received:10': 0.37; 'easily': 0.37; 'being': 0.38; 'to:addr:python-list': 0.38; 'rather': 0.38; 'does': 0.39; 'to:addr:python.org': 0.39; 'easy': 0.60; 'most': 0.60; 'entire': 0.61; 'simple': 0.61; 'url:p': 0.64; 'provide': 0.64; 'header:Reply-To:1': 0.67; 'normal.': 0.68; 'wish': 0.70; 'reply-to:no real name:2**0': 0.71; 'walk': 0.74; 'goal': 0.75; 'abc': 0.84; 'fast,': 0.84; 'suppliers': 0.84; 'url:actions': 0.84; 'xslt': 0.84; 'reliable,': 0.93; 'ultimate': 0.93 Subject: Re: Is it normal to cry when given XML? From: Adam Tauno Williams Reply-To: awilliam@whitemice.org To: python-list@python.org Date: Tue, 05 May 2015 06:20:28 -0400 In-Reply-To: References: Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAIAAADYYG7QAAAAA3NCSVQICAjb4U/gAAAJjElEQVRYw70Za0gUXXvmrLraqmmmpmVt2IWUlSLIyhATDLt4CRLqR1lUWJSFIdHNhEgsNwwl0TDLLBBLKUOlqNTUvBKUlZaXvLSVqK0puro7c2a+H0/f6bwzs5vv9+N7fogz+5znPPfbsIIgMDZBFMWcnBy1Wn348GHm/wCiKIqiKAiCqAQY48bGRjs7u6SkJI7jxL+BIAhAyhpBOb7kjZ0oiizLAnOCIPA8jxBSqVQsywJ2eno6xrirqwshJIoikYRlWfqRBkEQ4DihbANf+hJjLPwXMMZms9lsNgMrPM8XFRWpVCqGYdzc3CYnJwkmUQZ5BHXaQCBo9D9wKa0whpyZmJjgOI6m0tHR4ezsTORLSUnheV7xPgnQ9/1bfIbGlmjr1KlToB4AtVo9NDQkp06fsnafbc3RRBCxIsuytMl//fpVVFSEMSZvLBZLYWEhSEMbnT6l6Bb0o7Wf/hCRmxke8/LyJDexLOvj46NoNYmNFH0F/pF4jByfkXucIAgWiyU4OFgxgm7duiVnQiKM5I6/mpIOe0ZCDoLlzJkzckMAaDSagoICid/YdmGO46qrq/v6+iTalYeeIAiMPE319PTYSKQsy6pUqsrKytlkPyJheHi4g4NDeXn5X3MjI9fk5cuX/5rfFy1a9PTpU8X4ktvo5cuXarWaYRhHR8cTJ078+PGDqEoOjERvPM+vXLmS1oe9vf3q1asDAgJ8fHwcHBxYlkUIwd+HDx9ijGk/lcs9NTUVGBhICCKEQkJCTCYTz/OKSmIkGaWqqgohBId9fX3T0tL6+/s5jsMY8zw/ODh4+/bt2NhYjUbDsqyLi8vx48e/fPmiKCvwmpycLDe6Tqdrb29XzOz/KK4Wi2Xp0qVElHv37tFykLi1WCwtLS3z58+H1OXn51dVVUVLCaR5nq+qq rLmiOvWr TOZTHIlMfRN9fX1JDWvWrXKZDIphjTA+Pj41atXXV1dAT84ODg7O7uysvLt27e1tbX379+PjY11dHS04YinTp2CYkUTZ2gNHzx4kKgnPz/fdkEAhY+NjR04cICuMP8K9u7dOzY2JnVqUquXLFlCGOrt7aV1w/M8z/Ny/wXOjhw5YoMnlmU1Gs3evXuzsrKysrLi4+OdnZ0Bn2XZ69evKzg1xri6upoQDQoKoiu/2Wy+efPmyZMnr1y5Mjw8DEFL69lisZw7d06eS6HapKenf/36FeSBu4xGY0pKCuAvXry4u7ubODhDWp+IiAhCKC0tjU4VycnJRKD169ePjo7Kcw/HcfJqo1KpXr9+rZiuOI7z9/cHtMDAwOnp6X/UsoGBAQcHB2Kvuro6iC9BENra2uzs7Gih/fz8Ghoa5E1Fc3Ozu7s7raejR48SbiT4GOP09HRy4507d8Amvxl6/PgxST8ODg60KHq9Xu4Wy5Yts1gscNm7d+/6+/sB+ePHj6Sn02g0g4ODNordwMAAEXXNmjV/GMIYnzt3js6H9OGEhAQ5QwihuLg4yAtmszkiIqK3txdIpaamQiq3EackUIiVEUKZmZk8zzNgzoiICKJqrVZLH4uJiVGMHZVKVVFRAUzcuHFj9+7dEIMTExNeXl5arRbyO50qR0ZGDAaDxWIhxLOzs4knqNVqg8Hwm6EFCxaQm7RaLe2G4eHh1uJ53759EDtGo9Hb27utrQ3k7ujouHjxIq2Szs7OyMhIR0dHlUoVGRk5Pj4O79+/f0/73LVr1xhBEMrLy+m33t7eNK2oqChrDLm6ukLEiaIYHR0dFhYGjiUp2AaDgVQkUEZ4eDhJK9AIAKxYsYIRBGHPnj00Qwghmtz+/futMYQQKi4uBszz588zDFNUVCQpfxzHbdu2Td4NDw8Pyxlyd3dHHMfV19dLGu+urq7fWYFhaOHkA+Hjx49BJatWrWIY5tixYwaDgWaos7Pz+f Pn1kZEsB 15s3XrVjQ8PPzt2zfJYNDW1kYm2oCAABvFqLm5GWq+VqtlGGZycvLBgwdkhmFZtra2luM4a2MJ9DZEbdHR0ejz589y9uvq6si4s3bt2jlz5thYDQDf/v7+MCyXlZXRtamjo0NeUpycnMBSHz58INyEhobu2LGDKSgokF8zf/78mZkZEq7Hjh2z1vMvXryYdD+QyRBCb968IQxt3rxZfiooKAhK086dO+HNvHnzRkZGRFFEQ0ND8gNGo7Gnp4dIf/bsWV9fX0WeXF1dwQmgjoLOMjMzSayNjY3JK25MTAzLslNTU69evYKUlpyc7ObmJooio7j1QQjl5OSQbIQxLisrU2wwMjIyCNrq1avJ+w8fPkALu3HjRskRDw8P6IGKi4vBfHq9HrKlIAhoZGREMXygfIJjIoRiY2Nzc3MlPKnV6vj4eDKDz507l/zU398PB0lpI+qJiopycXERRbG2thYhlJSUlJSUZGdn95tOSEiIonN4eXnBXoY0hxjjwsJCcivLsgkJCXTbRI8rer0eTJaRkUGqJJi4oaEBYzwzM7N8+fLDhw+TrP27H7KWZliWbW1tlQwGGONPnz4dOnRIp9NdunTJZDIBAtwNkQ9w+vRpODU5OblhwwbgSaPRNDU1wZFnz54lJiZK6p0oiszChQutMXThwgXSHNL9g2RrAwhTU1N0zt23bx+9ecrNzU1LS2tpaSFny8vLf/78KW9ObHXgOp0OLMLzfFNTE20d+RDS3t5On42PjxdmAfJNCLLBUGdn55MnT4Dr+vr6xMREKAuKa56SkhL6jZubm+0FAb1ytbarVAj+OXPmQL7q6+tTqVQ+Pj7d3d3ytWtNTQ0dYgzDpKamKq4irO2H/jT5er3e3t7eBls5OTnQM5WUlLi4uHh4eOzatSsvL+/FixfNzc2lpaVHjhyhvQegtLRU+J+AEQShtbV106ZNdHBKisP3799hts/NzbVWQ2hzeHl5gV7lKynFXZb CFtZoNK5 du9YaT1u2bCGpaPv27fQQomhoGPVnuQZV0BDcND09nZ6e7uzsLNcBQujRo0dQCvr6+uLi4qzxBIlYsl6e/b72zxgELHMcNzo6GhYWJr8pPDwcchLGmOM4MlJJwNvb22Aw0Nlr9p8ZAFSpqam0JpycnHbu3BkYGGg2m7u7u8lPBoMBYxwaGooQQgitW7cuKirK09NzZmaGZVmMsU6nS0hIuHv3rqenJ2362YY0+fYgF4KoNz8/38PDgxRUhFBNTY3ikhXqkbVvMXJ8az4uiiKruNUmX154nm9sbGxqamptbe3s7PT396+oqAAFSA4SzwNB6U8t8JP8keDQyP8BCciofEZhq20AAAAASUVORK5CYII= Content-Type: text/plain; charset="ISO-8859-1" X-Mailer: Evolution 3.12.11 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.20+ Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 61 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1430822460 news.xs4all.nl 2907 [2001:888:2000:d::a6]:54709 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:89956 On Tue, 2015-05-05 at 02:28 -0700, Sayth Renshaw wrote: > Just checking if the reaction to cry when given XML is normal. No, not at all. I leap for ecstatic joy when given, as all to rarely happens, XML. Rather than someone's turdy text [which includes JSON] file. I wish all 1,200+ of my vendors and suppliers would provide their data in XML rather than the random swirl of bizarre crap I receive. > I thought maybe I am approaching it all wrong, using lxml largely or > some xquery to club it into submission. I do most of my processing with LXML, XSLT, and XPath. Fast, efficient, reliable, works great. And it is easy to abstract these tools to automate what I need to do over and over again. > See the usual goal is just to take the entire XML and push it into a > database. I do a lot of pushing into an SQL database, no problem. XSLT does 99.4% of the work. > See its never basic xml, "basic xml"? > usually comes from some database with a walk of tables and strange relationships. No problem. > Am I doing it wrong is there a simple way I am missing? I suspect so. Data is easily transformed into abc stanley ... And then that data can be processes as SQL insert/update/delete/upsert operations while being swung around on the end of a stick while you dance. XML is the ultimate file "format". It solves problems, much better than everyone trying to re-engineer their needs INTO a format [like JSON]. -- Adam Tauno Williams GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA