http://www.progenygenetics.com/community/ Progeny Community » Forum: General Discussion - Recent Posts en Sat, 31 Jul 2010 03:28:47 +0000 http://www.progenygenetics.com/community/topic/72#post-156 Wed, 30 Jun 2010 17:45:27 +0000 Daniel Mariani 156@http://www.progenygenetics.com/community/ <p>I just realize the problem. The default value of one field was in conflict with the mask of the same field. </p> http://www.progenygenetics.com/community/topic/72#post-155 Wed, 30 Jun 2010 17:31:10 +0000 Daniel Mariani 155@http://www.progenygenetics.com/community/ <p>When I try to add a new individual (for example: John) It appears the message "John was not added".<br /> What should I do to fix that? </p> http://www.progenygenetics.com/community/topic/67#post-152 Tue, 29 Jun 2010 15:03:24 +0000 Emily James 152@http://www.progenygenetics.com/community/ <p>I agree, my colleagues who used the older version found that data entry was easier when the pedigree and spreadsheet could be tiled.</p> <p>An option to select multiple individuals and change the vital status at one time would also be helpful. </p> http://www.progenygenetics.com/community/topic/70#post-151 Tue, 11 May 2010 09:20:35 +0000 Lianne Mink 151@http://www.progenygenetics.com/community/ <p>In Progeny, you can click on the Indiv SS button on the toolbar to create a spreadsheet. I would recommend using the System Field, Global ID, in your spreadsheet in addition to the other fields that you wish to see. Then click Run. You will see one row per individual in this spreadsheet when it populates. You can now click the Export button on the toolbar to export the data out of Progeny. Save the data in text tab delimited form. This can be opened by Excel. Name the file and save it to your pc. Now you can open that file in Excel and manipulate the data. The file must be saved in the tab delimited format in order to import back into Progeny. In Progeny you can run the same spreadsheet again then click the Import button and select the file that you were working with. You will have 1 column (the global ID) that will match during the import, then it will dump the rest of the data based on your column order. After you have imported the file, you must click Save to save the changes. If you are not satisfied with the import, then you can close the spreadsheet to ignore the changes.</p> <p>If you have questions specific to the data export/import that you are working with, feel free to send an email to support for more assistance! </p> http://www.progenygenetics.com/community/topic/70#post-150 Tue, 11 May 2010 00:01:56 +0000 Alicia 150@http://www.progenygenetics.com/community/ <p>I woul like to run a spread sheet from a simple database. I would like to be able to open it in excel enter data then upload it back in to progeny. Could you explain if this is possible details on how? </p> http://www.progenygenetics.com/community/topic/69#post-149 Mon, 03 May 2010 13:05:45 +0000 Lianne Mink 149@http://www.progenygenetics.com/community/ <p>Yes, there is a way to do this by creating a computed field. Keep in mind that since your assessment date will be in a table, the computed field MUST be added to the table as well. Otherwise, it will not work properly.</p> <p>Create a new field. Name the field and select the type as 'Computed'. </p> <p>The computed field expression will be similar to this:<br /> DATE(MONTHS({Field}, 3))</p> <p>Note; To get your {Field} name, you will need to drag the assessment date field to the computed field expression box.<br /> Click 'Test' to make sure that the expression is OK. Then click 'Add'. </p> <p>Now add this computed field to your table field. The 3 month date follow up date will automatically appear in the table for you to view. </p> http://www.progenygenetics.com/community/topic/69#post-148 Thu, 29 Apr 2010 20:29:43 +0000 Alicia 148@http://www.progenygenetics.com/community/ <p>Is there a way to automatically calculate a date 3 months from a specified date. I am trying to make a table with an inital assesment date then automatically fill in a 3 month follow up date. </p> http://www.progenygenetics.com/community/topic/67#post-147 Fri, 23 Apr 2010 11:26:21 +0000 genrox 147@http://www.progenygenetics.com/community/ <p>This would be a very nice function as it will be easier also for choosing individuals to genotype in large pedigrees, considering their position and affection status. </p> http://www.progenygenetics.com/community/topic/68#post-145 Thu, 15 Apr 2010 05:58:19 +0000 Samuel Domingo 145@http://www.progenygenetics.com/community/ <p>THANK YOU FOR THE ANSWER</p> <p>Contact you BY MAIL </p> http://www.progenygenetics.com/community/topic/68#post-144 Wed, 14 Apr 2010 12:08:16 +0000 Lianne Mink 144@http://www.progenygenetics.com/community/ <p>Hi Samuel! This field may be a little more complicated to create. I will contact you via email to help you further. </p> http://www.progenygenetics.com/community/topic/68#post-143 Wed, 14 Apr 2010 10:10:06 +0000 Samuel Domingo 143@http://www.progenygenetics.com/community/ <p>HI</p> <p>I wanted to create a field to rename the pedigrees in progeny</p> <p>I have a set of nomenclature for such families (0001-X,0002-X,0003-X,.....0159-X)</p> <p>but in cases whose family comes from a specific center, I want to rename</p> <p>for example if the family (0003-X,0008-X,0022-X) have been the "center-one"</p> <p>I name them in a new field as (0003-X = 0001-Y , 0008-X=0002-Y ,0022-X=0003-Y ...)</p> <p>occurred to me to do so but that function does not calculate the maximum number of pedigrees or nº pedigrees that have the value "center one"</p> <p>IF</p> <p>{prueba\CENTER}='center one'</p> <p>THEN</p> <p>INSERTSTR(0,'-F',LEFT(MAX{Pedigree name},4)+1)</p> <p>ELSE<br /> ''<br /> ENDIF</p> <p>best regards and sorry for my english </p> http://www.progenygenetics.com/community/topic/67#post-142 Thu, 04 Mar 2010 11:39:49 +0000 jamie-lheureux 142@http://www.progenygenetics.com/community/ <p>I agree. Being able to tile windows in progeny would be very useful. It seems like it would be a good way to compare two pedigrees to each other, do data entry while looking at the pedigree etc. </p> http://www.progenygenetics.com/community/topic/67#post-141 Tue, 02 Mar 2010 16:04:12 +0000 Lianne Mink 141@http://www.progenygenetics.com/community/ <p>I've had this request from other Progeny users as well. We are monitoring the popularity of this request in our database and would consider adding it to the software in the future if other users would also find it valuable. </p> <p>If there are other community members interested in this feature, please reply to this post! </p> http://www.progenygenetics.com/community/topic/66#post-140 Tue, 02 Mar 2010 12:49:54 +0000 Conrad Brammer 140@http://www.progenygenetics.com/community/ <p>Hello Betty, </p> <p>You can generate initials in a computed field based off the data fields "First Name", "Middle Name" and "Last Name", for instance, with the following computed field structure:</p> <p> substring({Demographics\First Name}, 0, 1) + substring({Demographics\Middle Name}, 0, 1) +<br /> substring({Demographics\Last Name}, 0, 1)</p> <p>Simply substitute the fields above (i.e. {Demographics\First Name}) with your own data fields and the computed field will take the first character from each field. </p> <p>Thanks for the question! </p> http://www.progenygenetics.com/community/topic/67#post-139 Tue, 02 Mar 2010 12:06:33 +0000 Kate 139@http://www.progenygenetics.com/community/ <p>Hi,</p> <p>An older version of Progeny would allow you to view a pedigree and data spreadsheet simultaneously. This made data entry much faster; name, age, dx, smoking status, whatever. </p> <p>A new function that would be helpful would be the ability to select multiple individuals in the pedigree and change the vital status of all at one time.</p> <p>Any chance of returning/adding these functions?<br /> Kate </p> http://www.progenygenetics.com/community/topic/66#post-138 Mon, 01 Feb 2010 18:42:12 +0000 Betty 138@http://www.progenygenetics.com/community/ <p>I currently have pedigrees created in Progeny, with peoples' names listed. Is there a way to create a field to just list these peoples' initials (rather than their full name)? If yes, is there a way to set-up the field so that it can take the full names to automatically generate the initials (instead of having to manually type in the intials of every single person on the pedigrees)? Any help/advice would be greatly appreciated. Thanks in advance! </p> http://www.progenygenetics.com/community/topic/35#post-137 Wed, 06 Jan 2010 13:44:59 +0000 Roger 137@http://www.progenygenetics.com/community/ <p>I guess a data dictionary feature "up front" would be useful.</p> <p>However, If you already use MS Access or some other front end to link to the Progeny database, it is easy to output the st_datadictionary table to a query or report. </p> http://www.progenygenetics.com/community/topic/64#post-131 Fri, 04 Dec 2009 12:02:53 +0000 genrox 131@http://www.progenygenetics.com/community/ <p>Thanks, I realize afterward that this was the way to do it! </p> http://www.progenygenetics.com/community/topic/64#post-129 Wed, 02 Dec 2009 16:07:45 +0000 Conrad Brammer 129@http://www.progenygenetics.com/community/ <p>The user name drop down on the login screen will populate any of the user names that have been entered for that computer. It works much like the "populate old searches" feature for search engines. All you need to do is type in her user name and log in one time. After that, her user name should populate in the drop down. </p> http://www.progenygenetics.com/community/topic/64#post-128 Wed, 02 Dec 2009 15:19:31 +0000 genrox 128@http://www.progenygenetics.com/community/ <p>I have a user that has not used the database for a while. We do not see her username in the dropdown field for the login. I have asked the user to change her password, her name did not appear; I have deleted her as a user and added her again (with all the settings she is allowed to), her name still did not appear. Do I forget something in the procedure? </p> http://www.progenygenetics.com/community/topic/61#post-120 Tue, 22 Sep 2009 10:53:10 +0000 librown 120@http://www.progenygenetics.com/community/ <p>I figured it out. I had to enter a pedigree into the new folder before copying features from another folder! Thanks, anyway. Lisa </p> http://www.progenygenetics.com/community/topic/60#post-119 Tue, 22 Sep 2009 09:56:06 +0000 librown 119@http://www.progenygenetics.com/community/ <p>Hi, I created a new folder and when I try to copy features to folder I get error message: Target folder is empty. Any thoughts? Thanks, Lisa </p> http://www.progenygenetics.com/community/topic/58#post-115 Fri, 21 Aug 2009 16:00:34 +0000 Lianne Mink 115@http://www.progenygenetics.com/community/ <p>We would love to hear your feedback on our first newsletter! Please post any comments or suggestions </p> http://www.progenygenetics.com/community/topic/55#post-110 Wed, 15 Jul 2009 16:00:08 +0000 Lauren S 110@http://www.progenygenetics.com/community/ <p>Thanks Lianne. I just looked back at the sample and it now appears correctly. I guess it just took some time for the change to go through. </p> http://www.progenygenetics.com/community/topic/55#post-109 Wed, 15 Jul 2009 15:53:28 +0000 Lianne Mink 109@http://www.progenygenetics.com/community/ <p>Thanks for your post Lauren!</p> <p>When you reopen the sample, are you referring to the tab that displays the sample name? A field on the sample datasheet? Please clarify.</p> <p>If you are a LIMS user, the barcode will not be renamed if you rename the sample. You can create an action in the database to update the barcode in this instance. </p> http://www.progenygenetics.com/community/topic/55#post-108 Wed, 15 Jul 2009 15:47:45 +0000 Lauren S 108@http://www.progenygenetics.com/community/ <p>I have a sample that is entered into progeny with the wrong label. I have tried to change this by editing the properties. I correct the sample name and select save at which point I get a message stating that the change has been successfully saved. When I re-open the sample however the sample appears with the old label. Any thoughts? </p> http://www.progenygenetics.com/community/topic/54#post-107 Thu, 09 Jul 2009 16:13:08 +0000 Lianne Mink 107@http://www.progenygenetics.com/community/ <p>Hi Greg! Please contact me via email and I can supply you with additional information. <a href="mailto:support@progenygenetics.com">support@progenygenetics.com</a> </p> http://www.progenygenetics.com/community/topic/54#post-106 Thu, 09 Jul 2009 16:11:09 +0000 Greg M. Silverman 106@http://www.progenygenetics.com/community/ <p>Hi Lianne,<br /> As we move towards production, I am looking at transferring data back and forth from our internal db to Progeny via XML.</p> <p>I was looking at the structure of the output XML from Progeny and am slightly confused as to how the data map to the fields. I looked through the schema as defined under the &lt;Database&gt; tag and nowhere is there a definition of mappings that says: "f35 data" maps to &lt;FIELD fieldname="Address 1" fieldtype="text" tabid="Demographics\"&gt;</p> <p>Thanks in advance!</p> <p>Greg-- </p> 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>