<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Simone Belometti on Medium]]></title>
        <description><![CDATA[Stories by Simone Belometti on Medium]]></description>
        <link>https://medium.com/@simone.b?source=rss-e16887fa1441------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*Tih8vtkaTDEHAF-l</url>
            <title>Stories by Simone Belometti on Medium</title>
            <link>https://medium.com/@simone.b?source=rss-e16887fa1441------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 18:57:09 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@simone.b/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Harnessing the Power of OPC-UA with Python: A Practical Guide]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Have you ever heard of OPC-UA? Whether you&#x2019;re an industrial automation enthusiast or just curious to learn something new, you&#x2019;re in the&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@simone.b/harnessing-the-power-of-opc-ua-with-python-a-practical-guide-570603ddae8e?source=rss-e16887fa1441------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@simone.b/harnessing-the-power-of-opc-ua-with-python-a-practical-guide-570603ddae8e?source=rss-e16887fa1441------2</link>
            <guid isPermaLink="false">https://medium.com/p/570603ddae8e</guid>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[opc-ua]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Simone Belometti]]></dc:creator>
            <pubDate>Mon, 30 Oct 2023 09:46:01 GMT</pubDate>
            <atom:updated>2023-10-30T09:46:01.820Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Using Modbus with Python: A Practical Guide for Implementation]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@simone.b/using-modbus-with-python-a-practical-guide-for-implementation-770ac350ec0d?source=rss-e16887fa1441------2"><img src="https://cdn-images-1.medium.com/max/900/1*09C87If0AbT3_ONHRNDeCQ.png" width="900"></a></p><p class="medium-feed-snippet">The Modbus protocol is an industry-standard widely used for communication between electronic devices, particularly in industrial&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@simone.b/using-modbus-with-python-a-practical-guide-for-implementation-770ac350ec0d?source=rss-e16887fa1441------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@simone.b/using-modbus-with-python-a-practical-guide-for-implementation-770ac350ec0d?source=rss-e16887fa1441------2</link>
            <guid isPermaLink="false">https://medium.com/p/770ac350ec0d</guid>
            <category><![CDATA[modbus]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[plc]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[iot]]></category>
            <dc:creator><![CDATA[Simone Belometti]]></dc:creator>
            <pubDate>Wed, 17 May 2023 08:39:12 GMT</pubDate>
            <atom:updated>2023-05-17T08:39:12.773Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How to query Oracle JDE E1 database]]></title>
            <link>https://medium.com/@simone.b/how-to-query-the-oracle-jde-e1-database-6707488aea99?source=rss-e16887fa1441------2</link>
            <guid isPermaLink="false">https://medium.com/p/6707488aea99</guid>
            <dc:creator><![CDATA[Simone Belometti]]></dc:creator>
            <pubDate>Thu, 11 Aug 2022 09:37:49 GMT</pubDate>
            <atom:updated>2022-08-12T08:28:07.484Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*i1yOFO6UV25sUJ-LB_CBSg.jpeg" /></figure><p>In this article I would like to tell you about my experience with using Oracle JD Edwards E1.</p><p>JDE E1 is an ERP developed by Oracle. I’m not going to tell you how to customize it, but how to perform selections to extract data from its database.</p><p>JDE E1 is very complex, so I am speaking to you as a developer who over time has had to exchange data with it, without going into too much detail of operation.</p><p>I’ll do a roundup of queries that have come in handy.<br>I will briefly describe the database tables that are used.<br>First I make a short intro on how JDE E1 tables are generally structured.</p><blockquote>The first time you see a jde tables what you think is: oh shit, what the hell is this! Now that I’ve scared you, let’s get to practical things.</blockquote><p>All tables in JDE E1 have the prefix “F”.<br>For example, the table relating to work orders is F4801.<br>the names of the fields in the tables consist of a prefix with the associated data type. <br>Example for the F4801 table: <br> WADOCO: workorder number<br> WADL01: description<br> WACO: company<br> …<br>Each table with dozens of fields.<br>A note on the date field. the date in JDE E1 is Julian date.</p><p>Now, I will make a list of generic and useful queries for those who need to query a generic jde database:</p><p>Select items (if you want to select the items branch use the table F4102):</p><pre>SELECT * FROM F4101</pre><p>Select sales Order Detail:</p><pre>SELECT * FROM F4211</pre><p>Select Purchase Order Detail:</p><pre>SELECT * FROM F4311</pre><p>Select Work Order:</p><pre>SELECT * FROM F4801</pre><p>Select Item Ledger:</p><pre>SELECT * FROM F4111</pre><p>Select Lot:</p><pre>SELECT * FROM F4108</pre><p>Now two examples more complex queries:</p><p>Select Work Order, Item and Work Order Routing:</p><pre>SELECT WLDOCO, WLDSC1, WLKIT, WLMCU, WLMACA, WLLABA, WLSETA, WLSTRX, IMITM, IMDSC1, IMDSC2, WLOPSQ, WLMMCU, WLBFPF, WASRST<br>FROM F3112 <br>INNER JOIN F4101 ON WLKIT = IMITM <br>INNER JOIN F4801 ON WLDOCO = WADOCO <br>ORDER BY WLSTRX, WLDOCO</pre><p>Select Orders for a certain item:</p><pre>SELECT * FROM f4211 WHERE SDLITM LIKE ‘279710%’</pre><p>A very useful reference site to navigate the hundreds of tables of oracle E1 is <a href="https://jde.erpref.com/">https://jde.erpref.com/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6707488aea99" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[NGINX monitoring commands]]></title>
            <link>https://medium.com/@simone.b/nginx-monitoring-commands-afcc6e25d463?source=rss-e16887fa1441------2</link>
            <guid isPermaLink="false">https://medium.com/p/afcc6e25d463</guid>
            <category><![CDATA[command-line]]></category>
            <category><![CDATA[nginx]]></category>
            <category><![CDATA[ubuntu]]></category>
            <category><![CDATA[monitoring]]></category>
            <category><![CDATA[logging]]></category>
            <dc:creator><![CDATA[Simone Belometti]]></dc:creator>
            <pubDate>Thu, 12 May 2022 11:23:36 GMT</pubDate>
            <atom:updated>2022-05-13T15:36:55.220Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*liO3WXPOnXzASQzUTzEa8Q.jpeg" /></figure><p>In thelast article i wrote about read PLC Siemens with Python.<br>(This is the link: <a href="https://medium.com/p/3c9c6789d543">https://medium.com/p/3c9c6789d543</a> )<br>This time i change the topic of my article.</p><p>To understand the context i make a small introduction.<br>I have an Ubuntu 20.04.2 LTS where run a Django-Nginx-Python-Gunicorn web application.<br>This application is used by 4 companies (100 users).<br>The application has been running without problem for 1 year and it is consuming few resources.<br>OK perfect!</p><p>I wanted to analyze my server logs to understand and possibly improve performance.<br>I don’t want to install any tools but i want to analyze the logs in particular of the Nginx web server with standard commands.</p><p>This is a list of useful commands that can be customized:</p><p>1. Case insensitive match ‘error’ in nginx access.log</p><pre>grep -i error /var/log/nginx/access.log</pre><p>2. How many 404 errors today?</p><pre>grep &quot;\&quot; 404 &quot; /var/log/nginx/access.log | grep &quot;12/May/2022&quot; | wc -l</pre><p>3. What caused 404 errors, how many times did each one happen, and sort based on # times</p><pre>grep &quot;\&quot; 404 &quot; /var/log/nginx/access.log | grep &quot;12/May/2022&quot; |cut -d \&quot; -f 2 | sort | uniq -c | sort -rh</pre><p>4. Total # of http requests</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | wc -l</pre><p>5. Total # of http requests that generated a 200 response code:</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | grep &quot;\&quot; 200 &quot; | wc -l</pre><p>6. Total number of unique IPs for today’s requests (if you’re behind a firewall or vpc, your webserver needs to be configured properly to forward customer IPs, and customers could be behind firewalls too, so… don’t put too much weight on this stat</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | awk ‘{print $1}’ | sort -u | wc -l</pre><p>7. Unique IPs today sorted by # of requests</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | awk ‘{print $1}’ | sort | uniq -c | sort -rh</pre><p>8. Top 20 referrer urls for today:</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | cut -d \&quot; -f 4 |sort | uniq -c | sort -rh | head -20</pre><p>9. Top 20 webserver requests for today</p><pre>grep &quot;12/May/2022&quot; /var/log/nginx/access.log | cut -d \&quot; -f 2 | sort | uniq -c | sort -rh | head -20</pre><p>I hope these lean commands are useful to you.</p><p>See you soon.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=afcc6e25d463" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to communicate with a Siemens PLC using Python]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@simone.b/how-to-communicate-with-a-siemens-plc-using-python-3c9c6789d543?source=rss-e16887fa1441------2"><img src="https://cdn-images-1.medium.com/max/735/1*0QsZd3w3pM2GYoFFjlkozw.jpeg" width="735"></a></p><p class="medium-feed-snippet">This is my first article. So, i apologize in advance for any errors. Any kind of suggestions are welcomed.</p><p class="medium-feed-link"><a href="https://medium.com/@simone.b/how-to-communicate-with-a-siemens-plc-using-python-3c9c6789d543?source=rss-e16887fa1441------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@simone.b/how-to-communicate-with-a-siemens-plc-using-python-3c9c6789d543?source=rss-e16887fa1441------2</link>
            <guid isPermaLink="false">https://medium.com/p/3c9c6789d543</guid>
            <category><![CDATA[python]]></category>
            <category><![CDATA[plc]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[iot]]></category>
            <category><![CDATA[siemens]]></category>
            <dc:creator><![CDATA[Simone Belometti]]></dc:creator>
            <pubDate>Wed, 08 Sep 2021 09:59:54 GMT</pubDate>
            <atom:updated>2022-05-31T06:23:14.270Z</atom:updated>
        </item>
    </channel>
</rss>