Jump to content

List of Events report - problem printing memos longer than 250 chars to excel, CVS or txt files.

Recommended Posts

I've recently been trying to create a List of Events report that has memos with a length of more than 300 chars.


<> 1. My preference was for a spreadsheet, primarily as it would make formatting easier, but the TMG output only sends about 250 chars max for each cell, (this is for both excel v5 and CSV files).


I can understand excel v5, as I think that had a max of about 256 chars per cell. However, there should be no need to restrict a CSV file. I assume this also goes back to the time when the standard was for just 256 chars / cell. I get the same problem with a tab delimited text file.


%% I would like to raise this as a bug (or at least should be fixed for v8) in that there is no longer a need to restrict to 256 chars for EXCEL, CSV or delimited files.


<> 2. Next option was to a text file (not as useful without the above delimiters). Same problem of about 256 chars with the added problem of end of lines being inserted at position 107. This I can only assume is a reflection to very distant times (like 1970 mainframes; I knew them well) when most files were of FB format (fixed block).


%% Is there a way to alter the line length? Otherwise I would like to raise a bug for this (or at least should be fixed for v8).


Is there a workaround for either of the above, particularly point 1.


For point 2 I have a workaround with producing the output to an *.RTF file with monospace font of Courier new. However, the lack of some sort of delimiter makes formatting (e.g. Word macros) very difficult.


Jim Orrell

Share this post

Link to post
Share on other sites

I did some testing and found that this limit hasn't been resolved with the v8 development. And wrote a message requesting a solution.

Share this post

Link to post
Share on other sites

I was a bit worried I did not originally get a response to this, so thanks Jim B for requesting an "official" solution. Although I'm assured there is an official feature request/ bug list or whatever, it's a pity we can't see it!


Anyway in the meantime I have another workaround to help deliniate output to an *.RTF file.


If you look at this thread on Rootsweb, you should be able to apply the same principles.

Subject: [TMG] List of People Hyphen



Jim O

Share this post

Link to post
Share on other sites

Thanks Jim O, an interesting idea. I'll try it

Thanks Jim Byram for raising the issue with TMG, I do hope the issue gets solved for real at some point



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now