Forum Home › Forums › Uncategorized Issues › ModDBExport
Tagged: DBEXPORT
- This topic has 36 replies, 3 voices, and was last updated 5 years ago by Mikhail.
-
AuthorPosts
-
April 11, 2018 at 12:31 am #3460MikhailModerator
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.
April 12, 2018 at 6:10 pm #3479sabasParticipantAs 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.April 12, 2018 at 6:31 pm #3480sabasParticipantDo 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.
Thank you very much.
April 13, 2018 at 11:41 am #3490MikhailModeratorI 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.
April 13, 2018 at 11:45 am #3491MikhailModeratorWhen 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.
April 16, 2018 at 7:57 am #3511sabasParticipantThe 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.
April 17, 2018 at 5:23 am #3518MikhailModeratorOK, write here to continue the topic.
April 17, 2018 at 11:10 pm #3523April 18, 2018 at 4:52 pm #3534MikhailModeratorDo you have an idea in which case a sent value is changed to 0, and in which case it is saved correctly?
April 19, 2018 at 10:07 am #3547sabasParticipantIt 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.
April 19, 2018 at 12:05 pm #3553MikhailModeratorThat’s funny, but not a bug 🙂
I will write this behavior in our memories.April 19, 2018 at 12:08 pm #3554MikhailModeratorShould 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!February 19, 2019 at 1:29 am #5023aluy069ParticipantI 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
February 19, 2019 at 1:44 pm #5030MikhailModeratorWhat 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.February 19, 2019 at 5:26 pm #5031aluy069ParticipantSQL 2017, yes si did , but how to doit?
-
AuthorPosts
- You must be logged in to reply to this topic.