http://www.progenygenetics.com/community/ Progeny Community » Recent Posts en Sun, 05 Feb 2012 16:36:23 +0000 http://www.progenygenetics.com/community/topic/238#post-681 Fri, 03 Feb 2012 17:43:10 +0000 freeseek 681@http://www.progenygenetics.com/community/ <p>I want to import a table we have with information about samples. Though, the samples don't exist in Progeny, so they are not going to match anything pre-existing in the database. I would like for them being created. Is this possible? Or do I have to create them first one by one and then import the data? </p> http://www.progenygenetics.com/community/topic/182#post-675 Wed, 01 Feb 2012 13:00:16 +0000 Toby McHenry 675@http://www.progenygenetics.com/community/ <p>So just to be clear, although I am getting more frequent successes with the "local" db over the "network" db, I am still seeing this problem occur even on the local db. Thanks!! </p> http://www.progenygenetics.com/community/topic/182#post-674 Mon, 30 Jan 2012 13:26:00 +0000 Toby McHenry 674@http://www.progenygenetics.com/community/ <p>Thanks! Another note: I am having the same problem viewing large numbers of errors in the Discrepancy Report tab too. Ideally I'd like to be able to see several hundred thousand in one report. Even when using the "local" version of our database, I seem limited in the number of errors I can view. I can get a report with 30K DEs to show up in the "local" db (though sometimes I have to try 3 or 4 times to get all 30K), but I can't seem to get even 100K to work, let alone the 600K I have total. </p> http://www.progenygenetics.com/community/topic/182#post-673 Mon, 30 Jan 2012 11:31:58 +0000 Conrad Brammer 673@http://www.progenygenetics.com/community/ <p>Understood. In that case, we can try replicating this problem via the "Network Connection" rather than locally. I'll pass this information along to the developers, and let you know if that is enough to isolate the issue. </p> http://www.progenygenetics.com/community/topic/182#post-672 Wed, 25 Jan 2012 12:37:50 +0000 Toby McHenry 672@http://www.progenygenetics.com/community/ <p>Hi again,</p> <p>Just to clarify, the "local" copy I mentioned is still accessed over one of our network drives, it's not housed on my local machine. </p> <p>So Lance says, "So really the difference is that it was not using the database engine (server/client). So not a network transport issue rather a server database service issue. Just trying to sort out where the problem may lie." </p> http://www.progenygenetics.com/community/topic/182#post-671 Wed, 25 Jan 2012 10:48:52 +0000 Toby McHenry 671@http://www.progenygenetics.com/community/ <p>Hi Conrad,</p> <p>I believe you have our db now. We have upgraded our server to 4GB of RAM and my machine to 2GB of RAM as suggested. Even after the upgrades, I am still having the same problem producing the full ME report with 38,070 entries. However, I found something interesting. We recently made a local copy of our network database for me to use offline, and though I am still seeing this problem on the network db, I was able to generate the full ME report when logged into the local copy. Maybe this issue has something to do with the network?</p> <p>Thanks,<br /> Toby </p> http://www.progenygenetics.com/community/topic/232#post-670 Tue, 24 Jan 2012 18:23:10 +0000 Conrad Brammer 670@http://www.progenygenetics.com/community/ <p>Additionally, Progeny 7 will tell you what you have directly on the login screen. When you launch Progeny, BEFORE you login, you will see CLINICAL, LAB and/or LIMS in the upper right hand corner. </p> <p>If you are still unsure, feel free to call support and give them your serial number and someone will be able to tell you exactly what you have. </p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/232#post-669 Tue, 24 Jan 2012 16:58:53 +0000 Sean 669@http://www.progenygenetics.com/community/ <p>The simplest way to tell is by looking at the available modules on the left-hand side of the screen. </p> <p>If you have Progeny Clinical, you should only see available modules for Pedigrees, Individuals, Samples, Fields, and Tasks.</p> <p>If you have Progeny Clinical + Lab, you will see all the modules listed above plus Markers, Genotypes, and Analysis. </p> http://www.progenygenetics.com/community/topic/232#post-668 Tue, 24 Jan 2012 16:03:42 +0000 gregm 668@http://www.progenygenetics.com/community/ <p>Hi, </p> <p>How can I determine which version of Progeny (clinical vs lab) we have installed? The "about" menu option just says it is Progeny 7.6.04. There was some talk here we might have clinical+ or something (if there is such a thing). The information was requested by a collaborator's database manger. </p> <p>thanks </p> http://www.progenygenetics.com/community/topic/231#post-667 Wed, 18 Jan 2012 11:23:35 +0000 Benjamin Fey 667@http://www.progenygenetics.com/community/ <p>Hi Conrad,</p> <p>I'm currently running Progeny 8.2.00.</p> <p>I sent you an email with the attached field txt export as you requested.</p> <p>Thanks,</p> <p>Ben </p> http://www.progenygenetics.com/community/topic/231#post-666 Fri, 13 Jan 2012 13:20:12 +0000 Conrad Brammer 666@http://www.progenygenetics.com/community/ <p>Hello Benjamin, </p> <p>There is no problem with running computed fields on spreadsheets in this manner. I'd like you to do two things for me to help isolate this issue:</p> <p>1. Can you indicate the exact version you are running? If you are not on the current version 8.2.00, please update to the current version and see if the problem persists. If it does, go on to step #2.<br /> 2. Send me a copy of your computed fields (NOTE: this will only send the computed definition and build any dependent fields exactly as you have them. It will not send any data.) To do this, follow these steps:<br /> - Go into the Fields tab and locate the computed field (or computed fields) causing the problem on your spreadsheet.<br /> - Select (highlight) the field(s) and select "Fields | Save Fields as txt | Save selected fields" and save that file to your desktop. Attach that field to your email as well.</p> <p>Send that email directly to me or to support and just say address the email to me. </p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/182#post-665 Fri, 13 Jan 2012 13:01:54 +0000 Conrad Brammer 665@http://www.progenygenetics.com/community/ <p>Hello Toby, </p> <p>Your database server is running on the bare minimum of 2 GB of RAM (<a href="http://www.progenygenetics.com/lab/requirements.html)" rel="nofollow">http://www.progenygenetics.com/lab/requirements.html)</a>. Client/Server software depends as much on the RAM of your PC, which is 1GB (also the bare minimum), as it does the server machine. Given the size of your database, you really should have about 4 GB of RAM on your server machine and 2GB of RAM on your PC. </p> <p>This appears to be the root cause in both issues. If you can send us your database file, we can run diagnostics during the exports to look for any memory leaks. We have not seen any with error reports of over 100,000 MEs. If we are unable to reproduce the issue with your database, I would recommend upgrading your hardware with additional RAM. Please contact me directly or contact support in regard to sending a copy of your database, and we'll get that tested as soon as possible. </p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/231#post-664 Thu, 12 Jan 2012 17:37:40 +0000 Benjamin Fey 664@http://www.progenygenetics.com/community/ <p>When I add one of my computed fields to a spreadsheet format and subsequently run that spreadsheet, I am getting a database error and the sheet stops populating after about 100 entries. I know that there should be &gt;3000 entries. The computed field is very simple and shouldn't be overly-taxing to calculate:</p> <p>YEARDIF({Patient Demographics\Date of Birth},{Patient Demographics\Date of Diagnosis})</p> <p>where "Date of Diagnosis" is calculated by another simple formula:</p> <p>YMD( {Patient Demographics\Year of Diagnosis}, 06, 01 )</p> <p>The fields are correctly calculated when I view them as a part of the Individual Datasheets. Is there a conflict in having the two computed fields nested like this? The error popup says "A database error prevented the data from being retrieved." </p> http://www.progenygenetics.com/community/topic/220#post-663 Thu, 12 Jan 2012 11:37:38 +0000 Conrad Brammer 663@http://www.progenygenetics.com/community/ <p>Hello Guy, </p> <p>We have a trigger for you to record this information during a reaction. I will email you directly to arrange a desktop session. </p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/182#post-662 Wed, 11 Jan 2012 12:26:34 +0000 Toby McHenry 662@http://www.progenygenetics.com/community/ <p>I am still experiencing trouble viewing my large ME report, and this is frustrating. The behaviour of Progeny is non-deterministic as well. When trying to view the 38,000 MEs, sometimes I see no MEs showing up in the report, and sometimes Progeny starts processing errors (i.e. 100 of 38000, etc) and quits at various points (sometimes after a few hundred, sometimes after a few thousand, though it never seems to get more than halfway through the report).</p> <p>We hope to be importing more GWAS data soon, and I am very concerned about scaling issues here with C1526. I am also concerned about the scaling issues submitted in request C1529. Thanks. </p> http://www.progenygenetics.com/community/topic/230#post-661 Wed, 11 Jan 2012 10:26:53 +0000 Toby McHenry 661@http://www.progenygenetics.com/community/ <p>Thanks, that would be helpful for large data sets. </p> http://www.progenygenetics.com/community/topic/230#post-660 Tue, 10 Jan 2012 09:41:14 +0000 Conrad Brammer 660@http://www.progenygenetics.com/community/ <p>Hello Toby, </p> <p>This option is not available for custom genotype exports, but I'd be happy to log this as a request for you. </p> <p>Tracking ID for this request is: C1557</p> <p>Thanks, </p> <p>Conrad </p> http://www.progenygenetics.com/community/topic/230#post-659 Fri, 06 Jan 2012 13:00:56 +0000 Toby McHenry 659@http://www.progenygenetics.com/community/ <p>I don't see any way to break a custom export into multiple output files (i.e. by chrom or per N number of markers). Is this option available for custom genotype exports?</p> <p>Thanks! </p> http://www.progenygenetics.com/community/topic/181#post-658 Wed, 04 Jan 2012 13:38:02 +0000 Toby McHenry 658@http://www.progenygenetics.com/community/ <p>I just emailed the screenshots. I will try to download and test Cute PDF too, but I hope we can get a fix to work with Adobe, since I think that is our standard PDF printer. I'll update again when I've tried the other PDF printer. Thanks! </p> http://www.progenygenetics.com/community/topic/181#post-651 Mon, 19 Dec 2011 15:36:23 +0000 Conrad Brammer 651@http://www.progenygenetics.com/community/ <p>Hello Toby, </p> <p>We are continuing to have difficulties reproducing this issue with the PDF printing. The biggest problem is that we don't have a copy of Adobe Acrobat 9 Pro and are unable to produce this issue with any other of the PDF printing softwares we do have. One thing that would help would be if you could reproduce this issue with another of those programs. There are a number of freeware print to PDF programs that you could use. The two that we have used for testing this issue are Foxit Reader (first item on this page: <a href="http://foxitsoftware.com/downloads/)" rel="nofollow">http://foxitsoftware.com/downloads/)</a> and Cute PDF (<a href="http://cutepdf-writer.en.softonic.com/download)" rel="nofollow">http://cutepdf-writer.en.softonic.com/download)</a>. Would you be able to download one of these programs and see if you can reproduce the same issue? Cute PDF would be the most convenient as I have that on my own PC. </p> <p>Additionally, if you can take a screen shot of your entire screen the moment you get that error message that would be very helpful as well. Please email the screen shot to my email account with the subject "C1537".</p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/221#post-649 Mon, 12 Dec 2011 13:23:53 +0000 Conrad Brammer 649@http://www.progenygenetics.com/community/ <p>Hello Tokhir, </p> <p>I've submitted this request for you to our developers to take a look at why that date is not displaying as expected. I will notify you on this thread when I receive feedback from them. </p> <p>Issue Tracking ID = C1540</p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/220#post-648 Mon, 12 Dec 2011 12:22:28 +0000 Conrad Brammer 648@http://www.progenygenetics.com/community/ <p>Hello Guy, </p> <p>I will need to run this by one of our developers to see if we can do this with a computed field. It would likely need to be based off a specific reaction, so you would want to make sure this reaction is unique to that particular action (if the reaction were to be included in another action for instance this wouldn't work). </p> <p>I'll go ahead and get this submitted now and let you know the moment this has been addressed. We may need to gather additional info such as the reaction ID of the action you want to use for the trigger, which you can access via Sybase Central. </p> <p>Issue Tracking ID = C1539</p> <p>I'll let you know when I hear back.</p> <p>Thanks </p> http://www.progenygenetics.com/community/topic/222#post-647 Wed, 07 Dec 2011 07:51:59 +0000 Tokhir Dadaev 647@http://www.progenygenetics.com/community/ <p>Addition of Console option into IndivSS/PedigreeSS, where user could enter basic SQL statements.</p> <p>Computed Field Editor - Computed Field Definition window could be improved, it is very basic. It is OK if the definition is couple of lines, but once I start using multiple nested IFs/CASEWHENs or SELECT statements then it is hard to keep track of things.<br /> - make the window resizable<br /> - when Test button is clicked - autoformat. example - <a href="http://www.dpriver.com/pp/sqlformat.htm" rel="nofollow">http://www.dpriver.com/pp/sqlformat.htm</a></p> <p>Bugs on Computed Field Editor?<br /> - When creating computed field in Individual level, Data Folders does not show Pedigree summary fields<br /> - When I am e.g. in Query folder, then right click to create computed field. In Editor if I drag and drop a field from Personal folder, then click Add. The field is created in Personal folder not in Query folder. </p> http://www.progenygenetics.com/community/topic/221#post-646 Tue, 06 Dec 2011 13:27:01 +0000 Tokhir Dadaev 646@http://www.progenygenetics.com/community/ <p>I have a date field in DD/MM/YYYY format. I want to create a computed field that would show the same date in YYYY/MM/DD? 111 is a JAPAN date code for YYYY/MM/DD (<a href="http://www.comsci.us/sybase/date_fmt.html)" rel="nofollow">http://www.comsci.us/sybase/date_fmt.html)</a>, so I have created a computed field as:</p> <p><code>CONVERT(datetime, {Personal\P DOB}, 111)</code></p> <p>but it still shows the date as DD/MM/YYYY when I run a IndivSS. </p> http://www.progenygenetics.com/community/topic/214#post-645 Tue, 06 Dec 2011 13:08:31 +0000 Tokhir Dadaev 645@http://www.progenygenetics.com/community/ <p>Right click on the folder with pedigrees that are not UL.<br /> Select "Copy Features to Folder..."<br /> Select your pedigree with UL.<br /> Tick features you want to copy. I think you need to tick "Customize Options".<br /> Then OK. </p> http://www.progenygenetics.com/community/topic/220#post-644 Mon, 05 Dec 2011 16:30:14 +0000 guyygarty 644@http://www.progenygenetics.com/community/ <p>I would like to add a calculated field to a sample, that shows the time/date 44h after a reaction is executed (or after a workflow stage is executed). Is there any way to access the info in the sample Audit? If not, is there a way to route the current date and time into a static field?<br /> guy </p> http://www.progenygenetics.com/community/topic/182#post-643 Mon, 05 Dec 2011 11:10:42 +0000 Toby McHenry 643@http://www.progenygenetics.com/community/ <p>Hi Conrad,</p> <p>Yes, I am having problems viewing the full set of errors in the "Mendelian Errors" tab in the bottom pane in the "Genotypes" section.</p> <p>My machine has 1GB of RAM and is Windows XP 32-bit. Rebecca's machine has 3.25 GB of RAM and has the same problem. When I just tried viewing the ME report on her machine and requested 38,000 ME's (or even 10,000 ME's), no errors showed up at all. The little window that pops up to show the count of errors being processed (i.e. 100 of 38000, etc) flashed for just a split-second and then was gone with no errors showing up in the report.</p> <p>The server has 2GB and runs Windows Server 2003 32-bit.</p> <p>Thanks! </p> http://www.progenygenetics.com/community/topic/219#post-642 Mon, 05 Dec 2011 05:26:54 +0000 Anonymous 642@http://www.progenygenetics.com/community/ <p><a href="http://www.themobilityresource.com/">Adaptive Equipment</a><br /> - Offers adaptive equipment including handicap accessible vans, scooter lifts, swivel car seat, wheelchair carriers and wheelchair vehicles. </p> http://www.progenygenetics.com/community/topic/218#post-641 Mon, 05 Dec 2011 02:26:39 +0000 Anonymous 641@http://www.progenygenetics.com/community/ <p><a href="http://www.watsons.com/pool-supplies.html">Pool Chemicals</a><br /> <br /> Watson's of Cincinnati is a toy store for adults offering above ground pools, pool supplies, Envisions Home Theater electronics, home theater furniture, casual patio furniture, spas &amp; hot tubs etc. </p> http://www.progenygenetics.com/community/topic/217#post-640 Sat, 03 Dec 2011 07:49:37 +0000 Anonymous 640@http://www.progenygenetics.com/community/ <p><a href="http://www.watsons.com/pool-supplies.html">Pool Supplies</a> -Watson's of Cincinnati is a toy store for adults offering above ground pools, pool supplies, Envisions Home Theater electronics, home theater furniture, casual patio furniture, spas &amp; hot tubs etc. </p> http://www.progenygenetics.com/community/topic/216#post-639 Fri, 02 Dec 2011 06:30:09 +0000 Anonymous 639@http://www.progenygenetics.com/community/ <p><a href="http://www.danmer.com/shutters/shutters.asp">Shutters</a> - Custom built . Over 30 years of shutter experience. Free in-home consultations. </p> http://www.progenygenetics.com/community/topic/215#post-638 Fri, 02 Dec 2011 06:24:21 +0000 margaretbechly 638@http://www.progenygenetics.com/community/ <p><a href="http://www.danmer.com/windowcoverings/blinds.asp">Window Blinds</a> - Custom built . Over 30 years of shutter experience. Free in-home consultations. </p> http://www.progenygenetics.com/community/topic/214#post-637 Thu, 01 Dec 2011 23:56:05 +0000 ERamigenics 637@http://www.progenygenetics.com/community/ <p>I know that you can change the proband arrow in the properties of each pedigree, but is there a way to change it to a default UL position for every pedigree in a folder? It's very frustrating to have to change each time I add a pedigree. Thanks! </p> http://www.progenygenetics.com/community/topic/122#post-636 Thu, 01 Dec 2011 23:52:39 +0000 ERamigenics 636@http://www.progenygenetics.com/community/ <p>Totally agree. The arrows were a much quicker and more reliable way to add. Thanks! </p> http://www.progenygenetics.com/community/topic/182#post-635 Wed, 30 Nov 2011 12:20:53 +0000 Conrad Brammer 635@http://www.progenygenetics.com/community/ <p>Hello Toby, </p> <p>I have received feedback from our developers, but they are unable to reproduce any errors. Are you experiencing these issues when you try to view the errors in the "Mendelian Errors" tab in the bottom pane of the "Genotypes" section of the software?</p> <p>If the problems are inconsistent, it might indicate that this an issue with your PC. Can you identify how much RAM you have on your PC and if possible the amount of RAM (dedicated RAM if applicable) on your server machine?</p> <p>At the moment, the developers are asking for more information before they can isolate any issues here. </p> <p>Thanks </p>