SMART IMPORT

 

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


Additional Features:

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

... "I have really enjoyed the RAD pattern capabilities. I have added my own windows and functions and then built new apps based off that and it is just fantastic to me how much coding (your own coding) can be done for you at the click of a button" - William Cook

“After 30 years of programming changing languages can be tough, in my conversion to using Windev and its products Glenn was invaluable as a resource and training mentor to make the transition possible as well as enjoyable.” Andy Stapleton / Cowboy Computing Solutions

"Thank you for the Video Streams . . . They are Great!!

The Video Stream discussion really brings to life the printed training material And the Q&A answered many of the questions that I had. This has taken MONTHS off of my learning curve!" - Jose Maldonado

Business Analyst (to one of the largest Medical Health Insurance Companies in the US)

"We've had the RAD Patterns for 6 days now. Thanks for making us more productive." - Gonzalo Martinez Garcia

“Glenn’s training materials were key to my success in getting started with WinDev & WebDev.  I highly recommend using them as a WXdev beginner and as a seasoned programmer.  His examples show great techniques using the product.” 

 

Robert Willis,

Principal

Blackwrist Gaming Solutions

“Glenn is very knowledgeable and experienced with WX, his training is efficient and effective. He crafted the training to meet our needs, made samples to assist us, and provided clear explanations.” Mark Robbins / University IT Director

“I especially like the practical knowledge of the instructor and informal interchange among the participants, depth of the examples” John Rae

"The real bonus of Glenn's training is the really cool and practical code in his many example apps!" Arnold Young