Jump to content


Photo

Custom Reports - Census Fact Census Family fact

Census Family Census

  • Please log in to reply
1 reply to this topic

#1 Nettie

Nettie

    Advanced Member

  • Members
  • PipPipPip
  • 1507 posts

Posted 23 November 2014 - 10:34 AM

Goal = To find all census records already in RM in one surname. 

  1. Created a custom report with Surname, Given, Record #, Census date, Census Family Date,
  2. Created a group of a Surname
  3. Generated the report
  4. saved to .rtf, then .txt
  5. both reports .rtf and .txt when copied into a spreadsheet, took the 2nd, 3rd & 4th date in the Census Date column and made them a new row, losing the Surname, Given, and R ecord #.
  6. Your statement that .txt will go into a spreadsheet, is not really valid.   :(

Remedy for 389 persons in the custom report.

  1. Saved it to a .rtf   put in word
  2. Created 4 more columns
  3. move all dates that were 2nd, 3rd, and 4th dates to new column
  4. Then was able to copy the file into a spreadsheet to make it work.

 

This needs to be fixed.   Took, total time, about an hour to figure out why, and how to make it work. Then moved all dates to a new column. 

 

Anyone else tried this and did you have the same issue. 

 

 


Genealogy:
"I work on genealogy only on days that end in "Y"." [Grin!!!]
from www.GenealogyDaily.com.
"Documentation....The hardest part of genealogy"
"Genealogy is like Hide & Seek: They Hide & I Seek!"
" Genealogists: People helping people.....that's what it's all about!"
from http://www.rootsweb....nry/gentags.htm
Using FO and RM since FO2.0 


#2 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 7084 posts

Posted 11 December 2014 - 01:03 PM

I finally had a chance to play with this. These are the settings I used when I opened the TXT file inside of Excel

 

Delimited

My data has headers

Delimiters is tab

Column data format - General

 

It imported in just fine. I think the difference is specifying the data has headers.


Renee
RootsMagic