Forum Forum Fortifications of the World
A web site about fortifications and freeware programs : Fortifications of the World
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Error "Impossible de convertier...

 
Post new topic   Reply to topic    Forum Fortifications of the World Forum Index -> SmartGenealogy
View previous topic :: View next topic  
Author Message
henryd



Joined: 12 Jul 2012
Posts: 25

PostPosted: Thu Jul 12, 2012 12:12 pm    Post subject: Error "Impossible de convertier... Reply with quote

Hello,

I have set up an excel file (Excel 2007) and tried to transfer soem test data to Smartgenealogy. First file went through ok. Then I added some dates (extracted from a secondary Excel file) and at one point I get the following error:
"Impossible de convertier le Variant de type (ERROR) en type (String)"

Any ideas?
Back to top
View user's profile Send private message
ale
Site Admin


Joined: 12 Apr 2005
Posts: 499
Location: Versailles, France

PostPosted: Thu Jul 12, 2012 7:05 pm    Post subject: Reply with quote

Hi,

The message means that SmartGenealogy was expecting a character sting in one of the fields, and got something that cannot be converted to a string : Check the data that you have added for the second trial, some of them are probably incorrect.

All dates must be in a correct format, for instance "17 JAN 1887", or "BEF JAN 1887" or "BET 1887 AND 1900"... or empty.

In the worksheet "Persons", columns A, Q, AB and AC must be numerical (0 to 99999)
In the worksheet "Events", columns A and G must be numerical (0 to 99999)
In the worksheet "Families", columns A, B and C must be numerical (0 to 99999)

If you cannot locate the problem, you can send me your Excel file that cannot be loaded, for analysis.
Back to top
View user's profile Send private message
henryd



Joined: 12 Jul 2012
Posts: 25

PostPosted: Sat Jul 14, 2012 10:03 am    Post subject: Reply with quote

Solved! Thank you so much for your help.

Am I correct in assuming that it will not accept Excel 2007 (.xlsx) files?
Back to top
View user's profile Send private message
ale
Site Admin


Joined: 12 Apr 2005
Posts: 499
Location: Versailles, France

PostPosted: Sat Jul 14, 2012 5:31 pm    Post subject: Reply with quote

You are right, SmartGenealogy will not accept *.xlsx files directly.
However, if you rename your .XLSX file as .XLS (just suppress the X in the extension name), it should load properly into SmartGenealogy.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Forum Fortifications of the World Forum Index -> SmartGenealogy All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group