We have it here ... No Problems We created an Regular Remedy form and loaded the data into it.
Just make sure you set up indexes for searching Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Logan Sent: Thursday, November 09, 2006 2:56 PM To: [email protected] Subject: USA City, State lookup by zip code for Customer in Help Desk Hello All, I've had a request to have the entirety of possible US (including Puerto Rico) zip codes available for City, State lookup in the Customer form for Help Desk. USPS has a ASCII file with all of them in readable format, but it looks monstrous (an entire CD, zipped; better than a DVD, I guess). We do not have an available outfacing web server, so a web service lookup is not viable. Has anyone tried this? If so, what size and type of system are you on and did the amount of data cause any issues? Right now, if they decide they want to go forward with this, is to put the data into a separate table and/or database and customize the Remedy code to pull from it. Again, any experience and/or advice on this is welcome. Thanks in advance! Kelly Logan Cybernetic Solutions, Inc. [EMAIL PROTECTED] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
