Alarm & Event Query To Spreadsheet.vi

[dhanwanti]

dear all,

 i m using  "Alarm & Event Query To Spreadsheet.vi" for alarm transfer using following inputs

1. Filter

2.Display Format

3. Output file path(C:\Program Files\National Instruments\LabVIEW 7.1\*.ALR)

and Database URL it will take by default i.e current tagfile.scf

on running this i get following error

"HIST_AlarmsToSpreadsheet.vi, Citadel:  (Hex 0x8ABC1008) Read alarm failed because of connection or query failure."

if i give the database URL manually in the following way

\\computer name\Labview

then i get the following error out
"HIST_AlarmsToSpreadsheet.vi, IAK_SHARED:  (Hex 0x8ABC700A) Not found."

so pls solve my problem as early as possible for u

 thanks and regards,

dhanwanti

[Jaime Rodriguez]

Are you using the correct database URL? The error message sounds like it has something to do with the query its trying to run on the database and for some reason cannot find it....

Can you post your code??/

[dhanwanti]

thank u very much

 for ur reply but it cann't solve my purpose

In Alarm & Event Query To Spreadsheet.vi's help if i left database url blank then it will auotmatically take the current path then why it cann;t find the database.

 i here attaches my vi

so pls go through it

and reply me as early as possible to u

---

@Jaime Rodriguez wrote:

Are you using the correct database URL? The error message sounds like it has something to do with the query its trying to run on the database and for some reason cannot find it....

Can you post your code??/

---

[Doug M]

Hi dhanwanti,

There could be a couple possibilities here -- one is that the database you are trying to reference has become disconnected -- Make sure you can see historical data in MAX.  If needed, reconnect your database or create a new one and change this in the .scf file in the Tag Configuration Editor.

Another possibility is that some of the parameters you have set in the filtering could be incorrect such as start and stop time.  I would suggest creating a simple test VI to make sure you can get the Alarm & Event Query To Spreadsheet.vi working, and then double check how it integrates into your project.   You may also want to take a look at the example that ships with the DSC Module for this VI, found in the Example Finder under Toolkits and Modules » Datalogging and Supervisory Control » Alarms and Events » Export Alarms to File.VI.

[BUI anh minh]

hello all!!!

You can send me Alarm and Event to Spreadsheet.vi.

thank you very much to you.

Best regard!!!

[Doug M]

BUI anh minh,

The Alarm & Event Query To Spreadsheet VI is part of the LabVIEW 7.1 DSC Module and is not freely distributed.  If you have the DSC Module and have corrupted this file you can do a repair on your installation of the DSC Module or reinstall the entire module.

Best regards,

[BUI anh minh]

Bonjour monsieur!!!

Je voudrais trier la page alarme avec cette fonction. Est ce que vous avez l'exemple s'il vous plait????

Merci beaucoup!!

[BUI anh minh]

Hello Mister!!!  

  I would like to sort the page alarms with this function. Is what you have the example if it plait you????

    Thank you very much!!

[BUI anh minh]

Hello!

I want to an example export alarm to file!!

Thank you very much!!

[Doug M]

Bui anh minh,

There is a LabVIEW DSC Shipping example that shows hwo to use the Alarm & Event Query To SpreadSheet VI.  If you open the example finder by going to Help»Find Examples..., then browse to Toolkits and Modules»Datalogging and Supervisory Control»Alarms and Events»Export Alarms to File.vi.  This example shows the use of this VI.

It is fairly straightforward, you basically give it a database URL and specify which parameters you want to export and the time limits you want to query for.

Best Regards,
Doug Mumford
Applications Engineer
National Instruments