|
|
|
|
|
- Overview
- WDModFic
- Starting WDModFic
- Required files
- Using WDModFic in command line mode
- Examples
- Using WDModFic in interactive mode
WDModFic: Tool for automatic modification of data files
Available only with these kinds of connection
WDModFic WDModFic is a tool for automated modification of data files on development and end-user workstations. By default, the automatic data file modification is performed on the end-user computers or on the deployment computer of the site when updating applications. However, in some cases (data files found on a laptop computer not connected to the network when the update was performed, failed update, ...), WDModFic must be used to perform this automatic modification once the application was updated. Caution: WDModFic is for experienced users only (e.g. the application administrator). Reminder: Automatic data modification allows you to reflect changes made in HFSQL analysis in data files.. For more details, see Automatic data file modification. Conditions of use: WDModFic is not automatically installed with applications developed with WINDEV or WEBDEV. The WDModFic.exe file must be selected along with the necessary files (see the next paragraph) when creating the setup. The license agreement of WINDEV and WEBDEV is fully enforced. Remark: It is also possible to program automatic modification of data files using the HModifyStructure function. WDModFic can be started: - in command line mode (without displaying the wizard of WDModFic). HFSQL Classic or HFSQL Client/Server data files can be modified.
- in interactive mode (while displaying the wizard of WDModFic):
- on the "Analysis" tab, in the "Analysis" group, expand "Synchronization" and select "Synchronize Structure and Deployed Data (SDD, Auto Modif...") (from the data model editor on the development computer only).
- run "WDModFic.EXE" directly.
Required files The following files are required to run WDModFic on a client computer: - wd300cpl.dll
- wd300hf.dll
- wd300obj.dll
- wd300pnt.dll
- WDOutil.WDK
- wd300std.dll
- wd30 0trs.dll (required only if the files are replicated)
- wd300vm.dll
- WDMod300.DLL
- WDModFic.Exe
- wd300mat.dll
- wd300prn.dll (required for printing)
Using WDModFic in command line mode To perform an automatic modification of the data files, the syntax is as follows: WDModFic.EXE [-subdir][-report][-error][-wizard][-nobackup][-noprogress][-nolink] [-noanaguid][-noanaconnection] /WDD=<WDDPath> /PWD=<WDDPassword> /DIR=<DataFileDir> /FILE=<DataFile> /FILEPWD=<FilePassword> /PRJ=<ProjectName> /SERVER=<HFSQLClientServerDatabase> /US Details of parameters: | | Parameter | Meaning |
---|
-subdir | If this parameter is specified, the data files are searched in the specified directory ("/DIR" parameter) and its subdirectories. By default, if this parameter is not specified, the data files are only searched in the specified directory ("/DIR" parameter) | -report | If this parameter is specified, a status report will be displayed at the end of the automatic modification of the data files. If this parameter is not specified, no status report will be displayed at the end of the automatic modification of the data files. | -error | If this parameter is specified, when an error occurs, a message will be displayed at the end of the automatic modification of the data files. If this parameter is not specified, no error message will be displayed at the end of the automatic modification of the data files. | -wizard | If this parameter is specified, the wizard for automatic modification of the data files will be started. By default, if this parameter is not specified, the wizard for automatic modification of the data files will not be started. | -nobackup | If this parameter is specified, the automatic backup of the modified data files will not be performed. By default, if this parameter is not specified, the automatic backup of the modified data files will be performed. | -noprogress | If this parameter is specified, no progress bar will be displayed during the automatic modification. | -noanaguid | If this parameter is specified, the automatic modification of the data files will be applied to the descriptions of the files that do not belong to the current analysis (when recreating the description of a file or when recreating an analysis for example). To perform the automatic modification, the HFSQL engine will use the logical name of the data file. After the automatic modification of the data files, the files become linked to the analysis. | -nolink | If this parameter is specified, the automatic data file modification will not create the integrity links when updating the HFSQL Client/Server database. By default, this parameter is not specified: automatic modification of data files creates integrity bindings when updating an HFSQL Client/Server database. | -noanaconnection | If this parameter is specified, the automatic modification will not use the connections defined in the analysis. By default, the automatic data file modification will use the connections defined in the data model editor. | -nobackground | If this parameter is specified, no "hot" automatic modification will be performed. In Client/Server mode, this parameter allows you not to ask for a password when the data files are password protected without being encrypted. | /WDD=<WDDFile> | Character string containing the name and full path of the analysis file (".WDD" file) that describes the new structure of the data files.>. This parameter is mandatory except if the "-wizard" parameter is specified. | /PWD=<WDDPassword> | Character string containing the runtime password of the specified analysis (password defined in the analysis description). This parameter must be specified only if the analysis is password protected. | /DIR=<DataFileDir> | Character string containing the directories where the data files to update will be searched. Only the data files that must receive an automatic modification will be taken into account. If this parameter is specified, the "/FILE" parameter must not be specified. If the data files to update are found in different directories, WDModFic must be run for each directory. Note: If ".REP" files are present in this directory, the location of the data files indicated in these ".REP" files will also be taken into account. | /FILE=<DataFile> | Character string containing the name and full path of the data file (".FIC" file) to update. If this parameter is specified, the "/DIR" parameter must not be specified. If several data files must be updated, WDModFic must be run for each file. | /FILEPWD=<FilePassword> | Character string containing the password of the specified data file (password defined by HPass, HCreation or HCreationIfNotFound, or during a previous automatic data modification). This parameter must be specified only if the specified data file is password protected. Note: Changing the password of a data file is only possible in interactive mode. | /PRJ=<ProjectName> | Character string containing the name of the project to use (without its path). If the "-PDA" parameter is specified and if the "-wizard" parameter is not specified, this parameter is mandatory. | /US | If this parameter is specified, the screens of the interactive mode of WDModFic are displayed in English. If this parameter is not specified, the screens are displayed in French. | /SERVER=<HFSQLClientServerDatabase> | String in format: [<login>[:<password>]@]<server>[:<port>]/<Database> In this string:- <login> corresponds to the login of the user
- <password> corresponds to the password of the user.
- <server> corresponds to the name of the HFSQL server. This parameter must be specified.
- <port> corresponds to the port number of the HFSQL server. This parameter is optional. The port 4900 will be used by default.
- <Database> corresponds to the name of the HFSQL Client/Server database. This parameter must be specified.
Example: /SERVER=Flo:pass@ServeurHF/Mabase Note: If spaces are present in the database name, use quotation marks.. Example: /SERVER="Flo:pass@ServeurHF/Ma base" | Remark: The above array shows the different parameters that can be used to launch WDModFic in command line mode.. To get these parameters when starting WDModFic, use one of the following syntaxes: - WDModFic.EXE /help - WDModFic.EXE /? Examples - The following command line is used to apply the changes made in the analysis "D:\MyApplication\MyAnalysis.WDD" to the data files found in "C:\MyDataFiles" and in its subdirectories ("-subdir" parameter). If an error occurs, a message is displayed at the end of the automatic modification of the data files ("-error" parameter). The wizard for automatic modification of the data files will not be started. A backup will be performed for the modified data files. Example:
ExeRun("C:\MyDirectory\WDModFic.EXE -subdir -error " + ...
"/WDD=D:\MyApplication\MyAnalysis.WDD " + ...
"/DIR=C:\MyDataFiles")
- The following command line allows you to apply the modifications performed in the analysis named "D:\MyApplication\MyAnalysis.WDD" to the "C:\MyDataFile.FIC" data file. A success or error message will be displayed at the end of the automatic modification of the data files ("-report" parameter). The wizard for automatic modification of the data files will not be started. The backup of the modified data files will not be performed ("-nobackup" parameter).
ExeRun("C:\MyDirectory\WDModFic.EXE -report -nobackup " + ...
"/WDD=D:\MyApplication\MyAnalysis.WDD " + ...
"/FILE=C:\MyDataFile.FIC")
- Using long names: When using long names, double quotation marks are required..
The following command line is used to apply the modifications performed in the "D:\MyWinDevApplication\MyAnalysis.WDD" analysis into the data file named "C:\MyDataFile.FIC". A success or error message will be displayed at the end of the automatic modification of the data files ("-report" parameter). The wizard for automatic modification of the data files will not be started. The backup of the modified data files will not be performed ("-nobackup" parameter).
ExeRun("""C:\My Application Directory\WDModFic.EXE -report -nobackup " + ...
"/WDD=D:\My WINDEV Application\MyAnalysis.WDD " + ...
"/FILE=C:\MyDataFile.FIC""")
- Using WDModFic for an HFSQL Client/Server database
sWDModFicDirectory is string = "C:\Program Files\WINDEV 2024\Programs\"
sFullWDDName is string = CompleteDir(fExeDir())+"MyAnalysis.wdd"
sUser is string = "guest"
sPassword is string = ""
sAddressOrNameHFServer is string = "ComputerName"
sPortNumHFServer is int = 4900
sDatabaseName is string = "MyAnalysis"
sCommandLine is string
sCommandLine = StringBuild([
"%1WDModFic.exe" /WDD="%2" /SERVER="%3:%4@%5:%6/%7" -report
], CompleteDir(sWDModFicDirectory), ...
sFullWDDName, sUser, ...
sPassword, sAddressOrNameHFServer, ...
sPortNumHFServer, sDatabaseName)
IF NOT ExeRun(sCommandLine, exeActive, exeWait) THEN
Error("Unable to execute automatic data modification: ", ErrorInfo(), ...
"Command line used: ", sCommandLine)
ELSE
END
- Example that uses variables to define the different paths.
ModFicDir is string
AnalysisDir is string
DataDir is string
ModFicDir = """C:\WINDEV\Programs\WDModFic.EXE"""
AnalysisDir = """C:\My Projects\CRM\Exe\CRM.wdd """
DataDir = """C:\My Projects\CRM\Exe\Data"""
ExeRun(ModFicDir + " -subdir -nobackup -" + "/WDD=" + AnalysisDir +"/DIR=" + DataDir, exeActive, exeWait)
Using WDModFic in interactive mode The wizard of WDModFic is started when WDModFic is started: - in interactive mode:
- on the "Analysis" tab, in the "Analysis" group, expand "Synchronization" and select "Synchronize Structure and Deployed Data (SDD, Auto Modif...") (from the data model editor on the development computer only).
- run "WDModFic.EXE" directly.
- in command line mode with the "-wizard" parameter.
To perform the automatic modification of the data files with the wizard: - Select the analysis (".WDD" file) that describes the new structure of the data files.
Note: If the specified analysis is password-protected at runtime, enter the password. - Select the data files (".FIC" files) to update.
- To save the data files before performing the automatic modification, check "Perform a backup before modification" and select the backup directory.
- To specify or modify the passwords of the different data files to update, check "I want to enter or change passwords for the new structures", select the desired data files and enter the corresponding password twice.
- Validate to start the automatic modification.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|