Campbell LoggerNet Instruction Manual Download Page 518 | Manualshive

Page: 518 / 580

background image

Appendix B. Campbell Scientific File Formats

B-24

Only without the tabs and carriage return in the middle. One with strings might
look like this.

PC1,StatMsg (TMSTAMP TIMESTAMP,RECNBR DECIMAL(10,0),SrcStn

VARCHAR(256),AbtStn VARCHAR(256),Hop DECIMAL(3,0),Message
VARCHAR(256)) VALUES ('1993-12-08
15:02:02.25',13355,'PC1','StatMsg',0,'DBSelect End Pipe Queue Dump')

The acknowledgment records to be sent back to the server for the two records
shown above would be:

Lgr,Sec15,123456

and

PC1,StatMsg,13355

«
...
516
517
518
519
520
...
»

Summary of Contents for LoggerNet

Page 1: ...LoggerNet Version 4 2 Revision 7 13 C o p y r i g h t 1 9 9 9 2 0 1 3 C a m p b e l l S c i e n t i f i c I n c...

Page 2: ......

Page 3: ...copy of the software is an upgrade from a previous version you must possess a valid license for the earlier version of software You may continue to use the earlier copy of software only if the upgrad...

Page 4: ...allation media or documentation Campbell Scientific will correct errors without charge by providing new media addenda or substitute pages If Campbell Scientific is unable to replace defective media or...

Page 5: ...4 Restoring the Network from a Backup File 2 7 2 3 3 Loss of Computer Power 2 7 2 3 4 Program Crashes 2 8 2 4 Installing Running LoggerNet as a Service 2 8 2 4 1 Issues with Running LoggerNet as a Se...

Page 6: ...4 2 4 4 2 Schedule Tab 4 13 4 2 4 4 3 Final Storage Area 1 and 2 Tab Edlog Dataloggers with Mixed array Operating System 4 17 4 2 4 4 4 Data Files Tab CRBasic Dataloggers and Edlog Dataloggers with T...

Page 7: ...vas 4 63 4 3 2 3 Changing the Canvas Scale 4 65 4 3 3 Adding Stations to the Network 4 65 4 3 4 Adding Peripherals to a Station 4 65 4 3 5 Adding Stations Links 4 66 4 3 6 Adding Activities 4 68 4 3 7...

Page 8: ...ts 5 38 5 2 1 3 Functions Available from the RTMC Menus 5 39 5 2 1 4 Expressions 5 44 5 2 1 4 1 Operators 5 46 5 2 1 4 2 Order of Precedence 5 47 5 2 1 4 3 Predefined Constants 5 47 5 2 1 4 4 Predefin...

Page 9: ...Step 4 Setup Output Tables 7 14 7 2 2 5 Step 5 Generate the Program in the Format Required by the Datalogger 7 17 7 2 3 Short Cut Settings 7 18 7 2 3 1 Program Security 7 18 7 2 3 2 Datalogger ID 7 1...

Page 10: ...49 7 3 4 13 1 Expressions in Parameters 7 49 7 3 4 13 2 Arrays of Multipliers and Offsets for Sensor Calibration 7 50 7 3 4 14 Program Access to Data Tables 7 50 7 4 Edlog 7 51 7 4 1 Overview 7 51 7 4...

Page 11: ...7 79 8 Working with Data Files on the PC 8 1 8 1 View Pro 8 1 8 1 1 Overview 8 1 8 1 2 The Toolbar 8 2 8 1 3 Opening a File 8 4 8 1 3 1 Opening a Data File 8 4 8 1 3 2 Opening Other Types of Files 8...

Page 12: ...s 8 42 8 2 3 1 3 Start Condition 8 46 8 2 3 1 4 Stop Condition 8 49 8 2 3 1 5 Copy 8 52 8 2 3 1 6 Select 8 53 8 2 3 1 7 Ranges 8 54 8 2 3 1 8 Variables 8 55 8 2 3 1 9 Numerical Limitations 8 55 8 2 3...

Page 13: ...5 9 1 1 3 2 Calendar 9 6 9 1 1 4 Define What the Task Does 9 8 9 1 2 Status Tab 9 13 9 1 3 Remote Administration of the Task Master 9 15 9 1 4 Task Master Logs 9 15 10 Utilities Installed with LoggerN...

Page 14: ...8 11 3 2 1 Connecting to a Computer Running the LoggerNet Server Software 11 8 11 3 2 1 1 Setting Up the Data Filer 11 9 11 3 2 2 Collection Options 11 9 11 3 3 The Collected Data 11 11 11 3 4 Determi...

Page 15: ...3 1 Setup 13 5 13 3 2 Operational Considerations 13 5 13 3 3 Special Considerations 13 6 14 Troubleshooting Guide 14 1 14 1 What s Changed 14 1 14 2 LoggerNet Server Problems 14 1 14 2 1 Starting Log...

Page 16: ...E4 B 21 B 3 4 IEEE8 B 21 B 4 Converting Binary File Formats B 22 B 4 1 Split B 22 B 4 2 View Pro B 22 B 4 3 CardConvert B 22 B 4 4 File Format Convert B 22 B 4 5 TOB32 EXE B 23 B 5 RTMS Format Descrip...

Page 17: ...Zeroing F 3 F 3 2 Offset Calibration F 4 F 3 3 Two Point Multiplier and Offset Calibration F 4 F 3 4 Two Point Multiplier Only Calibration F 5 F 4 Performing a Manual Calibration F 5 F 4 1 How to Use...

Page 18: ...cts of Out of Range Values for Given Output Options 8 54 8 6 Split Operators and Math Functions 8 56 8 7 Time Series Functions 8 58 8 8 Split SPECIAL FUNCTIONS 8 63 8 9 Definition of Blank or Bad Data...

Page 19: ...c and Short Cut To help with creating CR1000 programs a Transformer utility was developed to convert existing CR10X Edlog programs to CR1000 CRBasic programs LoggerNet 3 2 added support for our new CR...

Page 20: ...een added to the Network Planner An option to provide feedback on LoggerNet is now available from the LoggerNet Toolbar s Help menu Beginning with LoggerNet 4 1 Windows 2000 is no longer supported NOT...

Page 21: ...itor from the Connect Screen either by right clicking on the datalogger or from the Datalogger menu You can also manually set the datalogger s clock from the Connect Screen either by double clicking i...

Page 22: ...n a remote computer to monitor data or retrieve view and analyze data that was collected by LoggerNet into a file LoggerNet Admin and LoggerNet Remote enhance the capabilities of LoggerNet by providin...

Page 23: ...be used to cause LoggerNet to maintain a connection with a range of dataloggers once an incoming connection has been established An Image Files tab has been added to the Setup Screen for the CR1000 CR...

Page 24: ...c displays and the ability to specify what will happen when a NAN is encountered in a graph The configuration of the data displays can now be saved A new File Format option CSIXML has been added to Cu...

Page 25: ...button has been removed Peripheral devices are now listed in and selected directly from the Available Sensors and Devices tree CRBasic Editor The CRBasic Editor now gives you the option to Save and En...

Page 26: ...lding expressions in RTMC These include string functions time functions start option functions and function with state The ability to declare aliases for data values used in expressions has also been...

Page 27: ...ics box which shows the average standard deviation minimum and maximum of the displayed points From the toolbar you can also add a graph cursor to a Line Graph The cursor can be scrolled across the gr...

Page 28: ...development of a model of the PakBus network proposes and verifies valid connections between devices and allows integration of the model directly into LoggerNet 4 0 Data Filer A new File Format optio...

Page 29: ...raph LogTool the Device Configuration Utility Data Export and the RWIS Administrator Available alternate language packages are provided by Campbell Scientific s international representatives or on the...

Page 30: ...Preface What s New in LoggerNet 4 xxvi...

Page 31: ...and enabled access the Windows Control Panel Start Control Panel From the Control Panel open Administrative Tools and choose Services The list of installed services is typically displayed in alphabet...

Page 32: ...Section 1 System Requirements 1 2...

Page 33: ...to complete the installation Items are added to your computer s Start menu under Programs Campbell Scientific LoggerNet that start the Toolbar and some other selected utilities At the end of installa...

Page 34: ...longer be compatible with LoggerNet 2 x or 3 x For this reason the upgrade installation will automatically make a copy of the WorkingDirectory LoggerNet sys directory and all of its contents The copy...

Page 35: ...directory The working directory holds the user files created by the application as well as configuration and initialization INI files Because of this working directory scheme implemented in version 3...

Page 36: ...y in which a file was saved and will default to that directory until a different directory is selected Note that most all applications have one or more subdirectories in which configuration files are...

Page 37: ...Software Organization for additional information 2 3 2 Backing up the Network Map and Data Files As with any computer system that contains important information the data stored in the LoggerNet worki...

Page 38: ...a backup configuration choose Network Manual Backup from the Setup Screen s menu Proceed through the Backup wizard At the last step choose Save Configuration For Later The configuration will be saved...

Page 39: ...erver writes to several files in the SYS directory during normal operations The most critical files are the data cache table files and the network configuration files The data cache files contain all...

Page 40: ...onfirm the end process 2 4 Installing Running LoggerNet as a Service If you have LoggerNet Admin you can install and run LoggerNet as a service The advantage of running a software application as a ser...

Page 41: ...created from LoggerNet 3 4 it will be necessary to stop uninstall the service then reinstall the service in order to setup the password NOTE The LoggerNet user account will not show up in your list of...

Page 42: ...t full permissions for the directory Press the Apply button to apply the changes Press OK to close the dialog box The LoggerNet user should now have full access to the designated directory 2 4 1 2 Net...

Page 43: ...erver to open a socket on a specific port default is port 6789 to listen for requests for data from its clients This is usually quite safe since 1 no other application should be trying to use this por...

Page 44: ...Section 2 Installation Operation and Backup Procedures 2 12...

Page 45: ...LAN Wide Area Network WAN or the Internet If you have LoggerNet Admin or LoggerNet Remote any of the client applications can log on to a remote LoggerNet server Another benefit is the efficiency that...

Page 46: ...editing As you hover over a category in the list on the left side of the toolbar applications related to that category will be shown on the right Selecting an application in the right hand list will l...

Page 47: ...le Applications column shows all applications that are available in LoggerNet Press the sign next to a category to show the applications in that category An application can be added to the Favorites c...

Page 48: ...ion bring up the LoggerNet Options dialog box From this dialog box you can specify various options such as whether the toolbar always stays on top the behavior of the system tray icon language and whe...

Page 49: ...g LocalHost 6700 or 192 168 7 123 6700 NOTE If LoggerNet is being run as a service available in LoggerNet Admin you use LoggerNet Service Manager to specify an alternate working directory or IP port...

Page 50: ...w or Standard View will refer to the Standard View of the Setup Screen The EZ View of the Setup Screen uses the EZSetup Wizard which provides a simple step by step sequence of screens with on screen h...

Page 51: ...ns ports and flags You can also manually retrieve data in various formats and communicate with a datalogger in terminal emulation mode RTMC is used to for real time data displays of the data collected...

Page 52: ...dataloggers without a PC involved and dynamic routing PakBus devices can be configured as routers and learn about the presence of other PakBus devices or alternative routes to those devices as they co...

Page 53: ...CR5000 CR800 Series and CR9000 Instructions are available for sensor measurement intermediate processing program and peripheral control and data storage The built in precompiler provides error checkin...

Page 54: ...9 Automating Tasks with Task Master The Task Master is used to set up a Task that can be triggered on a defined schedule or upon a data collection event from a datalogger A Task can be data collection...

Page 55: ...n OPC format This allows use of the data by third party software applications that communicate using the OPC protocol 3 2 11 5 Software Development Kit LoggerNet SDK the LoggerNet Software Development...

Page 56: ...Section 3 Introduction 3 12 often explain the purpose of a control or a suggested action For text boxes where some of the text is hidden the full text will appear in the hint...

Page 57: ...gning a PakBus datalogger network The Device Configuration Utility or DevConfig is a stand alone tool that can be used to configure settings in the dataloggers themselves as well as in communication d...

Page 58: ...r telephone charges There are however other links that can result in expensive connection charges such as digital cellular links using TCP IP that charge by the byte Leaving the datalogger connected a...

Page 59: ...scheduled data collection attempt The Scheduled Collection step is where you can define a schedule on which LoggerNet will automatically call the datalogger and collect data Once a datalogger station...

Page 60: ...that your server computer is connected to the datalogger via a telephone modem You would first add a ComPort then the telephone modem the remote phone modem and the datalogger To add a ComPort to the...

Page 61: ...e to the Add Device window is to press the right mouse button while your cursor is on a device within the main device map window A shortcut menu like the one shown below will appear that will provide...

Page 62: ...n stages and periodically apply changes If there is a problem with the computer any changes that have been applied have been saved and will not have to be entered again Changing the network map or any...

Page 63: ...the device The Advanced section contains settings that can be left at the default for most applications All devices have a Notes tab which is only for the user s convenience It may be used to keep no...

Page 64: ...time for a response from each device in a communications path The extra response times defined for the communications link are cumulative Therefore the amount of time spent waiting for a device to re...

Page 65: ...time in seconds and milliseconds that LoggerNet should delay before hanging up the link to the device If a new command to the device is issued before the delay has expired communication will not be te...

Page 66: ...ox for those dataloggers which should be enabled for call back Extra Response Time In this field specify the additional time that LoggerNet should delay before terminating the communications link if t...

Page 67: ...to define a time limit for maintaining a connection to the device This may be useful in avoiding costly communication costs in the event that a connection to a station is inadvertently maintained for...

Page 68: ...d in instances where the communications link is noisy or network traffic is heavy Maximum Packet Size Data is transferred in chunks called packets For most devices the default value is 2048 byes The v...

Page 69: ...ryption Key can be up to 63 bytes long and can include any character with the exception of the Null character Note that if Unicode characters are included in the key those characters may take up to th...

Page 70: ...ction attempts will be made at 15 minutes past the hour each hour Primary Retry Interval If a data collection attempt is made but fails you can specify an interval on which another attempt will be mad...

Page 71: ...se statistics are not retrieved by default as users with slow or expensive communication may not wish to incur the additional cost or time associated with the extra commands In cases where the user do...

Page 72: ...empt to contact the datalogger and request the missing records Otherwise LoggerNet will not attempt to collect records missing from the data cache Please note that LoggerNet puts records from Data Adv...

Page 73: ...s option allows you to choose whether new data collected from the station is appended to the data file overwrites the old data in the data file or is not stored to a data file The default option is to...

Page 74: ...d When Collect All on First Collection is checked LoggerNet will collect all data in the datalogger the first time data is collected If Collect All on First Collection is not checked the first call to...

Page 75: ...ault option is to append to the data file so the old data is not lost If the data file is used only for a real time display or such that only the last data collected is needed overwrite will replace t...

Page 76: ...n LoggerNet calls the datalogger to collect data it will try to get all of the data stored by the datalogger since the previous call If this is the first call to a datalogger there might be a lot of h...

Page 77: ...k check may not be desirable It is possible to end up with missing data or duplicate data if the datalogger s clock is set forward or backward enough to skip or duplicate a data storage event Special...

Page 78: ...Dataloggers with PakBus Operating Systems Retrieval Mode This option determines the schedule for file retrieval Disabled No files are retrieved Follow Scheduled Data Collection Files will be retrieve...

Page 79: ...Max Files parameter will be recorded and they will not be retrieved later If this box is not selected the skipped files can be retrieved in a later attempt 4 2 4 5 PhoneBase The PhoneBase is a teleph...

Page 80: ...ong response times can delay other scheduled events while waiting for a device that is not responding NOTE 4 2 4 6 PhoneRemote The Hardware tab of the remote phone modem is used to set up the dialing...

Page 81: ...Maximum Time On Line This field is used to define a time limit for maintaining a connection to the device This may be useful in avoiding costly communication costs in the event that a connection to a...

Page 82: ...itional time may be needed in instances where the communications link is noisy or network traffic is heavy Maximum Packet Size Data is transferred in chunks called packets For most devices the default...

Page 83: ...ating system Hardware that can act as an RFBase TD includes the RF500M RF500B RF310M RF310B and RF315M The standard use of the Time Division Polling protocol is to communicate with PakBus dataloggers...

Page 84: ...s determined solely by the settings of the RF Polling Interval and RF Poll Offset NOTE Hardware Tab Standard Communications Enabled Before communications can take place all devices in the chain must h...

Page 85: ...rate for communication with this device Note that the actual rate of communication may be limited by the capability of other devices in the communications chain Advanced Extra Response Time In this f...

Page 86: ...he RFBase s clock if it varies by a certain amount This option should be used with caution since the change could result in data with missing or duplicate time stamps Enabled This check box is used to...

Page 87: ...network must have a unique address this number is entered in the Address field Each RF modem used as a repeater only site still needs its own unique Address Advanced Extra Response Time In this field...

Page 88: ...d Notes tabs LoggerNet assumes an MD9 base modem address of 255 Therefore the MD9 base modem must have the hardware switch ID set to 255 for communication to work NOTE A PakBus datalogger is added to...

Page 89: ...A message will be displayed indicating that Max Time On Line has been reached When connecting to servers older than LoggerNet 3 4 1 the behavior will be variable Generally you will be disconnected at...

Page 90: ...ss this number is entered in the Address field Maximum Time On Line This field is used to define a time limit for maintaining a connection to the device This may be useful in avoiding costly communica...

Page 91: ...e Data is transferred in chunks called packets For most devices the default value is 2048 byes The value entered in this field can be changed in 32 byte increments If a communications link is marginal...

Page 92: ...gerNet 3 4 1 server you will be disconnected with no advanced warning when Max Time On Line is reached A message will be displayed indicating that Max Time On Line has been reached When connecting to...

Page 93: ...If the Don t Reset button is pressed or if no button is pressed the connection will be terminated when Max Time On Line is reached The format for this field is 00 h ours 00 m inutes 00 s econds If yo...

Page 94: ...lue of 0 in this field indicates that there is no time limit on maintaining a connection to the device When the device is connected in the Connect Screen and the time limit approaches a dialog box is...

Page 95: ...lf Duplex Select this check box to enable half duplex communication This means that communication will take place in one direction at a time therefore it will significantly slow the communication spee...

Page 96: ...as part of scheduled data collection or manually by the user This way the port remains available for other uses except when it is in use by LoggerNet Maximum Time On Line This field is used to define...

Page 97: ...d at the specified interval unless LoggerNet is actively communicating over the PakBus Port PakBus Verify Interval The amount of time in seconds that will be used as the link verification interval in...

Page 98: ...ication in a datalogger network Standard Communication Enabled This check box is used to turn communication on or off This check box must be enabled for any communication to take place over the PakBus...

Page 99: ...in the Connect Screen and the time limit approaches a dialog box is displayed warning the user that Max Time On Line is about to be exceeded The dialog box has Reset Max Time and Don t Reset buttons...

Page 100: ...th a range of these dataloggers once an incoming connection has been established Hardware Tab Standard Communications Enabled This check box is used to turn communication on or off This check box must...

Page 101: ...datalogger A verify interval of zero causes LoggerNet to use a default verify interval of 2 5 times the beacon interval If the beacon interval is also zero the default verify interval is 5 minutes The...

Page 102: ...loggers attached to the PakBus TcpServer LoggerNet waits for an incoming connection from a datalogger in the range Once an incoming connection has been established with a datalogger in the range the c...

Page 103: ...modems the modems should all be such that any of the modems phone lines could be used in conjunction with any device that has it as part of its modem pool Using the same type brand of modem is suggest...

Page 104: ...Screen to connect to a remote server that is running an older version of LoggerNet the behavior will be different than described above When connecting to a LoggerNet 3 4 1 server you will be disconnec...

Page 105: ...vided by the terminal server Serial Port Pooling is used when virtual serial ports are installed NOTE Terminal Server Pooling is an alternative to using redirected serial ports In Terminal Server Pool...

Page 106: ...ooled modems the modems should all be such that any of the modems phone lines could be used in conjunction with any device that has it as part of its modem pool Using the same type brand of modem is s...

Page 107: ...connect to a remote server that is running an older version of LoggerNet the behavior will be different than described above When connecting to a LoggerNet 3 4 1 server you will be disconnected with n...

Page 108: ...When the schedule is enabled and LoggerNet is up and running the LoggerNet server will initiate calls to the datalogger on the defined schedule and collect its data Remember that what data is collecte...

Page 109: ...amental rate at which data is available In typical programs the sensor readings are taken at this rate and the values are stored in corresponding Input Locations or variables This execution interval i...

Page 110: ...schedule will be delayed waiting for the previous stations to finish RF networks with repeaters also add time delays since each modem must be contacted and then pass the message on to the next RF mod...

Page 111: ...s will also be identified by the Troubleshooter Section 6 Network Status and Resolving Communication Problems If data is not being collected check the following The Scheduled Collection Enabled box on...

Page 112: ...t to 12 04 15 Therefore there will be no data for the time stamps 12 03 and 12 04 Conversely if the datalogger s clock is a few minutes faster than the LoggerNet computer s clock the result would be d...

Page 113: ...TDF file with a datalogger TDF stands for Table Definitions File When a program is compiled for a CR1000 CR3000 or CR800 Series datalogger a program_name TDF file is created along with the original p...

Page 114: ...his is because when a neighbor filter is set up a PakBus datalogger will answer a Hello message from any device with an ID greater than 3999 but will ignore devices with IDs less than 4000 that are no...

Page 115: ...n to these settings an ID for each modem is set on the IPPort s Hardware tab of the Setup Screen AirLink Modem Name 4 2 8 1 4 1 Troubleshooting Tips If the computer on which the LoggerNet server is ru...

Page 116: ...options in the Backup menu can be used to create a backup of the network and then restore the network if necessary See Section 2 3 2 Backing up the Network Map and Data Files for more information 4 2...

Page 117: ...dropping it from the Assigned Dataloggers column to the Unassigned Dataloggers column Dataloggers in the Assigned Dataloggers column can be rearranged by dragging and dropping a datalogger to a new l...

Page 118: ...d to the model any peripherals that connect to the root device are added After adding the stations to your network you must identify links between stations and the activities that occur over those lin...

Page 119: ...nificant value in that they allow you to see the layout of your network related to the geography that you are trying to cover A good image can show landmarks and or topographical locations that guide...

Page 120: ...model a miniature version of that bitmap will appear in the overview The positions of stations on the canvas are represented with red dots A black rectangle is used within this area to show the curre...

Page 121: ...station will be created when you click on an empty part of the canvas When this is done a new icon for that station will appear on the canvas The appearance of that icon will either be a small image o...

Page 122: ...ted at the top Note that the Network Planner simplifies the task of selecting a link by hiding by default all of the links except those that have the highest priority You still have the option of seei...

Page 123: ...rsor is over another station with a small green icon indicating a compatible interface At this point the dialog shown below will appear As with adding peripherals to stations you must select the appro...

Page 124: ...Planner provides a means for you to specify that certain kinds of activities take place between station devices on a regular interval These activities include the following Scheduled polling from Logg...

Page 125: ...s icon When the mouse cursor hovers over a station that does not contain devices capable of originating activities a small red cross symbol will appear in the middle of that station s icon You can sp...

Page 126: ...ed with the set of activities that are compatible with the two selected devices serving as source and target If a given type of activity has already been specified between two devices that activity wi...

Page 127: ...es link that if clicked will present you with a dialog that contains property sheets for all of the devices and or links in the station A list of links to the parts of the report that describe the eac...

Page 128: ...PakBus devices List of links for which the device is an end point Any device specific details that may be applicable For example on the COM220 and the RF310 a table will be shown that specifies the ju...

Page 129: ...with the root device of that station 4 3 8 1 Configuring Using the Device Configuration Protocol The majority of device types that are supported by the Network Planner can be set up using the same pro...

Page 130: ...right hand corner of the dialog shows the instructions to connect to the device These instructions are obtained from the Device Configuration library and will thus always be the same as is shown in t...

Page 131: ...ed If you click on the Bypass button rather than on the OK button no communication with the local LoggerNet server will take place If the Bypass button is used and LoggerNet is actively using the sele...

Page 132: ...oggerNet on a remote computer that instance of LoggerNet must allow remote connections and must also be reachable from the computer hosting the Network Planner User Name Password These fields allow yo...

Page 133: ...ice links Since the dialog has not yet communicated with the server this summary shows only the expected structure and does not reflect any devices in the actual network map If you click on the Connec...

Page 134: ...r Work The Network Planner model can be saved to a file by one of several interactions By clicking on the Save or Save As tool bar button highlighted below By selecting the Save or Save As item from t...

Page 135: ...d to the frame by dragging that component s title bar over the top of the frame borders or the borders of other docked components When the component is dragged over one of these boundaries a blue rect...

Page 136: ...Section 4 Setting up Datalogger Networks 4 80...

Page 137: ...desired action and then end communication with the station If you have LoggerNet Admin or LoggerNet Remote installed you have the ability to set up security so that access to certain functions in Logg...

Page 138: ...g large amounts of data over a slow communication link could affect the speed of data collection If you want to perform multiple tasks e g send a new program and view measurements on a Numeric Display...

Page 139: ...r LoggerNet keeps track of two separate data collection pointers for each datalogger 1 the pointer for scheduled data collection and manual data collection from the Connect Screen s Collect Now button...

Page 140: ...data to collect and which final storage areas you want to collect NOTE While retrieving data from the datalogger using Custom Collection scheduled data collection will be suspended The directory wher...

Page 141: ...ta file This option only applies if a file with the same name exists in the directory specified Append to End of File When this option is selected the data collected using the Custom Collection option...

Page 142: ...uled collection data and by default are placed in a Data directory under the LoggerNet directory NOTE Collect Mode Newest Number of Records will retrieve the number of records specified in the Startin...

Page 143: ...rop down calendar and the time can be entered or edited using the arrows to the right of the control Starting Record Information Starting Record is used to specify a range of records to collect The da...

Page 144: ...rts and Flags window shows the current state of the ports and flags for the datalogger If a flag is enabled or a port is high the button next to the name appears green if the flag or port is disabled...

Page 145: ...ed by the number of cells available on the Ports and Flags display CR800 CR1000 and CR3000 dataloggers have ports that can be toggled from this display they will be displayed in the first column and t...

Page 146: ...Pause Clock Update In some situations it is desirable to pause the clock update to minimize data traffic over the communications link You can set the clock by clicking the Set button LoggerNet attempt...

Page 147: ...tor at the bottom of the dialog can be used to filter the files that are displayed This filter is set to the appropriate file type for each datalogger automatically dld for CR7 21X CR10 X CR510 and CR...

Page 148: ...Files for the CRBasic dataloggers e g CR1 can be opened directly in the CRBasic Editor A retrieved dld file can be imported into Edlog for editing by using Edlog s Document DLD feature Section 7 Creat...

Page 149: ...ected values graphically Data being monitored in a data display is updated as follows Mixed Array Dataloggers Final storage data from mixed array dataloggers is retrieved only when data collection fro...

Page 150: ...public variables However CR10X TD type dataloggers must transfer the entire input locations record in one packet Because of packet size if more than 500 input locations are used in the datalogger prog...

Page 151: ...ta fields for the available datalogger tables or final storage arrays Table based dataloggers If the Add Selection dialog box is empty return to the Setup Screen s Data Files table and select Get Tabl...

Page 152: ...input locations names are available to select and add to the display If the datalogger doesn t have an associated file generic labels for up to 28 input locations are still displayed in the Fields pa...

Page 153: ...Allows you to choose the text that will be displayed for Boolean values such as ports and flags or variables declared as Boolean By default the strings are True False though they could be set to High...

Page 154: ...to save the current configuration of the data display to a file that can be loaded in the future to restore the current configuration 5 1 7 2 3 Right Click Menu Options Press the right mouse button w...

Page 155: ...ues on a Graph A graph is initially blank when opened the fields to be plotted must be selected Press the Add button to bring up the Add Selection dialog box that lists the data fields for the availab...

Page 156: ...ontents of the graph can be cleared by pressing the Clear button The Rescale button is used to bring outlying data values back within the vertical axis of the graph when using one of the Powers of 10...

Page 157: ...ake variations in the other fields harder to see Powers of 10 0 to 10 Data values will be scaled so that they fit on a graph ranging from 0 to 10 Negative values will not be displayed Each trace is sc...

Page 158: ...n choose to Show Time and Date Display Just Time or Hide the Timestamp Numeric Display Options Select Automatic to have the number of decimal places determined automatically by the data value Select S...

Page 159: ...sual Display Tab The Visual Display options allow the user set the appearance of the graph The colors for the grids and background as well as how the trace should appear can be set here Titles can als...

Page 160: ...you to place a descriptive title over the top edge of the graph and for each axis Enter the text of the title in the text box then click the Show Title check box to make the title visible Click the F...

Page 161: ...s used to Save or Load graph configurations Save Config Saves the graph configuration to a file that can be loaded in the future Load Config Loads a previously saved graph configuration file 5 1 7 3 3...

Page 162: ...the data points are displayed on the graph When cleared they are not displayed and all other items on this tab are disabled Draw Every Determines how often the data points should be labeled When set t...

Page 163: ...verage value minimum maximum and number of data points for each data value being displayed Note that these values are for the default graph view i e not zoomed or panned Right Click on a Table Cell Di...

Page 164: ...ld and drag the mouse pointer up and to the left to return to normal view If you have stopped a graph and zoom in to a region you can use the right mouse button to drag the screen and thus scroll to o...

Page 165: ...em The File Control window displays a list of files stored on the datalogger s CPU PC card or USR drive The window on the left lists all of the data storage devices available for the selected datalogg...

Page 166: ...other ASCII files can be sent to the datalogger Format is used to format the selected device Just like the formatting a disk on a computer all of the files on the device are deleted and the device is...

Page 167: ...has the same name as one being output with the new program the message will be returned Data on Card is from a different program or corrupted Data will not be written to the card until the existing ta...

Page 168: ...ou have the option of whether or not to erase data files stored on a card Run On Power up The file will be sent with the Run On Power up attribute set The program will be run if the datalogger loses p...

Page 169: ...he Run Options button to restart it If data files were not deleted when the program was stopped you will once again be able to choose whether to retain or erase the data files You will also be able to...

Page 170: ...tion Status Station Status contains information about the datalogger type OS version date and signature program statistical information etc To view Station Status press the Station Status button or se...

Page 171: ...u can select fields or view modify a value if it is a writable value Press Refresh to prompt LoggerNet to query the datalogger and update the values again the Print button to print the information in...

Page 172: ...real time graphic display screen to display the data collected from the dataloggers Once the screen is built and saved as a file the screen can be displayed using RTMC Run Time This allows graphic dis...

Page 173: ...can be placed on the screen Many images have been included with RTMC The directory in which these files are stored is C Campbellsci Lib RTMCMediaLib Custom images can be used as well these should be p...

Page 174: ...window Once the link to the data value has been applied if there is data available from LoggerNet for the component the value on the display will update To make changes to display component settings t...

Page 175: ...ed is based on the Sensitivity property for the component An audible alarm can be disabled by right clicking the component with your mouse Time displays the server time server time at last data collec...

Page 176: ...pace The components can then be cut copied deleted grouped etc Clear Selection clears the selection of components currently highlighted on the active screen The Preferences menu item is used to change...

Page 177: ...pane of the default window Show Toolbox hides or displays the RTMC Component Toolbar Show Layout Toolbar hides or displays the Layout Toolbar which gives quick access to the Align Space Evenly Make Sa...

Page 178: ...rrent screen from the project If there are components on the screen they will also be removed Rename Screen brings up a dialog to change the name of the current screen This is the name that appears on...

Page 179: ...object selected Select one or more components by using the cursor to click and drag a bounding box around the desired components The components can also be selected by selecting the first component an...

Page 180: ...ading from degrees Celsius to degrees Fahrenheit Strings As shown above double quotes are used in RTMC to enclose the name of a data value or source datalogger or table depending on the component Ther...

Page 181: ...y Alias X Server CR1000 MyTable Value StartAtOffsetFromNewest 5 Order Collected IIF ABS X ValueAtTime X TimeStamp X 30 nsecPerSec 0 10 AND ABS ValueAtTime X TimeStamp X 30 nsecPerSec 0 ValueAtTime X T...

Page 182: ...n timestamp from the other datalogger s Once the buffer reaches 100 000 data points the oldest data value will be removed from the buffer each time a new data value is collected All of the functions a...

Page 183: ...b c 5 2 1 4 3 Predefined Constants Constant Description e 2 718282 PI 3 141593 True 1 False 0 NOPLOT NAN NAN NAN not a number INF INF non finite number 5 2 1 4 4 Predefined Time Constants These prede...

Page 184: ...x Returns the cosine of a number COSH x Returns the hyperbolic cosine of a number CSGN x Changes the sign of a number by multiplying by 1 0 EXP x Returns e raised to the x power FIX x Returns the inte...

Page 185: ...an angle TANH x Returns the hyperbolic tangent of a number 5 2 1 4 6 Logical Functions The following functions perform logical operations Function Description x AND y Performs a logical conjunction o...

Page 186: ...ces Mid Returns a substring that is within a string Replace Used to search a string for a substring and replace that substring with a different string Right Returns a substring that is a defined numbe...

Page 187: ...processed until a new record has been collected StartAtNewest Attempts to start processing at the newest record in the table StartAtOffsetFromNewest Attempts to start processing with the record at th...

Page 188: ...rTimeWithReset Returns the maximum of all values since the function was reset MaxSpa Returns the maximum of the specified values MedianRun Returns the median value of up to the last specified number o...

Page 189: ...Address is a number that will have four digits between 0 and 255 separated by decimal points An example would be 192 168 4 32 Do not put leading zeros with the numbers The default port number for Logg...

Page 190: ...screen can be run without starting the development mode window Select Data RTMC Run Time from the LoggerNet toolbar In the Run Time window select File Open to select the RTMC project screen to run In...

Page 191: ...istics and their meaning Information in the Status Monitor window can be sorted by column Click on a column heading to sort the devices For instance if the Network Map column is clicked once the devic...

Page 192: ...when communicating with a device a Trouble Indicator icon will be displayed to the left of that device The column heading for the network map will also display the Trouble Indicator icon The Communic...

Page 193: ...r left one segment at a time You can zoom in on a particular interval by clicking and dragging your mouse cursor from the upper left of an area to the lower right of an area To return to normal view c...

Page 194: ...below The table also shows how the LoggerNet server maps these server statistics to the Status Table of each datalogger Status Table Values Server Statistic displayed in Status Monitor CR1000 CR800 C...

Page 195: ...indicator next to the device name Marginal is indicated when warning messages for the device are logged in communications Critical is indicated when communication failures are logged in communication...

Page 196: ...he link and is closing down communication Comm Disabled Communications for this device have been disabled for this device a parent device or the network Link Time Remaining The time remaining in milli...

Page 197: ...ns with the blacklisted station on its regular RF Polling Interval Once the station has responded to one of these regular RF polling broadcasts it will be removed from the blacklist At that point comm...

Page 198: ...an be used to determine what is shown in your network map You can choose to view only your dataloggers by selecting Stations Only Selecting All Devices will show your entire network including root dev...

Page 199: ...ndow displaying statistics for all of the pooled devices in the network For each pooled device resource the following information is given Overall Error Rate This represents the error rate based on al...

Page 200: ...Error Rate This represents the error rate specific to the selected Modem Pool use of the selected pooled device Skipped Count The number of times this pooled device has been skipped when using the se...

Page 201: ...ations scheduled collections etc will have a priority of 2 Client sponsored operations will typically have priority of 3 or 4 Operations such as automatic hole collection will typically have a value o...

Page 202: ...00 AM 1 2 2013 8 45 00 AM 1 Changed 1 2 2013 8 45 00 AM CR3000 table poll OneMin collecting holes between 28827 and 28830 2 1 2 2013 8 45 00 AM 1 2 2013 8 45 00 AM 1000 ms 1 Changed 1 2 2013 8 45 00...

Page 203: ...an object at a given time Low Level I O Log io SerialPort_1 This log displays low level incoming and outgoing communications for a root device i e serial port 6 2 2 Using LogTool LogTool can be opened...

Page 204: ...es currently being displayed on the LogTool screen can be manually saved to a text file by selecting File Save Log Windows to File In addition these logs can be printed by selecting File Print Log Win...

Page 205: ...ile directory can be deleted by selecting File Delete All Log Files from the LogTool menu All of the log files can be zipped by selecting File Zip All Log Files When working with a Campbell Scientific...

Page 206: ...s by selecting the Show Stations Only check box 6 4 PakBus Graph PakBus Graph is a utility that graphically depicts the connections in a LoggerNet PakBus datalogger network It provides a look at Logge...

Page 207: ...r Password Your password for the software server The User Name and Password fields are required only if your server administrator has set up security on your system 6 4 2 Dynamic and Static Links Ther...

Page 208: ...communicate During this time the PakBus port is kept on line Broadcast Reset server only This option will reset the routing table in the selected PakBus device as well as any neighbors of the selected...

Page 209: ...ay include the type of device the device name in the network map the state of communication with the device whether or not scheduled data collection is enabled whether or not table definitions are val...

Page 210: ...n the Communication Test window which is described in Section 6 3 Comm Test TD RF Test This option opens a window from which you can perform a communications test on a table data RF modem link RFBase...

Page 211: ...e TD RF Quality Test window displays the results of successful RF Link Quality tests as well as events activating or deactivating the Advanced Features of the TD RF modems The most recent entries are...

Page 212: ...y identify variances and trends in link quality The numerical value for Link Quality is derived from the detailed information contained in the TD RF Quality Report and has a theoretical range of 0 to...

Page 213: ...ion of testing an RF path that with the exception of the selected RFBase TD may or may not be composed of devices configured in the network map When enabled by selecting an RFBase TD in the network ma...

Page 214: ...rting the serial data stream from the wired medium into a waveform of proper amplitude and frequency for driving the FM modulator circuits of the RF transceiver and vice versa In a process known as li...

Page 215: ...mum of all T1 bit transition points within the tolerance window 4 4 4 0 V The information recorded in the TD RF Quality Report includes the location of the maximum and minimum transition point for the...

Page 216: ...ngineer CAUTION It should be noted that the activation of the Advanced Features is not persistent when the modem is reset i e power removed the functionality will be discontinued Additionally while al...

Page 217: ...ggerNet Utilities LoggerNet Server Monitor When first opened a Login dialog box appears This dialog is used to specify the name or address of the computer running the LoggerNet server that you want to...

Page 218: ...ackground red text The LoggerNet server is no longer running If Warnings or Faults have been encountered you can reset the state of the icon by right clicking it and choosing Reset or by opening the S...

Page 219: ...e above programming tools the Transformer utility is offered in LoggerNet for those users of CR10X or CR23X dataloggers who need to develop programs for the CR800 Series CR1000 or CR3000 dataloggers 7...

Page 220: ...steps in Short Cut for a CRBasic datalogger as you would for an Edlog datalogger but then open the program in the CRBasic Editor to see how Short Cut created the program NOTE 7 2 Short Cut 7 2 1 Over...

Page 221: ...sensor form After generating the program you can send it to the datalogger from the Results tab of Short Cut s Finish screen or from LoggerNet s Connect Screen or from PC400 PC200W or RTDAQ s Clock P...

Page 222: ...osing a scan interval remember that faster scan intervals will use more power For most applications a 10 to 60 second scan interval is sufficient If faster scan intervals are required for your applica...

Page 223: ...0 Hz rejection is used for countries following European standards Fast 250 s integration should be used when you need an execution speed that cannot be accomplished using one of the other options This...

Page 224: ...model you will be presented with these two dialog boxes The state of these settings is saved between Short Cut sessions Any subsequent new or edited programs that are generated after a setting has bee...

Page 225: ...nsors Refer to the documentation for your sensors for the name of the sensors you have If your sensor is not shown you may be able to measure it with a generic measurement Contact your Campbell Scient...

Page 226: ...ds the necessary instructions with appropriate multipliers and offsets In some cases multiple sensors of the same type can be added at one time These sensors will have a How many sensors parameter as...

Page 227: ...Section 7 Creating and Editing Datalogger Programs 7 9...

Page 228: ...only be made when the group is first added To make changes to a wiring location at a later time you will need to change the number of sensors to one press OK reopen the parameter form make the desired...

Page 229: ...surements stored in particular units See the help for each calculation to determine the necessary inputs Note that there is also a User Entered calculation available in the Calculations folder With it...

Page 230: ...5C Air Temperature and Relative Humidity sensor and a 05103 Wind Speed and Direction sensor Each sensor was allocated the necessary terminals Short Cut will not let you add more sensors than there are...

Page 231: ...nce you ve added a device such as the AM16 32 multiplexer a tab is added to the screen for that device and the sensors available for that device are shown You can then add sensors to that device just...

Page 232: ...nt to final storage simply click on a measurement label on the left choose the data processing you want for that measurement by clicking one of the enabled buttons in the middle and Short Cut adds the...

Page 233: ...added for any one sensor For example you may want to store the maximum and minimum air temperature as well as the average Table based dataloggers have a TableName field as opposed to an array ID Ther...

Page 234: ...s stored in the table Table based dataloggers that support output to an SC115 will have an SC115 CS I O to USB Flash Memory Drive check box When this check box is selected new data will be copied to a...

Page 235: ...l of your selections for datalogger sensors outputs etc For CR10 CR10X CR500 510 CR23X and 21X dataloggers including mixed array table data and PakBus operating systems ProgramName DLD is the ASCII te...

Page 236: ...ht Rather it is designed to prevent honest people from making mistakes Notwithstanding its intention one mistake you can make is to set security and then forget the values If you send a program with s...

Page 237: ...ll of the released versions of the CR200 205 operating systems If at some time in the future you acquire a newer CR200 205 or choose to install a later operating system you must make sure you also hav...

Page 238: ...fault is set to C CampbellSci SCWIN 7 2 3 9 Enable Creation of Custom Sensor Files This setting is accessed from the Options menu item of the Tools menu It allows the user to create custom sensor file...

Page 239: ...t Cut s Online Help for additional information on changes that can be made By default custom sensor files will be created in C CampbellSci SCWin SENSORS which is a different location than that of Shor...

Page 240: ...vailable in the Instruction Panel by clicking the drop down arrow to the right of the text box above the list This will allow you to display only instructions of a specific type such as Measurement or...

Page 241: ...ariables that have been defined in the program A sample list is shown below The variable list is sorted by variable type and then alphabetically by name In the list above the first green A denotes tha...

Page 242: ...ox 7 3 2 2 Right Click Functionality The result of a right click action varies depending upon your cursor location Right click an instruction name to show the Parameter dialog box to edit the instruct...

Page 243: ...ct a program file to open File extension filters are provided to list only files of a certain type such as cr5 files for CR5000 programs Data files dat can also be opened Save Saves any changes to the...

Page 244: ...a text string to search for and a text string to replace it with You can replace all occurrences of the text or check them one at a time to make sure they should be replaced Find Next Finds the next...

Page 245: ...number and that line will be highlighted in the program editing window To move the highlight to the next error in the program press the Next Error button or choose Next Error from the Compile menu To...

Page 246: ...button on the toolbar When a file is sent to the datalogger using Compile Save and Send and the software is not actively connected to the datalogger the software connects to the datalogger sends the...

Page 247: ...tables Neither of these options affects existing data files on a card if one is being used If a data table exists on the card that has the same name as one being output with the new program the messag...

Page 248: ...gram will be run if the datalogger loses power and then powers back up Run Always Run Now and Run On Power up can both be selected This sets the program s file attribute in the datalogger as Run Alway...

Page 249: ...ax If Else ElseIf statements or constant customization See conditional compilation in the CRBasic Editor s online help for more information on conditional compile syntax See Section 7 3 3 9 2 Constant...

Page 250: ...Preferences menu item You can then navigate from bookmark to bookmark by selecting Previous or Next All bookmarks can be removed from the program by selecting Clear Bookmarks Bookmarks are persistent...

Page 251: ...to as a library file The file can then be reused by inserting it into another CRBasic program Insert File Inserts a library file CRB into the current program at the location of the cursor 7 3 3 8 CRB...

Page 252: ...an control whether blank lines are inserted before or after certain instructions and how the CRBasic Editor will process multiple blank lines in the program If Do Not Insert or Remove Any Blank Lines...

Page 253: ...ote that if special formatting font style color is assigned to Matched Parentheses when your cursor is on an opening or closing parenthesis it will be highlighted with the formatting and the other hal...

Page 254: ...ew or Hide the instruction panel which displays a list of available instructions which can be used in your datalogger program based on the pre defined instruction filter selected with the drop down se...

Page 255: ...tion This will insert two comments into the program Start of Constants Customization Section End of Constants Customization Section Within these two comments define the constants Following each consta...

Page 256: ...ng program code Start of Constants Customization Section Const SInterval 10 Min 5 Max 60 Inc 5 Const SUnits sec value sec value min Const Reps 1 Const Number 0 Min 100 Max 100 Const TableName OneSec v...

Page 257: ...ion s you want to associate and press the Associate Files button Show Keyboard Shortcuts This option displays a list of the functions of the CRBasic Editor which are accessible via the keyboard The li...

Page 258: ...bles data tables and subroutines be declared before they can be used The best way to do this is to put all the variable declarations and output table definitions at the beginning followed by the subro...

Page 259: ...iewed in display software Variables declared using Dim cannot be viewed Variables assigned to a fixed value are used as constants For example in a CRBasic program there may be multiple temperature or...

Page 260: ...he measurement hardware to make a measurement and place the results in a variable or a variable array Output processing instructions are procedures that store the results of measurements or calculated...

Page 261: ...the program at a later date you will know what each section of code does Comments can be inserted into the program by preceding the text with a single quote When the program is compiled the datalogge...

Page 262: ...ucture in the datalogger in order to optimize the time and space required Data are stored in tables such as TOA5 StnName Temp TIMESTAMP RECORD RefTemp_Avg TC_Avg 1 TC_Avg 2 TC_Avg 3 TC_Avg 4 TC_Avg 5...

Page 263: ...ify a fixed number or enter 1 to have the datalogger auto allocate the number of records The example creates a table name Temp outputs any time other conditions are met and retains 2000 records in RAM...

Page 264: ...the result in TABLE 7 1 and a disable variable that allows excluding readings from the average if conditions are not met A reading will not be included in the average if the disable variable is not e...

Page 265: ...onal ways to represent numbers in a program scientific notation binary and hexadecimal TABLE 7 2 TABLE 7 2 Formats for Entering Numbers in CRBasic Format Example Value Standard 6 832 6 832 Scientific...

Page 266: ...ssion Evaluation The datalogger s expression evaluator evaluates an expression and returns a number A conditional statement uses the number to decide which way to branch The conditional statement is f...

Page 267: ...Variable or Expression Constant Variable Array or Expression Name Name or list of Names Variable or Expression Variable Array or Expression TABLE 7 4 lists the maximum length and allowed characters f...

Page 268: ...fset but use the same for each repetition For instance in the above example if Mult 2 and Offset 2 were used the instruction would use 0 115 and 0 234 for the Multiplier and Offset respectively for ea...

Page 269: ...top table is full or a ring mode table has begun overwriting its oldest data 0 if the data table is not full begun overwriting oldest data TableName TableSize the size allocation in number of records...

Page 270: ...ted results when downloaded NOTE 7 4 1 4 Input Location Labels Though the datalogger uses a number to address input locations Edlog allows you to assign labels to these locations for ease of use when...

Page 271: ...tion for temperatures in degrees Celsius TempF TempC 1 8 32 7 4 2 Creating a New Edlog Program To create a new datalogger program choose File New from the Edlog menu and select the datalogger type fro...

Page 272: ...dataloggers using P84 to store output data NOTE When the program is complete select File Save from the Edlog menu A standard file dialog box will appear in which to type a file name Edlog supports lon...

Page 273: ...how the execution times for each instruction block e g subroutine and program table as well as the estimated number of final storage locations used per day The execution times are estimates PTI files...

Page 274: ...ft Insert on the keyboard Right click a blank line and select Insert Instruction from the pop up menu Type the instruction number onto a blank line and press enter The first three options will open th...

Page 275: ...s displayed immediately after an invalid input or potentially invalid input has been entered for an instruction s parameter The warning lists the valid inputs A valid input must be entered before adva...

Page 276: ...esult label must be to the left of the expression Expressions can have both fixed numbers and Input Location labels Input Locations can only be referenced by their label each number in an expression i...

Page 277: ...egrees ARCSIN arcsine angle in degrees ARCCOS arccosine angle in degrees ARCCOT arccotangent angle in degrees SQRT square root LN natural logarithm EXP exponent of e EXP 2 e2 RCP reciprocal RCP 4 1 4...

Page 278: ...c TempC 5 1 Mult 6 0 Offset the following expression converts TempC to a temperature in degrees Fahrenheit TempF TempC 1 8 32 When this program is compiled the DLD file contains the following instruct...

Page 279: ...ame expected is displayed when a program contains any of these expressions 5 el Vee en lambda COS theta 10 zee 2 bee These are correct ways of entering the above expressions five el Vee en lambda COS...

Page 280: ...or between two sets of parentheses For Example This error message is displayed when a program contains any of these expressions zee label1 label2 ex 5 ARCTAN data eee em see 2 These are correct ways o...

Page 281: ...sion that contains no equal sign causes compiler error 202 unrecognized text For Example Equal sign expected is displayed when a program contains any of these expressions zee 2 bee data number volt1 v...

Page 282: ...Field or Create New Line Shift Ins Select an Instruction from a Dialog Box Ctrl Right Arrow Move Instruction 1 Tab Right Cursor on Parameter Ctrl Left Arrow Move Instruction 1 Tab left Cursor on Param...

Page 283: ...ll catch many of these errors however this may be at the expense of much time and confusion 7 4 3 Library Files Library files can be created to store portions of programs which can then be inserted in...

Page 284: ...ed menu items in Edlog The toolbar is made visible by choosing Options Show Toolbar from the Edlog menu Conversely it is removed from the screen by choosing Options Hide Toolbar Toolbar Open a new fil...

Page 285: ...gram flow Indention is a visual aid it has no meaning to the datalogger If the programmer chooses to use indention it can be done automatically or manually The settings for indention are found under O...

Page 286: ...umber instead of the label use the mouse or press ctrl left arrow 7 4 8 Repetitions Many input output and output processing instructions have a repetitions parameter Repetitions REPS allow one program...

Page 287: ...e The first time it will sample the value stored in the TempC location The second time it will sample the value stored in the BatteryV location If an Input Location is inserted between the TempC and B...

Page 288: ...or marked as Manual Optimize tries to reduce the total number of locations used by moving existing Input Location labels to fill in unused locations This might change several Input Location numbers An...

Page 289: ...ons are used in a program the Toggle Manual feature can be used to manually mark Input Locations for use by the program 7 4 11 Final Storage Labels When output processing instructions are added to the...

Page 290: ...ll be stored Output Instruction lists the output instruction that was used to store the data value Line Number is the line number in the Edlog program for the output instruction Final Storage Label is...

Page 291: ...s will take affect These settings are accessed using Edlog s Options menu 7 4 13 Program Security Setting security in the datalogger allows you to restrict access to certain functions which helps ensu...

Page 292: ...ile 7 4 15 1 Mixed array Dataloggers Mixed array dataloggers can store the labels for input locations and final storage output in the DLD file LoggerNet uses this information on the Monitor Values dis...

Page 293: ...e values that were stored in the input locations before you turned the datalogger off to be included in the sample average and total when you turn the datalogger back on Intermediate Storage Allows da...

Page 294: ...the datalogger can communicate with directly i e without going through another router Maximum number of routers Enter the number in the PakBus network including the PC While it is possible to calcula...

Page 295: ...rs with PakBus addresses 1 2 3 4 and 5 as neighbors to the current datalogger This option is the same as the datalogger s D19 mode 7 4 18 4 Allocate General Purpose File Memory PakBus dataloggers have...

Page 296: ...0 or CR3000 program that will be created is the name of the original program with a CR extension This can be changed if desired by typing in a new path and or file name directly or by pressing the Bro...

Page 297: ...fferent name choose File Program File Save As If an Edlog file previously has been opened in the Transformer when the file is opened a second time you will receive a message This file filename already...

Page 298: ...Section 7 Creating and Editing Datalogger Programs 7 80...

Page 299: ...prior to analyzing it on your computer CardConvert is a utility used to retrieve binary data from a compact flash or PCMCIA card convert it to an ASCII or binary file and save it to disk 8 1 View Pro...

Page 300: ...file windows so that the title bar of each window is visible Windows cascade down and to the right starting from the upper left corner Tile Vertically Rearranges all open non minimized data file windo...

Page 301: ...iew Pro program This is a toggle button The butto have a green check mark through it whe option is currently selected Reset Grid for New Selections If no graphs are open this button will clear all sel...

Page 302: ...that is not a data file DLD CSI PTI FSL LOG CRX select File Open As Text from the menu Files opened in this mode cannot be graphed A file opened in this mode can be viewed only in its original format...

Page 303: ...orts SQL Server Compact SQL Server and MySQL databases The information to enter changes depending on the database type as described below SQL Server Compact SQL Server Compact is an embedded database...

Page 304: ...bo box because the desired server might not be published Windows Authentication or SQL Server Authentication can be selected Windows Authentication does not require a username and password but rather...

Page 305: ...y will be set to blank in the connection string It has been found that when set to blank the login id and password configured in the system data source are used You can select the default database def...

Page 306: ...ss the Change Database button 8 1 5 Importing a CSV File The File Import CSV menu item can be used to import A CSV Comma Separated Value file into View Pro When you select the File Import CSV menu ite...

Page 307: ...ters exist in the data If View Pro is able to derive the timestamp the Has Date Time Column check box will be checked and the derived timestamp format will be displayed in the Derived Date Time Format...

Page 308: ...es Sun dddd Day using long day names Sunday h Hour with no leading 0 s hh Hour as 2 digits n Minute with no leading 0 s nn Minute as 2 digits s Seconds with no leading 0 s ss Seconds as 2 digits z Mil...

Page 309: ...an array based datalogger you will be given the option of loading an FSL Final Storage Label file The FSL file will be used to provide column headings The FSL file is created when a datalogger progra...

Page 310: ...ext to the item when it is active Deactivate it by selecting it again 8 1 6 3 Locking the TimeStamp Column Selecting View Lock TimeStamp Column will lock the timestamp column on the left of the data f...

Page 311: ...is appropriate for the opened data file For instance if there is no data appropriate for an FFT the FFT button will be disabled on the View Pro toolbar Multiple instances of each type of graph can be...

Page 312: ...Undo Zoom button on the toolbar For a Rainflow Histogram or for a Histogram or FFT in 3D View you can also zoom in and out by using the Page Down and Page Up buttons on your keyboard Rotation For a R...

Page 313: ...ltiple columns can be added by holding the Ctrl key and dragging the mouse pointer over the column headings A partial column can be added by dragging the mouse pointer over the desired values Note tha...

Page 314: ...me and choosing Delete Selection by left clicking on the column heading in the data panel or by right clicking on the column in the data panel and choosing Clear Selection 8 1 7 1 2 Graph Width The Gr...

Page 315: ...eviation Minimum and Maximum Note that these statistics are for the data displayed in the graph They are not statistics for the entire column s of data Note that an asterisk next to a statistics value...

Page 316: ...u can click and drag the cursor across the graph Data values at the current cursor position will be shown in the table Show Hide Gradient A toggle button that turns on and off the gradient background...

Page 317: ...s the graph to its original state after zooming 8 1 7 2 Histogram From the Histogram screen you can view histogram data The Histogram button on the toolbar will be enabled if there is at least one val...

Page 318: ...in the list on the left side of the Histogram screen Additional histogram records can be added by pressing the New button These additional records can be from either the same histogram or a different...

Page 319: ...m type to Area Histogram Line or Bar You can use the arrow buttons to the right of Record to scroll through records of the Histogram You can also determine whether the Histogram is viewed in 2D or 3D...

Page 320: ...ram Modify Selection Brings up the Histogram Setup dialog box from which you can change the options for the selection Undo Zoom Returns the Histogram to its original state after zooming 8 1 7 3 XY Plo...

Page 321: ...XY Plot graphic on the Windows clipboard It can then be pasted into other applications Print Prints the XY Plot Print options can be set before printing begins Export Allows the XY Plot to be exported...

Page 322: ...s a 3D representation based on the rainflow counting algorithm of Endo and Matsuishi which was first published in 1968 These diagrams can be used to monitor fatigue levels of structures under stress s...

Page 323: ...can also be opened from a button on the Rainflow Histogram toolbar This allows you to change the options for the rainflow histogram record that is selected in the list on the left side of the Rainflow...

Page 324: ...Records from a Rainflow Histogram Display A Rainflow Histogram can be deleted from a graph by selecting it in the list of values being graphed on the left side of the graph window and then pressing t...

Page 325: ...ction Undo Zoom Returns the Rainflow Histogram to its original state after zooming 8 1 7 5 FFT From the FFT screen you can view FFT data The FFT button on the toolbar will be enabled if there is at le...

Page 326: ...lected in the list on the left side of the FFT screen Additional FFT records can be added by pressing the New button These additional records can be from either the same FFT or a different FFT in your...

Page 327: ...t the FFT type to Area Histogram Line or Bar You can use the arrow buttons to the right of Record to scroll through records of the FFT You can also determine whether the FFT is viewed in 2D or 3D Sele...

Page 328: ...m which you can change the options for the selection Undo Zoom Returns the FFT to its original state after zooming 8 1 8 Right click Menus Right clicking in View Pro will bring up a short cut menu The...

Page 329: ...clears the selection with focus This is the selection that has the dashed box around it Left or right click on a selection to give it focus Format Columns This option allows you to format a column in...

Page 330: ...Copy to Clipboard to place the graph on the clipboard Print to print the graph or Options to bring up the graph s Options dialog box 8 1 8 3 Traces Right clicking on a trace name in the list on the r...

Page 331: ...a menu from which you can select Print 8 1 10 View Pro Online Help View Pro has an online help system that can be accessed by choosing Help View Pro from the toolbar Once the help file is opened press...

Page 332: ...aw A D data such as the results of a burst measurement Split can be used to convert a file of one format to a different format For example a Table Oriented ASCII file can be converted to the Comma Sep...

Page 333: ...Section 8 Working with Data Files on the PC When Edlog compiled Birch dld it also created the Final Storage Label file Birch fsl that lists the final storage locations for each data element 8 35...

Page 334: ...ta File can be typed in or the Browse button can be used to select from available files In this example BirchCreek dat will be selected as the input data file Selecting the data to copy is simplified...

Page 335: ...File Label window so click array 60 To paste the desired values from this array into the Select box select the field names while holding down the ctrl key All of the values could be selected by clicki...

Page 336: ...t will run and display results but no output file will be created Click the OUTPUT FILE tab Type in hourly for the name of the output file By default Split will use the file extension PRN creating the...

Page 337: ...ame editing technique For table based data files the timestamp is normally the first column and is a quoted text string 2002 02 26 10 30 00 To display these timestamps in the output you will need to c...

Page 338: ...ogger files are stored in TOA5 a comma separated format with headers Split can process Input files from other software but they must be formatted in Comma Separated ASCII Final Storage Binary Format F...

Page 339: ...1400 92 7 67 7 15 15 220 1 115 189 1500 94 1 69 20 35 260 6 FIELD FORMATTED 115 189 1200 89 6 55 3 25 36 270 115 189 1300 91 3 61 5 27 25 255 4 115 189 1400 92 7 67 7 15 15 220 1 115 189 1500 94 1 69...

Page 340: ...ces Split automatically recognizes the type of data file it is reading when using Auto Detect in the File Info field However there are two exceptions for which you should choose the appropriate option...

Page 341: ...newly appended data or Split will never begin execution CAUTION Because Last Count keeps track of the number of bytes in the file if you delete data from the beginning of a file Last Count will not w...

Page 342: ...ytes of data before it begins processing the data in Input File Align Array When using a specific start offset the number of bytes specified may cause Split to seek to the middle of a row Selecting th...

Page 343: ...enter the number of channels for the Break Arrays value Output File Tab Other button Midnight is 2400 hours When programming mixed array dataloggers the Real Time instruction P77 has two different op...

Page 344: ...rray vali the value of that element For example the data in TABLE 8 1 contains seven elements per Output Array representing hourly data Assume that this data file contains one month of hourly data To...

Page 345: ...cause the maximum number of allowable and statements has been exceeded A range can be specified for vali by putting between the lower and upper limit For example 2 189 and7 200 275 In this example two...

Page 346: ...begin reading on data output at 1000 hours and 05 seconds on day 27 Split can also begin processing a file on a particular month and day Use the syntax E Month Day where E is the element that contain...

Page 347: ...tion Formatting Event Tests Containing Conditional Output Arrays The C option is used to combine data from two or more conditional arrays onto one Split output line A conditional array is one that is...

Page 348: ...u would for any Split process If you are including column headings the arrays and elements will appear in the order they are listed on the Input File tabs That is the first column will be Input File n...

Page 349: ...TABLE 8 3 Each line of data represents one test Notice that blanks were inserted if the data set conditional array did not exist 8 2 3 1 4 2 Trigger on Stop Condition F Option Output of Time Series T...

Page 350: ...nd blanks are output for data selected from the other Input Files Say for example that you were interested in the average value of the first data point element 2 for each test in the data set listed i...

Page 351: ...ons are used to separate each portion The format is 1 year 1 day 1 hhmm 1 seconds the number 1 was used since typically the timestamp is the first element in the data string In this format hhmm is the...

Page 352: ...ns defined bad values displayed in red and preceded by asterisk the text bad data highlighted in a red box at bottom right of screen blanks inserted for bad values bad values preceded by asterisk Repo...

Page 353: ...able statement as with all parameters in the Select line Once the variables have been declared they can be used later in the Select line i e x 4 5 6 3 0 y 6 3 2 3 6 7 7 x 6 y Variables can be defined...

Page 354: ...lement 5 3 5 subtract element 5 from element 3 3 9 5 8 7 10 same as 3 8 9 7 5 10 3 2 0 multiply element 3 by a fixed number 2 2 3 0 raise element 2 to the third power MATH FUNCTIONS Abs x Absolute val...

Page 355: ...ower of element x Example Exp 4 00037 Frac x returns the fractional value of the element x Examples Frac 4 89 Frac 6 7 95 Int x returns the integer portion of the element x Examples Int 7 270 Int 5 6...

Page 356: ...Details and Examples TABLE 8 7 Time Series Functions TIME SERIES FUNCTIONS Avg x n Average Blanks x n Number of blanks in element Count x n Number of data points in element Max x n Maximum Min x n Mi...

Page 357: ...ough 4 each time an array was output and an average value for element 4 would be calculated every 24th array and output as an additional column in the file An additional summary would occur for an Int...

Page 358: ...2 322 3 4 609 178 800 58 12 23 98 6 588 315 6 9 43 178 900 59 79 23 46 5 458 312 15 32 178 1000 61 09 24 12 4 622 299 3 18 3 178 1100 61 34 25 03 5 926 303 17 26 178 1200 60 61 27 46 6 815 309 7 18 71...

Page 359: ...minimum value of element x over a full data set or every nth value Examples Min 7 4 23 min std dev of WS for day Min 3 8 55 33 min temp for 8 hours 59 79 min temp for 8 hours 55 22 min temp for 8 hour...

Page 360: ...nd samples element y when the minimum is found If an nth value is specified then it outputs the sample on a minimum every nth value otherwise it outputs the sample on a minimum at the end of file Exam...

Page 361: ...e WDQ n Outputs the wind direction using an alphabetical abbreviation based on 8 quadrants WDQS n Outputs the wind direction using an alphabetical abbreviation based on 16 quadrants The Mt Logan data...

Page 362: ...characters A maximum of thirty 30 labels are allowed per Select line Make sure that the column widths are big enough for the label to fit Otherwise the output will indicate Bad Data Examples Max Temp...

Page 363: ...ining wind direction For example if n 111 ESE would be returned in the output file Date format S H D Y Converts a datalogger s time stamp to a different format and encloses it in double quotes edate w...

Page 364: ...version will not fit in the specified column width The on screen display and the report file will precede the date with asterisks In the PRN output file Split uses the Bad Data string NOTE When Date a...

Page 365: ...ime series data by using Date for the interval in the time series function This will trigger time series output for the first day of each month The syntax is avg 7 date 3 2 where you want to take a mo...

Page 366: ...g is a parameter file that operates on the Mt Logan data with several of the Split features being utilized This first screen shows the input file and the select criteria that were programmed This exam...

Page 367: ...h Kcal m 2 hr 1 wind chill index v wind speed in meters second T temperature in degrees C Note that at wind speeds between 0 to 4 mph 0 to 1 8 m s the wind chill should be ignored because this formul...

Page 368: ...186 59 335 15 467 5 2791 493 51 10 635 51 142 13 439 6 9821 584 71 6 5016 43 703 13 044 7 6526 607 86 5 4526 41 815 12 9 5 3014 566 29 7 3368 45 206 Reference 1 Wind Chill Errors Edwin Kessler Bulleti...

Page 369: ...the interval Sample on maximum and sample on minimum require two elements or expressions also separated by a semicolon 8 2 3 1 15 Time Synchronization The time synchronize function is useful when dat...

Page 370: ...fied without specifying a starting time e g 2 3 If you are working with only one file Split will begin processing that file at the first record in the file If any gap in the data is found blank data o...

Page 371: ...he comment entered in the Replace bad data with field is output to the Output File See TABLE 8 5 8 2 3 1 15 2 Using Time Synchronization While Starting Relative to PC Time Split tries to time sync fil...

Page 372: ...will not be overwritten the new data will be added to the end of the existing file However the RPT and HTM files will be overwritten If Create New is selected Split will create all new files using the...

Page 373: ...the Regional Settings for Numbers the decimal symbol uses the character specified in the Decimal Symbol field the separator uses the character specified in the List Separator field These settings are...

Page 374: ...ile or printer There are three report options File Printer HTML One or more can be selected A report sent to a file has the extension of RPT If the report is sent to a printer the printer must be on l...

Page 375: ...included in the Time Series processing if it satisfies the Copy line If the Trigger on Stop Condition is selected a Time Series output will occur each time the Stop Condition is met Start Stop On Afte...

Page 376: ...ntaining more than 26 arrays several passes are required Change the Output file name and Start Condition for each pass Split may then be used to merge the multiple files No FF Suppresses form feeds an...

Page 377: ...r Julian Day Hour Minute Date Function Data Data 10 2002 151 2200 05 31 02 22 00 1 701 193 6 10 2002 151 2300 05 31 02 23 00 1 476 31 99 10 2002 151 2400 05 31 02 00 00 1 123 106 2 Caution should be u...

Page 378: ...e labeled by entering a title into the Time Series Heading field at the bottom of the Output File page Time Series interval summaries cannot be assigned individual titles directly but you can use spec...

Page 379: ...ss the R switch is used The syntax for this switch is SPLITR LOGAN R where LOGAN is the parameter file name The R switch should follow immediately after the parameter file name with no space between t...

Page 380: ...ly one copy of Splitr can be active at any one time unless the M switch is used However if other commands are used along with Splitr such as opening the file in a spreadsheet copying it to an archive...

Page 381: ...e input and output file names must be used In addition if long file names are used in the path you may need to surround the path and file name by double quotes NOTE Output File Options These switches...

Page 382: ...option for the File Format 2 Outputs the data using the Regional Settings of your Windows operating system for the decimal indicator and data value separator This is the same as choosing the Custom op...

Page 383: ...x that is found under the Other button of the Output File tab Bnnn Breaks a long array into multiple lines where nnn is the number of values to place on each line This is the same as choosing the Brea...

Page 384: ...uts the results to TEST PRN then executes the SINKS PAR file on TEST1 DAT and outputs the results to TEST2 DAT Execution of SINKS PAR starts when the first element in TEST1 DAT is 189 8 2 7 Log Files...

Page 385: ...MyData stored in TOA5 format would be TOA5_MyData dat The destination directory or filename for a converted file can be changed on an individual file basis Click on the row for the file that you wish...

Page 386: ...y a comma Selecting Year will output the year represented by four digits YYYY e g 2006 The Day will be represented as a Julian Day The Hour Minutes will be represented by four digits hhmm When Midnigh...

Page 387: ...e used as a reference for the file interval Processing always starts at the beginning of the file When Use Filemarks Use Removemarks or Use Time is selected the Create New Filenames option is disabled...

Page 388: ...entage of the conversion completed will be displayed at the bottom edge of the window Note that the values reflect an estimate of the amount of data in a table If the table is set to a fixed size Card...

Page 389: ...d of the data file during the repair process the end of valid frames it will stop and display a message The message prompts the user either to continue searching the file for more good data frames or...

Page 390: ...un CardConvert using the settings contained in myfile ccf If there are no problems or questions encountered CardConvert will start convert the file s and then exit with no user interaction However if...

Page 391: ...Task Master cannot interact with the desktop Therefore any tasks set up in the Task Master should not require any user interaction 9 1 Task Master The Task Master sets up and manages the optional user...

Page 392: ...will execute the specified action following the completion of the parent task Multiple tasks linked to a datalogger will execute based on the conditions specified for the start of the task This allow...

Page 393: ...scribed above 9 1 1 2 Logger Event Tasks There are 13 data collection events that can be selected to trigger a task linked to a datalogger Clicking the drop down list button to the right of Station Ev...

Page 394: ...he task will run after LoggerNet has processed the datalogger call back After Failed Retry The task is run whenever a retry fails This can be the failure of a primary retry or a secondary retry After...

Page 395: ...peated at a specified interval or based on the calendar 9 1 1 3 1 Interval Tasks The Base Date and Time are used to set the initial date and time for the task execution The interval specifies the time...

Page 396: ...To execute a task on the first day of every month at 8 00 a m set the Hours of the Day to 8 the Minutes of the Hour to 00 the Days of the Month to 1 and leave the other settings blank To execute a ta...

Page 397: ...Day to 00 the Minutes of the Hour to 00 the Days of the Month to 5 the Months to 1 January 4 April 7 July 10 October and leave the other settings blank After specifying the desired schedule press the...

Page 398: ...xecute File Select this check box to execute a file or command when a task event is triggered Use the browse button to the right of the File Name field to select the file or type in the name and path...

Page 399: ...tup Screen for the datalogger Use the drop down list box to select the station that will be called FTP Settings This check box is only available when configuring an Add After task with the Station Eve...

Page 400: ...led The format of the new file name is ftplog_YYMMDDhhmm txt The Task Master will maintain up to five log files At that point the oldest one will be deleted each time a new one is written It is not id...

Page 401: ...hown below server server_address port e g LocalHost 6700 or 192 168 7 123 6700 The files contained in the backup will be based on a saved backup configuration file To save a backup configuration choos...

Page 402: ...Section 9 Automating Tasks with Task Master 9 12...

Page 403: ...gger the task It is only applicable to Add After tasks The event types are listed above Station Event Types Event Trigger For a Scheduled Interval task the schedule for the task will be listed in the...

Page 404: ...oll Finished The last time that polling of the specified station was finished Last Poll Outcome The outcome of the last poll This can have one of the following values Not Polled Success Security Failu...

Page 405: ...elect the LoggerNet server to which the Task master should connect You also specify the username and password to be used For remote administration of the Task Master the following conditions must be m...

Page 406: ...Section 9 Automating Tasks with Task Master 9 16...

Page 407: ...atalogger support software such as LoggerNet or PC400 Some key features of DevConfig include To keep the process as simple as possible DevConfig supports only serial and IP connections between the PC...

Page 408: ...a dialog that searches your local area network for any available devices If the device has a TCP Password you will need to enter it in the TCP Password field You ll be offered a choice of baud rates...

Page 409: ...stems An example for the CR1000 is shown below The text at right describes any interface devices or cabling required to connect the PC to the device Screens for other devices vary only in the text on...

Page 410: ...ll appear similar to the one shown below The information in the dialog helps to corroborate the signature of the operating system sent For devices such as the CR10X especially those with extended memo...

Page 411: ...operators manuals using the keyboard display or a terminal emulator Another example is that the status table in mixed array dataloggers B can also be accessed via an S command in terminal mode This st...

Page 412: ...arious protocols will be attempted again When DevConfig recognizes the response from the device and the device type is one of the supported types that device type will automatically be selected 10 1 6...

Page 413: ...ritten to the standard output device A command is defined as the text up to a semicolon The semicolon tells CoraScript that the command is complete and ready to execute The flexibility of the commands...

Page 414: ...l marks the end of the command This command would normally appear on one line as follows connect localhost name bilbo password baggins For a more detailed explanation of the interpretation of the symb...

Page 415: ...mage By default the data cache will not be saved so it may be a good idea to include at least this option if your intent is to fully restore LoggerNet to the exact state it was in when the backup was...

Page 416: ...ck check and set 10 3 RWIS Administrator 10 3 1 Overview The RWIS Administrator is a LoggerNet client that provides support for communication with RWIS Road Weather Information Systems weather station...

Page 417: ...current focus Apply This button becomes enabled when changes have been made to settings for the selected station Clicking on this button will send the changed settings to the LoggerNet server Cancel L...

Page 418: ...on this panel include the following Host IP Address Enter the IP address for the station This setting must match that used by the physical device in order for LoggerNet to be able to successfully com...

Page 419: ...oggerNet server will use when downloading snapshots from the RWIS station In most cases the default value of 21 should be adequate FTP Passive Specify whether active or passive mode should be used for...

Page 420: ...d be made using the Primary Retries Interval Once the number of primary retries is exhausted data collection will be attempted on the Secondary Retries Interval if it is enabled Otherwise data collect...

Page 421: ...red in a binary format Though this format saves disk storage space it must be converted before it is usable in other programs CSIXML Data is stored in XML format with Campbell Scientific defined eleme...

Page 422: ...ox specifies both the number of snapshots to collect as well as the source FTP path for each snapshot A snapshot cannot be collected from an NCTIP ESS version 1 station unless the path to the source i...

Page 423: ...ime when the clock is set LoggerNet Data Time Displays the date and time for the computer on which the LoggerNet server is running This value will be displayed updated only when the Check button is pr...

Page 424: ...ables has an associated collect area The grouping of variables as well as the order in which they are declared is derived from the variables that are defined as blocks in NTCIP ESS version 2 The table...

Page 425: ...nt dimension the current table will be deleted and a new table created in its place Refer to the online help to see the variables defined for each table 10 4 File Format Convert File Format Convert is...

Page 426: ...engths to a fixed length the length is assigned to 64 If the string is longer than this it is truncated Converting a File Press the Open button to browse to a file to be converted After a file is sele...

Page 427: ...ble If this option is selected the Julian day day of year will be used in the suffix instead of the month and day of the month Create New Filenames When the Create New Filenames option is selected Fil...

Page 428: ...and Interval and start time for baling based on time 10 5 Toa_to_tob1 This utility is used to convert TOA5 ASCII Table Data files to TOB1 Binary Table Data format By default it is located in C Progra...

Page 429: ...e run as a service is discussed in the installation notes Section 2 Installation Operation and Backup Procedures The LN Server Monitor which monitors the status of a remote LoggerNet server or a Logge...

Page 430: ...r rights can be set up if desired Only users with Full Administrator rights can open and make changes in the Security Manager regardless of whether or not security is enabled Once the security account...

Page 431: ...r Full Administrator The user has full access rights in all LoggerNet clients including the Security Manager If an option in the LoggerNet user interface is not applicable for the security level of th...

Page 432: ...Comm Test X X X X Modify Statistics Viewed X X X X X Add Modify View X X X X X Pause scheduled collection X X Collect Data X X X X PakBus Graph View Networks X X X X X Retrieve network settings X X X...

Page 433: ...1 3 Resetting Security There is a way to remove all security settings from the server in the event that administrative account information is lost and you are unable to open the Security Manager to en...

Page 434: ...Hole Monitor Utility s main window You can monitor hole collection for all stations by enabling the Select All Stations check box above this list or you can monitor a subset of these stations by clea...

Page 435: ...nd the range for the collectable hole will be adjusted The informational record for a lost hole will be displayed for approximately fifteen seconds and then deleted Begin The beginning record for the...

Page 436: ...llection in LoggerNet can be performed manually by a user or automatically by setting up a data collection schedule For information on collecting data from a datalogger refer to Section 5 Real Time To...

Page 437: ...iler All the Data Retrieves all records from the selected tables Data Since Last Collection Retrieves all uncollected records from the selected tables Newest Number of Records Retrieves a specific num...

Page 438: ...tored in a comma separated format No header information is included in the file Starting Record Information The Starting Record Information is applicable if the Collect Mode is Newest Number of Record...

Page 439: ...tions list you can press the View Data Info button to display a Data Information table that indicates the number of records and range of record numbers in the LoggerNet data cache for each table in th...

Page 440: ...t at 0 After a short while as the new records were put into the data cache and old ones overwritten the earliest record in the data cache might be 251 while the newest record number might be 50 In the...

Page 441: ...le is encountered If Wait for Any Holes is selected Data Export will wait until data holes are filled or become uncollectible before exporting the next record Thus the utility attempts to export data...

Page 442: ...t application acts as a server for the custom data retrieval client The most typical use for the Data Export functionality is a situation where the customer has a database or file system that is alrea...

Page 443: ...ord sent depends on the Data Export option settings When the data retrieval client receives the record it must parse the data and return the acknowledgment message to the Data Export The acknowledgmen...

Page 444: ...s that use the format provided by the RTMS socket export Standard format this format provides an easily interpreted data string containing the data along with format information for each data field De...

Page 445: ...custom data retrieval client application Client State Diagram Key Word Description Test For Server Rdy With Socket APIs usually there will be a function used to open the socket In this state the clien...

Page 446: ...vent after the record is secured In Send Ack the client forms an acknowledgment record from information taken from the data record and sends it to the server Stop It is important to note that the Stop...

Page 447: ...II record could come out to be a little longer than 25K characters Typical datalogger programming will produce record sizes of about 150 characters It would not be unusual to see records that contain...

Page 448: ...r String TimeStamp Year Month Day Hour Minute Second Year 4 Digit Month 2 Digit Day 2 Digit Hour 2 Digit Minute 2 Digit Second 2 Digit Digit RecordNumber 10 Digit Number Digit Digit String Character A...

Page 449: ...imeStamp year month day hour minute second RecNo digit digit Year 4 digit Month 2 digit 0 month 12 day 2 digit 0 day 31 hour 2 digit 0 hour 60 minute 2 digit 0 minute 60 second 2 digit digit 0 0 secon...

Page 450: ...Section 11 Utilities Installed with LoggerNet Admin and LoggerNet Remote 11 22...

Page 451: ...s from a remote computer is not possible Remote Connections is enabled from the LoggerNet Toolbar s Tools Options menu item Select the Allow Remote Connections check box to allow remote connections Co...

Page 452: ...to easily move data from a LoggerNet data cache into a database such as Microsoft SQL Server or MySQL The two main components of LNDB are LNDB Manager and LNDB Engine LNDB Manager is used to set up a...

Page 453: ...gement software in an OPC format to other applications The CSIOPC Server supports OPC Data Access Specification 2 05a The CSIOPC Server is not covered in this manual The CSIOPC Server comes with a sep...

Page 454: ...Section 12 Optional Client Applications Available for LoggerNet 12 4...

Page 455: ...ime required between the computer and the RF base LoggerNet will make a call each time that it does data collection for a station It will stay on line until a response is received either the data or a...

Page 456: ...e communication between the devices Extra response time added to one or more of the devices may help to prevent the software from timing out Note that the extra response times added for each device ar...

Page 457: ...LoggerNet Setting up a datalogger at the RF base in a Phone to RF system requires that the datalogger be connected as a child of the remote phone modem and the RF Base be connected as a child of the...

Page 458: ...MD9 base modem must match for successful communications refer to your MD9 users manual for information on setting the hardware switches within the device In addition the address specified in Setup for...

Page 459: ...P IP network This allows the LoggerNet server computer to be located in a central area for administration while providing communications to remote RF networks 13 3 1 Setup The device map set up in the...

Page 460: ...lines need to be in place This special cable is needed to allow an RF base to work with the standard RS 232 Port on other Internet serial devices The drawing below depicts the cable needed Third Party...

Page 461: ...with the serial device attached to the COM port The RF base communicates at a baud rate of 9600 IP Port ID This specifies the port ID used by the serial server to direct serial communications This mu...

Page 462: ...Section 13 Implementing Advanced Communications Links 13 8...

Page 463: ...tioning correctly Sometimes the smallest thing a cable or a new PC utility program can cause widespread havoc If using TCP IP or cellular telephone communications check with the network administrator...

Page 464: ...ns that use sockets One situation that does cause problems is using the IPPorts to communicate with dataloggers where the socket is being opened and closed quickly For example if you have 20 stations...

Page 465: ...erating system cannot create any more socket connection See the text above about Maximum Number of Sockets Open 10058 Cannot send after socket shutdown A message was sent to a socket that has been clo...

Page 466: ...efinitions from the Setup Screen or the Connect Screen Network Paused indicates that data collection for the entire network has been suspended You will need to go to the Status Monitor and remove the...

Page 467: ...be 115 200 baud and LoggerNet simply opens the port For a phone modem the baud rate will be set to the value in the Setup Screen for that phone modem the COM port will be opened and the DTR line will...

Page 468: ...en Terminal will allow you to send ASCII characters to the phone modem This can also be used to test communications to the phone modem and the initialization strings used to set up and configure it Ge...

Page 469: ...followed by a series of beeps and tones followed by what sounds like white noise or scratching sounds and screeches When the modems connect you should see the word CONNECT appear on the screen perhap...

Page 470: ...e datalogger Pressing Enter for an array based logger should return an asterisk Typing A Enter should return the status line Type 7H 2718H for 21X or CR7X dataloggers to put the datalogger in remote k...

Page 471: ...al or omnidirectional and is designed for the frequency being used Most antennas will have labels identifying the frequency range Make sure the antenna is mounted for a clear line of sight and that di...

Page 472: ...square root ratio R Calculate the Voltage Standing Wave Ratio VSWR with the following equation VSWR 1 R 1 R Where R Wr Wf The impedance of the RF transmission cable usually RG 8A U and antenna combin...

Page 473: ...ators or attenuation pads You will need someone at each end of the radio link with a way to talk to each other If the carrier detect light is coming on at the RF base station radio but communication q...

Page 474: ...you are using a data radio that does not have a transmit button built in you can easily build a push to transmit button from the documentation of the radio RF modem interface connector There will be o...

Page 475: ...od in that direction The next sub link can now be tested Remember to place the attenuation pads at the receiving station only If all of the sub links were good the same sub links can be tested in the...

Page 476: ...re LoggerNet is running leave the default Server Host Address as localhost The Server Port number should also be 6789 The Logon Name and Logon Password are only used with versions of LoggerNet that su...

Page 477: ...data in the data cache At Time This option allows a selection of the starting position based on the timestamp in the data The time and date are set in the Begin Date field All of the records available...

Page 478: ...ing for holes to be filled Any data in holes will be skipped in the output Real Time the most recent data is always sent out starting with the last record stored This will not provide a complete data...

Page 479: ...d datalogger Remedy 3 Add PakBusPort Possible reason 4 No PakBus OS in datalogger Remedy 4 If you have two in range routers using neighbor filters in order for them to discover one another you must li...

Page 480: ...will take place Possible reason 4 A CR200 Series has just received an OS download resetting network address radio address hopping sequence and radio power mode to defaults Remedy 4 Configure CR205 se...

Page 481: ...s devices don t transfer data Possible reason The Master datalogger s D15 setting configures too few max nodes max neighbors and max routers Remedy Change Master D15 settings for max nodes max neighbo...

Page 482: ...Section 14 Troubleshooting Guide 14 20...

Page 483: ...atalogger B Batch Files An ACSII text file that contains one or more DOS commands or executable file commands When the batch file is run the commands in the file are executed sequentially Battery This...

Page 484: ...d between the computer s COM port and the datalogger Communication Server The software typically packaged as a DLL that provides the communications functions within other software such as PC200W PC400...

Page 485: ...the table The size of the table in number of records and when records are written to the data table are determined by the datalogger s Data Table Instruction P84 The fields columns of the table are d...

Page 486: ...scent mode This conserves battery power and creates predictable measurement intervals The execution interval is synchronized with the datalogger s real time clock Execution Time The time required to e...

Page 487: ...cted to the data cache The server tracks and collects these holes only if that option is enabled This entry in the status table shows the number of data points in missed records for the data storage t...

Page 488: ...in the datalogger network Log files are typically used for troubleshooting purposes LoggerNet has four types of log files Transaction Communications Status Object State and Low Level I O Refer to App...

Page 489: ...ata to Final Storage The output interval is defined by Instruction 84 in Edlog for table based dataloggers or the instructions that set the output flag high in mixed array dataloggers Output Processin...

Page 490: ...am The signature is a unique number derived from the size and format of the datalogger program PromID An entry in the status table that shows the version number of the datalogger PROM or OS PromSig An...

Page 491: ...r the DataTable declaration in CRBasic dataloggers The individual fields within each record are determined by the Output Processing instructions following the instruction that created the data table R...

Page 492: ...data Server Also communication server a software application that accepts connections from client applications and provides data or other information as requested The LoggerNet server manages all the...

Page 493: ...number of user created data tables See also Data Table Table based Dataloggers Table based dataloggers store each record of data that follows an output instruction in a table Each separate occurrence...

Page 494: ...uding variables to be used in Boolean form as high or low W Wiring Panel The set of terminals and underlying circuits that enable connections of sensors control and power supply wiring to the datalogg...

Page 495: ...es and binary files Data from table data dataloggers are output as ASCII table files with no header TOACI1 files TOA5 files TOB1 binary files Array Compatible CSV files or CSIXML files Data from PC ca...

Page 496: ...0 0000 12 0 0000 B 1 3 TOACI1 This file format was originally introduced to support data coming from table data dataloggers This format has the following features The file includes a header that cont...

Page 497: ...imum Time of Maximum Max TMx Minimum Minimum Time of Minimum Min TMn SampleMaxMin Sample at Maximum or Minimum SMM StdDev Standard Deviation Std Moment Moment MMT Sample Sample No Suffix Histogram His...

Page 498: ...mestamp is present it will be formatted with sub second resolution Data values are formatted as comma separated text suitable for importing into spreadsheet or database applications Each TOA5 file con...

Page 499: ...rovided in the program then an empty string placeholder is left in this line for that specific field Header line four describes the processing performed in the datalogger to produce the value for each...

Page 500: ...53 29 13 39 24 04 23 98 101 2009 105 1054 30 13 39 24 04 24 101 2009 105 1055 31 13 39 24 04 23 98 101 2009 105 1056 32 13 39 24 04 23 98 B 1 7 CSIXML CSIXML is an XML eXtensible Markup Language based...

Page 501: ...with the less than character followed by the name of the element If that element has attributes these will be expected to follow the element name with a name value syntax At least one white space cha...

Page 502: ...describe the general XML Schema see http www w3 org TR xmlschema 0 for details xsd schema xmlns xsd http www w3 org 2001 XMLSchema xsd element name csixml type csixmlType xsd complexType name csixmlTy...

Page 503: ...xsd complexType xsd simpleType name fieldDataType xsd restriction base xsd string xsd enumeration value xsd string xsd enumeration value xsd long xsd enumeration value xsd unsignedLong xsd enumeration...

Page 504: ...n xml lang en In order to make value elements easily addressable in transforms as well as describable in table specific XML Schema documents value element names will begin and end with a unique number...

Page 505: ...t may be omitted if the information is not available dld name Specifies the file name of the program that is running in the datalogger This element may be omitted if the information is not available d...

Page 506: ...logger program based upon the processing instruction used to output data into final storage B 1 7 3 2 The data Element This element marks the beginning of data storage in the file It will contain a co...

Page 507: ...type xsd float process Min field name AirTemp_TMn type xsd dateTime process TMn field name RH_Max type xsd float units process Max field name RH_TMx type xsd dateTime units process TMx field name RH_M...

Page 508: ...18 2006 08 16T17 28 53 v18 v19 11 86 v19 v20 2006 08 16T14 34 31 v20 v21 217 4 v21 v22 0 v22 v23 2006 08 16T00 02 48 v23 v24 0 v24 v25 922 v25 v26 2006 08 16T12 47 13 v26 v27 26 68 v27 v28 764 5 v28 v...

Page 509: ...ntains the station meta data and field descriptions while the data object is an array of record objects B 1 8 2 1 The head Object The head object contains information about the datalogger and program...

Page 510: ...ies the datalogger table name model Specifies the model of the datalogger that produced this data This object is optional serial_no Specifies the serial number for the datalogger that produced this da...

Page 511: ...cted to represent a signed four byte integer xsd unsignedInt The data will be expected to represent an unsigned four byte integer xsd short The data will be expected to represent a signed two byte int...

Page 512: ...th the equivalent element in the head fields array B 1 8 3 File Example head signature 21334 transaction xxxxyyyy environment station_name jon cr1000 table_name one_day model CR1000 serial_no 1084 os_...

Page 513: ...at has been replaced in new dataloggers by the TOB3 file format TOB3 format is similar to TOB2 in most respects but differs from TOB2 in the following ways Frame headers in TOB3 are twelve bytes long...

Page 514: ...gger Name of the program running in the datalogger Signature of the program running in the datalogger The time that the file was created Header line two contains The name of the table as declared in t...

Page 515: ...given by header line six The frame footer makes up the last four bytes of the frame B 3 Binary Data Value Types When data is written in datalogger memory or in binary data files each value must be ass...

Page 516: ...a Files on the PC for complete information on Split View Pro and CardConvert Refer to Section 10 Utilities Installed with LoggerNet for complete information on File Format Convert B 4 1 Split Split ha...

Page 517: ...ormat Description The EBNF description of RTMS syntax is as follows Record DataRecord AckRecord CRLF DataRecord StationName TableName FieldSpecs VALUES FieldValues AckRecord StationName TableName Reco...

Page 518: ...s PC1 StatMsg TMSTAMP TIMESTAMP RECNBR DECIMAL 10 0 SrcStn VARCHAR 256 AbtStn VARCHAR 256 Hop DECIMAL 3 0 Message VARCHAR 256 VALUES 1993 12 08 15 02 02 25 13355 PC1 StatMsg 0 DBSelect End Pipe Queue...

Page 519: ...able represents a record and each column represents a field The number of fields in a record is determined by the output processing instructions in the datalogger program that follow the Data Table ou...

Page 520: ...ds in a record is determined by the number and configuration of output processing instructions that are included as part of the Data Table definition The number of records to be kept in a table before...

Page 521: ...s C 2 Converting an Array Based Program to a CR10X TD Table Based Program using Edlog The following information is provided for those users familiar with writing programs for array based dataloggers o...

Page 522: ...ls are specified in seconds Instruction 18 Time Instruction 18 is used to store the current time into an input location Parameter 1 designates what format will be used when storing the time There are...

Page 523: ...the program is compiled by the datalogger Once the maximum number of records for a table have been stored the next record stored will overwrite the oldest record in the table The record number will co...

Page 524: ...cs and Status The default tables in CR5000 CR1000 CR3000 CR800 CR9000 and CR200 dataloggers are Status and Public Timeset Table The Timeset table contains a history of clock sets for the datalogger It...

Page 525: ...input locations allocated for the program PrgmFree Amount of remaining program memory in bytes Storage Number of final storage locations available Tables Number of user created data tables DaysFull Es...

Page 526: ...Free Amount of free space in the CPU RAM disk that is used to store program files ProcessTime Time in microseconds that it took to run through processing on the last scan Time is measured from the end...

Page 527: ...ogram ErrorCalib A counter that is incremented each time a bad calibration value is measured The value is discarded not included in the filter update and this variable is incremented VarOutOfBound Fla...

Page 528: ...ggers C 10 TABLE C 1 Example of Status Table Entries CR10T CardStatus Contains a string with the most recent card status information CompileResults Contains any error messages that were generated by c...

Page 529: ...e data cache files are stored in addition to the output data files D 2 1 Organization The data cache is set up to emulate the way data is stored in the datalogger When a new datalogger station is defi...

Page 530: ...datalogger table or array and data field The data can be requested by a query where the request specifies the starting and ending timestamp or record number along with the data to retrieve D 2 4 Upda...

Page 531: ...s used for storing data files and system status information files from LoggerNet System files are stored in the Sys directory The C CampbellSci LoggerNet Sys Bin subdirectory contains the configuratio...

Page 532: ...cations you have only one instance of CRBasic running on your machine and it will look the same regardless of whether it is started from LoggerNet or PC400 Changing or removing any of the files in the...

Page 533: ...r network This is the most readable of the logs and contains event messages that are meaningful to most users Examples of these events are Datalogger clock check set Datalogger program downloads Data...

Page 534: ...e are more saved files for that log than are allowed by the File Count parameter the server will delete the oldest of these files until the count is less than or equal to the File Count E 1 3 Log File...

Page 535: ...1 Transaction Log Messages Code Message Text Message Parameters Message Meaning User Response to Message 1 Network device added Device Name A new device was added to the network map 2 Network branch d...

Page 536: ...ile wmodem cust If the user has not set up custom modem configurations this file will not exist 11 Clock check started A clock check has been initiated This clock check is not sent out to the station...

Page 537: ...datalogger has failed or the operation has timed out waiting for a response Check communications with the datalogger by trying to check the clock If that fails follow the steps for message 14 20 Hole...

Page 538: ...g failed due to communication failure or a timeout Check communications with the datalogger by trying to check the clock If that fails follow the steps for message 14 29 Directed data query start A us...

Page 539: ...either timed out or communication has failed Check the connections from the PC to the RF base 40 Datalogger message Severity S for Status W for Warning F for Fault Message text This is a message that...

Page 540: ...to acknowledge the set variable message 49 Table resized The size of the table storage area in the data cache has been changed If the table is made smaller the oldest data will be lost 50 Program file...

Page 541: ...trying to check the clock If that fails follow the steps for message 14 58 Collection schedule normal This is an advisory message that the normal data collection schedule is active 59 Collection sche...

Page 542: ...onfiguration file has been corrupted Check the network map and the computer file system 66 Device save to file succeeded The update to the device configuration file was successful 67 Device save to fi...

Page 543: ...een saved to a file if desired 70 A device setting value has changed Setting Identifier Client s logon name New value of the setting A client has changed one of the device configuration settings 71 A...

Page 544: ...sage is seen without the shut down message before it this is an indication that the server or the PC crashed without exiting properly 80 Collect area initialized Collect area name A data cache collect...

Page 545: ...plete due to communications failure or a timeout Check communications with the datalogger by trying to check the clock If that fails follow the steps for message 14 89 Selective manual poll begun Coll...

Page 546: ...for message 14 99 Collect area first poll This message is posted either the first time data is collected for a collect area or holes were lost for the datalogger If this is not the first poll for the...

Page 547: ...e message 100 104 BMP1 packet sent The packet message type code 0 Packet Delivery Fault Notification 1 Status Warning Fault Notification 2 Network Description Transaction 3 Clock Check Set Transaction...

Page 548: ...I O Transaction Terminal Mode 12 Memory Image Down load Transaction 13 Memory Image Up load Transaction 14 Get Table Definitions Transaction 15 RF Test Transaction 16 Communication Status Notificatio...

Page 549: ...pt help 111 PakBus route added A new PakBus route has been added to the routing table 112 PakBus route lost A PakBus route has been lost and will be removed from the routing table 113 PakBus station a...

Page 550: ...d TestFast 20900 20960 polling 2009 04 15 16 41 06 601 CR1000 21 Hole collected TestFast 20900 20960 2009 04 15 16 41 06 648 CR1000 41 Records received TestFast 20961 20999 polling 2009 04 15 16 41 06...

Page 551: ...PakBusPort_ip S received message src 2 dest 4094 proto BMP5 type 0x89 tran 218 2009 04 15 16 41 06 492 CR1000 S BMP5 message received type 0x89 table poll CR1000 TestFast 2009 04 15 16 41 06 523 PakB...

Page 552: ...ere are processes that are loading down your CPU check to see if there is an updated driver for your USB RS232 adapter Invalid low level signature The packet received from the device got corrupted and...

Page 553: ...000 2009 04 15 16 41 05 382 CR1000 starting BMP5 operation delay hangup 2009 04 15 16 41 05 382 CR1000 Bmp5 OpDelayHangup transaction started 216 2009 04 15 16 41 05 413 PakBusPort_ip PakBusTran closi...

Page 554: ...yyy Noise Level Indicator zzzz Noise Level Indicator A communication failure occurs when a signature of a block of data does not match its original signature These blocks are subsequently retransmitte...

Page 555: ...eviously used methods such as re writing the CRBasic program or interfering with measurements to obtain calibration constants manually With this method changes to multipliers and offsets can be made q...

Page 556: ...xists It will also indicate whether the attempt to load those values was successful or not by returning a Boolean true false result SampleFieldCal optional This is a table output instruction It writes...

Page 557: ...ing Calibration Offset Calibration Two point Multiplier Offset Calibration Linear Fit and Two point Multiplier Only Calibration These calibration types are described below F 3 1 Zeroing Zeroing is the...

Page 558: ...libration Two point multiplier and offset calibration uses a linear fit technique against two different known value conditions of the sensor s measurement The sensor is placed into the first condition...

Page 559: ...nd condition After completing the measurement of the second point condition a best fit of the two points is calculated resulting in a slope value m value or multiplier with the offset assumed to be ze...

Page 560: ...iated with the mode value being set to 1 NOTE By properly changing the known value variables and the mode variables in a calibrating program a manual calibration can be performed on a sensor Steps for...

Page 561: ...ro for a fresh start 2 Place the sensor into the first known point condition 3 Indicate the known value of the first point by changing the known value variable to that value 4 Set the mode variable to...

Page 562: ...ctions is running on a datalogger and RTDAQ is connected to that datalogger you can select Datalogger Calibration Wizard from the Connect Screen s menu to start the Wizard A list of measurements refer...

Page 563: ...ect which sensor it is that you wish to calibrate and press Next You can select an entire array or any single element of that array as well as scalar single valued variables Any items that have been a...

Page 564: ...the first value The word Calibrating will be visible in the Current Value box until that process is complete Now place the sensor into the second known condition and then enter the corresponding know...

Page 565: ...appears You can conclude the calibration or return to the starting point to perform more calibrations of the same or different sensors The steps for performing a two point slope only multiplier only...

Page 566: ...bration Select the sensor you wish to calibrate press Next If the variable is configured as an array of sensors you may select an individual item to calibrate only that element or you can select the e...

Page 567: ...the calibration process When it finishes you will see the new value of the sensor after the application of the zeroing offset Press Finish to end the calibration F 5 4 Using the Wizard to Perform Off...

Page 568: ...e sensor to be calibrated Set the sensor to the known value calibrate to value Enter that value into the Enter Calibrated Value box Press Calibrate The current value will show Calibrating until the pr...

Page 569: ...pecialized needs for shunt and strain gauge calibrations It uses the same calibration file cal as well as the other utility calibration instructions SampleFieldCal NewFieldCal LoadFieldCal For more in...

Page 570: ...Appendix F Calibration and Zeroing F 16...

Page 571: ...h having its own window G 1 Array Based Data File Import Array based data files are typically comma separated with the first column of each line being an array ID If time and date are included in the...

Page 572: ...ox select Comma and Space The Comma option directs Excel to place each data value which is separated by a comma into a separate column The Space option will separate the Date and the Time into two col...

Page 573: ...convert the timestamp fields in the array data to the decimal format used by Excel Microsoft s database MS Access and spreadsheet MS Excel programs store dates and times as real numbers where the inte...

Page 574: ...ortion of the HHMM time field to a fraction of a day Sec 60 60 24 Converts the seconds field in to a fraction of a day Once you have entered the formula for one cell you can apply it to multiple cells...

Page 575: ...ox select Comma and Space The Comma option directs Excel to place each data value which is separated by a comma into a separate column The Space option will separate the Date and the Time into two col...

Page 576: ...the YMD format To complete the import select the Finish button As imported the Date and Time fields have a quotation mark in the field TOACI1 CR10T FiveSecond TMSTAMP RECNBR counter SineOut IntTemp_C...

Page 577: ...Find What field type in a quotation mark Leave the Replace With field blank and select the Replace All button If headers have been imported with the data the column headings will be off by one since...

Page 578: ...Appendix G Importing Files into Excel G 8...

Page 579: ......

Page 580: ...ific Canada Corp CSC 11564 149th Street NW Edmonton Alberta T5M 1W7 CANADA www campbellsci ca dataloggers campbellsci ca Campbell Scientific Centro Caribe S A CSCC 300 N Cementerio Edificio Breller Sa...

Reviews:

No comments

Related manuals for LoggerNet

Brand: Panasonic Pages: 20

Brand: DAVIS Pages: 20

Jetstream CPX-1000

Brand: Paradyne Pages: 93

Brand: Adobe Pages: 122

VCENTER CHARGEBACK 1.5 - API

Brand: VMware Pages: 150

IP Office CTI Link

Brand: Avaya Pages: 28

Brand: M-Audio Pages: 88

AURORA BROWSE 7

Brand: GRASS VALLEY Pages: 4

Brand: Oracle Pages: 140

Artistic Suite V6

Brand: Janome Pages: 5

MAXIMO SG24-7645-00

Brand: IBM Pages: 152

Brand: Tascam Pages: 16

Brand: Asus Pages: 114

Brand: Asus Pages: 154

Brand: Asus Pages: 72

Brand: Asus Pages: 93

NFC EXPRESS DESKTOPS

Brand: Asus Pages: 4

Brand: Asus Pages: 106

Brands by name

0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Popular brands

Load more brands