Question

Hello,

Once again I must rely on the kindness of people on this site for advice

I have a web that contains data on about 500 cities. Each city has several topics dedicated to various types of information. One topic for each city, is Contact information -- various agencies that our company uses in these cities. Some contact info is currently in Outlook as a Contact list. We want to put it into Wiki on the contact page for each city.

However, the department that uses these contacts often sends mailings to them by exporting a list of addresses from Outlook.

How can I give them this capability after we move it all to Wiki? I thought of attaching a form to each contact page, and putting the mailing address in each form, BUT often there are multiple contacts of this type, in one city.

Maybe there's a way to put each contact in a table and extract the data that way?

I've looked at the available plugins and didn't see one offhand that looked liek it would suit my needs.

Does anyone have any ideas?

Thanks!

Environment

-- KathyDeLaCruz - 20 Nov 2008

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

I have found this sample app: http://twiki.org/cgi-bin/view/Sandbox/SearchBookTitles -- perhaps if I format the addresses just right, I can extract most like this, but I still am not sure what to do if there are multiple contacts in one topic; that must be mailed to separately...

-- KathyDeLaCruz - 20 Nov 2008

The FilterPlugin makes data extraction a lot easier. For multiple entries, perhaps my BlogEntry200810x8 has useful examples, especially this (the trickiest bit):

after the FilterPlugin EXTRACTs the row number and predecessor list, the SpreadSheetPlugin is used to split the comma-separated predecessors into separate entries. But since its SUBSTITUTE can't handle commas, they first had to be TRANSLATEd into semi-colons.

-- SeanCMorgan - 21 Nov 2008

Thank you Sean - I will check that out!

-- KathyDeLaCruz - 21 Nov 2008