expected a 'Int32' but received a 'String'

expected a 'Int32' but received a 'String'

  
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!
Can't you just receive the excel value like a string and pass it as a number to the entity with the function TextToInteger?
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
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.