Data input

This topic contains 11 replies, has 5 voices, and was last updated by Mikhail Mikhail 10 months, 2 weeks ago.

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • #566
    Avatar
    Daniel
    Participant

    Is there any other way to input data into software interface? Or edit the DAT files in other software to input large amount of data? The actual method is very annoying and slow!
    Tks.

    #567
    Mikhail
    Mikhail
    Moderator

    Hi,

    Could you provide more details about your task? What kind of data do you need to input?

    #568
    Avatar
    Daniel
    Participant

    Hi,
    In configuration database on SCADA administrator page, to input connection data ( on Devices panel) each line represents a Device , which has a name , an address, and so on…
    My question is if exists other method to input these data than line by line, because in my application , has several devices to acquire data( approx. 100). By the actual method, will take a lot of engineering time to fill these fields.
    In short i’m looking for a copy / paste function with excel data.

    Tks.

    #569
    Mikhail
    Mikhail
    Moderator

    There are a few ways:
    1. Export data, then import the same data with other IDs in SCADA-Administrator.
    2. Generate SQL queries, connect to ScadaBase.sdf using a tool supports Microsoft SQL Server Compact 3.5 and execute the queries.
    3. For input and output channels there are the built in auto create and clone features.

    • This reply was modified 3 years, 9 months ago by Mikhail Mikhail.
    #3769
    Avatar
    jeff
    Participant

    Hi,

    Can Excel data act as an input to Rapid Scada?

    #3770
    Avatar
    manjey73
    Participant

    If we are talking about the xlsx you can write a driver. The data format is nothing but an archived set of xml files. And search xml a realistic goal. If this is the old format it will be more difficult.

    #3771
    Mikhail
    Mikhail
    Moderator

    Hi,
    In this year it’s planned to develop a module that will receive data from a 3rd party database as input. As for me, Excel is not a good data source because it is not stable.

    #3772
    Avatar
    jeff
    Participant

    Hi Mikhail,

    Excel is not a good data source, so what is your suggested format file if want to receive data from the 3rd party database?

    Hi Manjey73,

    Thank you for your information. I will try it.

    Jeff

    #3775
    Mikhail
    Mikhail
    Moderator

    When we complete this module, you can specify SQL request to retrieve data from a database which has any structure. We are going to support Oracle, MS SQL, PostgreSQL and MySQL. You don’t need files working with DB.

    #3782
    Avatar
    jeff
    Participant

    Noted with thanks.

    #4197
    Avatar
    leon
    Participant

    Looking forward to this feature.

    #4200
    Mikhail
    Mikhail
    Moderator

    Till the end of this year )

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.