PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Choosing a conversion
  • Converting the data found in a file of an external database into a HFSQL data file
  • Converting the data found in a file in Hyper File 5.5 format into a HFSQL Classic data file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
WDConver : Use in interactive mode
HFSQLAvailable only with this kind of connection
Overview
Before you start using WDConver, you must have:
  • The WINDEV analysis (".WDD" file) into which the data must be imported. This analysis must have been generated at least once.
    Reminder: This analysis must contain the structure of the HFSQL files into which the data will be imported.
  • The database containing the data to import.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Choosing a conversion
When it is started, WDConver proposes to:
  • Create a new conversion description. This conversion will be automatically run at the end of its description.
  • Choose an existing conversion description (".WDV" file) already created with WDConver. The conversion is automatically performed.
    This allows you to perform a conversion without having to re-describe it.
    A conversion description can also be used to start a conversion from a WINDEV application. See Starting WDConver in command line mode for more details.
Converting the data found in a file of an external database into a HFSQL data file
To describe and convert the data found in a file of an external database into a HFSQL data file:
  1. Start WDConver and validate the different screens until you reach to the "Choose the data source" plane.
  2. Select the "External database" data source.
  3. Select the HFSQL Classic analysis (".WDD" file) containing the structure of the external files to convert.
  4. Specify (if necessary) the password of this analysis at run time. This password was defined in the description of the analysis.
  5. Select the access mode to the external database ("Type" option). The connection can be established via:
    • an OLE DB provider,
    • an ODBC driver,
    • a native access (AS/400, Oracle, SQL Server, ...).
      Note: To define the advanced connection parameters, click the button.
  6. Specify the data source of the connection. This data source can correspond to:
    • The name and full path of the database.
      For example, with Access: "C:\MyDirectory\AccessDatabase.MDB"
    • The name or the alias of the server.
      For example, with Oracle: "Oracle_Server"
    • The directory containing the xBase file (".DBF").
      For example: "C:\MyxBaseDirectory"
  7. Enter (if necessary) the user name that will be used to connect to the database.
    Note: This name was defined when creating the database. Several users with different rights can exist for the same database.
  8. Enter (if necessary) the password used to connect to the database. This password was defined when creating the database.
  9. Select the files (tables) whose data must be imported. The description of these files must be found both in the source database and in the destination WINDEV analysis.
    Note: If no table is found, enter the name of the table whose data must be imported.
  10. Specify the directory where the HFSQL Classic data files will be created.
  11. Save (if necessary) the description of the conversion (".WDV" file) so that it can be re-used.
  12. Start the data conversion (validation button of the wizard). The HFSQL Classic data files are automatically created in the specified directory.
    Note: If these files already exist, the converted records will be added after the existing records.
Converting the data found in a file in Hyper File 5.5 format into a HFSQL Classic data file
To describe and convert a file in Hyper File 5 format into a HFSQL Classic data file:
  1. Start WDConver and validate the different screens until you reach to the "Choose the data source" plane.
  2. Select the "Hyper File 5" data source.
  3. Select the analysis in Hyper File 5 format associated with the data to convert (".WDD" file) and specify (if necessary) the password of this analysis at run time. This password was defined in the description of the analysis.
  4. Select the HFSQL Classic analysis (".WDD" file) containing the structure of the files containing the data to convert and specify (if necessary) the password of this analysis at run time. This password was defined in the description of the analysis.
  5. Select the files (".FIC" files) whose data must be imported. The description of these files must be found both in the source database and in the destination analysis. Specify their logical name and password if necessary.
  6. Specify the directory where the HFSQL Classic data files will be created.
  7. Save (if necessary) the description of the conversion (".WDV" file) so that it can be re-used.
  8. Start the data conversion (validation button of the wizard). The HFSQL Classic files are automatically created in the specified directory.
    Note: If these files already exist, the converted records will be added after the existing records.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment