<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On May 2, 2007, at 4:30 PM, Karl O. Pinc wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">On 05/02/2007 12:19:29 PM, kfenn wrote:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Once the above changes/fixes occur, we have one more speedbump with FoxPro before we can move exclusively to PPA.<SPAN class="Apple-converted-space"> </SPAN>The new files of "old" census data that Jen Foreman has entered is in dbf form.<SPAN class="Apple-converted-space"> </SPAN>Karl says trying to do an upload of<SPAN class="Apple-converted-space"> </SPAN>this into PPA<SPAN class="Apple-converted-space"> </SPAN>is not going to be easy....the upload is best done in FoxPro.<SPAN class="Apple-converted-space"> </SPAN>I agree, but I can forsee that this update may generate a substantial number of new errors when we run through another conversion given that such a large bulk of data is replacing old data.</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The problem is in the new system's requirement that everything</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">be consistent all the time.<SPAN class="Apple-converted-space"> </SPAN>Simply deleting all the "old style"</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">census rows in preparation for replacing them with the actual</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">census data probably won't be allowed.<SPAN class="Apple-converted-space"> </SPAN>When the old rows are deleted</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">that will probably take individuals out of groups that other</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">parts of the database expect them to be in.</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV>OK thanks for this. I would like to talk about other options that will move us past foxpro quickly. For instance, it seems to me that any file created in foxpro should be infinitely translatable to other file formats; can we just "export" these files into some form that PPA can handle, and then holding off on uploading until all the data are entered? I think that I don't completely understand all the issues, so maybe a quick phone call is in order. I will try to call you later today to talk about this Karl. In the interests of time let's not try to do a whole conference call just yet, let's you and me explore options.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Susan</DIV><DIV><BR><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV></BLOCKQUOTE></DIV><DIV><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV>-----------------------------------------------</DIV><DIV>Susan Alberts, Dept. Biology, Duke University, Durham NC 27708. Phone 919-660-7272, Fax 919-660-7293. <A href="mailto:alberts@duke.edu">alberts@duke.edu</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN> </DIV><BR></BODY></HTML>