Wavetronix Command Translator (CMD-DT) - User Guide Manuel d'utilisateur Page 147
- Page / 156
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
146 APPENDIX
below. Click on Edit to bring up the DataBase Conversion sub-window.
5 Select the database and table for both the source and destination columns. e col-
umns for each table should appear in their respective column boxes.
6 To map the data, either use the mouse to drag from the source column to the destina-
tion column, or use the Add button (see Chapter 11). Not all source columns need to
be mapped.
7 Click Accept when the mapping is complete. If there are any destination columns le
unmapped, the Default Values sub-window will appear and you can enter default val-
ues for each data row.
8 Save the task.
Note
The username/password combinations used to log into both the source and destina-
tion databases must have appropriate access rights for the tables aected by the
task. This is usually SELECT for the source table, and SELECT,INSERT,UPDATE for the
destination database (see Appendix B).
One Database Table to Multiple Database Tables
Copying all or part of one table in a database to multiple destination tables is similar to the
one DB to one DB task described above.
If all the destination tables are part of the same database server, then additional table map-
ping is done by adding more actions between the same two components (see Figure A.2).
Figure A.2 – One Database Table to Multiple Database Tables
Each action represents a table-to-table mapping, even if all the actions have the same source
table.
Note
This mapping presumes that the same username/password combination used to ac-
cess the first destination table has equal rights to all the other destination tables.
If this is not the case, dierent DB components with dierent username/password
combinations will need to be used.
- 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.fr. Tous droits réservés | 0.033 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels