ModDBExport

Forum Home Forums Uncategorized Issues ModDBExport

Tagged: 

This topic contains 36 replies, has 3 voices, and was last updated by Mikhail Mikhail 4 months, 2 weeks ago.

Viewing 15 posts - 16 through 30 (of 37 total)
  • Author
    Posts
  • #3460
    Mikhail
    Mikhail
    Moderator

    Do you know that you can simulate sending data by the Generator function of the Server app? May be it helps. Also you can write simple application that sends data to Server. I can assist a bit here.

    #3479
    Avatar
    sabas
    Participant

    As I remember, if data don’t change, Communicator doesn’t send them to Server, so they are not passed to DB.

    That’s what I’m try to say. There are some applications where data don’t change but value should be recorded, as I’m explaining in the counter case.

    I think this evaluation to avoid sending data to DB is only justified in case you have a very limited hardware to minimize memory usage and reduce hard disk usage.

    I think that the regular working way should be sending all data assigned to a channel, and “not sending Data if value don’t change” could be an option for every channel, but perhaps is my personal view of data acquiring.

    The trick you are talking about is your “Sending all device data period” without the double record issue, no more…(And got no trouble in paying to avoid it at the moment I need it)
    I thought this was an issue in your program and I was trying to help. I still think that sending data twice if you active the “Sending all device data period” option is an issue.

    #3480
    Avatar
    sabas
    Participant

    Do you know that you can simulate sending data by the Generator function of the Server app? May be it helps. Also you can write simple application that sends data to Server. I can assist a bit here.

    I was trying to “play” with it… and found something…. It only work properly with assigned channels but you can send records in channel that are not in the list but values sent are 0,0 instead of value and status you write (Would be nice if check channels and don’t let you sending or it doesn’t send the registry)

    Here is a video.

    https://imgur.com/a/u5sog

    Thank you very much.

    #3490
    Mikhail
    Mikhail
    Moderator

    I thought this was an issue in your program and I was trying to help. I still think that sending data twice if you active the “Sending all device data period” option is an issue.

    Thanks a lot. Your help is very useful.
    I also think, that we should create more options to configure how Communicator sends data to the server.

    Double recording is an issue. I suppose, it sends data the 1st time after communication session and the 2nd time when an interval ends. This is a part of the whole task – optimizing data sending algorithm and adding more options of it.

    The video is very small. Is there a button to make it larger? I can’t recognize what is shown in the video.

    #3491
    Mikhail
    Mikhail
    Moderator

    When we modify Communicator the next time, likely we will create the necessary options. If you need this changes in time, we could talk about purchasing the development.

    #3511
    Avatar
    sabas
    Participant

    The video is very small. Is there a button to make it larger? I can’t recognize what is shown in the video.

    Good morning. Got it at home… I’ll try to upload to Vimeo later, because Imgur made it smaller.

    Regarding to development, I first got to develop my part, so I’ll contact in case I need. Thank you very much.

    #3518
    Mikhail
    Mikhail
    Moderator

    OK, write here to continue the topic.

    #3523
    Avatar
    sabas
    Participant

    • This reply was modified 1 year, 2 months ago by Avatar sabas.
    #3534
    Mikhail
    Mikhail
    Moderator

    Do you have an idea in which case a sent value is changed to 0, and in which case it is saved correctly?

    #3547
    Avatar
    sabas
    Participant

    It only work properly with assigned channels but you can send records in channel that are not in the list but values sent are 0,0 instead of value and status you write (Would be nice if check channels and don’t let you sending or it doesn’t send the registry)

    If the channel you update is in the list of “Input Channels” in administrator you get the right value and record.

    If you write a channel that is not in the list you get a record with a 0. (Should it say “The channel is not defined” or something so?)

    Best wishes.

    #3553
    Mikhail
    Mikhail
    Moderator

    That’s funny, but not a bug 🙂
    I will write this behavior in our memories.

    #3554
    Mikhail
    Mikhail
    Moderator

    Should it say “The channel is not defined” or something so?

    Probably. In the next iteration of development of this module, we will take this into account.
    Thank you, Sabas!

    #5023
    Avatar
    aluy069
    Participant

    I send data to SQL using DB export with this scrip and worked fine
    — Insert current data
    INSERT INTO CnlData (DateTime, CnlNum, Val, Stat)
    VALUES (@dateTime, @cnlNum, @val, @stat)

    I need to send to SQL just the value of DateTime, plus only 7 input channels and status. I did something like but do not worked

    — Insert current data CnlDataLS
    INSERT INTO CnlDataLSt (DateTime, Val(1), Val(2), Val(3), Val(4), Val(5), Val(5), Val(7), Stat)
    VALUES (@dateTime, @Modelo, @Calidad, @Eficiencia, @Disp, @Turno, @OEE, @Run, @stat).

    I created in the SQL the table an columns. I can not figured out how to get it done

    #5030
    Mikhail
    Mikhail
    Moderator

    What database do you use? (MS SQL, MySQL, etc.)
    I suppose, you should specify a stored procedure where to filter channels. And use this stored procedure in the export module.

    #5031
    Avatar
    aluy069
    Participant

    SQL 2017, yes si did , but how to doit?

Viewing 15 posts - 16 through 30 (of 37 total)

You must be logged in to reply to this topic.