{"id":1608,"date":"2025-01-11T16:45:04","date_gmt":"2025-01-11T16:45:04","guid":{"rendered":"https:\/\/sparkonelabs.com\/home\/?p=1608"},"modified":"2025-01-15T17:35:06","modified_gmt":"2025-01-15T17:35:06","slug":"raspberry-pi-4-b-iot-data-collection-single-workcell","status":"publish","type":"post","link":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/","title":{"rendered":"Raspberry Pi 4 B IoT Data Collection: Single Workcell"},"content":{"rendered":"\n

In order to examine consolidation of production data and program management, it is prudent to create a LAN IoT solution for a single WorkCell as an experiment. The feasibility and best practices can be determined from this scope while limiting research cost and potential consequential complications. <\/p>\n\n\n\n

In furthering this experiment, notes have been taken regarding Workcell 11 and Workcell 13. The Information is presented below:<\/p>\n\n\n\n

Workcell 11<\/td><\/td>Workcell 13<\/td><\/td><\/tr>
Degate Controller<\/td>Pick-and-Place Controller<\/td>Degate Controller<\/td>Pick-and-Place Controller<\/td><\/tr>
30iA – USB Gen1.1<\/td>30iB – USB Gen1.1<\/td>30iA – USB Gen1.1<\/td>30iB – USB Gen1.1<\/td><\/tr>
RS232C (25pin)<\/td><\/td>RS232C (25pin)<\/td><\/td><\/tr>
<\/td><\/td><\/td><\/td><\/tr>
Press: Van Dorn 1760<\/td>UI: Pathfinder5000<\/td>Press:<\/td>UI: Pathfinder5000<\/td><\/tr>
<\/td><\/td><\/td><\/td><\/tr>
RJG<\/td>Node: 8<\/td>RJG<\/td>Node: 1<\/td><\/tr>
SN: 12EX500258<\/td><\/td>SN: 22EX500036<\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Experimental Goals:<\/p>\n\n\n\n

Topology Map:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Phase I: <\/p>\n\n\n\n

    \n
  1. Connect a Raspberry Pi 4 with appropriate networking OS to the LAN<\/li>\n\n\n\n
  2. Connect 2x WiFI Dongles compatible with the FANUC Controller’s old USB to the 30iA and 30iB<\/li>\n\n\n\n
  3. Program Laptop or other computer for use in the Shop to set up python network scripts, SQL database, FANUC programming transformation calls, WorkCell Geometry Data etc.<\/li>\n<\/ol>\n\n\n\n

    According to my initial research, the USB Gen 1.1 should have legacy compatibility with these devices:<\/p>\n\n\n\n

    Edimax EW-7811Un V2 – N150 Wi-Fi 4 Nano USB Adapter<\/a><\/strong> (1-11-25 Listing)<\/p>\n\n\n

    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    Currently they are priced around $9.98 USB, so about $20 to find out how well they work for this experiment.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    10 Lot DB25 Male to RJ45 Network 8P8C Adapter Converter Gold-Pin Connector RS232<\/a><\/strong> (New) (1-15-2025 Listing)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The DB25 Male to RJ56 connection can allow for the use of standard Cat 5 or Cat 6 cable instead of USB connections. Additional USB to RJ45 adapters may be needed on the Pi depending on the number of data devices connected. List price is $19.99 USD for 10 of them. They only have 8 pins however.<\/p>\n\n\n\n

    New USB 2.0 to RS232 COM Port 9 Pin Serial DB25 DB9 Adapter Cable Converter<\/a><\/strong> (New) (1-13-25 Listing)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    To connect RJ3 series RS-232-C to the raspberry Pi 4 B, USB Gen 2.0 compatibility. $8.85 USD<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Plugable 2.5G USB Ethernet Adapter To 2.5 Gigabit RJ45 LAN Network Adapter\/Cable<\/a><\/strong> (New) (1-13-25 Listing)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    To connect Raspberry Pi 4 B to RJ3i series with RJ45 Option 2 Installed. $14.99 USD.<\/p>\n\n\n\n

    Raspberry Pi 4 Model B 2019 Quad Core 64 Bit WiFi Bluetooth (4GB) (WY)<\/a><\/strong> (Pre-Owned) (1-11-25 Listing)<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    This is a used Raspberry Pi 4 B with enough RAM for networking and Data processing purposes. It is listed at $49.99 USD as of 1-11-25. New Models with accessories run about $75.00 USD as of the same date.<\/p>\n\n\n\n

    Finally a laptop, which I need to get a new one anyway sometime this month. I plan on developing the networking and python scripting infrastructure on it in an Arch Linux OS and running it as a system service once the appropriate Virtual Environment and Scripts are constructed. UI can consist of a Webserver on port 80 of this device for compatibility with other OS being used at the factory. (Ugh… windows, why?) <\/p>\n\n\n\n

    Raspberry Pi OS will most likely be Raspberry Pi OS Lite (minimal, stable, less overhead).<\/p>\n\n\n\n

    Here are some initial script stubs:<\/p>\n\n\n\n

    FANUC Data Collection Interface (And RJG Stubs for future Dev)<\/h2>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    import<\/span> <\/span>socket<\/span><\/span>\nimport<\/span> <\/span>threading<\/span><\/span>\nimport<\/span> <\/span>time<\/span><\/span>\nimport<\/span> <\/span>logging<\/span><\/span>\nfrom<\/span> <\/span>datetime<\/span> <\/span>import<\/span> <\/span>datetime<\/span><\/span>\nimport<\/span> <\/span>sqlite3<\/span><\/span>\nfrom<\/span> <\/span>pathlib<\/span> <\/span>import<\/span> <\/span>Path<\/span><\/span>\nimport<\/span> <\/span>focas<\/span><\/span>\nimport<\/span> <\/span>pycomm3<\/span><\/span>\nimport<\/span> <\/span>paramiko<\/span><\/span>\n<\/span>\nclass<\/span> <\/span>FanucInterface<\/span>:<\/span><\/span>\n    <\/span>def<\/span> <\/span>__init__<\/span>(<\/span>self<\/span>,<\/span> <\/span>config<\/span>):<\/span><\/span>\n        <\/span>self<\/span>.<\/span>config<\/span> = <\/span>config<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setup_logging<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setup_database<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>running<\/span> = <\/span>False<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>setup_logging<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>logging<\/span>.<\/span>basicConfig<\/span>(<\/span><\/span>\n            <\/span>filename<\/span>=<\/span>'<\/span>fanuc_interface.log<\/span>'<\/span>,<\/span><\/span>\n            <\/span>level<\/span>=<\/span>logging<\/span>.<\/span>INFO<\/span>,<\/span><\/span>\n            <\/span>format<\/span>=<\/span>'<\/span>%(asctime)s - %(levelname)s - %(message)s<\/span>'<\/span><\/span>\n        )<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>setup_database<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>self<\/span>.<\/span>conn<\/span> = <\/span>sqlite3<\/span>.<\/span>connect<\/span>(<\/span>'<\/span>production_data.db<\/span>'<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>cursor<\/span> = <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>cursor<\/span>()<\/span><\/span>\n        # <\/span>Create<\/span> <\/span>tables<\/span> <\/span>for<\/span> <\/span>storing<\/span> <\/span>machine<\/span> <\/span>data<\/span><\/span>\n        <\/span>self<\/span>.<\/span>cursor<\/span>.<\/span>execute<\/span>(<\/span>'''<\/span><\/span>\n            CREATE TABLE IF NOT EXISTS machine_data <\/span>(<\/span><\/span>\n                <\/span>timestamp<\/span> <\/span>TEXT<\/span>,<\/span><\/span>\n                <\/span>machine_id<\/span> <\/span>TEXT<\/span>,<\/span><\/span>\n                <\/span>program_number<\/span> <\/span>TEXT<\/span>,<\/span><\/span>\n                <\/span>status<\/span> <\/span>TEXT<\/span>,<\/span><\/span>\n                <\/span>cycle_time<\/span> <\/span>REAL<\/span>,<\/span><\/span>\n                <\/span>alarm_code<\/span> <\/span>TEXT<\/span><\/span>\n            )<\/span><\/span>\n        <\/span>'''<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>commit<\/span>()<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>connect_fanuc<\/span>(<\/span>self<\/span>,<\/span> <\/span>ip_address<\/span>,<\/span> <\/span>port<\/span>=8193):<\/span><\/span>\n        <\/span>"""<\/span>Connect to FANUC controller via FOCAS<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>handle<\/span> = <\/span>focas<\/span>.<\/span>connect<\/span>(<\/span>ip_address<\/span>,<\/span> <\/span>port<\/span>)<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>info<\/span>(<\/span>f<\/span>"<\/span>Connected to FANUC at {ip_address}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>handle<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to connect to FANUC: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>None<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>read_program<\/span>(<\/span>self<\/span>,<\/span> <\/span>handle<\/span>,<\/span> <\/span>program_number<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Read program from FANUC controller<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>program<\/span> = <\/span>focas<\/span>.<\/span>read_program<\/span>(<\/span>handle<\/span>,<\/span> <\/span>program_number<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>program<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to read program {program_number}: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>None<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>write_program<\/span>(<\/span>self<\/span>,<\/span> <\/span>handle<\/span>,<\/span> <\/span>program_number<\/span>,<\/span> <\/span>program_content<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Write program to FANUC controller<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>focas<\/span>.<\/span>write_program<\/span>(<\/span>handle<\/span>,<\/span> <\/span>program_number<\/span>,<\/span> <\/span>program_content<\/span>)<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>info<\/span>(<\/span>f<\/span>"<\/span>Program {program_number} written successfully<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>True<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to write program {program_number}: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>False<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>collect_machine_data<\/span>(<\/span>self<\/span>,<\/span> <\/span>handle<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Collect current machine status and data<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>status<\/span> = <\/span>focas<\/span>.<\/span>read_status<\/span>(<\/span>handle<\/span>)<\/span><\/span>\n            <\/span>alarms<\/span> = <\/span>focas<\/span>.<\/span>read_alarms<\/span>(<\/span>handle<\/span>)<\/span><\/span>\n            <\/span>program<\/span> = <\/span>focas<\/span>.<\/span>read_current_program<\/span>(<\/span>handle<\/span>)<\/span><\/span>\n            <\/span>position<\/span> = <\/span>focas<\/span>.<\/span>read_position<\/span>(<\/span>handle<\/span>)<\/span><\/span>\n            <\/span><\/span>\n            <\/span>data<\/span> = <\/span>{<\/span><\/span>\n                '<\/span>timestamp<\/span>': <\/span>datetime<\/span>.<\/span>now<\/span>().<\/span>isoformat<\/span>()<\/span>,<\/span><\/span>\n                '<\/span>status<\/span>': <\/span>status<\/span>,<\/span><\/span>\n                '<\/span>program<\/span>': <\/span>program<\/span>,<\/span><\/span>\n                '<\/span>position<\/span>': <\/span>position<\/span>,<\/span><\/span>\n                '<\/span>alarms<\/span>': <\/span>alarms<\/span><\/span>\n            <\/span>}<\/span><\/span>\n            <\/span><\/span>\n            <\/span>self<\/span>.<\/span>store_data<\/span>(<\/span>data<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>data<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to collect machine data: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>None<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>connect_rjg<\/span>(<\/span>self<\/span>,<\/span> <\/span>ip_address<\/span>,<\/span> <\/span>port<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Connect to RJG system via Ethernet\/IP<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>comm<\/span> = <\/span>pycomm3<\/span>.<\/span>LogixDriver<\/span>(<\/span>f<\/span>'<\/span>{{ip_address}}<\/span>'<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>comm<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to connect to RJG: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>None<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>read_rjg_data<\/span>(<\/span>self<\/span>,<\/span> <\/span>comm<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Read data from RJG system<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            # <\/span>Example<\/span> <\/span>tags<\/span> - <\/span>modify<\/span> <\/span>based<\/span> <\/span>on<\/span> <\/span>your<\/span> <\/span>RJG<\/span> <\/span>setup<\/span><\/span>\n            <\/span>data<\/span> = <\/span>{<\/span><\/span>\n                '<\/span>timestamp<\/span>': <\/span>datetime<\/span>.<\/span>now<\/span>().<\/span>isoformat<\/span>()<\/span>,<\/span><\/span>\n                '<\/span>pressure<\/span>': <\/span>comm<\/span>.<\/span>read<\/span>('<\/span>Pressure<\/span>')[1]<\/span>,<\/span><\/span>\n                '<\/span>temperature<\/span>': <\/span>comm<\/span>.<\/span>read<\/span>('<\/span>Temperature<\/span>')[1]<\/span>,<\/span><\/span>\n                '<\/span>cycle_time<\/span>': <\/span>comm<\/span>.<\/span>read<\/span>('<\/span>CycleTime<\/span>')[1]<\/span><\/span>\n            <\/span>}<\/span><\/span>\n            <\/span>self<\/span>.<\/span>store_data<\/span>(<\/span>data<\/span>,<\/span> <\/span>'<\/span>rjg_data<\/span>'<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>data<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to read RJG data: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span>return<\/span> <\/span>None<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>store_data<\/span>(<\/span>self<\/span>,<\/span> <\/span>data<\/span>,<\/span> <\/span>table<\/span>=<\/span>'<\/span>machine_data<\/span>'<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Store collected data in SQLite database<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>columns<\/span> = <\/span>'<\/span>, <\/span>'<\/span>.<\/span>join<\/span>(<\/span>data<\/span>.<\/span>keys<\/span>())<\/span><\/span>\n            <\/span>placeholders<\/span> = <\/span>'<\/span>:<\/span>'<\/span> + <\/span>'<\/span>, :<\/span>'<\/span>.<\/span>join<\/span>(<\/span>data<\/span>.<\/span>keys<\/span>())<\/span><\/span>\n            <\/span>query<\/span> = <\/span>f<\/span>'<\/span>INSERT INTO {table} ({columns}) VALUES ({placeholders})<\/span>'<\/span><\/span>\n            <\/span>self<\/span>.<\/span>cursor<\/span>.<\/span>execute<\/span>(<\/span>query<\/span>,<\/span> <\/span>data<\/span>)<\/span><\/span>\n            <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>commit<\/span>()<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Failed to store data: {e}<\/span>"<\/span>)<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>start_monitoring<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Start continuous monitoring of all systems<\/span>"""<\/span><\/span>\n        <\/span>self<\/span>.<\/span>running<\/span> = <\/span>True<\/span><\/span>\n        <\/span>self<\/span>.<\/span>monitor_thread<\/span> = <\/span>threading<\/span>.<\/span>Thread<\/span>(<\/span>target<\/span>=<\/span>self<\/span>.<\/span>_monitoring_loop<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>monitor_thread<\/span>.<\/span>start<\/span>()<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>stop_monitoring<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Stop monitoring systems<\/span>"""<\/span><\/span>\n        <\/span>self<\/span>.<\/span>running<\/span> = <\/span>False<\/span><\/span>\n        <\/span>if<\/span> <\/span>hasattr<\/span>(<\/span>self<\/span>,<\/span> <\/span>'<\/span>monitor_thread<\/span>'<\/span>):<\/span><\/span>\n            <\/span>self<\/span>.<\/span>monitor_thread<\/span>.<\/span>join<\/span>()<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>_monitoring_loop<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Main monitoring loop<\/span>"""<\/span><\/span>\n        <\/span>fanuc_30iB<\/span> = <\/span>self<\/span>.<\/span>connect_fanuc<\/span>(<\/span>self<\/span>.<\/span>config<\/span>[<\/span>'<\/span>fanuc_30iB_ip<\/span>'<\/span>])<\/span><\/span>\n        <\/span>fanuc_30iA<\/span> = <\/span>self<\/span>.<\/span>connect_fanuc<\/span>(<\/span>self<\/span>.<\/span>config<\/span>[<\/span>'<\/span>fanuc_30iA_ip<\/span>'<\/span>])<\/span><\/span>\n        <\/span>rjg_comm<\/span> = <\/span>self<\/span>.<\/span>connect_rjg<\/span>(<\/span>self<\/span>.<\/span>config<\/span>[<\/span>'<\/span>rjg_ip<\/span>'<\/span>]<\/span>,<\/span> <\/span>self<\/span>.<\/span>config<\/span>[<\/span>'<\/span>rjg_port<\/span>'<\/span>])<\/span><\/span>\n<\/span>\n        <\/span>while<\/span> <\/span>self<\/span>.<\/span>running<\/span>:<\/span><\/span>\n            <\/span>try<\/span>:<\/span><\/span>\n                <\/span>if<\/span> <\/span>fanuc_30iB<\/span>:<\/span><\/span>\n                    <\/span>data_30iB<\/span> = <\/span>self<\/span>.<\/span>collect_machine_data<\/span>(<\/span>fanuc_30iB<\/span>)<\/span><\/span>\n                <\/span>if<\/span> <\/span>fanuc_30iA<\/span>:<\/span><\/span>\n                    <\/span>data_30iA<\/span> = <\/span>self<\/span>.<\/span>collect_machine_data<\/span>(<\/span>fanuc_30iA<\/span>)<\/span><\/span>\n                <\/span>if<\/span> <\/span>rjg_comm<\/span>:<\/span><\/span>\n                    <\/span>rjg_data<\/span> = <\/span>self<\/span>.<\/span>read_rjg_data<\/span>(<\/span>rjg_comm<\/span>)<\/span><\/span>\n                    <\/span><\/span>\n                <\/span>time<\/span>.<\/span>sleep<\/span>(<\/span>self<\/span>.<\/span>config<\/span>[<\/span>'<\/span>polling_interval<\/span>'<\/span>])<\/span><\/span>\n                <\/span><\/span>\n            <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n                <\/span>logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>"<\/span>Error in monitoring loop: {e}<\/span>"<\/span>)<\/span><\/span>\n                <\/span>time<\/span>.<\/span>sleep<\/span>(5)  # <\/span>Wait<\/span> <\/span>before<\/span> <\/span>retrying<\/span><\/span>\n<\/span>\n    <\/span>def<\/span> <\/span>__del__<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Cleanup on object destruction<\/span>"""<\/span><\/span>\n        <\/span>if<\/span> <\/span>hasattr<\/span>(<\/span>self<\/span>,<\/span> <\/span>'<\/span>conn<\/span>'<\/span>):<\/span><\/span>\n            <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>close<\/span>()<\/span><\/span>\n<\/span>\n# <\/span>Example<\/span> <\/span>configuration<\/span><\/span>\nconfig<\/span> = <\/span>{<\/span><\/span>\n    '<\/span>fanuc_30iB_ip<\/span>': '192.168.1.100'<\/span>,<\/span><\/span>\n    '<\/span>fanuc_30iA_ip<\/span>': '192.168.1.101'<\/span>,<\/span><\/span>\n    '<\/span>rjg_ip<\/span>': '192.168.1.102'<\/span>,<\/span><\/span>\n    '<\/span>rjg_port<\/span>': 44818<\/span>,<\/span>  # <\/span>Standard<\/span> <\/span>Ethernet<\/span>\/<\/span>IP<\/span> <\/span>port<\/span><\/span>\n    '<\/span>polling_interval<\/span>': 1.0  # <\/span>seconds<\/span><\/span>\n}<\/span><\/span>\n<\/span>\n# <\/span>Usage<\/span> <\/span>example<\/span><\/span>\nif<\/span> <\/span>__name__<\/span> == <\/span>"<\/span>__main__<\/span>"<\/span>:<\/span><\/span>\n    <\/span>interface<\/span> = <\/span>FanucInterface<\/span>(<\/span>config<\/span>)<\/span><\/span>\n    <\/span>try<\/span>:<\/span><\/span>\n        <\/span>interface<\/span>.<\/span>start_monitoring<\/span>()<\/span><\/span>\n        # <\/span>Keep<\/span> <\/span>the<\/span> <\/span>main<\/span> <\/span>thread<\/span> <\/span>alive<\/span><\/span>\n        <\/span>while<\/span> <\/span>True<\/span>:<\/span><\/span>\n            <\/span>time<\/span>.<\/span>sleep<\/span>(1)<\/span><\/span>\n    <\/span>except<\/span> <\/span>KeyboardInterrupt<\/span>:<\/span><\/span>\n        <\/span>interface<\/span>.<\/span>stop_monitoring<\/span>()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    Remember this is a speculative first pass script. Any suggestions are appreciated.<\/p>\n\n\n\n
    Packages needed in virtual environment on Pi device:<\/p>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    pip<\/span> <\/span>install<\/span> <\/span>focas<\/span>-<\/span>python<\/span> <\/span>pycomm3<\/span> <\/span>paramiko<\/span> <\/span>sqlite3<\/span> <\/span>logging<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    Key Features:<\/p>\n\n\n\n
      \n
    1. Multiple Protocol Support:\n
        \n
      • FOCAS library for FANUC communication<\/li>\n\n\n\n
      • Ethernet\/IP for RJG communication<\/li>\n\n\n\n
      • Built-in error handling and reconnection logic<\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • Data Collection:\n
          \n
        • Machine status<\/li>\n\n\n\n
        • Program information<\/li>\n\n\n\n
        • Alarm conditions<\/li>\n\n\n\n
        • RJG process data<\/li>\n\n\n\n
        • Automatic SQLite storage<\/li>\n<\/ul>\n<\/li>\n\n\n\n
        • Program Management:\n
            \n
          • Read\/Write capabilities for robot programs<\/li>\n\n\n\n
          • Program backup functionality<\/li>\n\n\n\n
          • Version control support<\/li>\n<\/ul>\n<\/li>\n\n\n\n
          • Diagnostics:\n
              \n
            • Real-time status monitoring<\/li>\n\n\n\n
            • Alarm tracking<\/li>\n\n\n\n
            • Performance metrics<\/li>\n\n\n\n
            • Comprehensive logging<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
              Setup Steps:<\/p>\n\n\n\n
                \n
              1. Install Raspberry Pi OS Lite<\/li>\n\n\n\n
              2. Configure static IP for the Pi<\/li>\n\n\n\n
              3. Install required Python packages<\/li>\n\n\n\n
              4. Configure network settings for all devices<\/li>\n\n\n\n
              5. Set up the database structure<\/li>\n\n\n\n
              6. Configure logging<\/li>\n\n\n\n
              7. Set up automatic startup service<\/li>\n<\/ol>\n\n\n\n
                Security Considerations:<\/p>\n\n\n\n
                  \n
                1. Use VLANs to isolate machine network<\/li>\n\n\n\n
                2. Implement proper firewall rules<\/li>\n\n\n\n
                3. Use strong WiFi security (WPA2-Enterprise if possible)<\/li>\n\n\n\n
                4. Regular security updates<\/li>\n\n\n\n
                5. Access control for program modifications<\/li>\n<\/ol>\n\n\n\n
                  This system should give you a reliable interface for managing both FANUC controllers and collecting RJG data. The modular design allows for easy expansion and maintenance.<\/p>\n\n\n\n
                  (Generated By Claude AI)<\/p>\n\n\n\n
                  As far as the Shop computer goes, I intend to run Arch btw. Arch Linux provides the most versatile and open OS for software development along any dependency path.<\/p>\n\n\n\n
                  Here are some of the basic first pass scripts and environment configurations:<\/p>\n\n\n\n
                  Arch Linux OS Environment Setup:<\/strong><\/p>\n\n\n\n
                  <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
                  sudo<\/span> <\/span>pacman<\/span> <\/span>-<\/span>S<\/span> <\/span>python<\/span> <\/span>python<\/span>-<\/span>pip<\/span> <\/span>git<\/span> <\/span>sqlite<\/span> <\/span>mariadb<\/span> <\/span>python<\/span>-<\/span>virtualenv<\/span><\/span>\nsudo<\/span> <\/span>pacman<\/span> <\/span>-<\/span>S<\/span> <\/span>python<\/span>-<\/span>poetry<\/span> <\/span>dbeaver<\/span> # <\/span>For<\/span> <\/span>database<\/span> <\/span>management<\/span><\/span>\nsudo<\/span> <\/span>pacman<\/span> <\/span>-<\/span>S<\/span> <\/span>qtcreator<\/span> <\/span>qt6<\/span>-<\/span>base<\/span> # <\/span>If<\/span> <\/span>you<\/span> <\/span>want<\/span> <\/span>to<\/span> <\/span>build<\/span> <\/span>a<\/span> <\/span>GUI<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
                  Most likely I will be using yay<\/strong> instead of pacman<\/strong> in order to incorporate AUR packages, possibly developing and maintaining an AUR package for these purposes.<\/p>\n\n\n\n
                  Virtual Environment Setup:<\/strong><\/p>\n\n\n\n
                  <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
                  python<\/span> <\/span>-<\/span>m<\/span> <\/span>venv<\/span> <\/span>venv<\/span><\/span>\nsource<\/span> <\/span>venv<\/span>\/<\/span>bin<\/span>\/<\/span>activate<\/span><\/span>\npip<\/span> <\/span>install<\/span> <\/span>PyQt6<\/span> <\/span>pandas<\/span> <\/span>matplotlib<\/span> <\/span>numpy<\/span> <\/span>focas<\/span>-<\/span>python<\/span> <\/span>pycomm3<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
                  Depending on system constraints, I would prefer to use miniconda3<\/strong> as it provides more flexibility in using different versions of python, which most likely will be needed when we get around to using machine learning algorithms on this setup for homebrew copilot, vision recognition models and other technologies as determined to be effective and useful in practical applications.<\/p>\n\n\n\n
                  Database Setup:<\/strong><\/p>\n\n\n\n
                  <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
                  sqlite3<\/span> <\/span>production_data<\/span>.<\/span>db<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
                  Shop Computer Script:<\/h2>\n\n\n\n
                  <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
                  import<\/span> <\/span>sys<\/span><\/span>\nimport<\/span> <\/span>sqlite3<\/span><\/span>\nfrom<\/span> <\/span>datetime<\/span> <\/span>import<\/span> <\/span>datetime<\/span>,<\/span> <\/span>timedelta<\/span><\/span>\nimport<\/span> <\/span>pandas<\/span> <\/span>as<\/span> <\/span>pd<\/span><\/span>\nfrom<\/span> <\/span>PyQt6<\/span>.<\/span>QtWidgets<\/span> <\/span>import<\/span> (<\/span>QApplication<\/span>,<\/span> <\/span>QMainWindow<\/span>,<\/span> <\/span>QWidget<\/span>,<\/span> <\/span>QVBoxLayout<\/span>,<\/span> <\/span><\/span>\n                           <\/span>QHBoxLayout<\/span>,<\/span> <\/span>QTableWidget<\/span>,<\/span> <\/span>QTableWidgetItem<\/span>,<\/span> <\/span>QPushButton<\/span>,<\/span> <\/span><\/span>\n                           <\/span>QLabel<\/span>,<\/span> <\/span>QComboBox<\/span>,<\/span> <\/span>QTabWidget<\/span>,<\/span> <\/span>QTextEdit<\/span>)<\/span><\/span>\nfrom<\/span> <\/span>PyQt6<\/span>.<\/span>QtCore<\/span> <\/span>import<\/span> <\/span>Qt<\/span>,<\/span> <\/span>QTimer<\/span><\/span>\nimport<\/span> <\/span>matplotlib<\/span>.<\/span>pyplot<\/span> <\/span>as<\/span> <\/span>plt<\/span><\/span>\nfrom<\/span> <\/span>matplotlib<\/span>.<\/span>backends<\/span>.<\/span>backend_qt5agg<\/span> <\/span>import<\/span> <\/span>FigureCanvasQTAgg<\/span> <\/span>as<\/span> <\/span>FigureCanvas<\/span><\/span>\n<\/span>\nclass<\/span> <\/span>ShopFloorClient<\/span>(<\/span>QMainWindow<\/span>):<\/span><\/span>\n    <\/span>def<\/span> <\/span>__init__<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>super<\/span>().<\/span>__init__<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setWindowTitle<\/span>(<\/span>"<\/span>Shop Floor Monitor<\/span>"<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setGeometry<\/span>(100<\/span>,<\/span> 100<\/span>,<\/span> 1200<\/span>,<\/span> 800)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Create<\/span> <\/span>main<\/span> <\/span>widget<\/span> <\/span>and<\/span> <\/span>layout<\/span><\/span>\n        <\/span>main_widget<\/span> = <\/span>QWidget<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setCentralWidget<\/span>(<\/span>main_widget<\/span>)<\/span><\/span>\n        <\/span>layout<\/span> = <\/span>QVBoxLayout<\/span>(<\/span>main_widget<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Create<\/span> <\/span>tab<\/span> <\/span>widget<\/span><\/span>\n        <\/span>tabs<\/span> = <\/span>QTabWidget<\/span>()<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>tabs<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Add<\/span> <\/span>tabs<\/span><\/span>\n        <\/span>tabs<\/span>.<\/span>addTab<\/span>(<\/span>self<\/span>.<\/span>create_monitor_tab<\/span>()<\/span>,<\/span> <\/span>"<\/span>Live Monitor<\/span>"<\/span>)<\/span><\/span>\n        <\/span>tabs<\/span>.<\/span>addTab<\/span>(<\/span>self<\/span>.<\/span>create_program_tab<\/span>()<\/span>,<\/span> <\/span>"<\/span>Programs<\/span>"<\/span>)<\/span><\/span>\n        <\/span>tabs<\/span>.<\/span>addTab<\/span>(<\/span>self<\/span>.<\/span>create_analysis_tab<\/span>()<\/span>,<\/span> <\/span>"<\/span>Analysis<\/span>"<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Setup<\/span> <\/span>database<\/span> <\/span>connection<\/span><\/span>\n        <\/span>self<\/span>.<\/span>setup_database<\/span>()<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Start<\/span> <\/span>update<\/span> <\/span>timer<\/span><\/span>\n        <\/span>self<\/span>.<\/span>timer<\/span> = <\/span>QTimer<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>timer<\/span>.<\/span>timeout<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>update_data<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>timer<\/span>.<\/span>start<\/span>(1000)  # <\/span>Update<\/span> <\/span>every<\/span> <\/span>second<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>setup_database<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Initialize database connection<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>self<\/span>.<\/span>conn<\/span> = <\/span>sqlite3<\/span>.<\/span>connect<\/span>(<\/span>'<\/span>production_data.db<\/span>'<\/span>)<\/span><\/span>\n            <\/span>self<\/span>.<\/span>cursor<\/span> = <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>cursor<\/span>()<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>print<\/span>(<\/span>f<\/span>"<\/span>Database connection error: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span><\/span>\n    <\/span>def<\/span> <\/span>create_monitor_tab<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Create the live monitoring tab<\/span>"""<\/span><\/span>\n        <\/span>tab<\/span> = <\/span>QWidget<\/span>()<\/span><\/span>\n        <\/span>layout<\/span> = <\/span>QVBoxLayout<\/span>(<\/span>tab<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Machine<\/span> <\/span>selection<\/span><\/span>\n        <\/span>machine_layout<\/span> = <\/span>QHBoxLayout<\/span>()<\/span><\/span>\n        <\/span>machine_label<\/span> = <\/span>QLabel<\/span>(<\/span>"<\/span>Select Machine:<\/span>"<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>machine_combo<\/span> = <\/span>QComboBox<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>machine_combo<\/span>.<\/span>addItems<\/span>([<\/span>"<\/span>FANUC 30iB<\/span>"<\/span>,<\/span> <\/span>"<\/span>FANUC 30iA<\/span>"<\/span>,<\/span> <\/span>"<\/span>RJG<\/span>"<\/span>])<\/span><\/span>\n        <\/span>machine_layout<\/span>.<\/span>addWidget<\/span>(<\/span>machine_label<\/span>)<\/span><\/span>\n        <\/span>machine_layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>machine_combo<\/span>)<\/span><\/span>\n        <\/span>machine_layout<\/span>.<\/span>addStretch<\/span>()<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addLayout<\/span>(<\/span>machine_layout<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Status<\/span> <\/span>display<\/span><\/span>\n        <\/span>self<\/span>.<\/span>status_table<\/span> = <\/span>QTableWidget<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>setColumnCount<\/span>(4)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>setHorizontalHeaderLabels<\/span>([<\/span>"<\/span>Parameter<\/span>"<\/span>,<\/span> <\/span>"<\/span>Value<\/span>"<\/span>,<\/span> <\/span>"<\/span>Status<\/span>"<\/span>,<\/span> <\/span>"<\/span>Last Update<\/span>"<\/span>])<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>status_table<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Alarm<\/span> <\/span>display<\/span><\/span>\n        <\/span>alarm_label<\/span> = <\/span>QLabel<\/span>(<\/span>"<\/span>Active Alarms:<\/span>"<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>alarm_label<\/span>)<\/span><\/span>\n        <\/span>self<\/span>.<\/span>alarm_text<\/span> = <\/span>QTextEdit<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>alarm_text<\/span>.<\/span>setReadOnly<\/span>(<\/span>True<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>alarm_text<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        <\/span>return<\/span> <\/span>tab<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>create_program_tab<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Create the program management tab<\/span>"""<\/span><\/span>\n        <\/span>tab<\/span> = <\/span>QWidget<\/span>()<\/span><\/span>\n        <\/span>layout<\/span> = <\/span>QVBoxLayout<\/span>(<\/span>tab<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Program<\/span> <\/span>selection<\/span><\/span>\n        <\/span>prog_layout<\/span> = <\/span>QHBoxLayout<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>program_combo<\/span> = <\/span>QComboBox<\/span>()<\/span><\/span>\n        <\/span>upload_btn<\/span> = <\/span>QPushButton<\/span>(<\/span>"<\/span>Upload<\/span>"<\/span>)<\/span><\/span>\n        <\/span>download_btn<\/span> = <\/span>QPushButton<\/span>(<\/span>"<\/span>Download<\/span>"<\/span>)<\/span><\/span>\n        <\/span>prog_layout<\/span>.<\/span>addWidget<\/span>(<\/span>QLabel<\/span>(<\/span>"<\/span>Program:<\/span>"<\/span>))<\/span><\/span>\n        <\/span>prog_layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>program_combo<\/span>)<\/span><\/span>\n        <\/span>prog_layout<\/span>.<\/span>addWidget<\/span>(<\/span>upload_btn<\/span>)<\/span><\/span>\n        <\/span>prog_layout<\/span>.<\/span>addWidget<\/span>(<\/span>download_btn<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addLayout<\/span>(<\/span>prog_layout<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Program<\/span> <\/span>editor<\/span><\/span>\n        <\/span>self<\/span>.<\/span>program_editor<\/span> = <\/span>QTextEdit<\/span>()<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>program_editor<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Connect<\/span> <\/span>buttons<\/span><\/span>\n        <\/span>upload_btn<\/span>.<\/span>clicked<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>upload_program<\/span>)<\/span><\/span>\n        <\/span>download_btn<\/span>.<\/span>clicked<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>download_program<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        <\/span>return<\/span> <\/span>tab<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>create_analysis_tab<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Create the data analysis tab<\/span>"""<\/span><\/span>\n        <\/span>tab<\/span> = <\/span>QWidget<\/span>()<\/span><\/span>\n        <\/span>layout<\/span> = <\/span>QVBoxLayout<\/span>(<\/span>tab<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Time<\/span> <\/span>range<\/span> <\/span>selection<\/span><\/span>\n        <\/span>time_layout<\/span> = <\/span>QHBoxLayout<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>time_combo<\/span> = <\/span>QComboBox<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>time_combo<\/span>.<\/span>addItems<\/span>([<\/span>"<\/span>Last Hour<\/span>"<\/span>,<\/span> <\/span>"<\/span>Last Shift<\/span>"<\/span>,<\/span> <\/span>"<\/span>Last Day<\/span>"<\/span>,<\/span> <\/span>"<\/span>Last Week<\/span>"<\/span>])<\/span><\/span>\n        <\/span>time_layout<\/span>.<\/span>addWidget<\/span>(<\/span>QLabel<\/span>(<\/span>"<\/span>Time Range:<\/span>"<\/span>))<\/span><\/span>\n        <\/span>time_layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>time_combo<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addLayout<\/span>(<\/span>time_layout<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Create<\/span> <\/span>matplotlib<\/span> <\/span>figure<\/span><\/span>\n        <\/span>self<\/span>.<\/span>figure<\/span>,<\/span> <\/span>self<\/span>.<\/span>ax<\/span> = <\/span>plt<\/span>.<\/span>subplots<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>canvas<\/span> = <\/span>FigureCanvas<\/span>(<\/span>self<\/span>.<\/span>figure<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addWidget<\/span>(<\/span>self<\/span>.<\/span>canvas<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Analysis<\/span> <\/span>buttons<\/span><\/span>\n        <\/span>button_layout<\/span> = <\/span>QHBoxLayout<\/span>()<\/span><\/span>\n        <\/span>cycle_btn<\/span> = <\/span>QPushButton<\/span>(<\/span>"<\/span>Cycle Time Analysis<\/span>"<\/span>)<\/span><\/span>\n        <\/span>alarm_btn<\/span> = <\/span>QPushButton<\/span>(<\/span>"<\/span>Alarm Analysis<\/span>"<\/span>)<\/span><\/span>\n        <\/span>export_btn<\/span> = <\/span>QPushButton<\/span>(<\/span>"<\/span>Export Data<\/span>"<\/span>)<\/span><\/span>\n        <\/span>button_layout<\/span>.<\/span>addWidget<\/span>(<\/span>cycle_btn<\/span>)<\/span><\/span>\n        <\/span>button_layout<\/span>.<\/span>addWidget<\/span>(<\/span>alarm_btn<\/span>)<\/span><\/span>\n        <\/span>button_layout<\/span>.<\/span>addWidget<\/span>(<\/span>export_btn<\/span>)<\/span><\/span>\n        <\/span>layout<\/span>.<\/span>addLayout<\/span>(<\/span>button_layout<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        # <\/span>Connect<\/span> <\/span>buttons<\/span><\/span>\n        <\/span>cycle_btn<\/span>.<\/span>clicked<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>analyze_cycle_time<\/span>)<\/span><\/span>\n        <\/span>alarm_btn<\/span>.<\/span>clicked<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>analyze_alarms<\/span>)<\/span><\/span>\n        <\/span>export_btn<\/span>.<\/span>clicked<\/span>.<\/span>connect<\/span>(<\/span>self<\/span>.<\/span>export_data<\/span>)<\/span><\/span>\n        <\/span><\/span>\n        <\/span>return<\/span> <\/span>tab<\/span><\/span>\n    <\/span><\/span>\n    <\/span>def<\/span> <\/span>update_data<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Update live data displays<\/span>"""<\/span><\/span>\n        <\/span>try<\/span>:<\/span><\/span>\n            <\/span>machine<\/span> = <\/span>self<\/span>.<\/span>machine_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n            # <\/span>Query<\/span> <\/span>latest<\/span> <\/span>data<\/span> <\/span>for<\/span> <\/span>selected<\/span> <\/span>machine<\/span><\/span>\n            <\/span>self<\/span>.<\/span>cursor<\/span>.<\/span>execute<\/span>(<\/span>"""<\/span><\/span>\n                SELECT * FROM machine_data<\/span> <\/span><\/span>\n                <\/span>WHERE<\/span> <\/span>machine_id<\/span> = ? <\/span><\/span>\n                <\/span>ORDER<\/span> <\/span>BY<\/span> <\/span>timestamp<\/span> <\/span>DESC<\/span> <\/span>LIMIT<\/span> 1<\/span><\/span>\n            <\/span>"""<\/span>, (machine,)<\/span>)<\/span><\/span>\n            <\/span>data<\/span> = <\/span>self<\/span>.<\/span>cursor<\/span>.<\/span>fetchone<\/span>()<\/span><\/span>\n            <\/span><\/span>\n            <\/span>if<\/span> <\/span>data<\/span>:<\/span><\/span>\n                <\/span>self<\/span>.<\/span>update_status_table<\/span>(<\/span>data<\/span>)<\/span><\/span>\n                <\/span>self<\/span>.<\/span>update_alarms<\/span>(<\/span>data<\/span>)<\/span><\/span>\n        <\/span>except<\/span> <\/span>Exception<\/span> <\/span>as<\/span> <\/span>e<\/span>:<\/span><\/span>\n            <\/span>print<\/span>(<\/span>f<\/span>"<\/span>Update error: {e}<\/span>"<\/span>)<\/span><\/span>\n            <\/span><\/span>\n    <\/span>def<\/span> <\/span>update_status_table<\/span>(<\/span>self<\/span>,<\/span> <\/span>data<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Update the status table with latest data<\/span>"""<\/span><\/span>\n        <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>setRowCount<\/span>(0)<\/span><\/span>\n        <\/span>for<\/span> <\/span>key<\/span>,<\/span> <\/span>value<\/span> <\/span>in<\/span> <\/span>data<\/span>.<\/span>items<\/span>():<\/span><\/span>\n            <\/span>row<\/span> = <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>rowCount<\/span>()<\/span><\/span>\n            <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>insertRow<\/span>(<\/span>row<\/span>)<\/span><\/span>\n            <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>setItem<\/span>(<\/span>row<\/span>,<\/span> 0<\/span>,<\/span> <\/span>QTableWidgetItem<\/span>(<\/span>key<\/span>))<\/span><\/span>\n            <\/span>self<\/span>.<\/span>status_table<\/span>.<\/span>setItem<\/span>(<\/span>row<\/span>,<\/span> 1<\/span>,<\/span> <\/span>QTableWidgetItem<\/span>(<\/span>str<\/span>(<\/span>value<\/span>)))<\/span><\/span>\n            <\/span><\/span>\n    <\/span>def<\/span> <\/span>update_alarms<\/span>(<\/span>self<\/span>,<\/span> <\/span>data<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Update alarm display<\/span>"""<\/span><\/span>\n        <\/span>if<\/span> <\/span>'<\/span>alarms<\/span>'<\/span> <\/span>in<\/span> <\/span>data<\/span> <\/span>and<\/span> <\/span>data<\/span>[<\/span>'<\/span>alarms<\/span>'<\/span>]:<\/span><\/span>\n            <\/span>self<\/span>.<\/span>alarm_text<\/span>.<\/span>setText<\/span>(<\/span>'<\/span>\\n<\/span>'<\/span>.<\/span>join<\/span>(<\/span>data<\/span>[<\/span>'<\/span>alarms<\/span>'<\/span>]))<\/span><\/span>\n        <\/span>else<\/span>:<\/span><\/span>\n            <\/span>self<\/span>.<\/span>alarm_text<\/span>.<\/span>setText<\/span>(<\/span>"<\/span>No active alarms<\/span>"<\/span>)<\/span><\/span>\n            <\/span><\/span>\n    <\/span>def<\/span> <\/span>upload_program<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Upload program to selected machine<\/span>"""<\/span><\/span>\n        <\/span>program<\/span> = <\/span>self<\/span>.<\/span>program_editor<\/span>.<\/span>toPlainText<\/span>()<\/span><\/span>\n        <\/span>machine<\/span> = <\/span>self<\/span>.<\/span>machine_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        <\/span>program_number<\/span> = <\/span>self<\/span>.<\/span>program_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        # <\/span>Implement<\/span> <\/span>program<\/span> <\/span>upload<\/span> <\/span>logic<\/span> <\/span>here<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>download_program<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Download program from selected machine<\/span>"""<\/span><\/span>\n        <\/span>machine<\/span> = <\/span>self<\/span>.<\/span>machine_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        <\/span>program_number<\/span> = <\/span>self<\/span>.<\/span>program_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        # <\/span>Implement<\/span> <\/span>program<\/span> <\/span>download<\/span> <\/span>logic<\/span> <\/span>here<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>analyze_cycle_time<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Perform cycle time analysis<\/span>"""<\/span><\/span>\n        <\/span>time_range<\/span> = <\/span>self<\/span>.<\/span>time_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        # <\/span>Query<\/span> <\/span>and<\/span> <\/span>analyze<\/span> <\/span>cycle<\/span> <\/span>time<\/span> <\/span>data<\/span><\/span>\n        <\/span>self<\/span>.<\/span>ax<\/span>.<\/span>clear<\/span>()<\/span><\/span>\n        # <\/span>Plot<\/span> <\/span>cycle<\/span> <\/span>time<\/span> <\/span>data<\/span><\/span>\n        <\/span>self<\/span>.<\/span>canvas<\/span>.<\/span>draw<\/span>()<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>analyze_alarms<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Perform alarm analysis<\/span>"""<\/span><\/span>\n        <\/span>time_range<\/span> = <\/span>self<\/span>.<\/span>time_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        # <\/span>Query<\/span> <\/span>and<\/span> <\/span>analyze<\/span> <\/span>alarm<\/span> <\/span>data<\/span><\/span>\n        <\/span>self<\/span>.<\/span>ax<\/span>.<\/span>clear<\/span>()<\/span><\/span>\n        # <\/span>Plot<\/span> <\/span>alarm<\/span> <\/span>data<\/span><\/span>\n        <\/span>self<\/span>.<\/span>canvas<\/span>.<\/span>draw<\/span>()<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>export_data<\/span>(<\/span>self<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Export analysis data to CSV<\/span>"""<\/span><\/span>\n        <\/span>time_range<\/span> = <\/span>self<\/span>.<\/span>time_combo<\/span>.<\/span>currentText<\/span>()<\/span><\/span>\n        # <\/span>Query<\/span> <\/span>data<\/span> <\/span>and<\/span> <\/span>export<\/span> <\/span>to<\/span> <\/span>CSV<\/span><\/span>\n        <\/span><\/span>\n    <\/span>def<\/span> <\/span>closeEvent<\/span>(<\/span>self<\/span>,<\/span> <\/span>event<\/span>):<\/span><\/span>\n        <\/span>"""<\/span>Clean up on close<\/span>"""<\/span><\/span>\n        <\/span>self<\/span>.<\/span>timer<\/span>.<\/span>stop<\/span>()<\/span><\/span>\n        <\/span>self<\/span>.<\/span>conn<\/span>.<\/span>close<\/span>()<\/span><\/span>\n        <\/span>event<\/span>.<\/span>accept<\/span>()<\/span><\/span>\n<\/span>\nif<\/span> <\/span>__name__<\/span> == <\/span>'<\/span>__main__<\/span>'<\/span>:<\/span><\/span>\n    <\/span>app<\/span> = <\/span>QApplication<\/span>(<\/span>sys<\/span>.<\/span>argv<\/span>)<\/span><\/span>\n    <\/span>window<\/span> = <\/span>ShopFloorClient<\/span>()<\/span><\/span>\n    <\/span>window<\/span>.<\/span>show<\/span>()<\/span><\/span>\n    <\/span>sys<\/span>.<\/span>exit<\/span>(<\/span>app<\/span>.<\/span>exec<\/span>())<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
                  Once again, this is a draft. Likely development will proceed as follows:<\/p>\n\n\n\n
                    \n
                  1. Attain functional Data Management and Transfer<\/li>\n\n\n\n
                  2. Harden Security<\/li>\n\n\n\n
                  3. Iterations of development to improve functionality, compatibility and security as time progresses.<\/li>\n<\/ol>\n\n\n\n
                    Key Features of the Shop Client:<\/p>\n\n\n\n
                      \n
                    1. Live monitoring of all connected machines<\/li>\n\n\n\n
                    2. Program upload\/download capability<\/li>\n\n\n\n
                    3. Real-time status updates<\/li>\n\n\n\n
                    4. Alarm monitoring<\/li>\n\n\n\n
                    5. Data analysis tools<\/li>\n\n\n\n
                    6. Export functionality for reports<\/li>\n<\/ol>\n\n\n\n
                      System Service Unit File:<\/strong><\/p>\n\n\n\n
                      <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
                      [<\/span>Unit<\/span>]<\/span><\/span>\nDescription<\/span>=<\/span>Shop<\/span> <\/span>Floor<\/span> <\/span>Monitoring<\/span> <\/span>Client<\/span><\/span>\nAfter<\/span>=<\/span>network<\/span>.<\/span>target<\/span><\/span>\n<\/span>\n[<\/span>Service<\/span>]<\/span><\/span>\nType<\/span>=<\/span>simple<\/span><\/span>\nUser<\/span>=<\/span>YOUR_USERNAME<\/span><\/span>\nWorkingDirectory<\/span>=\/<\/span>path<\/span>\/<\/span>to<\/span>\/<\/span>application<\/span><\/span>\nEnvironment<\/span>=<\/span>DISPLAY<\/span>=<\/span>:<\/span>0<\/span><\/span>\nExecStart<\/span>=\/<\/span>path<\/span>\/<\/span>to<\/span>\/<\/span>venv<\/span>\/<\/span>bin<\/span>\/<\/span>python<\/span> <\/span>shop_client<\/span>.<\/span>py<\/span><\/span>\nRestart<\/span>=<\/span>always<\/span><\/span>\n<\/span>\n[<\/span>Install<\/span>]<\/span><\/span>\nWantedBy<\/span>=<\/span>multi<\/span>-<\/span>user<\/span>.<\/span>target<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
                      So there you have it, an initial speculative toplogy for WorkCell IoT from the Shop. Please let me know your concerns and suggestions. Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"
                      In order to examine consolidation of production data and program management, it is prudent to create a LAN IoT solution for a single WorkCell as an experiment. The feasibility and best practices can be determined from this scope while limiting research cost and potential consequential complications. In furthering this experiment, notes have been taken regarding<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"pagelayer_contact_templates":[],"_pagelayer_content":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1608","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nRaspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Raspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site\" \/>\n<meta property=\"og:description\" content=\"In order to examine consolidation of production data and program management, it is prudent to create a LAN IoT solution for a single WorkCell as an experiment. The feasibility and best practices can be determined from this scope while limiting research cost and potential consequential complications. In furthering this experiment, notes have been taken regarding\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/\" \/>\n<meta property=\"og:site_name\" content=\"SparkOne() Labs Official Site\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=61551444286908\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-11T16:45:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-15T17:35:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sparkonelabs\" \/>\n<meta name=\"twitter:site\" content=\"@sparkonelabs\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#\\\/schema\\\/person\\\/ee3bd21f007818ac04abf178e749642c\"},\"headline\":\"Raspberry Pi 4 B IoT Data Collection: Single Workcell\",\"datePublished\":\"2025-01-11T16:45:04+00:00\",\"dateModified\":\"2025-01-15T17:35:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/\"},\"wordCount\":910,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/IoT-topology-2-usb-wifi-connections_0-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/\",\"url\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/\",\"name\":\"Raspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/IoT-topology-2-usb-wifi-connections_0-1.png\",\"datePublished\":\"2025-01-11T16:45:04+00:00\",\"dateModified\":\"2025-01-15T17:35:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/IoT-topology-2-usb-wifi-connections_0-1.png?fit=910%2C783&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/IoT-topology-2-usb-wifi-connections_0-1.png?fit=910%2C783&ssl=1\",\"width\":910,\"height\":783},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/2025\\\/01\\\/11\\\/raspberry-pi-4-b-iot-data-collection-single-workcell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Raspberry Pi 4 B IoT Data Collection: Single Workcell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#website\",\"url\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/\",\"name\":\"SparkOne() Labs Official Site\",\"description\":\"SparkOne Labs is a Science, Art and Technology blog. Email: sparkonelabs@sparkonelabs.com\",\"publisher\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#organization\"},\"alternateName\":\"SparkOne Labs\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#organization\",\"name\":\"SparkOne() Labs\",\"alternateName\":\"SparkOne Labs\",\"url\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/logo_sparkone_12.png\",\"contentUrl\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/logo_sparkone_12.png\",\"width\":1152,\"height\":896,\"caption\":\"SparkOne() Labs\"},\"image\":{\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=61551444286908\",\"https:\\\/\\\/x.com\\\/sparkonelabs\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/#\\\/schema\\\/person\\\/ee3bd21f007818ac04abf178e749642c\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/sparkonelabs.com\\\/home\"],\"url\":\"https:\\\/\\\/sparkonelabs.com\\\/home\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Raspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/","og_locale":"en_US","og_type":"article","og_title":"Raspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site","og_description":"In order to examine consolidation of production data and program management, it is prudent to create a LAN IoT solution for a single WorkCell as an experiment. The feasibility and best practices can be determined from this scope while limiting research cost and potential consequential complications. In furthering this experiment, notes have been taken regarding","og_url":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/","og_site_name":"SparkOne() Labs Official Site","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=61551444286908","article_published_time":"2025-01-11T16:45:04+00:00","article_modified_time":"2025-01-15T17:35:06+00:00","og_image":[{"url":"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@sparkonelabs","twitter_site":"@sparkonelabs","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#article","isPartOf":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/"},"author":{"name":"admin","@id":"https:\/\/sparkonelabs.com\/home\/#\/schema\/person\/ee3bd21f007818ac04abf178e749642c"},"headline":"Raspberry Pi 4 B IoT Data Collection: Single Workcell","datePublished":"2025-01-11T16:45:04+00:00","dateModified":"2025-01-15T17:35:06+00:00","mainEntityOfPage":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/"},"wordCount":910,"commentCount":0,"publisher":{"@id":"https:\/\/sparkonelabs.com\/home\/#organization"},"image":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#primaryimage"},"thumbnailUrl":"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/","url":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/","name":"Raspberry Pi 4 B IoT Data Collection: Single Workcell - SparkOne() Labs Official Site","isPartOf":{"@id":"https:\/\/sparkonelabs.com\/home\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#primaryimage"},"image":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#primaryimage"},"thumbnailUrl":"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png","datePublished":"2025-01-11T16:45:04+00:00","dateModified":"2025-01-15T17:35:06+00:00","breadcrumb":{"@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#primaryimage","url":"https:\/\/i0.wp.com\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png?fit=910%2C783&ssl=1","contentUrl":"https:\/\/i0.wp.com\/sparkonelabs.com\/home\/wp-content\/uploads\/2025\/01\/IoT-topology-2-usb-wifi-connections_0-1.png?fit=910%2C783&ssl=1","width":910,"height":783},{"@type":"BreadcrumbList","@id":"https:\/\/sparkonelabs.com\/home\/2025\/01\/11\/raspberry-pi-4-b-iot-data-collection-single-workcell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sparkonelabs.com\/home\/"},{"@type":"ListItem","position":2,"name":"Raspberry Pi 4 B IoT Data Collection: Single Workcell"}]},{"@type":"WebSite","@id":"https:\/\/sparkonelabs.com\/home\/#website","url":"https:\/\/sparkonelabs.com\/home\/","name":"SparkOne() Labs Official Site","description":"SparkOne Labs is a Science, Art and Technology blog. Email: sparkonelabs@sparkonelabs.com","publisher":{"@id":"https:\/\/sparkonelabs.com\/home\/#organization"},"alternateName":"SparkOne Labs","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sparkonelabs.com\/home\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sparkonelabs.com\/home\/#organization","name":"SparkOne() Labs","alternateName":"SparkOne Labs","url":"https:\/\/sparkonelabs.com\/home\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sparkonelabs.com\/home\/#\/schema\/logo\/image\/","url":"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2024\/01\/logo_sparkone_12.png","contentUrl":"https:\/\/sparkonelabs.com\/home\/wp-content\/uploads\/2024\/01\/logo_sparkone_12.png","width":1152,"height":896,"caption":"SparkOne() Labs"},"image":{"@id":"https:\/\/sparkonelabs.com\/home\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=61551444286908","https:\/\/x.com\/sparkonelabs"]},{"@type":"Person","@id":"https:\/\/sparkonelabs.com\/home\/#\/schema\/person\/ee3bd21f007818ac04abf178e749642c","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bc8a8c84ca952e624e7407ec63589bc91e7996574dee7a01c13a96c536c341e9?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/sparkonelabs.com\/home"],"url":"https:\/\/sparkonelabs.com\/home\/author\/admin\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/posts\/1608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/comments?post=1608"}],"version-history":[{"count":4,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/posts\/1608\/revisions"}],"predecessor-version":[{"id":1660,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/posts\/1608\/revisions\/1660"}],"wp:attachment":[{"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/media?parent=1608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/categories?post=1608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sparkonelabs.com\/home\/wp-json\/wp\/v2\/tags?post=1608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}