I have a client that requires all his financial data (held in multiple
related layouts) to be exported as a flat csv file to his accountant
every month so he can import it into his accounting software. I created
an 'export' script then listed every field from each layout that is
required along with the field name.
I may not have appreciated the actual issue here, however, using a few
looping copy and paste scripts could you not just create the necessary
'new' fields in the largest of the relational layouts and run those
scripts. This would have all the data in one layout then export that as
a csv file.
Lee
On 20/04/11 12:51 PM, Richard S. Russell wrote:
On 2011 Apr 19, at 18:24, Jonathan Fletcher wrote:
Alan Weiss says to fire 15% of your clientele every year. Sounds like
you've got your first really good candidate for that category.
It's easy for me to say I'd walk.
You're the one who has to decide, though.
Well, since I've been retired for over a decade, I do all my database
development /pro bono/ for worthy non-profit organizations, so it's
not as if I'd be throwing away any money, but in some ways that makes
it harder, because I feel I've let this group of good folx down by not
being able to meet their actual data needs.
OTOH, what they're asking for is a horrendous amount of work, even if
it would be something I enjoyed (as I normally DO enjoy building FMP
databases), and I suspect they'll spend the next 5 years kicking
themselves over the limitations of the system they're moving into.
This is very frustrating.
--
