Dang, thanks for sharing that! Mind if I link this in my FAQ?
Yes for sure, you can include it in the FAQ.
To be fair, I think if the developer packages their CSV file with the project, this might not apply. In my specific case though I wanted the end user to be able to select their CSV file from anywhere on the drive. In this case, I needed to add that key into the entitlements file. My OS open file dialog wouldnāt even show up until I did this.
1 Like
Hi @JaredTherriault. Iām noticing with many UE5 Game Templates/Game Systems the use of Data Assets is becoming commonplace. Iāve been replacing DataAssets with Runtime Datatables, but, the process is extremely pain staking, thus Iām looking to acquire the ā¦
Runtime DataAsset - Import/Export text CSV or Google Sheet at runtime and auto-update DataAssets and UObjects!
Hey TechLord - I havenāt tried it myself, but I know DataAssets are just UObjects. You should be able to treat them the same. Have you attempted this yourself?
I just copied the title of this Post and replaced ādatatableā with ādataassetā LOL. But no means to import/export text CSV from a DataAsset which is why I dont favor using them.
What I mean is that a DataAsset is a UObject and RDT supports updating properties of UObjects. Instead of an array of structs, use an array of DataAssets. As long as the property names match up to your CSV column names, it should work in theory. You can export properties from UObjects using Generate CSV From Array. Unless I am missing something here. Please give it a try and let me know if you need something else to achieve what you need.
I see what you mean. Oh that, DataAssets are readonly which is reason #2 why I dont favor using them. No means to write to them.
Ah, I see what you mean. Well, Iāll look into the possibility of creating them at runtime and if I can, Iāll add the feature. No eta on when that will be though.
Fair Enough. It will be a game changer for DataAssets. Im not sure why or how they are becoming popular with such limitations.
Hi, I wanna make something like digital twin that can show data etc. Is this the correct plugin to use? or are there any specific plugin should I use?
Hello yogisenpai, can you give me a little more information regarding what youāre trying to do? Iām not familiar with the data aspects of digital twin.
Hello, Is it possible to hide the part that prints the value retrieved from the sheet? I donāt want this value to appear ā any help would be appreciated.
Hello SyBui_21, sorry to spam your log!
You can turn off log messages from RuntimeDataTable by clicking āFiltersā in the Output Log then unchecking āLogRuntimeDataTable.ā
Yes i understand what you say, but i want to hide/remove it from the outlog too, because i donāt want my data to be shown in the editor - but maybe not because it might affect your other users.
Thanks for the reply, the Plugins you create are great.
I understand, you want the logging event to not occur for privacy or other reasons. Unfortunately I donāt have an option for this at the moment, I only have added controls for on-screen prints. Iāll add a control for logging events for the next version.
In the meantime, if youāre comfortable with compiling C++ (and itās super simple!) you can comment out the logging events in Plugins/RuntimeDataTable/Source/RuntimeDataTable/Private/RuntimeDataTableModule.cpp in the āPrintā function.
At the time of this writing, lines 97-108 can be removed or commented out. After recompiling, the logging events will no longer occur!
Hi, how can I send my enum as string to the CSV/Sheet? When I write to CSV, It read as enum01,02,ā¦
Also, when write to sheet I got this error
Hi There, weāre running into a lot of Runtime Errors concerning GET issues (Error 429)
LogRuntimeDataTable: Error: URuntimeDataTableObject::GenericValidateHttpResponse: GET Response received, success: false, Response code: 429, Response: ...
I know you wrote something about it in the manual, but I am trying to understand how it works in the firstplace. We have a Sheet, where I get data from 6 different tabs.
Basically I do the following 6 times, once for each sheet.
What is generating the amount of requests, how does the it work. Is pulling data from each sheet 1 request, or is it a request per cell inside a sheet ? what generates so many requests that i run into the limit?
Hi yogisenpai,
enums are serialized internally by unreal as unit8, so thereās no way to serialize it as a string. You could work around this however by adding another struct member of type string and use āenum to stringā in blueprints or the UEnum ptr in C++ to keep track of that separately.
Can you paste the logs for the error youāre seeing? I canāt read it in the screenshot. Thanks!
-Jared
Hello Beeldenfabriek,
as you know 429 is a usage limit error: Usage limits | Google Sheets | Google for Developers
If youāre only hitting the sheet 6 times. you shouldnāt be hitting the limit - is there a possibility other users could be querying the sheet? Are you running the requests in a construction script or on Tick?
LogRuntimeDataTable: Error: URuntimeDataTableObject::GenericValidateHttpResponse: POST Response received, success: false, Response code: 400, Response:
{
"error": {
"code": 400,
"message": "Invalid requests[0].appendDimension: No grid with id: 0",
"status": "INVALID_ARGUMENT"
}
}
LogRuntimeDataTable: Error: URuntimeDataTableObject::WriteCsvToSheet_Internal_ClearSheet: ERROR: The ClearSheet operation was not successful.
{
"error": {
"code": 400,
"message": "Invalid requests[0].appendDimension: No grid with id: 0",
"status": "INVALID_ARGUMENT"
}
}
I only have 1sheet and set it to editor public.