Search the Community

Showing results for tags 'logging'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • DAQFactory
    • Alarming
    • Channels, Conversions and general data acquisition
    • Graphing
    • Logging
    • Modbus
    • Networking: web, email, FTP etc.
    • PID
    • Screen Components and User Interface
    • Sequences and scripting
    • Serial Communications
    • General DAQFactory
    • DAQFactory and the LabJack
    • DAQFactory Express
    • DAQConnect
    • DAQFactory New Feature Requests
    • The DAQFactory Guru's Articles
    • DAQFactory Newletters

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 22 results

  1. We recently ran a test for the last 7 days and had issues logging data for one of the tests. DAQFactory is still active and has all the history data. I tried using export to save the data to a file by removing the indexes from each channel (channel_1[0] -> channel_1). When I run the export function, DAQFactory 'freezes' for a couple of hours appearing to be doing something, but no file is actually created. Is it possible to use the export functionality in DAQFactory to save our data to non-volatile storage?
  2. amswitch

    Logging average of data

    I've set up my program to log 10 seconds of data (i.e. input voltage and output voltage) in the following sequence: while(1) wait(5) beginLogging(station7) wait(10) endLogging(station7) wait(5) endwhile But instead of logging each data point, I'm trying to just have the average value be logged. Under "Event" for my output voltage (output7) channel, I wrote: Logging.station7.AddValue("Average", Mean((input-output) [0,9])) Then I manually added "Average" as a channel for my "station7" logging set. When I checked the .csv file I saved under "station7", nothing was logged. Is there another way of logging the average value for a channel?
  3. ateori

    Remote mysql

    Can I write to the MySQL database via remote (ip) data via code without ODBC connection?
  4. hello , i'have logging data using the "ASCII delimited" using protocol "mod-bus tcp-IP" and time out is 1000,...using this i communicate plc and scada successfully . my first question is that if i remove the communication cable then after the graphical representation is not changing means that scada representing healthy graphical representation instead of cross marking representation.linking my second question is that after removing this cable i want data logging in .csv format which is working o.k but in data logging it holds last value which i don't want. for example,if communication cable is inserted the data logged values are 12,13,11,0 and at the time of removing communication cable if at that time last value is 13 then it will continue log data 13 means it holds last value.but i want if communication breaks than then doesn't hold last value.
  5. Hi, I want to save into a database (SQLSERVER) using ODBC some information triggered by the change of a variable. I have had some struggle using Logging, Exporting and SEQUENCE. 1) Logging is the easiest in my case, but I have no control about what I am saving ( I don't know how to ) so I am currently saving duplicated information that is useless, I tried to use Logging.LoggingName.startstop() + delay(milliseconds) but sometimes works and sometimes it doesn't and I still have no control. 2) Using exporting was almost the best... I did a script (as shown below) and worked fine, except that anytime it was trying to connect to the database it was asking for the password so... once again useless. ID is an OPC value that is randomly changing between -100 and 100 Global oldValue = 0 Global newValue = 0 while(1) newValue = ID if(newValue!=oldValue export.Exp.Start() // I also used beginexport(exp) oldValue = NewValue endif endwhile 3) I finally when through the manual way... time, temp and pres, are OPC values in channels. Global count = 0 Global oldValue = 0 Global newValue = 0 while(1) newValue = Valor1 if(newValue!=oldValue) count++ dbase = db.OpenEx("DSN=DAQF;UID=batch;PWD=12345") if(count==1) db.Execute(dbase,'CREATE TABLE Hartman(time datetime, ID int, Temp int, Pres int)') endif // db.Execute(dbase,'INSERT INTO Hartman values (' + FormatDateTime("%y-%m-%d %H:%M:%S",systime()) + ',' + count + ',' + Valor1 + ',' + Valor + ')') // db.Execute(dbase,'INSERT INTO Hartman values (' + Valor.time[0] + ',' + count + ',' + Valor1 + ',' + Valor + ')') // db.Execute(dbase,'INSERT INTO Hartman values (' + systime() + ',' + count + ',' + Valor1 + ',' + Valor + ')') db.Execute(dbase,'INSERT INTO Hartman values (' + Tiempo + ',' + count + ',' + Valor1 + ',' + Valor + ')') db.Close(dbase) oldValue = NewValue endif endwhile I wanted to use the red-color-text lines instead of the blue one, but it was showing an error (shown below (1)) (1) db.Execute(dbase,'INSERT INTO Hartman values (' + FormatDateTime("%y-%m-%d %H:%M:%S",systime()) + ',' + count + ',' + Valor1 + ',' + Valor + ')') Unable to execute: HY010: Line 1 (2) db.Execute(dbase,'INSERT INTO Hartman values (' + systime() + ',' + count + ',' + Valor1 + ',' + Valor + ')') Unable to execute: HY010: Line 1 so I couldn't use the DAQF time in order to save it into the database, instead I had to import from OPC the time which makes no sense for me... In this moment the last script is working and doing what I wanted to... but i have those doubts and I would want to solve them. I appreciate any help... I attach the file used for this... Basculas.ctl
  6. Hi, I'm trying to write a sequence where data is logged at the 10 second mark, stops at 20 seconds, and then starts logging again at 30 seconds. So at 10sec, 30sec, 50sec, 70sec, etc. data is logged for 10 seconds. Any suggestions on how I could do this? Thanks!
  7. amswitch

    Logging Set Up

    Hi, I'm a new user of DAQFactory. So far I've set up my Variable Value Components (voltage) and a graph (voltage vs. time). Now I am trying to set up the program so that it logs the Variable Value Component data into a spreadsheet (.csv file). Under a new Logging Set, I added my Variable Value Component (voltage) and beside "File Name" I selected an empty spreadsheet I made. After started/stopped the logging set and open the spreadsheet, I get two columns of numbers, the second row contains the voltage data, but I don't know what the first column is (see below): 42587.647858800 42587.647870370 42587.647881950 Would this be time? How can I change this so I don't get decimal numbers?
  8. Hi There I currently have a number of test channels i am using as variables for a sequence (as i want to see their history). I want to log these values with other instrument channels (that update at regular time intervals 1s data). Do you know if there is a way to log these test channels (which probably only update every 5 minutes or so) at the same intervals as the instrument channels so even if they are unchanged a duplicate value is generated with the latest instrument value. I hope that makes sense! Thanks in advance Regards Rich
  9. rlrepoff

    Logging--Parsing

    Hello, I have a string that is coming in from a serial connection and this is the output that I am getting: Rx: 669.00,-252,5795,-12,131071,167,37669,6833,14764,540,47\013\010 I am using 'parse' to parse each of the measurements from this string as follows: Seconds[0]=StrToDouble(parse(StringIn,0,",")) (The first indexed item is the time). During my last indexed item (the number 47 before the returns of \013\010), the 7 is getting cut off and I am only getting the 1st digit and not the second (i.e. I am getting the 4 on my channel but not 47). Here is the code for the last parsed item: RelHum[0]=StrToDouble(parse(StringIn,10,",")) Is there a way for me to get the whole value instead of just the first number. All of my other assigned channels are getting the correct value.
  10. roiyjet

    Save String To Odbc

    Hi I am using windows 7 ans access 2010 I change the format to TEXT in access I'm writing number into the database without any problem but I cant write string even if the command is running fine inside access SQL query . private string mess mess='high temperature' command='INSERT INTO Alarms ( Description, Startt,Temp) VALUES ('+ mess+ ','+ Temp1.Time+ ',' +Temp1[0]+')' i Also try command='INSERT INTO Alarms ( Description, Startt,Temp) VALUES (''"High Temperature",'+ Temp1.Time+ ',' +Temp1[0]+')' maybe you know why its not working ? Roy
  11. jerzydziewierz

    Odbc Preview Sql Statement?

    Hello, I am trying to set up logging of my 54-element numeric array that i load from OPC server, i am using Oracle database through DSN. I have went through all the hoops related to selecting proper ODBC version (32bit), getting correct connection string, correcting SQL keywords and data types in the "SQK Strings" box etc. now i can see that DAQFactory correctly connects to the database, creates a table when it it not there (throws an error when it is) and creates fields with correct data types in the table. I now get "C1012 Failed to access table for logging. Msg: ORA-00911: invalid character" in other words, Oracle reports "ORA-00911" due to incorrectly formatted insert query. I cannot imagine what invalid character this might be. Is there a way of previewing the SQL query that DAQFactory generates? Regards, Jerzy Dziewierz
  12. Hi. I have a document with a button to remove all history from all channels. Since one of my channels contains string data, I have a logging set for that channel in order to be able to recover (persist) its contents over a restart of DF. So, I have to clear not only the channel but also its log file. Unfortunately, this file is locked by DF and cannot be removed, I get the error "F0011 SHARE.EXE was not loaded, or a shared region was locked." I have found the following post: http://www.azeotech.com/board/index.php?/topic/3698-logging-file-available-read-only/ but this does not work reliably for me. When I change the logging set's file name, normally nothing happens, and even after an endlogging(...) and beginlogging(...), the old file is still locked. Any idea how I may delete that log file from code?
  13. Am currently executing a project using Daqfactory in which I have a Start/Stop button Component that I just click to start or stop logging set. I was wondering if it were possible to also start or stop the logging set by pressing keys on the keyboard. I would appreciate any kind response.
  14. I desire to log to a file so that I can open it in Excel. I also create a button component that I can just click to change file names that I want my logging saved into. Initially, I had my filename under my logging set end as in .csv. Also I had the file name on the button component end as in .csv. However, I noticed that when I used the button component to change my file name/path to a new file name, it changes the file name/path under logging set also, but doesn't make it end as in .csv. This problem now makes it difficult for me to open the saved file successfully in Excel, because the system tells me that it is saved in a format different from Excel, even though I have my FileSaveDialog function coded for any new file name to always end in .csv?
  15. I am using callibration equations to set the zero-offset and span of the input for 8 pressure transducers and need to create a simple way to callibrate the channels for a party who isn't a DaqFactory user. I esentially need two variables per equation (16 in all) which are saved in a callibration text file as .csv formatt and are called and defined at the first stage of the startup script. My issue is that I'm not sure the easiest way to go about this and secondly what would be the script to assign the variable to the value in the .csv file ascociated with it. Cheers
  16. SteveMyres

    Values Missing In Log File

    I have a logging set that's doing two things I can't figure out. The first thing is that there is one channel that comes up in the "Available Channels" box, I add it and click Apply. Yet the next time I come back to the logging config, it's back in the Available Channels box again. Second issue is that the lines aren't all created equal. In some cases fields that are closer in time than the align threshold aren't combined into the same line, and also fields seem to be missing for no reason I can discern. The points are derived from data arriving on a serial device, and during testing, all the values seem to appear in sequence every time, and trigger the section of sequence with the AddValue() call, but not all the fields are logged. Here's a section of a log file 1364293414.1,,,,,4200,,,4200,4200,,,,,4200,4200,840,,4200,4200,,4200,4200 1364293415.1,4250,,,4250,,,4250,,,,840,840,840,,4250,,,,,,, 1364293416.1,,,,,4250,,,4250,4250,,,,,4250,,850,,4250,4250,,4250,4250 1364293417.1,4300,,,4300,,,4300,,,,850,850,850,,4300,,,,,,, 1364293418.1,,,,,4300,,,4300,4300,,,,,4300,,860,,4300,4300,,4300,4300 1364293419.0,4350,,,4350,,,4350,,,,860,860,860,,4350,,,,,,,[/CODE] As you can see, the pattern of what gets logged is close to repetitive. Align threshold is set at 3.
  17. We have a system DSN using the MS SQL ODBC connection to a 2008 R2 database in a logging set. We were successfully logging 6 channels from a spinwave network, but due to the Excel time, we were getting repeated record groups of 8 all with the same timestamps. We went back to DF time and that reduced the repeats to 2-3 per timestamp. We've tried both "All Data Points - Aligned" and "Fixed Interval" and both give the same result. We tried logging to ODBC .csv file to see if the ODBC was a problem, but that file looks great. One record per interval. We set up the SQL DSN logging set the exact same way and we still get the repeated records. For the interval, we're using 60 seconds and we're using the "Align Threshold" of 60 seconds to match. Time sig figs is 15. Any idea why we're getting duplicate records when logging to MS SQL over ODBC?
  18. muniprasad

    Odbc Logging Password

    Sir, I created ODBC Database logger. I saved it on my local drive. While i open the file, it asks SQL server password. I want a script to set sql password to ODBC logging. So While I Logon to windows , its automatically works on without user interface. Thanking you
  19. Hi all, I've got my U3 measuring duty cycle using Timer0 and Timer1. Since I'm streaming the data, I've set up the configuration using sequences and setup four channels to read Channel 200, 224, 201, 225. I'm confident that I have the streaming working properly and am able to log the raw data (which consists of 4 elements - the LSW,MSW of Timer 0 and LSW,MSW of TImer1) without any issues. However, I'd rather not have to calculate the duty cycle for tens of thousands of points from the raw data for every one of my log files in excel. As such, I've been able to calculate the duty cycle within DAQFactory using both virtual channels and test channels. In my virtual channel, I've simply written the expression to calculate the duty cycle using the results of my data channels. My test channels receive the results of those same expressions from the Event tab of channels 224 and 225 using the AddValue command. So, I feel I can successfully calculate duty cycle values using two different methods. However, the issue is in trying to correctly log them. 1) From what I've read, I believe logging will not work with virtual channels, and as such must be recorded using export. However, I think export only exports the history of the channel, so if you happen to exceed the history, you'd be losing data. Is there another way to use Virtual Channels to actually log, rather than export, data? 2) When using the event tab of channel 224, I use the following expression to calculate duty cycle from the raw data for the LSW and MSW: DutyCycle_Calc.AddValue(DutyCycle_LSW/(DutyCycle_LSW+DutyCycle_MSW)*100) where DutyCycle_Calc is my test channel. When I use this form, nothing is logged from DutyCycle_Calc. However, if I use this expression instead: DutyCycle_Calc.AddValue(DutyCycle_LSW[0]/(DutyCycle_LSW[0]+DutyCycle_MSW[0])*100) I log a duty cycle value every few milliseconds but have a large number of raw data logged in between. I believe this is because the event is only being triggered when the packet from the streaming is written, and since the [0] only looks at one element of the package, only one piece of data from the packet is used to calculate a duty cycle. Is there a way to record a calculated DutyCycle for every piece of raw data that was streamed within a packet and have it logged? 3) On an unrelated note, does the channel # of a test channel matter? Or can these be arbitrarily set? Honestly, I'm still not clear on how to use test channels properly and couldn't find any direct explanations in the DAQFactory Manual. Any pointers to references would be greatly appreciated. If there's an easy and obvious answer to any of these questions (calculate in sequences and then somehow log the values?), I apologize, but I'd really appreciate some help either way, as I've really put a lot of time into figuring this out and haven't found a solution yet. Cheers!
  20. Hi all, I've been working on streaming some data, namely some digital inputs on FIO4-7. I'm successfully streaming channel 193 and getting good data. However, when I try to use scanrates>1000, I start running into timestamp issues, where blocks of data all have the same timestamp. My guess is that it's an issue using excel time - perhaps excel time doesn't have capacity for resolution > .0001 seconds? When I turn off excel time, it seems to run fine (obviously I have to calculate time differently since it's now seconds from 1970). In case I wanted to use excel time, do you know a way around the limitation in resolution? Thanks!
  21. GregGiles

    Odbc Logging To Ibm Iseries

    Hi, I am attempting to log data to a DB2 database in an IBM iSeries. I've set up a library on the IBM that the ODBC maps to. I get the following error on DAQFactory. C1011 Could not create table for logging. Msg: SQL0104 - Token ; was not valid. Valid tokens: <END-OF-STATEMENT> If I look on the IBM side, the following error is generated. Additional Message Information Message ID . . . . . . : SQL0104 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date sent . . . . . . : 12/08/31 Time sent . . . . . . : 09:52:36 Message . . . . : Token ; was not valid. Valid tokens: <END-OF-STATEMENT>. Cause . . . . . : A syntax error was detected at token ;. Token ; is not a valid token. A partial list of valid tokens is <END-OF-STATEMENT>. This list assumes that the statement is correct up to the token. The error may be earlier in the statement, but the syntax of the statement appears to be valid up to this point. Recovery . . . : Do one or more of the following and try the request again: -- Verify the SQL statement in the area of the token ;. Correct the statement. The error could be a missing comma or quotation mark, it could be a misspelled word, or it could be related to the order of clauses. -- If the error token is <END-OF-STATEMENT>, correct the SQL statement because it does not end with a valid clause. Anybody have a setup sequence for IBM ODBC? Has this been implemented before, and if so, what is the procedure? Thanks, Greg
  22. Please help. I need to send file with push button during logging to which I am logging data. I got error: C1008 Could not send message! Response: 354 End data with <CR><LF>.<CR><LF> here is the code: email.strTo = "x@xx.sk" email.strSubject = "Measurements" email.strBody = MeasMessage email.strFile = Logging.SaveInputs.Filename email.Send() Until I do not start logging it works fine.