Genealogy Chat

Yes, I think it does ! So the original csv file is intact and your first page is type into another file called blank.xls in your "My Documents" folder ? Does that sound right to you ? Rick.

rick yes!!! hooray lol...thankyou so much,i was in despair susie ps..got any red wine left from your binge the other nite lmao susie

Got a drop of white in the fridge - shall we celebrate ? Right, so all you need to do is call the file after the name of the piece you are transcribing. Open up your blank.xls file with your data in it and click File, Save As and type the contents of cell A1 into the filename. For me this is RG91456. This will also leave your old blank.xls, but don't use that once you've successfully got your RGxxxx.xls file created. With me ? Rick.

rick i think so...lol white will be fine...cheers if i get any more hassle can i contact you again...please susie

Of course, no problem ! Are you OK what you need to do on page 2 ? You just carry on adding rows below page one - you change the page number every page and the folio number every 2 pages. I'll check this thread again later if you need more help. Rick ;-)

Hi Rick Can I pcik yor brains now? lol The cd's still not working properly but I thought I'd transcribe a bit anyway to get the hang of it. Do you know if there's another co-ordinator we can contact in the absence of Carol? By the way, I did everything you just explained to Susie but saved it as a CSV file. Is that ok? Jeanette

Just got an email from jo re co-ordinators. But I'd still like to know if the CSV file is ok. Cheers! Thanks Jo!

Hi Jeanette, Is Carol the co-ordinator for your census area then or are you just talking to her because of the GC connection. Mine's a bloke called Terry and hew sent me another contact's details too. I think all the co-ordinators are listed by area on the freecen site. Are you using Excel too ? Rick.

Hi Rick Carol is my co-ordinator - I'm doing the West Riding for now - but Jo has sent me the names of 2 people I can contact for help. My daughter informs me that I'm using works as it says microsoft works spreadsheet at the top of the page. Doh! Why didn't I see that? Jeanette the blind dinosaur!

Hi Jeannette, I don't know Works, but the principal should be the same. Open the downloaded blank.csv the format it and same as blank.??? where ??? is the file extension that Works uses. I would have thought that Works does this automatically - Excel does. Open blank.??? and start transcribing, but save it as RGxxxx.??? where RGxxxx is your piece number from cell A1. That was you still have your blank files if you ever need them again. I don't think you can actually do anything too wrong if you think about it though. If your data is going into the csv file, you're not losing your work and you can always get another blank file down from freecen. Does the formatting of the cells get preserved when you re-open the csz or do have to do it every time ? I have to hit the M4 now. Back Sunday if you need more help then ! Rick.

Hi Rick Yes the formatting of the cells is preserved. The reason I asked about the CSV file is cos I got the impression it had to be saved as one of these in order to send it off. Please correct me if I'm wrong. I've just about got the hang of it now after losing all 6 pages that I'd transcribed. lol. You live and learn. Have a good weekend and thanks for the help. Jeanette

Just got a couple of mins..... Karen are you after Susie and Ricks left over wine? LOL Well done Rick for your help, hope you keep looking! Take care every one, best wishes, Jo

nudging this up for Isobel

hi jo could you please tell me how i can transcribe for freecen as i would like to help and not got a clue how to start tanks tracey

Tracy I have mailed you re-Freecen, just thought i would help Jo out a bit as a fellow transcriber! Regards Ann,Doing 1861 for Darlington

Message for Tricia Tanner...... Got your email, but I'm having trouble replying. Have you got some sort of restriction on AOL as to who can send to you ? Rick.

Just nudging this up again. Have got my cd now, am doing 1861 Melton Mowbray, Leics, when I have figured it all out that is!!! My husband is going to help me with everything later I hope. He also says, like Rick, that you don't have to put SSCens onto a floppy. By the way Rick, have just been laughing my socks off at all your banter regarding enumerators. I haven't looked at my cd yet, am just going to. Lol! Lisa x

Hi Lisa, It helps to have a sense of humour as you'll find out ! How did you get on with it ? I've now finished the first 3 pages,but page 4 looks awful. Rick.

Hi Rick Mine is going swimmingly at the mo but I've had a look at the end of the cd and the writing is awful. How many pages do we have to do initially to have checked bafore we can carry on? Jeanette

Hi Jeanette, They suggest 5 pages. Glad you're flying along. You don't fancy a few pages of Devon 1861 do you? :-)