Welcome to QS_Toolbox page

 

UPDATE: We are working hard on the next version (2.00) and it will be totally FREE !!

You can already test the next Master Candidate version. Just go to the download page!

 

Before anything, we appreciate evaluation, bugs declaration or any comments on this tool for multiple reasons:

– we want to give you a very powerfull tool, for FREE

– we need feedback to improve QS_Toolbox to be better and better, and more ….

 

Last update: November 2017, 22th.

 

Why QS_Toolbox

  • You take back a development which you don’t know and have to make a technical state
  • You want to prepare a migration
  • You want to analyse your code because it is slow, old
  • You want to convert pictures library before migrating in 4DV16
  • You have to update methods properties in mass
  • You want to export methods, forms definition into a DOC or PDF document
  • You want to have a picture of links between form objects & methods called
  • You want to have a Version Control System for all you developments
  • You want to have a quick access to all you code at any time
  • You need to produce a documentation / report on database
  • You want to check commands
For all these reasons and for some unsaid here (see below the tool description), QS_Toolbox IS the tool you need.

 

COMMITMENT  -> NEED 4D V15 R3 / V15.2 minimum

This component is free without any guaranty and will always be free for any 4D developer’s for personal use.

Why it is free? Because we implement good ideas from us (they are always good :-D) or from the french 4D-Forum.

So, we created this component for multiple purposes:

– we want to be able to manage ourself the code by implementing functions / tools that we estimate missing or incomplete in 4D software.
– it is also for us a way to discovered and put in practice some new commands and new technologies coming from latest 4D version.
– and because we used it the most oftenly we can.

WHAT’S NEW IN THIS VERSION

– A lot of bug corrections, mostly minors, but never high level. A high level bug, is for us, a bug which has a direct impact on your structure or data.
– Add an amount of new functionalities. You will find them with the keyword NEW.
– Increase the stability and speed execution.

 

In this v2.00 version, User Interface (UI) has been rework to be more clear and useful.

There are also a lot of correction of bugs and optimization.

Note: for few functionalities, QS_ToolBox needs to create a method into the host database. The name is: « __QST_HOST_temporary_method ».

At any time, feel free to give us feedback.

– MAIN SCREEN

* NEW (2.00): add a preference button where it is possible to define some parameters used by the component.
* NEW (2.00): remove the licence notion –> the component is now TOTALLY FREE!
* NEW (2.00): review of the UI.

– DATA EXPLORER:

* Can display data inside a listbox and, eventually, help you to copy data into the paperboard to paste them into a spreadsheet (Excel for example).

* NEW (v1.60): Integrate C_OBJECT in the data view

– FORM EXPLORER:

* Display the screenshot of a form with all information about it (form objects, methods, object definition).
* Can display the form definition on JSON format.
* Can export the form definition on JSON format. It can be used for archiving, backups, and source code management in another tool.
* Can display the method used for a form object.
* (1.80): Add a status bar
* NEW (2.00): During page selection (included page 0), only objects of the page are listed.
* NEW (2.00): Analysis take care of 16R4 new object definition and form definition (soming soon)
* NEW (2.00): add the beautify of the code
* NEW (2.00): Screenshot of project form works with a turnaround.

– CODE EXPLORER:

* Can perform analysis on « all » stored methods in the structure including project methods, project form/object methods, table form/object methods, database methods and trigger methods.
* Show stats methods: line counts, comment line counts, blank line counts, code line counts, and cyclomatic complexity.
* Show method properties which will be updated directly from the interface
* UPDATE (1.90): Show methods called from a specific method, and calling methods
* Can export, as HTML disk files, every method in the structure. Can be used for archiving, backups, and source code management.
* Can export, as DOCX, HTML, RTF or ODT format, all objects of the structure (methods, forms) with screenshot, object information. Can be used for archiving, backups, and source code management.
* Can manage 4D Project Method Comments
* Can export all Project Methods with DOT language to create a view in PDF, PNG or JPG format. To be able to use this function, Graphviz must be installed on your computer. (see http://www.webgraphviz.com/).
* (1.80): Add a ReadOnly mode. Defined  by default.
* (1.80): Reduce the number of buttons used for exportation (HTML, documentation, graphwiz schema)
* (1.80): Add a status bar
* NEW (2.00): review of the interface
* NEW (2.00): add the beautify of the code

– METHOD PALETTE:

* Display a list of all methods, including database, projectform and tableform methods, sorted by name or lastest modification date.
* List can be reduce to Methods only.
* (v1.60): List can be reduced to created/modified since x days.
* (v1.60): List can be reduced based on criteria search.
* (v1.60): Display the content of a method with the capability to copy all or a part of it to the pasteboard.
* (v1.80): Add a button to copy methods’ list to pasteboard
* NEW (2.00): Addition of the possibility to select methods by searching keywords included in methods code.
* NEW (2.00): Search can be done by multiple keywords

– ANALYSIS & UPDATE TOOLBOX (OTHERS TOOLS):

* Can perform analysis of the structure and display fields definition.
* Can copy, per table, all fields name and type to paperboard.
* Can update, for a select field, a BTree index if none exist
* Can perform analysis of the code to see which fields are used in a query and report if they are indexed or not and the number of call. This analysis shows also fields indexed and NOT involved into any 4D command using index.
* Check table name and field name regarding 4D recommandation (accent, 4D command name, SQL function)
* Allow SQL command execution and display result into a listbox
* Allow 4D execution code (no check done regarding code executed)
* Export all data as DUMP, and by the way, can import a DUMP. Before using this function, think to save your application data first !
* Display ‘fat’ table
* Create the code to insert a new record (code is set into memory)
* Give some information about plugins used, components used, public IP address, format system used
* Open CSM, application folder, application properties
* Start a compression of the data file. Before using this function, think to save your application data first !
* Can show 4D folders, Syst* (v1.70.5): Some correction issues for JSON view & JSON export
* REMOVE – Can install/uninstall an event manager (special thanks to Vincent De Lachaux)
* (v1.60): Event Manager has been rewritten to check consistent thrue current events and objects. Results are displayed into a listbox.
* (v1.60): Can restore all debugger button
* (v1.60): If version >=16, add the capability ‘4D File’
* (v1.60): Display relations between table and field. Result is automatically copy to the pasteboard.
* (v1.60): Correct old declaration like C_STRING, C_INTEGER, ARRAY STRING, _o_AP BLOB to print settings …
* (v1.70): Export to disk the picture library in PNG format.
* (v1.70): Replace pictures from picture library based on the name. Pictures are converted to PNG format.
* (v1.70): List all variables using picture from picture library.
* (v1.70.6) : Add the Index number when a table is selected.
* (1.80): Add a ReadOnly mode for all functions which updated the structure or data. Defined by default.
* (1.80): Add a status bar.
* NEW (2.00): Overhaul supplements the correction of statement with addtion of new orders to be corrected and some other options.
* NEW (2.00): Add the research of all deprecated commands
* NEW (2.00): Add an evaluation of Open/Close couple commands to prevent memory error (eg: Create menu/Release menu)
* NEW (2.00): Add an analysis of commands based on specific point of the documentation (Warning, Tips …)

– 4D COMMAND USAGE:

* Display used commands and location.
* Can access directly to the edition mode by double-clicking
* Can list all unused command
* Show easily the obsoleted command / function used
* (v1.60):On selection, copy on paperboard the CID of the command / function (Command:C{number})
* (v1.60): allow a search in Method name or Command name, indifferently.
* (v1.60): Display the ID and CID for each command used
* (v1.80): Reduce the number of ‘false positive’.
* NEW (2.00): Overhaul the method to eliminate ‘false positive’ result and increase speed analysis.

– VCS: Source Code Management

* Initial idea from J.Pupier. All initial methods have been rewritten.
* Can save methods for Version Control perspective. You can know what is the latest version of your code.
* (v1.60): Methods are saved into a 4D external database at a selected location.
* (v1.60): Comparison between current version and an older one is performed with jsdifflib library.
* (v1.60): Allow to navigate inside all saved version of a method
* (v1.60): Allow to force to save all methods from the database (Press shift on ‘Create a stamp point’) . Available only for the full version.
* (v1.60): Allow to manage all projects in the same window.  Available only for the full version.

KNOWN LIMITATION of VCS:

This component has not been tested in C/S. This is very important because VCS module save LOCALLY all methods into an external database.

–  CONVERT EN/FR (NEW 2.00):

* Based on all command names, constants and keywords used by 4D, allow the conversion from EN->FR or FR->EN of your code.

* Insert code to translate is done by copy/paste.
* Get translated code by copy/paste
* Allow to save the converted code directly as a new method into the host database
* Search Command or Constant from the current 4D version

– SETUP (NEW 2.00)

* User can define it own limits used in the Code explorer for Complexity and level of comments.

– RESTART 4D:

* Just do the job

Please feel free to drop us a note on suggestions and feature requests. We do plan to do some more tweaks and will add new features in the future.

RESPONSABILITY

We recommend to you to work on a copy of your database before doing any real updating.

Just to be clear: you use this component at your own responsibility and we decline any lost of data or methods. In other words, we will not responsible for any problems you might encounter so use it at your own risk! 

Our commitment is to offer you a tool with high quality of functionalities and few could be ‘dangerous’ like the direct execution of SQL code or 4D code.

If you find bugs, have suggestions, or want to send back enhancements, please email us at: info at association-qualisoft.eu.

We have a special thanks to some of you. As recognition, 2 people (we keep them anonymous) get a full licence for free due to there very good feedback on bugs (they are all corrected quickly) and requests. We want really to have a strong and useful tool for the 4D community.

Thanks!

IMPORTANT NOTE:  For OS X system, QS_TOOLBOX require Graphviz tool to be installed on the computer. For PC system, the tool is already included onto Ressources folder.