http://www.progenygenetics.com/community/ Progeny Community » Tag: cancer diagnosis in import - Recent Posts en Sat, 31 Jul 2010 03:30:03 +0000 http://www.progenygenetics.com/community/topic/53#post-105 Thu, 09 Jul 2009 15:26:31 +0000 Lianne Mink 105@http://www.progenygenetics.com/community/ <p>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.</p> <p>I can also answer your SQL questions via email: <a href="mailto:support@progenygenetics.com">support@progenygenetics.com</a></p> <p>I look forward to discussing this with you further. </p> http://www.progenygenetics.com/community/topic/53#post-104 Thu, 09 Jul 2009 14:33:31 +0000 Greg M. Silverman 104@http://www.progenygenetics.com/community/ <p>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! </p> <p>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?</p> <p>Thanks again!</p> <p>Greg-- </p> http://www.progenygenetics.com/community/topic/53#post-103 Thu, 09 Jul 2009 12:27:40 +0000 Greg M. Silverman 103@http://www.progenygenetics.com/community/ <p>Hi Lianne,<br /> 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..</p> <p>Any suggestions?</p> <p>P.S. Is there some kind of SQL interface outside of Progeny in which I can write SQL scripts to move data about?</p> <p>Thanks very much in advance!</p> <p>Greg-- </p>