Wavetronix Command Translator (CMD-DT) - User Guide Manuel d'utilisateur télécharger pdf (Page 56)

CHAPTER 4  ROUTES PAGE 55

06/15/2011 10:27:27 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[Segments](

[Timestamp] [datetime] NOT NULL,

[RouteId] [varchar](250) NOT NULL,

[SegmentId] [varchar](250) NOT NULL,

[TravelTime] [int] NOT NULL,

[Volume] [int] NULL,

[Occupancy] [decimal](18, 0) NULL,

[DataType] [int] NOT NULL

) ON [PRIMARY]

SET ANSI_PADDING OFF

<<<<< End Script - Copy above this line >>>>>

1 2 ... 51 52 53 54 55 56 57 58 59 60 61 ... 155 156

Command Translator 1
Contents 4
Part II Taskbuilder 5
Appendix 145 6
Introduction 8
Translator Web Interface 9
Translator 12
In this chapter 14
Logging In 14
Menu Bar 15
Context-sensitive Help 15
Logging Out 16
Job List Page 2 18
Job Status Summary 19
Job List 19
Adding and Conﬁguring Jobs 20
Information Bar 21
Figure 2.6 – History Section 22
Figure 2.7 – Tasks Section 24
Figure 2.8 – Events Section 25
Notiﬁcations 27
Services 28
Service List 29
Add Service 30
Service Information 30
Properties 32
Figure 2.20 – Notiﬁcations 33
Users Page 3 34
User List 35
Edit User 35
New User 36
36 CHAPTER 3  USERS PAGE 37
Routes Page 4 38
Routes Page 39
Route Toolbar 40
Deleting Routes 41
Exporting Route Deﬁnitions 41
Copying a Route 41
Editing a Route 42
Route Conﬁguration 43
Display Options 43
Zoom Options 44
44 CHAPTER 4  ROUTES PAGE 45
Figure 4.10 – Remove Segment 46
Adding Assets to a Group 47
Figure 4.14 – Add Asset 48
48 CHAPTER 4  ROUTES PAGE 49
Figure 4.16 – Asset Tab 50
Assigning Assets to Segments 51
Travel Points 52
Route Data and Overrides 53
Figure 4.20 – Override Tab 54
Figure 4.21 – Task Pattern 54
Setting Up Route Database 55
System Page 5 58
Status Tab 59
Information 61
Mail Settings 61
Job Settings 61
Reclaim Memory Interval 61
Support Tab 62
Notiﬁcations Tab 63
Collectors Tab 64
Journal Tab 65
Tasks Tab 65
Import Tasks 66
Export Tasks 66
TaskBuilder Tab 67
Help Page 6 68
User Guide Tab 69
License Agreement Tab 69
CHAPTER 6  HELP PAGE 69 70
TaskBuilder 72
TaskBuilder User Interface 7 74
TaskBuilder User Interface 75
Menu and Toolbar Buttons 76
Options Menu 77
Help Menu 77
Debug Menu 77
Component List 78
Main Task Window 79
Properties Area 80
Creating a New Task 82
Opening an Existing Task 83
Figure 8.2 – Task Manager 84
Exporting a Task 85
Importing a Task 86
Working with Multiple Tasks 87
Adding Components to a Task 87
Adding Actions to a Task 87
Moving Components or Actions 89
Copying Components or Actions 91
Cutting Components or Actions 91
Copying an Entire Task 92
Executing a Task 92
Debugging a Task 94
Using Third-Party Editors 95
Changing Task Execution 95
Depth-ﬁrst Execution 96
Breadth-ﬁrst Execution 96
TaskBuilder Components 9 98
Database (DB) 99
Figure 9.2 – Data Component 100
Figure 9.3 – XML Component 100
Figure 9.4 – Email Component 101
Figure 9.5 – HTML Component 102
Figure 9.6 – PDF Component 103
Figure 9.7 – Text Component 103
File Name Placeholders 104
Trip Time 105
Advanced Trip Time 106
Figure 9.13 – Route Component 107
TaskBuilder Actions 10 108
Database-to-Database Action 109
Database-to-Data Action 109
Data-to-Database Action 110
$column3 111
Data-to-XML Action 112
Data-to-Text Action 112
Data-to-3 Card Action 113
XML-to-Data Action 114
XML-to-XML Action 115
XML-to-Text Action 115
XML-to-HTML Action 116
XML-to-PDF Action 116
[File]-to-Email Action 117
Text-to-Data Action 117
Text-to-XML Action 118
FTP-to-[File] Action 119
[File]-to-FTP 119
Data-to-Trip-Time Action 120
Trip-Time-to-XML Action 120
TaskBuilder Sub-windows 11 122
Figure 11.1 – DB Conversion 123
Creating a Mapping 124
Default Values 125
Sybase and Oracle Databases 126
Mapping Sub-window 127
Mapping Sub-window Elements 128
Trip Time Mapping Sub-window 129
Trip Time Template Sub-window 131
Trip Time Sub-window 133
SmartSensor Trip Times 135
Add Component Sub-window 136
Creating Properties 137
Add Action Sub-window 138
Settings Tab 140
Components Tab 142
Editors Tab 143
Databases Tab 144
Translator Hosts Tab 144
Appendix 146
146 APPENDIX 147
APPENDIX 147 148
Database Table to XML File 149
APPENDIX 149 150
Figure A.6 – Database-to-XML 150
Figure A.7 – File to Email 150
Basic SELECT Query 151
APPENDIX 151 152
Renaming Columns 153
APPENDIX 153 154

Commentaires sur ces manuels

Pas de commentaire

Wavetronix Command Translator (CMD-DT) - User Guide Manuel d'utilisateur Page 56

Commentaires sur ces manuels