Difference between revisions of "TUFLOW Message 0627"

From Tuflow
Jump to navigation Jump to search
 
(2 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
|alt_msg=NA<br>
 
|alt_msg=NA<br>
 
|type=[[WARNING]]
 
|type=[[WARNING]]
|message_desc=CSV file appears to contain multiple data blocks... skipping xf file generation.
+
|message_desc=CSV files in TUFLOW can support multiple data blocks, one after the other in the file.  This was done as prior to 2007 Excel (.xls) had a column limit of 256 in a single worksheet.  To get around this, large datasets could be written with data split into vertical blocks in a file, like the schematic below:
|suggestions=Please contact [mailto:support@tuflow.com support@tuflow.com].
+
<br>
 
+
[[File:Msg_0627_csv_xf_unsupported.JPG|200px]]<br>
 +
After Excel increased the limit on the number of columns (in the .xlsx format) this style of .csv is rarely used. Whilst it is still supported in TUFLOW, it is not supported with the xf file format.
 +
|suggestions=There are a number of ways to overcome this:
 +
* Turning off XF files for the model (with the .tcf command "<tt><font color=blue>XF Files </font><font color=red>==</font> OFF</tt>". Refer to TCF Appendix of the <u>[https://docs.tuflow.com/classic-hpc/manual/latest/ TUFLOW Manual]</u>
 +
* Turning off XF files for the boundary data (with the .tcf command "<tt><font color=blue>XF Files Boundaries </font><font color=red>==</font> OFF</tt>". Refer to TCF Appendix of the <u>[https://docs.tuflow.com/classic-hpc/manual/latest/ TUFLOW Manual]</u>
 +
* Changing the format of the .csv file so that all data appears in the same data block, as per the schematic below.  The last option is the preferred option, as this will allow the model to use XF files, speeding up the initialisation.  
 +
[[File:Msg_0627_csv_xf_supported.JPG|400px]]<br>
  
 
|uplink=[[0xxx_TUFLOW_Messages|0xxx Messages]]
 
|uplink=[[0xxx_TUFLOW_Messages|0xxx Messages]]
 
}}
 
}}

Latest revision as of 15:35, 28 May 2025

TUFLOW Message
WARNING 0627 - CSV file appears to contain multiple data blocks... skipping xf file generation.

Alternate Message
NA

Message Type
WARNING

Description
CSV files in TUFLOW can support multiple data blocks, one after the other in the file. This was done as prior to 2007 Excel (.xls) had a column limit of 256 in a single worksheet. To get around this, large datasets could be written with data split into vertical blocks in a file, like the schematic below:
Msg 0627 csv xf unsupported.JPG
After Excel increased the limit on the number of columns (in the .xlsx format) this style of .csv is rarely used. Whilst it is still supported in TUFLOW, it is not supported with the xf file format.

Suggestions
There are a number of ways to overcome this:

  • Turning off XF files for the model (with the .tcf command "XF Files == OFF". Refer to TCF Appendix of the TUFLOW Manual
  • Turning off XF files for the boundary data (with the .tcf command "XF Files Boundaries == OFF". Refer to TCF Appendix of the TUFLOW Manual
  • Changing the format of the .csv file so that all data appears in the same data block, as per the schematic below. The last option is the preferred option, as this will allow the model to use XF files, speeding up the initialisation.

Msg 0627 csv xf supported.JPG


Up
Go-up.png 0xxx Messages