Data issues printing summary for a non-profit - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail Suite 7 » PrintShop Mail Design » Data issues printing summary for a non-profit

Topic Options

#54480 - 01/20/17 06:22 PM Data issues printing summary for a non-profit
MPW OL Newbie Registered: 01/20/17 Posts: 1	This nonprofit has donors who typically make 30 to 90 contributions a year. To place all this gift information (date, amount, gift purpose, etc) in a flat database would exceed the 255 field limitation of data programs. Is this an issue beyond PSM's capabilities?
Top

#54492 - 01/25/17 04:31 AM Re: Data issues printing summary for a non-profit [Re: MPW]
MartinS OL Guru Registered: 08/06/12 Posts: 142 Loc: Munich	If you mean number of columns in a csv file, then yes this is a limitation of the software.
Top

#54506 - 02/01/17 01:57 PM Re: Data issues printing summary for a non-profit [Re: MPW]
SanderO OL Newbie Registered: 03/25/13 Posts: 12	Instead of having a separate field for each piece of information for a donation, You could have a single field made up of all of the fields (formatted with a fixed length) concatenated. (Date......Dollars...Reason....................). Then you could split the field with MID(). This would allow for 200 donations easily.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre