Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario Pagina 110
- Pagina / 156
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
CHAPTER 10 TASKBUILDER ACTIONS 109
Figure 10.2 – Database-to-Data Action
e Database-to-Data action has the following properties:
Database (Value—String) – e Database property is a string that represents the name
of the individual database on the target server to connect to. A Database server, repre-
sented by the Database component, may contain a number of separate databases.
Table Name (Value—String) – e Table Name property represents the table within
the given database to connect to and copy data from.
Note
The username and password combination used in the Database start component
must have Read Access to this table or the action will fail.
SQL Query (Value—Filename) – e SQL Query property is optional; it represents a
text le containing a SQL Query in cases where a direct copy of all data and columns
from the source table is not desired. e SQL le should only contain one complete
SELECT statement, which represents the query to be sent to the source database to
retrieve data (see Appendix B).
If using a SQL Query is not desired for a Database-to-Data action, this property should
be le blank.
Data-to-Database Action
e Data-to-Database action (see Figure 10.3) copies the contents of a dataset in memory
directly into a specied table in the destination database.
Figure 10.3 – Data-to-Database Action
e Data-to-Database action has the following properties:
Database (Value—String) – e Database property is a string representing which in-
dividual database on the target server to connect to. A Database server, represented by
- 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 Configuring Jobs 20
- Information Bar 21
- Figure 2.6 – History Section 22
- Figure 2.7 – Tasks Section 24
- Figure 2.8 – Events Section 25
- Notifications 27
- Services 28
- Service List 29
- Add Service 30
- Service Information 30
- Properties 32
- Figure 2.20 – Notifications 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 Definitions 41
- Copying a Route 41
- Editing a Route 42
- Route Configuration 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
- Notifications 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-first Execution 96
- Breadth-first 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
© 2020, manymanuals.es. Todos los derechos reservados | 0.028 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales