Quelltext der Seite Inhalt/Arduino PM

== Arduino Power Monitoring Project v1.2 == 


[[Bild:arduinoSmall.jpg]]

----


Xml Impulses List Output: 

* ARDUINO N Panel http://10.254.50.20
* ARDUINO U Panel http://10.254.50.21

----


Database:

* Host: apm.in.nessus.at 
* User: apm
* Pass: xxx

* TABLES:
 - impulses (contains all impulses data inserted)
 - mapping (contains all mapped RACK_ID to PRIMARY_ID of table IMPULSES)
 - rack_impulses (view containg merged information)

----


Django Web Frontend (temporary)

* Total Overview http://10.254.50.132:8000/power

* Detailed View http://10.254.50.132:8000/power/1 ( /* = powerswitch mapped number)


----


Hardware used/developed:

*Arduino Duemilanove Atmel328 (Diecimila Atmel168)
*Multiplexer Shields (8x Maxim-Intersil [http://www.intersil.com/data/fn/fn3116.pdf DG406])
*Forlong DRS-201D kWh meter


----

Software used/developed:

scripts path @apm.in.nessus.at:/home/bons/apm

* Arduino
  - Arduino_PM 1.2b ([[Media:ArduinoPM_b.pde |source code]]) revision B
  - Arduino_PM 1.3 ([[Media:ArduinoPM_1_3b.pde |source code]]) version 3
              added sync feature between arduino memory and db

* Python
  - apmrobot.py - Apm Robot for XML data import - ([[Media:apmrobot.py |source code]])
  - sync2db.py - Sync2db XML-arduino-memory and DB  - ([[Media:sync2db.py |source code]])
  - memreset.py - Cronjob runs every monday and resets impulse memory of the arduino to prevent overrun

* USAGE:
  - apmrobot.py - Parse XML output from ARDUINO and INSERT data in DB (sanity value check control included)
  - sync2db.py param1 param2 (where param1=RACK_ID and param2=KWfromDISPLAY to sync) 
          example: "sync2db.py N1P1 100" 
                this will update the DB value of RACK N1P1 with value 100*2000 (1kw/h = 2000 impulses)
                and reset the memory of the arduino for that rack to 0 to start counting

== Project RoadMap: == 

*Circuit:
**Multiplexer Shield [https://backoffice.nessus.at/Wiki/Nessus/wiki/images/a/af/Mux.brd Circuit Design]
**Conversion with script metaboard.sh (process developed @ Metalab.at) to output file for CNC
**Milling and Drilling with CNC
**Soldering and Cabling


*Software:
** Arduino
*** Reading impulse on GPIO pins
*** Cycling Multiplexers
*** Store multiplexing and impulses data in "unsigned long" 3d matrix (2x16x8) [impulse capacity upgraded to 2^31-1]
*** Webserver with live XML output available on EthernetShield


** Python
*** Manage data import from arduino memory xml (parse, check, insert)
*** Sync arduino memory with db to current read value (webserver http get parse for parameters)
*** Django DB model for data stored in memory
*** Django Views for showing stored Power Information

== Power Racks/Switches Mapping ==

{| class="wikitable" border="1" cellpadding="5" cellspacing="0"
! RackSwitch !! CableColor !! Connector/pin !! Mux !! Pin 
|- 
| <b>N1P1</b> || green || A / 1 || 1 || s1 
|- 
| <b>N1P2</b> || white || A / 2 || 1 || s2 
|- 
| <b>N1P3</b> || red || A / 3 || 1 || s3
|- 
| <b>N1P4</b> || green || A / 4 || 1 || s4
|- 
| <b>N1P5</b> || white || A / 5 || 1 || s5 
|- 
| <b>N1P6</b> || red || A / 6 || 1 || s6
|- 
| <b>N2P1</b> || blue || A / 7 || 1 || s7
|- 
| <b>N2P2</b> || red || A / 8 || 1 || s8  
|- 
| <b>N2P3</b> || blue || B / 1 || 1 || s9 
|- 
| <b>N2P4</b> || red || B / 2 || 1 || s10 
|- 
| <b>N2P5</b> || blue || B / 3 || 1 || s11
|- 
| <b>N2P6</b> || white || B / 4 || 1 || s12
|- 
| <b>N3P1</b> || green || B / 5 || 1 || s13
|- 
| <b>N3P2</b> || green || B / 6 || 1 || s14
|- 
| <b>N3P3</b> || white || B / 7 || 1 || s15
|- 
| <b>N3P4</b> || red || B / 8 || 1 || s16
|- 
| <b>N3P5</b> || green || C / 1 || 2 || s1
|- 
| <b>N3P6</b> || red || C / 2 || 2 || s2
|- 
| <b>N4P1</b> || blue || C / 3 || 2 || s3
|- 
| <b>N4P2</b> || green || C / 4 || 2 || s4
|- 
| <b>N4P3</b> || white || C / 5 || 2 || s5
|- 
| <b>N4P4</b> || red || C / 6 || 2 || s6
|- 
| <b>N4P5</b> || blue || C / 7 || 2 || s7
|- 
| <b>N4P6</b> || white || C / 8 || 2 || s8
|- 
| <b>N5P1</b> || white || D / 1 || 2 || s9
|- 
| <b>N5P2</b> || green || D / 2 || 2 || s10
|- 
| <b>N5P3</b> || blue || D / 3 || 2 || s11
|-
| <b>N5P4</b> || red || D / 4 || 2 || s12 
|-
| <b>N5P5</b> || white || D / 5 || 2 || s13 
|-
| <b>N5P6</b> || red || D / 6 || 2 || s14 
|-
| <b>N6P1</b> || green || D / 7 || 2 || s15 
|-
| <b>N6P2</b> || blue || D / 8 || 2 || s16 
|-
| <b>N6P3</b> || blue || E / 1 || 3 || s1 
|-
| <b>N6P4</b> || white || E / 2  || 3 || s2 
|-
| <b>N6P5</b> || green || E / 3 || 3 || s3 
|-
| <b>N6P6</b> || red || E / 4 || 3 || s4
|-
| <b>N7P1</b> || blue || E / 5 || 3  || s5 
|-
| <b>N7P2</b> || white || E / 6 || 3 || s6
|-
| <b>N7P3</b> || red || E / 7 || 3 || s7
|-
| <b>N7P4</b> || green || E / 8 || 3 || s8 
|-
| <b>N7P5</b> || white || F / 1 || 3 || s9
|-
| <b>N7P6</b> || green || F / 2 || 3 || s10
|-
| <b>N8P1</b> || blue || F / 3 || 3 || s11
|-
| <b>N8P2</b> || red || F / 4 || 3 || s12
|-
| <b>N8P3</b> || red || F / 5 || 3 || s13
|-
| <b>N8P4</b> || white || F / 6 || 3 || s14 
|-
| <b>N8P5</b> || green || F / 7 || 3 || s15
|-
| <b>N8P6</b> || blue || F / 8 || 3 || s16
|-
| <b>N9P1</b> || blue || G / 1 || 4 || s1 
|-
| <b>N9P2</b> || red || G / 2 || 4 || s2 
|-
| <b>N9P3</b> || blue || G / 3 || 4 || s3 
|-
| <b>N9P4</b> || green || G / 4 || 4 || s4 
|-
| <b>N9P5</b> || green || G / 5 || 4 || s5
|-
| <b>N9P6</b> || white || G / 6 || 4 || s6
|-
| <b>N10P1</b> || red || G / 7 || 4 || s7
|-
| <b>N10P2</b> || white || G / 8 || 4 || s8 
|-
| <b>N10P3</b> || blue || H / 1 || 4 || s9
|-
| <b>N10P4</b> || white || H / 2 || 4 || s10 
|-
| <b>N10P5</b> || red || H / 3 || 4 || s11
|-
| <b>N10P6</b> || green || H / 4 || 4 || s12 
|-
| <b>N11P1</b> || red || H / 5 || 4 || s13
|-
| <b>N11P2</b> || white || H / 6 || 4 || s14 
|-
| <b>N11P3</b> || green || H / 7 || 4 || s15
|-
| <b>N11P4</b> || blue || H / 8 || 4 || s16
|-
| <b>N11P5</b> || green || I / 1 || 5 || s1
|-
| <b>N11P6</b> || white || I / 2 || 5 || s2
|-
| <b>N12P1</b> || blue || I / 3 || 5 || s3
|-
| <b>N12P2</b> || red || I / 4  || 5 || s4
|-
| <b>N12P3</b> || green || I / 5 || 5 || s5 
|-
| <b>N12P4</b> || blue || I / 6 || 5 || s6
|-
| <b>N12P5</b> || white || I / 7 || 5 || s7 
|-
| <b>N12P6</b> || red || I / 8  || 5 || s8
|-
| <b>N13P1</b> || red || J / 1 || 5 || s9
|-
| <b>N13P2</b> || blue || J / 2 || 5 || s10 
|-
| <b>N13P3</b> || green || J / 3 || 5 || s11
|-
| <b>N13P4</b> || white || J / 4 || 5 || s12
|-
| <b>N13P5</b> || blue || J / 5 || 5 || s13
|-
| <b>N13P6</b> || white || J / 6 || 5 || s14
|-
| <b>N14P1</b> || green || J / 7 || 5 || s15
|-
| <b>N14P2</b> || red || J / 8 || 5 || s16
|-
| <b>N14P3</b> || n/a ||  ||  ||  
|-
| <b>N14P4</b> || n/a ||  ||  || 
|-
| <b>N14P5</b> || n/a ||  ||  ||  
|-
| <b>N14P6</b> || n/a ||  ||  || 
|-
|}

<br>

{| class="wikitable" border="1" cellpadding="5" cellspacing="0"
! RackSwitch !! CableColor !! Connector/pin !! Mux !! Pin 
|- 
| <b>U1P1</b> || black/brown || A / 1 || 1 || s1 
|- 
| <b>U1P2</b> || white/gray || A / 2 || 1 || s2 
|- 
| <b>U1P3</b> || yellow/gray || A / 3 || 1 || s3
|- 
| <b>U1P4</b> || red/white || A / 4 || 1 || s4
|- 
| <b>U1P5</b> || white/black || A / 5 || 1 || s5 
|- 
| <b>U1P6</b> || pink/green || A / 6 || 1 || s6
|- 
| <b>U2P1</b> || white/blue || A / 7 || 1 || s7
|- 
| <b>U2P2</b> || brown/blue || A / 8 || 1 || s8  
|- 
| <b>U2P3</b> || brown || B / 1 || 1 || s9 
|- 
| <b>U2P4</b> || red || B / 2 || 1 || s10 
|- 
| <b>U2P5</b> || blue || B / 3 || 1 || s11
|- 
| <b>U2P6</b> || gray || B / 4 || 1 || s12
|- 
| <b>U3P1</b> || pink || B / 5 || 1 || s13
|- 
| <b>U3P2</b> || green || B / 6 || 1 || s14
|- 
| <b>U3P3</b> || white || B / 7 || 1 || s15
|- 
| <b>U3P4</b> || yellow || B / 8 || 1 || s16
|- 
| <b>U3P5</b> || green/blue || C / 1 || 2 || s1
|- 
| <b>U3P6</b> || purple || C / 2 || 2 || s2
|- 
| <b>U4P1</b> || red || C / 3 || 2 || s3
|- 
| <b>U4P2</b> || black || C / 4 || 2 || s4
|- 
| <b>U4P3</b> || white || C / 5 || 2 || s5
|- 
| <b>U4P4</b> || yellow/blue || C / 6 || 2 || s6
|- 
| <b>U4P5</b> || blue || C / 7 || 2 || s7
|- 
| <b>U4P6</b> || brown || C / 8 || 2 || s8
|- 
| <b>U5P1</b> || yellow/red || D / 1 || 2 || s9
|- 
| <b>U5P2</b> || pink/red || D / 2 || 2 || s10
|- 
| <b>U5P3</b> || green/red || D / 3 || 2 || s11
|-
| <b>U5P4</b> || gray/red || D / 4 || 2 || s12 
|-
| <b>U5P5</b> || black || D / 5 || 2 || s13 
|-
| <b>U5P6</b> || blue || D / 6 || 2 || s14 
|-
| <b>U6P1</b> || white/yellow || D / 7 || 2 || s15 
|-
| <b>U6P2</b> || yellow/brown || D / 8 || 2 || s16 
|-
| <b>U6P3</b> || white/pink || E / 1 || 3 || s1 
|-
| <b>U6P4</b> || white/blue || E / 2  || 3 || s2 
|-
| <b>U6P5</b> || brown/blue || E / 3 || 3 || s3 
|-
| <b>U6P6</b> || pink/green || E / 4 || 3 || s4
|-
| <b>U7P1</b> || yellow/pink || E / 5 || 3  || s5 
|-
| <b>U7P2</b> || pink/brown || E / 6 || 3 || s6
|-
| <b>U7P3</b> || green/gray || E / 7 || 3 || s7
|-
| <b>U7P4</b> || yellow/gray || E / 8 || 3 || s8 
|-
| <b>U7P5</b> || brown/black || F / 1 || 3 || s9
|-
| <b>U7P6</b> || white/red || F / 2 || 3 || s10
|-
| <b>U8P1</b> || white/black || F / 3 || 3 || s11
|-
| <b>U8P2</b> || red/blue || F / 4 || 3 || s12
|-
| <b>U8P3</b> || green/blue || F / 5 || 3 || s13
|-
| <b>U8P4</b> || gray/pink || F / 6 || 3 || s14 
|-
| <b>U8P5</b> || yellow/blue || F / 7 || 3 || s15
|-
| <b>U8P6</b> || brown/brown || F / 8 || 3 || s16
|-
| <b>U9P1</b> || black || G / 1 || 4 || s1 
|-
| <b>U9P2</b> || pink/gray || G / 2 || 4 || s2 
|-
| <b>U9P3</b> || brown/green || G / 3 || 4 || s3 
|-
| <b>U9P4</b> || white/green || G / 4 || 4 || s4 
|-
| <b>U9P5</b> || yellow/brown || G / 5 || 4 || s5
|-
| <b>U9P6</b> || white/yellow || G / 6 || 4 || s6
|-
| <b>U10P1</b> || red/blue || G / 7 || 4 || s7
|-
| <b>U10P2</b> || purple || G / 8 || 4 || s8 
|-
| <b>U10P3</b> || green/black || H / 1 || 4 || s9
|-
| <b>U10P4</b> || blue/black || H / 2 || 4 || s10 
|-
| <b>U10P5</b> || yellow/black || H / 3 || 4 || s11
|-
| <b>U10P6</b> || white || H / 4 || 4 || s12 
|-
| <b>U11P1</b> || gray/pink || H / 5 || 4 || s13
|-
| <b>U11P2</b> || red/black || H / 6 || 4 || s14 
|-
| <b>U11P3</b> || gray/blue || H / 7 || 4 || s15
|-
| <b>U11P4</b> || pink/blue || H / 8 || 4 || s16
|-
| <b>U11P5</b> || gray/brown || I / 1 || 5 || s1
|-
| <b>U11P6</b> || gray/black || I / 2 || 5 || s2
|-
| <b>U12P1</b> || gray/blue || I / 3 || 5 || s3
|-
| <b>U12P2</b> || green/brown || I / 4  || 5 || s4
|-
| <b>U12P3</b> || yellow/red || I / 5 || 5 || s5 
|-
| <b>U12P4</b> || pink/black || I / 6 || 5 || s6
|-
| <b>U12P5</b> || pink/red || I / 7 || 5 || s7 
|-
| <b>U12P6</b> || pink/blue || I / 8  || 5 || s8
|-
| <b>U13P1</b> || brown/brown || J / 1 || 5 || s9
|-
| <b>U13P2</b> || white/red || J / 2 || 5 || s10 
|-
| <b>U13P3</b> || gray/green || J / 3 || 5 || s11
|-
| <b>U13P4</b> || black/white || J / 4 || 5 || s12
|-
| <b>U13P5</b> || brown/blue || J / 5 || 5 || s13
|-
| <b>U13P6</b> || yellow/gray || J / 6 || 5 || s14
|-
| <b>U14P1</b> || white/blue || J / 7 || 5 || s15
|-
| <b>U14P2</b> || brown/black || J / 8 || 5 || s16
|-
| <b>U14P3</b> || n/a ||  ||  ||  
|-
| <b>U14P4</b> || n/a ||  ||  || 
|-
| <b>U14P5</b> || n/a ||  ||  ||  
|-
| <b>U14P6</b> || n/a ||  ||  || 
|-
|}

<br>