Page 1 of 1

Open Specific file in Database Viewer

Posted: Fri Aug 31, 2012 8:17 am
by vinit_patil
Hi,
I have exported data to "abc1.csv" file & stored it to USB/Panel Memory.
After exporting the data database will get clear for storing new data for fresh job.
Is it possible to view the data stored in "abc1.csv" in database viewer by selecting this particular file?
We required this feature for post job analysis.

Do we need the custom scripting for this feature in A12 panel?
Does this feature available in any other Beijer product?

Re: Open Specific file in Database Viewer

Posted: Fri Aug 31, 2012 9:09 am
by Ron L.
Is it possible to view the data stored in "abc1.csv" in database viewer by selecting this particular file?
Yes with scripting
Do we need the custom scripting for this feature in A12 panel?
Yes
Does this feature available in any other Beijer product?
iX Developer software has the most features of our Beijer products. I've attached some examples that have code that I think would help write the necessary script.

Re: Open Specific file in Database Viewer

Posted: Fri Aug 31, 2012 3:24 pm
by Ron L.
I've created a sample application that will do what you're looking for. Before using, you will need to add a DataGrid control to your objects and restart iX Developer. See screen shots.

Re: Open Specific file in Database Viewer

Posted: Sat Sep 01, 2012 2:23 am
by vinit_patil
Thanks

Re: Open Specific file in Database Viewer

Posted: Fri Dec 28, 2018 8:07 am
by darren.tan.cw
Hi,

I follow the sample provided. It is working well.

However, i can not read a csv file that i export from beijer alarm server.

I found that the exported alarm server csv file is encoded in UCS-2 LE BOM.

And the sample code display grip can only display UTF-8 csv file.

Can you guide me on this issue?

Thanks
Regards
Darren

Re: Open Specific file in Database Viewer

Posted: Wed Jan 02, 2019 5:25 am
by darren.tan.cw
Hi,

I have follow the sample program to get the result I wanted.

Now, I face the problem to resize the datagrid vertical scroll bar.

Can anyone teach me how to do it?

[img]
Vertical Scroll Bar3.jpg
Vertical Scroll Bar3.jpg (190.29 KiB) Viewed 11047 times
[/img]


Thanks

Regards
Darren

Open Specific file in Database Viewer

Posted: Sat Aug 31, 2019 9:25 pm
by LenDamedy
I just read your jar file Mythruna-core.jar and went into scripts and read default.groovy and i am almost completely confused. This is what i understood:
Code: