[BUG] Struct Formatting in CSV

Is there a way to format a struct in csv. As far as found there isn’t. Either get missing parenthesis or unknown data type for column (X). I am not talking about the original struct for the data table but a struct inside of that struct.

Whats Exported for a struct.

"Row_Name_4_3A54F5A5410E88176D276FB4077BC6D3=,MinValue_7_C67D90DC4B3DF28EBF5E8ABB06DD2A09=0.000000,MaxValue_9_E4CC3858470AC9D7B806BABB35672D27=0.000000)"

What I want or something readable.

"(Row_Name=,MinValue=1,MaxValue=1)"

Sadly, you cannot export a struct to CSV. You can, however, make a data table out of a struct and export the data table to csv.

This is not what I am talking about, I need to know why you can’t format a struct in a datatable. Not the datatable itself. For example, Make a new data table with selected struct > with in that table has a data type struct in it. When you export that, you get what I showed above. However, that is unreadable and not manageable at all. Hell there is no way to even know what the actual struct reference name is unless you actually export that datatable with the struct in it with data added. It is unreadable and ins’t formatted the same as the actual datatable struct.

I believe 4.13 fixed that problem with data tables exporting as CSV.

110768-datatablecsv.png

As you can see, there no longer is any reference ID’s in the exported CSV

That table was made from a struct though …

If you plan on adding a nested structure inside of that initial struct, then you will get that nested struct’s ID inside of the CSV, but not inside of the Data Table as you will see below.

I’m not sure if it behaves the same way with C++ created structures, you may want to give that a try.

Nested structures within structures will behave as follows

There is no struct in that table.
All Data types work fine except structs, which case doesn’t get formatted correctly on import.

Thats exactly my point, and when importing it will format it differently. It isn’t readable or any good to work with. I already have large amount of databases and struct do not get formatted correctly. It should work like this as for your example:

"(boolStruct=True)"

You simply can not manage structs in spreadsheets like it currently is. Add more than one simple bool and make the struct an array and you will see how god awful it is.

Unfortunately, you will be limited to this as long as you use Blueprint Structures.

I just tested this with a c++ structure and the results are exactly as you wish them to be.

110774-datatablecsvc.png

So, to fix your problem, you will need to convert your blueprint structures to c++ structures.

Yeah that’s how it supposed to be but should be the same with blueprint structs as well. Maybe we can get a bug report and have this fixed.

Well, good luck with this issue either way, glad I was able to give you a work around in the meantime :slight_smile:

Can we get a bug report so blueprint structs work the same as the C++ for csv?

You will need to post this in the Bug Reports section for that. This section is for ways of using the engine.