Is it possible to request an Events > Events Places > create CSV filtered Place Name Report - without ending up with a column for notes?
I know I can delete the column once I have created the spreadsheet, but I am wondering if the profusion of material in my notes causes the following problem in the creation of the CSV filtered report:
The bulk of the report looks fine, but a few entries become "confused" and appear in further away right hand columns with a lot of blank lines in between so that instead of ending up with total 8 columns - the nine minus the notes - after I delete the notes column, I end up with 17 columns, the last of which is also notes, but columns 9 - 17 are spaced far apart with lots of blank lines in between them.
Spreadsheet has a total of 168 lines. The left columns 1-8 look very neat, an entry on every line.
I notice that there are only 4 entries in columns 9-17 and I see that they have parked themselves in a line (occupying columns 9-17) where columns 1-8 refer to the same place as they each do - so their placement isn't random.
Kind of a bother to clean up, although doable.
It also makes me wonder if I can trust the information...
Anyone else having this problem?
My CSV report goes to Numbers, not Excell.
(March 31, 2011 I changed title of this post. It initially and erroneously referred to "sources" report. It should refer to "Place Names report" as I have now corrected it! Sorry!
Kirsten)
Leave notes out of Place Names report?
Leave notes out of Place Names report?
Last edited by Kirsten on Fri Apr 01, 2011 4:14 am, edited 2 times in total.
-
- Posts: 328
- Joined: Sun Oct 19, 2008 7:12 pm
- Location: Cornwall, England
Hi Kirsten,
I have just run the report on my database and there is no option to exclude the Notes.
However, I did not have the problems you describe - all my data goes into columns 1-9
I tried this on both Numbers and Excel without any data in later columns. Excel will spill the data over later columns if there is no content but the column width can be adjusted to compensate. Numbers only puts in 9 columns for me.
I wonder if you have imported the .csv file using some parameters that is putting a new row in when there is a new line character (/n) in the file as these occur in the multiline notes fields.
I opened the .csv with Numbers and it took it with out having to set any variables.
Hope that helps,
Nigel
I have just run the report on my database and there is no option to exclude the Notes.
However, I did not have the problems you describe - all my data goes into columns 1-9
I tried this on both Numbers and Excel without any data in later columns. Excel will spill the data over later columns if there is no content but the column width can be adjusted to compensate. Numbers only puts in 9 columns for me.
I wonder if you have imported the .csv file using some parameters that is putting a new row in when there is a new line character (/n) in the file as these occur in the multiline notes fields.
I opened the .csv with Numbers and it took it with out having to set any variables.
Hope that helps,
Nigel
Nigel,NigelRichman wrote: I did not have the problems you describe - all my data goes into columns 1-9
I wonder if you have imported the .csv file using some parameters that is putting a new row in when there is a new line character (/n) in the file as these occur in the multiline notes fields. Nigel
I am absolutely delighted that you have a suggestion for the possible source of my problem - and so quickly.
Thank you very much. I will check this out soon.
Thanks to wonderful help on this forum I feel like I am making great strides in getting off to a good start.
That was exactly the problem! I located my five instances of new line character (/n) in note fields. As soon as those new line characters were removed, I had a very normal looking spreadsheet.NigelRichman wrote: a new line character (/n) in the file as these occur in the multiline notes fields.
Thank you, Nigel for taking the time to help me resolve this.
I feel happy to have discovered early on that it is not a good idea to put new line characters into the event note fields. Not hard to avoid...
Kirsten
-
- Posts: 328
- Joined: Sun Oct 19, 2008 7:12 pm
- Location: Cornwall, England
- Warwick Wilson
- Site Admin
- Posts: 495
- Joined: Sat Nov 15, 2008 12:36 am
- Contact: