Skip to Content (Press Enter)
2012-04-17 11-21-58
Rui Molefas
19Views
3Comments
expected a 'Int32' but received a 'String'
Question
Hi all,
i know this issue has been posted before, and i replied to it actualy saying i never had it....until now.
Since the original thread didnt had any response i will post it again.

I am importing data from excel and i know that the data is an Int. Some values are missing, they are non existant but the ones that exist are definitly Int. I even tried to change the type of the attribute to 'Text', checked in the DB that it was actualy changed to 'varchar(50)' but the error remains the same.

Any quick fix or ideas?


Thank you in advance!
0
0
13 Apr 2012
Copy Link
2016-04-22 00-29-45
Nuno Reis
 
MVP
Can't you just receive the excel value like a string and pass it as a number to the entity with the function TextToInteger?
0
0
13 Apr 2012
Copy Link
2012-04-17 11-21-58
Rui Molefas
Hi Nuno, thx for the reply.
Yes i tried doing that. That's what i meant by " I even tried to change the type of the attribute to 'Text', checked in the DB that it was actualy changed to 'varchar(50)' but the error remains the same." 

So i still got the same error...seems strange
0
0
14 Apr 2012
Copy Link
2012-04-17 11-21-58
Rui Molefas
In case anyone gets the same problem, the way i solved it was:

1- Deleting all the previous tables created with that excel file;
2- Re-import entities from Excel using the same file;
3- Changing the type of the attribute to Text manualy;
4- Make sure that the table in the database changed the vale to a varchar(50);
5- Right-click on the table and select 'Update action to boostrap data from excel'.

Worked for me, hope it helps someone.


Thank you all for the help.
0
0
15 Apr 2012
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.