|
Export Historical CSV Report on your Extended User Memory card - Printable Version +- Ewon Technical Forum (https://techforum.ewon.biz) +-- Forum: Development (https://techforum.ewon.biz/forum-50.html) +--- Forum: BASIC Script (https://techforum.ewon.biz/forum-52.html) +--- Thread: Export Historical CSV Report on your Extended User Memory card (/thread-216.html) Pages:
1
2
|
RE: Export Historical CSV Report on your Extended User Memory card - jbrainard - 21-03-2019 I know this is a little older topic, but i needed to know how to change this from a 1 hour export to export data every 24 hours. My goal is to have all the data recorded over the last 24 hours pushed into a single file. 2nd related question i have is will this work outside of having data uploaded via Talk2M->eSync path? Like can i have the data go to both locations? RE: Export Historical CSV Report on your Extended User Memory card - simon - 21-03-2019 Hi, 1. Yes, just change the schedule : ONDATE 1,"0 * * * *","GOTO GENERATE_REPORT" ==> ONDATE 1,"0 0 * * *","GOTO GENERATE_REPORT" -> Will execute the script every day at 00:00 (It follows the CRONTAB syntax) 2. Yes, both can work at the same time. Simon RE: Export Historical CSV Report on your Extended User Memory card - NEAPT - 25-03-2020 (21-03-2019, 03:03 PM)simon Wrote: Hi,Hello all, O know that's an older threat but I have one Question regarding the data storage. I tested this scrip and it works very well. But if the Card ist full then I get a message only: LOGEVENT "EUM Card full or not present", -1 How can I make a loop that if the Card is full then the older file will be replaced by the new one? Regards Sergej RE: Export Historical CSV Report on your Extended User Memory card - simon - 27-03-2020 Hi Sergej, Possible but really not easy. In BASIC, you have a function called "FS" that allows you to list, create and delete files. However you cannot get the date/time of the file creation, so you should use the name of your files to store the date and time. If you SD card is full, you can then loop the filenames and delete the older files before re-creating new files. Simon RE: Export Historical CSV Report on your Extended User Memory card - pte - 20-05-2020 Hi Simon, didn't knew how to start a new thread while referring to this one...so I hope it's okay that I ask my question over here... I'm using the code above and at midnight the Ewon tries to write the historical data... => Today I received an email that there was not enough space on the SD. After checking this (free memory on disk 800mb of 1Gig), I think perhaps the device didn't see the disk at that time? => In the logging I saw that there was also a data-push (identical timestamp) towards the mailbox but no error messages... perhaps this is causing the problem? How can I proceed to check and see what might be causing it? br Teunen Peter RE: Export Historical CSV Report on your Extended User Memory card - simon - 20-05-2020 Hi Peter, Yes no problem. What did you put at the line IF SDCardSize_Int% > 5000 THEN // 5 MB remains ?? You can check the SD card size in Diagnostic > Status > System Counters > Memory information : SDExtTotal:0 SDExtFree:0 RE: Export Historical CSV Report on your Extended User Memory card - djonedd - 17-09-2020 This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate. (20-05-2020, 06:39 PM)simon Wrote: Hi Peter, Hi Simon, actually how much capacity of SD Card we can use for Flexy 205? And, what is the format of SD card we can use for Flexy 205 (FAT32/NTFS) to use this system (export Historical CSV report)? thank you Regards, Joned RE: Export Historical CSV Report on your Extended User Memory card - simon - 17-09-2020 Joned, Regarding the size, there is theoretically no limit. The file system must be ext3. You can format the SD card in ext3 under Windows OS using the software ease US (https://www.easeus.fr/partition-manager/partition-master-free.html) Simon RE: Export Historical CSV Report on your Extended User Memory card - Romu_fr - 15-01-2021 This thread has been marked as solved. If you have a similar issue, it would be better to post your own thread rather than bump this one, to help keep everybody's different issues separate. (17-09-2020, 12:49 PM)simon Wrote: Joned, Same Issue for me. I've tried to format the fad in ext3 with partition manager but this is not working. I have a 64Gb brand new Sandisk SD card. Pretty annoying. RE: Export Historical CSV Report on your Extended User Memory card - simon - 19-01-2021 Hi, Have you set the cluster size to 4KB as described here https://ewon.biz/docs/librariesprovider10/ewon-english/datasheets/eum-card---extend-ewon-user-directory-memory.pdf ? Simon RE: Export Historical CSV Report on your Extended User Memory card - Romu_fr - 20-01-2021 (19-01-2021, 06:50 PM)simon Wrote: Hi, Yes, I did from the very beginning (as I read in the documentation) |