Page 2 of 3
Re: Copy Historical data (rra databases) between Toons
Posted: Mon Jul 06, 2020 11:02 pm
by ovdleun
Hi Marcelr,
The version from github, is that a working version?
https://github.com/ToonSoftwareCollective/transfer-logs
I'm having a hard time getting it to work
I can compile it under linux but it's, of course, not working on arm then:
# ./transfer-logs
./transfer-logs: line 1: syntax error: unexpected "("
I'd like to transfer the files from my old Toon1 to new Toon2, if even possible.
Any hints for me? Before I'm installing a full arm toolchain ;o)
Regards,
Onno.
Re: Copy Historical data (rra databases) between Toons
Posted: Tue Jul 07, 2020 5:39 pm
by marcelr
Hmmm .. apparently it has issues.
The best you can do is just copy the old rra databases + dat files to the new toon, together with the config_hcb_rrd.xml file and config_hcb_pwrusage.xml. These files hold all information regarding your history. And remember: Thou shalt make back-ups!
Re: Copy Historical data (rra databases) between Toons
Posted: Tue Jul 07, 2020 9:31 pm
by ovdleun
Tnx! Damn .. forgot about the layout files .. did copy the rra's but that doesn't work without the xml's of course. Fixed it.
Re: Copy Historical data (rra databases) between Toons
Posted: Fri Jul 10, 2020 10:45 am
by Pieterraxis
Maar....
Waar vind ik die bestanden?
Re: Copy Historical data (rra databases) between Toons
Posted: Fri Jul 10, 2020 11:35 am
by marcelr
/mnt/data
and this thread is supposed to be English.
Re: Copy Historical data (rra databases) between Toons
Posted: Fri Jul 10, 2020 2:44 pm
by Pieterraxis
Tnx,
And do you guys have a samba server installed on the toon?
Can't get in with sftp
Code: Select all
Status: Verbinden met 192.168.178.9...
Antwoord: fzSftp started, protocol_version=9
Opdracht: open "root@192.168.178.9" 22
Opdracht: Pass: ****
Status: Connected to 192.168.178.9
Fout: FATAL ERROR: Received unexpected end-of-file from SFTP server
Fout: Kan niet verbinden met server
I called the 2nd toon toon2 in smb.conf just in case.
But windows can't connect
Re: Copy Historical data (rra databases) between Toons
Posted: Tue Jul 14, 2020 11:49 am
by Pieterraxis
voor sftp access :
Code: Select all
opkg install http://files.domoticaforum.eu/uploads/Toon/ipk/cortexa9hf-vfp-neon/openssh-sftp-server_6.7p1-r0_cortexa9hf-vfp-neon.ipk
Re: Copy Historical data (rra databases) between Toons
Posted: Tue Jul 14, 2020 3:22 pm
by Pieterraxis
I do have the file config_HAPP_pwrusage.xml but not config_HCB_pwrusage.xml
Searched all of "/" without capitals.
Re: Copy Historical data (rra databases) between Toons
Posted: Fri Jan 01, 2021 4:49 pm
by Toonz
Hi all,
happy to present a new python script to load historical usage data from an old Toon in to another Toon.
The old Toon doesn't need to be rooted, the target Toon must be rooted.
Usage:
- On the old Toon create the export.zip file via the Toon menu, 'Instellingen', 'Internet', 'Toon Data'.
- Download the newly created export.zip file from the old Toon.
- Extract the file usage.zip from the file export.zip
- Extract all files from usage.zip in a separate folder
- download the attached python script (tested with Python 3.7)
- edit the two variables in the script:
folderPath = "c:\\temp\\usage\\" -- replace this with the folder name where you extracted the files from usage.zip
toonIpAddress = "192.168.2.16" --replace this with the ip adress of the new target Toon
- start the script DataConv.py with python and get a coffee (could run for quite some time, progress bars are shown).
That's all folks.
Known limitations:
the file 'gas_flow_CurrentGasFlow_5min.csv' in the usage.zip file is empty on newer firmwares. This is an error in the Toon firmware.
I will look into a workaround for this but that will require the source Toon to be rooted as well.
Happy to take any feedback.
Kind regards and a happy 2021.
Toonz
Re: Copy Historical data (rra databases) between Toons
Posted: Sun Mar 28, 2021 10:47 pm
by mogwai
I see multiple methods described in this thread and I'm not sure what to do. I have an (old) rooted Toon1 and a (new) rooted Toon2. I have gas/electricity/solar panels connected. What is the recommended method to transfer the data from the Toon1 to the Toon2?
Thanks
Re: Copy Historical data (rra databases) between Toons
Posted: Mon Mar 29, 2021 12:08 am
by Toonz
the last method works best (above this post) and is replacing the old method which has quite some limitations
Re: Copy Historical data (rra databases) between Toons
Posted: Tue Mar 30, 2021 11:05 pm
by mogwai
Thanks, that worked like a charm
Re: Copy Historical data (rra databases) between Toons
Posted: Mon May 24, 2021 2:15 pm
by Hypermobile
For people like me, without a lot of Pyton knownledge
>on windows, i had to install Python 3.7
Then start command prompt: (windows Key +R) CMD [enter] or in windows explorer. go the the Folder of the Script....and type in the URL bar CMD enter >> command prompt will start from this Directory.
Then you need to:
- pip install pandas [enter]
- pip install request [enter]
- pip install tqdm [enter]
Then adjust the script as descripted,
Then Type:
- Python c:\location\DataConv.py [enter]
Re: Copy Historical data (rra databases) between Toons
Posted: Sat Jun 19, 2021 12:33 am
by oepi-loepi
I have made a Windows version based on Toonz method.
https://github.com/oepi-loepi/toonConvert
Download the files and run the setup.exe
Get the old data from the old toon by clicking the wifi symbol and then toon data at the bottom of the page
Extract the data from the downloaded zip file
Open the converter and point to the extracted data folder (usage)
Fill in the ip of the new toon
Click start and leave your toon for 2 hours untill a message apears that the process is ready
Do not restart, power cycle or reboot your toon during the process.
Re: Copy Historical data (rra databases) between Toons
Posted: Mon Jul 19, 2021 6:57 am
by hafeez
Finally a method so I can copy my historical data form my old rooted Toon to my new rooted Toon 2
Followed the procedure and used the Windows program.
Everything is converted to the new Toon 2. I can see my historical power & gas usage but I do not see any data for my Solarpanels.
Am I missing anything or is that not supported?
Do I need to do something on the new Toon 2 first?