Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline Giri  
#1 Posted : 18 May 2021 20:57:04(UTC)
Giri

Rank: Newbie

Groups: Registered
Joined: 18/05/2021(UTC)
Posts: 4
India
Location: TN

Dear Team,
Error.png

I have updated the software today after I am getting this error.

When I insert a file and try to retrieve the data from it shows result - not defined.

I am using the syntax for few years and I havent faced this error. Kindly someone help to solve it.

I have attached the working files also.Sad

_database.sm (9kb) downloaded 15 time(s). Loading.sm (9kb) downloaded 14 time(s).

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline Davide Carpi  
#2 Posted : 18 May 2021 21:13:16(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
The error happens because no match is found (result is not defined before the loop in vlookup).

Probably something wrong about encoding in include() due to recent API changes.

You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently)
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline Giri  
#3 Posted : 18 May 2021 21:20:45(UTC)
Giri

Rank: Newbie

Groups: Registered
Joined: 18/05/2021(UTC)
Posts: 4
India
Location: TN

Originally Posted by: Davide Carpi Go to Quoted Post
The error happens because no match is found (result is not defined before the loop in vlookup).

Probably something wrong about encoding in include() due to recent API changes.

You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently)


Kindly find the below image,
Error With Explanation.png
Offline Davide Carpi  
#4 Posted : 18 May 2021 21:36:40(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
You have to display the data imported by include().

I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins.
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline Razonar  
#5 Posted : 18 May 2021 22:33:28(UTC)
Razonar


Rank: Advanced Member

Groups: Registered
Joined: 28/08/2014(UTC)
Posts: 1,356
Uruguay

Was thanked: 815 time(s) in 516 post(s)
Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard.

Clipboard01.jpg

Best regards.
Alvaro.
Offline Giri  
#6 Posted : 19 May 2021 07:57:38(UTC)
Giri

Rank: Newbie

Groups: Registered
Joined: 18/05/2021(UTC)
Posts: 4
India
Location: TN

Originally Posted by: Davide Carpi Go to Quoted Post
You have to display the data imported by include().

I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins.


Please find the screenshots from two different files.

database sheet
database sheet.png

Loading sheet
Loading Sheet.png
Offline Giri  
#7 Posted : 19 May 2021 07:59:54(UTC)
Giri

Rank: Newbie

Groups: Registered
Joined: 18/05/2021(UTC)
Posts: 4
India
Location: TN

Originally Posted by: Razonar Go to Quoted Post
Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard.

Clipboard01.jpg

Best regards.
Alvaro.


Hi, I did the same, but still I get this error.Sad

Error_2.png
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.