[Babase] Fecal Update
Lacey Maryott
lacey.maryott at duke.edu
Thu Jul 19 16:24:08 EDT 2007
Karl,
I am having some trouble putting this data in. This is the error I
am getting:
Import error on line 273: Line does not possess the correct number of
columns.
but it is a csv file, and I looked through it in excel and I can't see
that any line around that number has too many columns etc. Is this an
error you are familiar with?
Lacey
Laurence wrote:
> Thanks a lot Lacey and Karl!
> Laurence
>
> Lacey Maryott wrote:
>> Hello All,
>> Karl and I just spent roughly 90 minutes figuring out the commands
>> together (and Karl teaching me how to do things), but we are at the
>> stage where I can go ahead and put the new data into the fecal
>> tables. The only hold up now is that, as I pointed out earlier today
>> in an e-mail to the list, the export and import buttons have
>> disappeared from this newest version of PPA. Karl is working on the
>> issue as I write this e-mail and hopes to have it resolved soon at
>> which point I will put the new data into tmprep2 and tmpresults. For
>> right now, these tables are unusable, as this transition happens (you
>> could use them, but don't trust them) But as soon as the most updated
>> information is in these tables, I will let everyone know! :) This
>> should be completed by days end! :)
>>
>> Lacey
>>
>> Laurence wrote:
>>> Hello Lacey,
>>>
>>> Thanks so much for taking care of the fecal tables for me. Let me
>>> know if you have any questions or if I can help you in any way.
>>> Laurence
>>>
>>> lacey.maryott at duke.edu wrote:
>>>> Quoting lacey.maryott at duke.edu:
>>>>
>>>>>
>>>>> Quoting "Karl O. Pinc" <kop at meme.com>:
>>>>>
>>>>>>
>>>>>> On 07/18/2007 02:17:28 PM, lacey.maryott at duke.edu wrote:
>>>>>>> Ok, I'm going to go ahead and create a backup of the fecal schema,
>>>>>>> empty it,
>>>>>>> restore it? (right?) to make sure restore works, empty it again and
>>>>>>> then insert
>>>>>>> the updated data. Karl is this what you had in mind?
>>>>>>>
>>>>>>> also, for the restore am I using something like:
>>>>>>>
>>>>>>> $ pg_restore --file fecalbackup.custom --host=localhost
>>>>>>> --schema=fecal
>>>>>>> --data-only --user lmaryott babase
>>>>>>>
>>>>>>> This is a combination of what i found in the Postgres
>>>>>>> documentation,
>>>>>>> and the
>>>>>>> backup documentation on the Wiki... (Probably a less than accurate
>>>>>>> procedure..
>>>>>>> but a first shot anyway)
>>>>>>
>>>>>> That all sounds good.
>>>>>>
>>>>>> But I was thinking you'd restore it somewhere else just so
>>>>>> you'd keep the data you already have in case there's a problem.
>>>>>>
>>>>>> (If you don't use --data-only on the backup then the restore
>>>>>> will re-create the file for you.)
>>>>>>
>>>>>
>>>>> Ok, where would be a good place to stick it? I'm guessing this
>>>>> data has no
>>>>> validation, since it is just in its own schema at this point, so
>>>>> would
>>>>> restoring it into my schema work? Oh and by the by... did I
>>>>> really get that
>>>>> command right on the first try??? hahaha if so I never fail to
>>>>> amaze myself!
>>>>>
>>>>
>>>>
>>>> This is why I shouldn't work at night, hahaha... I can't restore a
>>>> schema into a
>>>> schema, can I? This just occurred to me as I sat here thinking
>>>> about what to do
>>>> next. Karl, could we maybe have a phone call tomorrow? I'm just
>>>> needing to
>>>> clarify a few things I think. Thanks :)
>>>>
>>>>> Lacey
>>>>>
>>>>>> Karl <kop at meme.com>
>>>>>> Free Software: "You don't pay back, you pay forward."
>>>>>> -- Robert A. Heinlein
>>>>>>
>>>>>> _______________________________________________
>>>>>> Babase mailing list
>>>>>> Babase at www.eco.princeton.edu
>>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Babase mailing list
>>>>> Babase at www.eco.princeton.edu
>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Babase mailing list
>>>> Babase at www.eco.princeton.edu
>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>
>>> _______________________________________________
>>> Babase mailing list
>>> Babase at www.eco.princeton.edu
>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>
>>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
--
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list