How-to: Browse data with lookup texts instead of raw number codes
SQLMerger already has, when a project has been generated, a lot of information about the database. Often database designers and other use some naming conventions and those SQLMerger can often interpret, and find out what actually is referenced textually. If for example there exists a field like "UserId" in a table and in the same project, a table "User", with a field called "Id", "UserId" or similar, there is a good chance that for example a "DisplayText" or "username" field from the User table will be a good candidate for a lookup text, that for example can be displayed instead of the number "4".
Do:
1. First, open your tables:
You can open both tables by using the option "Open Source & Target" from the "Item" menu, or you can just click the [Open Source] and [Open Target] buttons. (Notice, if you invoke an operation in SQLMerger that needs data, SQLMerger will open the data automatically, for your convenience.)
The database etc. shown below in the example is from the built-in demo.
When data has been opened the main window will look like:
|
|
The contents of a table referring other tables may be difficult to handle when only human. There's only numbers here, help me!
|
2. Automatically add lookup specifications.
Choose the option "Auto create lookup definitions for merge setup item" from the "Item" menu.
This opens a window where you can see what SQLMerger proposes for lookup texts:
|
|
Automatically detected lookup texts. You can adjust as desired.
|
Click the button [OK].
3. When you open the data again, you will now see this:
|
|
Easy modification of data that really is only the key values. This also prevents input errors.
|
This is much better for a human being to look at.
Finished!
Tip:
SQLMerger can go through several lookup tables to look up the texts. You just need to create multiple lookup definitions manually and used them linked together.
Tip:
There are facilities to add and correct lookup definitions manually.
Tip:
You can also manually create a SQL query, in a lookup definition, to find exactly what you want to see. And it is also there the next time you open the project, so you always have better access to see and edit data.
Back to Overview...
|
Works with all Windows versions.
|
