1. 

   Greg M. Silverman
   

   Member
   Posted Jul 9, 2009 #

   Hi Lianne,
   So far so good in the importing of our data into Progeny for the generation of pedigrees. However, I've run into a problem when trying to get data into the cancer diagnosis table. In a nutshell, it isn't working. I've tried doing it as the cancer description string (I have made sure the string that is in the file being imported is in the ICD table), as the icd code, etc., but the data are not being imported into this field. I have also tried adding diagnosis date, again with no luck..

   Any suggestions?

   P.S. Is there some kind of SQL interface outside of Progeny in which I can write SQL scripts to move data about?

   Thanks very much in advance!

   Greg--
2. 

   Greg M. Silverman
   

   Member
   Posted Jul 9, 2009 #

   Mea culpa. The data did get imported. I was just accessing it through the Cancer History table. A direct query to Cancer Diagnosis showed it was there!

   The second part of my question though is still open: Is there some kind of SQL interface outside of Progeny in which I can write SQL scripts to move data about?

   Thanks again!

   Greg--
3. 

   Lianne Mink
   

   Progeny Staff
   Posted Jul 9, 2009 #

   Thanks for your post Greg! It seems like you probably imported the diagnosis data into the flat field for diagnosis instead of the table field. All table field data must be imported in through the spreadsheet import. Only flat fields (those fields not in a table) are able to be imported into Progeny using the import module. If you have additional questions on your specific import, I would be happy to answer them via email.

   I can also answer your SQL questions via email: support@progenygenetics.com

   I look forward to discussing this with you further.

Reply

You must log in to post.