This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

export data on net csv file
#1
Hello

I would like to know if it is possible to export energy meter data in the following paths.

  • A csv file on the network
  • A csv file in the local FTP folder

using script

Thank you
Reply
#2
See this: https://openrb.com/example-export-last-h...-from-lm2/
Reply
#3
(03.06.2021, 06:25)admin Wrote: See this: https://openrb.com/example-export-last-h...-from-lm2/

If I don't have an FTP server but only a network path, can I write to a non-FPT server directory?

thank you very much
Reply
#4
Do you mean a Windows shared network folder? If so then it's not supported.
Reply
#5
(03.06.2021, 06:33)admin Wrote: Do you mean a Windows shared network folder? If so then it's not supported.

Hello

I tried to follow the instructions of the example, to use internal FTP, I would like to mix the 2 possibilities, the first script takes the values from a csv buffer, while later there is the possibility to choose the data to put in the table, how do I tell the first script to fetch the data from the table table (it is possible to display them with a bank for each entry).
In the example there is also a scrip to clean the data older than 60 days (I guess in the ftp folder).
Does the storage table clean itself automatically when it is written to the file or do I need to add a command?

Thanks so much for the support
Reply
#6
You have manually clear it by calling storage.delete('key_name')
Reply
#7
(04.06.2021, 07:42)admin Wrote: You have manually clear it by calling storage.delete('key_name')

OK

I have seen how to delete old files in FTP

In the example script the log data is stored in the CSV, but I should use the data that I have stored in the "MyPowerLog" table which I will then go to cancellaer at the end of the export, so as not to fill the memory with very old data.

Thanks in advance
Reply


Forum Jump: