Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dmac  
#1 Posted : Tuesday, January 19, 2021 2:26:46 PM(UTC)
dmac
Rank: Member

Reputation:

Groups: Registered
Posts: 10
Australia
Location: Melbourne

Thanks: 3 times

Hi

I am getting the following validation error when attampting to import locations using the 'populated import template' : 

  • Unable to cast object of type 'System.Double' to type 'System.String'.

error relates to the location code column

i am not sure what this means or what i should do to proceed.

Regards

Daniel

Nick Tumney  
#2 Posted : Thursday, January 21, 2021 7:04:16 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Daniel,

The error suggests to me that it is trying to convert numbers to text.  What are your Locations called?

Also, if you generate a new Location import template and paste the data in, do you get the same error or does it upload?

Thanks,

Nick

thanks 1 user thanked Nick Support for this useful post.
dmac on 1/21/2021(UTC)
dmac  
#3 Posted : Thursday, January 21, 2021 1:34:11 PM(UTC)
dmac
Rank: Member

Reputation:

Groups: Registered
Posts: 10
Australia
Location: Melbourne

Thanks: 3 times
Hi nick, Thankyou , yes i converted the locations codes from numbers to text and all worked fine. Thanks. Regards Daniel
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.