XML (not strictly)/transformation & output problem

Go to: Forums > Technology: Programming Languages

There is only one posting to this topic on our Member website and this page runs 7 days behind our Member website. For the full topic click to sign up to OUTeverywhere.

A topic from Technology: Programming Languages

#187499Tue 19/02/08 19:12

Ok guys and gals... a but of a stab in the dark here, but all help gratefully received.

I have to program a module into a proprietary database system (using IIS/SQL/XML etc) to get a batch of account statements out of it (periodically) and it needs to be flexible as we have a number of clients with differing demands.

The data set up... I have a number of relational tables and need to pull differing amounts of data from different tables into a document to send to customers; each client will have a different set of data (although the data will be in a similar format - some clients could have 10 investment funds, others could have 20 or so). Usually, we'd program the system to output using a 'wordlink' (MS Word mail merge), however, the wordlink will only apply one filter per table, so is rendered useless for what I want to do. I also cannot add any new tables to the database to transform the data.

The current process (migrated badly from an old system) cycles through each customer and pulls out the data by doing data reads, which is unbelievably inefficient, so I need to replace it.

I can potentially do the statement in XML/XSL (in fact I have most of this already roughly programmed), however, I need to get this into something that can be printed and posted as well as applied to EDM on the database (so I can put a letter on the front and a notes page on the back etc). Obviously Word uses XML (to a degree) but passing data connection strings is an issue in the way that the system holds Word documents on the database, as well as from a security point of view.

So has anyone any tips/ideas on how I might be able to transform the data/get it out into a printable document? I think my situation here is reasonably unique as it's programming with both arms behind my back as there is only so much I can do with the software!!!

Help! It's keeping me up at night. lol

Enjoy chatting with our members

Click to join and start meeting people today

Imagine joining a social network of people from all around the country and see how you'll feel a year from today. You're increasing your circle of friends. You're doing more of the stuff you enjoy. You're having a great time meeting new people in your area. You're seeing all the benefits of becoming a member of OUTeverywhere. It still feels great making new friends and every day you're hearing more and more about the stuff that everyone's doing. You're joining in. Now, that was easy, wasn't it?

We make meeting people easy. Click to sign up to OUTeverywhere and get up and do something different!

PLEASE NOTE: Events are listed on this website on behalf of organisers in accordance with the Terms of Membership of OUTeverywhere and only if they have chosen broad publicity when adding their event to the Member Events calendar. As such, events are not necessarily affiliated to or endorsed by OUTeverywhere and may not be organised by the person who has listed the event: the person listing this event may simply be attending an event organised by another person or organisation and may wish to meet other people sharing their interest in the event. The mention or appearance of any person or organisation featured on these pages is not to be taken as any indication of sexual, social or political orientation of such persons or organisations. We cannot guarantee that the information is accurate and recommend that you always seek to contact the organiser directly to confirm full details of any event. Under no circumstances will we be responsible for any loss or damage resulting from reliance on, use or misuse of, the information on this website.

Our Vision | Our Team | Privacy Policy | Identity Theft Protection | Terms of Membership

Chat and Meet People

Enter one or two words to tell us something you enjoy:

Or enter a postcode or the name of a place:

Latest Shout OUT

Broadcast to the gay world with our public Shout OUTs service! Post on our member website or from your mobile phone and raise your profile.

Robert Crowe (robcrowe) from the Kentish Town area in United Kingdom shouts OUT: "Because l invented it in Camberwell, and it is shaped like a carrot""

Events Calendar

< December 2008 >
S	M	T	W	T	F	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31

This Topic's Tags

Members tag topics with key words to help us find similar topics.

Discover GMEET

Add all your web profiles to the new GMEET.com website profiles directory service. Supports Facebook, YouTube, MySpace, Bebo, LinkedIn and dozens more. For social and business networking, web personals and online dating.