If you are trying to import a CSV file with a header using the LOAD command, you can use the IGNORE keyword to skip the first line of the file. Here’s an example:
basket random
LOAD DATA INFILE 'filename.csv'
INTO TABLE tablename
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

The IGNORE 1 ROWS statement tells MySQL to skip the first row of the file, which is the header. This will allow you to import the data from the CSV file without including the header row.

Many thanks for that solution.

Regard,
Clifton Evans

The compatibility summary screen shot includes a footnote that references the Genero Desktop Client user guide. You can find the referred-to documentation in that footnote at this URL: https://4js.com/online_documentation/fjs-gdc-manual-html/#gdc-topics/c_gdc_ur_migration.html

[Next GDC 4.01.07 release - New compatibility plan]

Next GDC 4.01.07 release - New compatibility plan

Dear customers,

Genero Desktop Client (GDC) 4.01.07 will be delivered in the second half of February 2024, and it comes with a new compatibility plan.

GDC 4.01.07 and Genero compatibility:

   GDC 4.01.07 can run in direct mode (SSH) with FGLGWS 4.01 and FGLGWS 3.21.

   GDC 4.01.07 can run on the UA protocol using FGLGWS 4.01 + GAS 4.01 and FGLGWS 3.21 + GAS 3.21.

   When using FGLGWS 3.21 (direct mode or UA protocol), GDC uses native rendering.

   When using FGLGWS 4.01 and above (direct mode or UA protocol), GDC uses universal rendering.

   The Genero Report Viewer (GRV) 5.00, which is included in the GDC, is compatible with FGLGWS 4.00 and FGLGWS 3.21.

 

Warning:

GDC 3.21 will no longer be supported after this release. We will only fix issues in the latest supported GDC version.



What are the advantages for you?
 
1/ You can update progressively to new versions. If one part of your application works with FGLGWS 3.21 and the second part works with FGLGWS 4.01, you can open a single GDC to handle both parts.

2/The GDC will always be working with the latest QT libraries. What does it mean for you?

• The GDC is working with OpenSSL 3
  
• The GDC is working with the latest QtWebEngine to display your web components and Universal Rendering; the latest QtWebEngine uses Chromium as the backend.
  

Compatibility summarized: Look at the attached image.





 

Hello Paul,
 
May I ask you if you get the same problem in Genero BDL 4.01.06 or the latest Genero EAP V5?
 
Thank you,
 
--
Olivier Eckert – Four Js Customer Care

Hi,

As suggested by Reuben you should check the version you are using, to see if it contains the fix of WCG-145.
Anyway, the best would be to report this problem to your support center with a test case reproducing it.

Regards,
Bernard

[Genero Enterprise 5.00 EAP program]

Genero Enterprise 5.00 EAP program

Four Js is pleased to announce that the Early Access Program (EAP) for Genero Enterprise 5.00 is now open.

This release comprises important new features that will improve your productivity and the user experience of your applications. You now can have access to the product packages in the Early Access Programs section of our web site.
If this is your first time participating in a Four Js EAP, please read the section “What is an EAP?” in the sidebar where you will learn how to subscribe to this service.

The list of features highlighted in this announcement here are not exhaustive. To find the complete list, read the “What’s New” and “Upgrade” sections provided in the appropriate User Guide.

The “What’s New” section provides the full list of new features in the release. The “Upgrade” section tells you how to migrate from a previous version of Genero.

Additional features may be added during the EAP, so we recommend frequent visits to the forum.

We appreciate your interest in pre-release access to our products, and value your feedback. Thank you for your participation in this important phase of our product development.

Best Regards,

The Four Js Development Team

Two things to note here ...

1. JUSTIFY is not the solution.  Note the second paragraph in the JUSTIFY section http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_FSFAttributes_JUSTIFY.htmlgetting over it

2. In the GDC, default position for IMAGE in table is center, https://4js.com/support/issue/?id=GDC-4308.   There is a task GBC-3800 to get the GBC behaviour to match GDC.  Where there is a clear difference like this between 3.20 and 4.01 behaviour you should not be shy about reporting a case to support.  The number of reporters is a factor for priority so even though there maybe a simple 3 line workaround via GBC customisation, you should still let us know you had to do that so that we give the issue the attention it deserves.  (It's not a 3 line solution for us as we have to a)  consider the alignment presentation style attribute and the fact that default for GRID is top left and for TABLE it is center! and b) FLIPPED rendering)
   
3. There is another interesting case we have on the books GBC-4249 that the introduction of STRETCH=X has highlighted, for non-text widgets such as CHECKBOX, RADIOGROUP how should they behave when the grid is stretched and getting consistency with what happens in a TABLE.  I suspect the alignment presentation style attribute will be extended beyond IMAGE to other widgets

I got it. Thx.

Hello, no we didn't solve the problem. We are storing only texts for now.

With the upgrade to our Support Portal that occurred just prior to the end of the year, it is an opportune time to remind you of the practises that will keep your support contact happy when you communicate via the Support Portal, and lead to faster and more effective resolution of issues and questions you may have.

Read more at https://4js.com/ask-reuben/ig-211/

Most of you should be aware of the concepts of optimistic and pessimistic locking as it relates to the concept of how to handle concurrent access to the same database records (if not then that will be a future Ask-Reuben).  When it comes to validating the data entered by an INPUT dialog, there are two coding patterns that can be used to validate the data that I like also to describe as being pessimistic and optimistic.
 
Both patterns have their strengths and weaknesses.

Read more at https://4js.com/ask-reuben/ig-210/