Progratically importing CItadel Data into Data POrtal

[DIAdem Neo]

Hi There,

I am having the Data files from the Citadel Database, the Data files include Citadel4 and Citadel5. I am able to load the Citadel4 Data manually through Data Storeage, but would like to do it programatically. Can you please let me know the comand or method to do this. I belive the Datafileload() does not work for this.

I would like to add that I have the data files alone and not the Database. Am using Diadem9.1.
Expecting for your early response.

Thanks,
Priya

[DIAdem Neo]

Hi Again,

I made use of this command
Call OdsOpen("CITADEL", "localhostC:\Data\Citadel", 0, 0)
though the OdsStat value is 0 I am unable to view the Data in the Data Portal. Can you let me how can I load/View the Data.

Thanks,
Priya

[Brad_Turpin]

Hi Priya,

If you are able to load the data interactively with the NAVIGATOR, then you should have the required LOGOS drivers installed on that computer, and we should be able to load that data programmatically with DIAdem.

The simplest thing to do is to turn on the Script Recorder and have DIAdem trap the specific load command to input your selected traces. This works, but the resulting code is very hard to re-use, unless you want to load the same traces each time.

As you suggested, the alternative approach is to use the Ods...() functions in DIAdem, which is a very general API for loading hierarchical data and data properties from any data storage. This is, in essence, how the NAVIGATOR does its magic.

Below you will find attached a ZIP file which contains examples of using this API. If you choose to use the "SimpleDataSets" Citadel database in the ZIP file, you will need to register it first with your DIAdem as a new Citadel 4 Data Storage. When you decide to try to use your own Citadel Data Storage, you must change the Data Storage name in line 5 or 7 of "Load Selected Traces.VBS". Note that this VBScript launches a SUDialog which contains the same ActiveX control that you see in the NAVIGATOR. The ODS...() functions in the SUDialog control this instance of the ActiveX object which the user manipulates in the SUDialog.

The other VBScript, "Load Citadel Traces.VBS", uses the items selected in the "ASAM Data Service" dialog. I seriously doubt you will want to use this built-in dialog, but the ODS...() functions in this VBScript are easier to find and understand than in the callbacks of the SUDialog.

Ask as you have questions,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[DIAdem Neo]

Hi Brad,

Thanks a lot for your response. I do have few doubts and questions.
As said by you, I first registered the "SimpleDataSets" in DIAdem.
I shall just give you the steps which I followed to register.
Opened Navigator,
Clicked on Change Data Storeage
Double clicked on Citadel4->New data storage and Changed the name to "SimpleDataSets"
Clicked Enter
On the Dialog box selected the folder path. and clicked ok.
Clicked on Open which registered and load the Data in the Navigator.

Now I was able to run the script file and select the necessary channels and load them to the Data portal.

Can't we do this registration of data programmatically? Can the entry of data folder name and the time intervals be done programmatically? Could you please let me know this?

Also, can I have any links to study about Citadel Database, its traces etc as I am entirely fresh on this topic.

Waiting for your early response.

Thanks,
Priya

[marvind]

Hi Bred,

  Have you ever done any interfacing of Diadem with ASAM ODS server.

i need help for Importing the date in Data portal from ASAM ODS without opening ODS Browser.

Regards,

Arvind Mane. 

[Brad_Turpin]

Hi Arvind,

If you want to work with ASAM-ODS data bases using DIAdem, then do yourself a BIG favor and get a copy of DIAdem 2010 (or later).  DIAdem 2010 releases a completely reworked and readically expanded built in user interface and programmatic API to work with ASAM-ODS data bases.  You can sign up for the Beta program and get a free version that will work until September, 2010.

www.ni.com/beta

Let me know if you need help activating your DIAdem Beta account,

Brad Turpin

DIAdem Product Support Engineer

National Instruments