GET DIRECT DATA corrupted function
Posted: Sun Aug 10, 2025 4:02 pm
Hi,
I have had a data read in variable in my model sets for more than 2 years. I found out recently that with a recent modification of a .mdl file, reading in an old tab in an xlsx file that the GET DIRECT DATA() function simply stopped working for that .mdl file. I was puzzled, thinking that it was because of a .mdl modification that really had nothing to do with the GET DIRECT DATA() function, but I found that it was exclusively for that .xlsx tab that the function stopped working. In creating other similarly modified .mdls, the function works fine. I did model compares and found nothing of significance that was different. Is there anything that makes the GET DIRECT DATA() function fail commonly? I am asking to see if there might be some salvation for the file, or if I have to delete it and remake the .mdl.
No errors appear when running the corrupt GET DIRECT DATA(), it simply picks a number (on which basis I have no idea) and repeats it for all of model time, which renders the data import useless. Anyway, if there are no commonly known bugs/work arounds for this I will plan to rebuild the .mdl.
I have had a data read in variable in my model sets for more than 2 years. I found out recently that with a recent modification of a .mdl file, reading in an old tab in an xlsx file that the GET DIRECT DATA() function simply stopped working for that .mdl file. I was puzzled, thinking that it was because of a .mdl modification that really had nothing to do with the GET DIRECT DATA() function, but I found that it was exclusively for that .xlsx tab that the function stopped working. In creating other similarly modified .mdls, the function works fine. I did model compares and found nothing of significance that was different. Is there anything that makes the GET DIRECT DATA() function fail commonly? I am asking to see if there might be some salvation for the file, or if I have to delete it and remake the .mdl.
No errors appear when running the corrupt GET DIRECT DATA(), it simply picks a number (on which basis I have no idea) and repeats it for all of model time, which renders the data import useless. Anyway, if there are no commonly known bugs/work arounds for this I will plan to rebuild the .mdl.