Have you ever needed a
universal import where you could simply select tables and columns from a source and destination database and easily export the data without using an analysis? How about the ability of
automatically mapping fields if they have the same name, or manually if not. How about providing default values if needed? We're proud to introduce Smart Import.
With Smart Import you will be able to move data between the following databases. (More to follow)
HF Classic (Hadd)
HF SQL (Sql insert)
MySQL (Sql insert) - PCSoft Native Driver Required
Sql Server (Sql insert) - PCSoft Native Driver or OleDB Required
Postgres (Sql insert) - PCSoft Native Driver Required
SQLite (Sql insert) - PCSoft driver included with WD
Access (Sql insert) - PCSoft driver included with WD
dBase III (Sql insert) - PCSoft driver included with WD
1. Restrict the 'From' and 'To' tables if needed.
2. Add a Where Clause if needed.
3. Automatically map all fields named the same.
4. Manually map individual fields.
5. Provide default values
Can Insert WLanguage code in the following areas…
6. Before the Import
7. After the Import
8. Before processing the table
9. After processing the table
10. Before processing the record
11. After processing the record
12. Before each field
13. After each field
Can manage database features if supported by the database
14. Turn triggers On / Off.
15. Turn off Auto Increment.
16. Use HListItem or Schema to retrieve the field definitions.
17. Run selected Imports in batch mode.
The real advantage to Smart Import is that it includes the WinDev source code (all procedural) which makes it easy for you to add additional functionality or modify existing behavior. You are
free to distribute it with or incorporate it into your application.
A more technical discussion can be found here.
Smart Import can be purchased along with any of our training materials on the 'Purchase Training' page, item #10