1 reply to this topic

[Nettie]

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. 

 

 

[Renee Zamora]

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.