Open Specific file in Database Viewer

A forum devoted to the discussion of all topics having to do with scripting and other advanced programming using iX Developer.
Post Reply
vinit_patil
Posts: 9
Joined: Sat Jun 09, 2012 11:30 am

Open Specific file in Database Viewer

Post 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?

User avatar
Ron L.
Posts: 214
Joined: Fri Jul 15, 2011 3:21 pm

Re: Open Specific file in Database Viewer

Post 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.
Attachments
CopyPDFfromUSB.zip
(23.55 KiB) Downloaded 1090 times
Script_Database_Adjustable_Columns.zip
(361.12 KiB) Downloaded 1177 times
Best Regards,

Beijer Electronics, Inc.
Ron Lloyd | Applications Engineer

User avatar
Ron L.
Posts: 214
Joined: Fri Jul 15, 2011 3:21 pm

Re: Open Specific file in Database Viewer

Post 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.
Attachments
DataGridCSVUSBTest.zip
(24.58 KiB) Downloaded 1131 times
Snap 2012-08-31 at 15.22.40.png
Snap 2012-08-31 at 15.22.40.png (204.32 KiB) Viewed 15905 times
Snap 2012-08-31 at 15.22.57.png
Snap 2012-08-31 at 15.22.57.png (122.71 KiB) Viewed 15905 times
Best Regards,

Beijer Electronics, Inc.
Ron Lloyd | Applications Engineer

vinit_patil
Posts: 9
Joined: Sat Jun 09, 2012 11:30 am

Re: Open Specific file in Database Viewer

Post by vinit_patil »

Thanks

darren.tan.cw
Posts: 2
Joined: Fri Dec 28, 2018 7:59 am

Re: Open Specific file in Database Viewer

Post 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

darren.tan.cw
Posts: 2
Joined: Fri Dec 28, 2018 7:59 am

Re: Open Specific file in Database Viewer

Post 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 11050 times
[/img]


Thanks

Regards
Darren

LenDamedy
Posts: 5
Joined: Sun Aug 25, 2019 6:53 am
Location: Canada
Contact:

Open Specific file in Database Viewer

Post 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:

Post Reply