search

Jishar13 / pvbeancounter

Automatically exported from code.google.com/p/pvbeancounter
1 stars 0 forks source link

pvbeancounter question #21

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 

In the following step
11 - Open SMA's Sunny Explorer and create a new Sunny Explorer plant 
definition. Name the new plant "SunnyExplorer" and save the plant definition in 
a file named "SunnyExplorer.sx2". This file must be saved to the "Default 
Directory" configured above. 
Can you be more specific re the default directory?  What is the path? It says 
see above but sorry im confused lol.
I have it all running but for some reason its pushing 0's to the pvoutput site.

Original issue reported on code.google.com by Joesan...@gmail.com on 8 Apr 2011 at 4:01

GoogleCodeExporter commented 8 years ago 
On the SQLite config page it says:

6 - Ensure that "Default Directory" contains the correct location of the 
"PVRecords" folder. 

This is on the "Basic Configuration" tab is is normally C:\PVRecords

This is the directory that contains the SQLite or MS Access database as well as 
the Archive directory.

You need to create this directory yourself using the contents of the 
PVRecords.zip file. This is visible in the program menu and is stored in the 
main program file directory.

I suggest you examine the PVService.log file (also found in the default 
directory). If you cannot solve the problem please upload the PVService.log 
file and the settings.xml file (in the main program directory).

Dennis M-F

Original comment by DennisMackayFisher on 8 Apr 2011 at 9:00

GoogleCodeExporter commented 8 years ago 
I have the PVRecords folder in the root of c:\ drive.
Within the folder are the extracted files and the SunnyExplorer.sx2 file

I have attached the pvservice.log file for your reference.

As mentioned previously it pushes up zeros to the site.

Original comment by Joesan...@gmail.com on 8 Apr 2011 at 12:46

GoogleCodeExporter commented 8 years ago 
Sunny Explorer does not return an error code if it cannot reach the inverter, I 
just dies silently. It behaves the same way as it would if bluetooth was turned 
off of communication was too weak. The absence of errors indicates that 
SunnyExplorer is not communicating with the inverter via bluetooth. In most 
cases this has proved to be an issue with the plant name in the 
SunnyExplorer.sx2 file.

Use Sunny Explorer to manually open your SunnyExplorer.sx2 file. Confirm that 
the plant name is SunnyExplorer.

I assume you are using 32 bit windows, that is reflected in your settings.xml 
file.

Please download the attached batch file (it will work on 32bit only) and place 
it in the C:\PVRecords directory.

Stop the PVBC service to prevent interference.
Open the windows "Command Prompt" and enter:

cd "C:\PVRecords"
SunnyExplorerTest_x86.bat "C:\PVRecords" 20110408

--------------------------------------------------

This simulates the command executed by PVBC to extract data from the inverter. 
You will see messages regarding progress on the screen. If if works correctly 
you will find a file named C:\PVRecords\SunnyExplorer-20110408.csv

The SunnyExplorer part of this name comes from the plant name you entered when 
you created the SunnyExplorer.sx2 file. If the plant name is wrong, the csv 
file will have the wrong name.

Use this to test your SunnyExplorer.sx2 installation.

Dennis M-F

Original comment by DennisMackayFisher on 8 Apr 2011 at 11:15

GoogleCodeExporter commented 8 years ago 
Here are the results. Deffinetly connects to the inverter.  Bluetoothlight 
comes on when its running.

C:\PVRecords>"C:\Program Files\SMA\Sunny Explorer\SunnyExplorer.exe" "C:\PVRecor
ds"\SunnyExplorer.sx2 -userlevel user -password "0000" -exportdir "C:\PVRecords"
 -exportrange 20110408-20110408 -export energy5min
CSV-Export: establishing connection to plant ...
CSV-Export: plant login started ...
CSV-Export: current plant time is 9/04/2011 4:15:54 PM
CSV-Export: starting export ...
CSV-Export: completed

C:\PVRecords>dir
 Volume in drive C has no label.
 Volume Serial Number is DAE5-5EC0

 Directory of C:\PVRecords

09/04/2011  04:16 PM    <DIR>          .
09/04/2011  04:16 PM    <DIR>          ..
08/04/2011  02:36 PM    <DIR>          Archive
08/04/2011  12:08 AM    <DIR>          Empty Databases
08/04/2011  02:36 PM         1,269,760 pvhistory.s3db
09/12/2010  05:26 PM           434,176 PVRecords_jet.accdb
07/04/2011  05:31 PM           462,848 PVRecords_jet.mdb
08/04/2011  02:38 PM             1,646 PVService.log
09/04/2011  04:16 PM             9,459 SunnyExplorer-20110408.csv
09/04/2011  04:15 PM             4,464 SunnyExplorer.sx2
09/04/2011  04:13 PM               161 SunnyExplorerTest_x86.bat
               7 File(s)      2,182,514 bytes
               4 Dir(s)  289,321,467,904 bytes free

C:\PVRecords>

Original comment by Joesan...@gmail.com on 9 Apr 2011 at 6:20

GoogleCodeExporter commented 8 years ago 
This all seems to be working correctly.

I had a look at your pvoutput live page. You are loading consumption data. It 
is possible that this consumption data load is ovevwriting th PVBC output. How 
is the consumption data loaded? What type of meter is in use?

Original comment by DennisMackayFisher on 9 Apr 2011 at 8:53

GoogleCodeExporter commented 8 years ago 
No i am currently running pvupload for now to get the data up there.  When i 
use pvbeancounter i end the task and disable the scheduler so pvupload does not 
run.  Then i fire up pvbeancounter to try but not success so far.  I might try 
turning off the windows firewall as a test later in the day when i get home 
from work. You never know with windows.

Original comment by Joesan...@gmail.com on 9 Apr 2011 at 11:07

GoogleCodeExporter commented 8 years ago 
When you try again, Check "Log Content - Trace" on the Advanced tab, save you 
settings and start the service. After about 1 hour, upload a copy of the 
resultant log file. I am hoping the trace entries will contain a clue.

Dennis M-F

Original comment by DennisMackayFisher on 11 Apr 2011 at 10:30

GoogleCodeExporter commented 8 years ago 
I have attached my pvrecords folder.

Original comment by Joesan...@gmail.com on 11 Apr 2011 at 11:50

GoogleCodeExporter commented 8 years ago 
I note that it seems to have worked today. There are entries in the database 
and a green line at pvoutput.org.

Do you know what made the difference?

Original comment by DennisMackayFisher on 12 Apr 2011 at 12:20

GoogleCodeExporter commented 8 years ago 
PS

Can you send me a csv file (in the Arvhive directory) from the end of 12/04. I 
wouldlike to examine the flat spots (0 output). Is the csv file correct? Was 
your output very low on 12/04?

Dennis M-F

Original comment by DennisMackayFisher on 12 Apr 2011 at 12:23

GoogleCodeExporter commented 8 years ago 
Here are todays fresh ones.  I cleaned out yesterdays.

Original comment by Joesan...@gmail.com on 12 Apr 2011 at 10:45

GoogleCodeExporter commented 8 years ago 
Just an update on this.   I switched everything back to use msaccess instead of 
sql there were also some windows updates for msoffice which i applied and 
restarted the machine.  Looks like pvbeancounter is now working and pushing the 
data up to pvoutput.org using the access databases.

Original comment by Joesan...@gmail.com on 12 Apr 2011 at 11:49

GoogleCodeExporter commented 8 years ago 
I am pleased the issue is resolved.

Regards
Dennis M-F

Original comment by DennisMackayFisher on 13 Apr 2011 at 9:01