Setup Domoticz

[Pandabeer]

Hello All,

I'm quit new here - installed Domotics on my Raspberry Pi2 - please see attached overview - hope some cof you can help me, advise me, point me in the right direction...

Some details:
Samil inverter connected to Raspberry (RS232 - USB) collect detailed power generation (by perl script) and stores it in a MSQL Database and on PVOutput.org

P1Ethernet collects data from the smart meters like power consumption, power exported (from the sun) and natural gas consumption - this information is sent to teh Raspberry Pi - which (by python3 script) - the information will be stored in the MSQL Database and sent out top PVOutput.org

Now I have some questions,

1) I added PVOutput in Domoticz - but I only receive power generation - how can I add also power consumption and, if possible consumption of natural gas (available on pvoutput.org as extended data) - or is there a smarter way - if so, how? P1Ethernet to Domoticz? How can I sent data from Domoticz to PVOutput?

2) I want to detect water consumption as wel - this is a standard meter (with mirror) - what do you advise (I have a spare Raspberry Pi2 - or should I invest in a Raspberry Pi 3 or Arduino? - what kind of sensor can I use to collect water consumption etc.

3) How can I use data from Domoticz on a custom website?

4) What kind of hardware do you advise if I want to have possibilities in the future to:
- swith lights on voice control
- control temperature per room
- geo fencing

I have KaKu light switches and ICS1000 - also a Nefit + Nefit Moduline thermostat

Thank you for your advise and help!