Save Values To A Excel File Or Xml File

 
#1

Hello everybody from the EZB Forum!


I am searching for a solution to save values to a Excel or XML file (or different Database).


My idea is:

A Camera recognize me ( $Face_Reco = Boris) + ($date) + ($time)

Now i have the info that "Boris" was recognized @ 31.10.2017 @ 17:55

This info i want to save somewhere (Excel - XML - Database)


Now the Camera recognize me 5 times on the 31.10.2017

FINE!


On the 1.11.2017 i can ask the EZB ( a script) how many times the camera sees (recognize) me yesterday.

EASY: In the Excel-Database are 5 records/entries. So the answer is: "5 times i saw you"


Other Example

Record every hour the Temperatur - The i have 24 values - And then i can ask what is the average Temperatur yesterday.

So how can i save values and read the values with EZB?


If there is a Solution - EZB will come for me to the next level.


PS:

Please no online Solutions - where i must pay for every data stream.

I love offline solutions! ;-)

#2

EZ-Builder can write to files. If you look at the Script Help in EZ-Builder you'll find some options for "FileWrite" and "FileWriteLine" and the examples show .txt files, but you can also write to a .xls file.

To see some ways to use the Read and Write options with files check out my tutorial from the learn Section.

#3

Hello Justin,

thanx for you fast answer!

Do you have some links to usefull "Example-Scripts"

Or maybe to you have an example for my problem with the Face Reco / Date / time?


Happy Halloween to you


Boris

#4

Building on what Justin said you can write your data to a text file using CSV (comma separated data) format in which excel can import/open... It will take only a line or two of coding to save your data in CSV format...

eg... myFile.csv

#5

This has me thinking of an interesting plugin! One that allows you to save the state of variables...

#6

HI DJ!

Yes this will be amazing to save variable / values to a file and read them out later / calculated with them .....


This is want i need!


Hi Richard!

Yes CSV will also work - i know this from google merchant ;-)

But a little example how the script will look like, will be great.

But thanx to all for you interest in my problem!


Happy Halloween!

Boris

#7

If you want a csv example , look at the file Example Projects included with EZ-Builder.

#8

HI DJ,

ok i want Excel file ;-)


Boris

#9

a csv is excel compatible

my plugin will not be excel native xls

#10

Hello DJ,

i will let me suprise.

I am also really lucky if somebody can give me a direct link to a tutorial or example for read and write values into a file.


I really not find something like this in the EZ-Tutorial.


Thanx a lot.