navitron
 
Renewable Energy and Sustainability Forum
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Anyone wishing to register as a new member on the forum is strongly recommended to use a "proper" email address - following recent spam/hack attempts on the forum, all security is set to "high", and "disposable" email addresses like Gmail, Yahoo and Hotmail tend to be viewed with suspicion, and the application rejected if there is any doubt whatsoever
 
Recent Articles: Navitron Partners With Solax to Help Create A More Sustainable Future | Navitron Calls for Increased Carbon Footprint Reduction In Light of Earth Overshoot Day | A plea from The David School - Issue 18
   Home   Help Search Login Register  
Pages: 1 ... 3 4 5 6 [7]   Go Down
  Print  
Author Topic: Getting data from Mastervolt Sunmaster to PC  (Read 44056 times)
supremetwo
Hero Member
*****
Offline Offline

Posts: 1069


« Reply #90 on: August 15, 2013, 12:23:38 PM »

Hi, does anyone know how to read and manipulate the myLogData.sdf DB file from the XS3200 so I can produce charts of my own.

The author of Masterlog has been asked about export of all data from the myLogData.sdf as a CSV, but so far it has not been implemented. As you have no doubt found, you can only export one day at a time from the grid and there are issues with very large data files loading into the Mlog grid.

Meanwhile, this is my workaround:-

Make a copy of myLogData.sdf.

Work on the copy.

Download:- http://sqlcedatabaseeditor.codeplex.com/ (free)

Run it, click on the open icon and locate your copy of myLogData.sdf.

You will be asked for a password, which is logXS

Click on 'logdata' and you will see the data in the pane on the right.

Highlight everything, press ctrl C

Wait if there is lots of data.

ctrl V paste into notepad and save as a text file.

If you are using excel, open the saved txt file in excel and select 'delimited' to import.

Save the file as excel.

Enter a header row title manually:-

id;date;time;address;type;sn;status;udc;idc;fac;uac;iac;pact;etot;eday;temp;runtime

or copy the top row of a CSV file of a single day.

Edit - The above editor may not work in Windows 7/8.

Alternative editor is downloaded via External mirror 1 [ZIP] here:
http://www.softpedia.com/progDownload/SdfBrowser-Portable-Download-206606.html

No installer because it's a portable application.
Unzip to a key or a spare folder and run SdfBrowser.exe

File menu - open - select your copy of myLogData.sdf - enter password - logdata will appear in the left pane.

Use the file menu again and click 'Generate queries' then 'select' and finally press the F12 key.

The bottom pane should now show the data lines from your sdf file.
« Last Edit: February 01, 2014, 12:23:21 AM by supremetwo » Logged

GeoffM
Full Member
***
Offline Offline

Posts: 197


« Reply #91 on: September 24, 2014, 06:43:39 PM »

One for Supremetwo I imagine...

A work colleague has just had three inverters fitted, 2 x Soladin 600 and 1 x Afore HNS2000TL

I have no idea what his setup is, but three seems a lot!! Anyway I don't really want to go there...

He wants to be able to get data on his PC, and I'm reading in this thread that the Soladin looks the same as my SunMaster, can you confirm please?  http://www.navitron.org.uk/forum/index.php/topic,3529.135.html

And any idea about the Afore?
Logged
supremetwo
Hero Member
*****
Offline Offline

Posts: 1069


« Reply #92 on: September 24, 2014, 07:49:37 PM »

There is a PC adaptor available for the 600 and this will work in Masterlog.

http://images.mastervolt.nl/files/PClinkSoladin600_050926.pdf

No idea about the Afore - it does have an RS45 port also dedicated monitoring.

http://aforeuk.com/wp-content/uploads/2014/06/afore-inverters.pdf

http://aforeuk.com/remote-monitoring/

Contact details at the bottom:
If you require any further assistance, please use our Contact Form, or call us direct on 01283 845039
« Last Edit: September 24, 2014, 07:59:09 PM by supremetwo » Logged

GeoffM
Full Member
***
Offline Offline

Posts: 197


« Reply #93 on: September 24, 2014, 08:23:55 PM »

Thanks for the prompt response :-) I have passed the info along.
Logged
thewaver
Newbie
*
Offline Offline

Posts: 24


« Reply #94 on: September 25, 2014, 09:28:47 AM »

Hi Supremtwo,
Finally got around to using the sql ce database editor V1.0 but it won't run on Windows 7. Is there an alternative that can be used or am I back to square one.
Cheers
Don...
Logged
supremetwo
Hero Member
*****
Offline Offline

Posts: 1069


« Reply #95 on: September 25, 2014, 10:43:21 AM »

Try CompactView:-

http://sourceforge.net/projects/compactview/

I have not used this so please feed back.
Logged

thewaver
Newbie
*
Offline Offline

Posts: 24


« Reply #96 on: May 31, 2015, 08:53:14 AM »

Hi, tried this and it wouldn't work. Is there any other sdf reader out there  for windows 7?
Logged
omega1
Newbie
*
Offline Offline

Posts: 21


« Reply #97 on: May 31, 2015, 09:37:54 AM »

Have you tried running the program/s in compatibility mode.
Right click program/ select properties/ select compatibility mode/ ticking check box allows you to select an earlier operating system which the program runs in.
Worth a shot.  fingers crossed!
Logged
thewaver
Newbie
*
Offline Offline

Posts: 24


« Reply #98 on: May 05, 2019, 03:49:37 AM »

Hi,
Long time since our last communication. Hope you are well and that everything is ok.

My laptop monitoring my mastervolt xs3200 has finally given up and I am now looking at trying to connect the xs3200 to my network so I can display it on my mobile via mqtt.

I did find something on the web from a gentleman who managed to do this but lost the link and cannot find it .

Is this something you have achieved by getting it on the network??
Cheer Don
Logged
Pages: 1 ... 3 4 5 6 [7]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.20 | SMF © 2013, Simple Machines
SMFAds for Free Forums
Simple Audio Video Embedder
Valid XHTML 1.0! Valid CSS!