MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Hold Territory Zip Codes in Oracle db?

This is a discussion on Hold Territory Zip Codes in Oracle db? within the MapPoint 2006 Discussion forums, part of the Map Forums category; I searched this forum and didn't find much on my dilemna..... I need my end users to use a ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  2 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-20-2008
Junior Member
White Belt
 
Join Date: Mar 2008
Posts: 2
Question Hold Territory Zip Codes in Oracle db?

I searched this forum and didn't find much on my dilemna.....

I need my end users to use a mapping software to select all the zip codes that are in someone's territory. I downloaded the MapPoint 2006 trial and it seems to do that really well, but..........

I also need that information (the zip codes and name of the territory) to be stored - or exported - into my Oracle 9 database for use in other programs.

My research seems to say that exporting the zip codes into a file is not an option with MapPoint. Is this still true?

Even if I had a Microsoft database linked (or figured out how to link to an Oracle db) with this information, can MapPoint update or insert these zip codes in the database table??? Or does MP just READ the zip code data? Cause I need MapPoint to UPDATE and INSERT the zip codes for the territories when the user makes changes to the territory boundries.

If MapPoint cannot export the selected territory zip codes to a file or update and insert that information into a database, do you know another mapping program that DOES do this -- and still selects territory zip codes as nicely as MapPoint?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-20-2008
lfdmike's Avatar
Member
Yellow Belt
 
Join Date: May 2004
Posts: 38
Blog Entries: 7
Re: Hold Territory Zip Codes in Oracle db?

The desktop version of MP can export the zip codes in a territory if the territory is based on zip codes, and it will open in Excel.
To do that you would just select the area you want to export and click on >Data >Export to Excel

You may be better off to have an application that is tied to the db and utilizes MP to view the data
__________________
Mike Mueller
Lannon Fire Department
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 03-20-2008
Junior Member
White Belt
 
Join Date: Mar 2008
Posts: 2
Re: Hold Territory Zip Codes in Oracle db?

Quote:
Originally Posted by lfdmike View Post
The desktop version of MP can export the zip codes in a territory if the territory is based on zip codes, and it will open in Excel.
To do that you would just select the area you want to export and click on >Data >Export to Excel

You may be better off to have an application that is tied to the db and utilizes MP to view the data
Wow - I swear I tried that 3 hours ago and it didn't work -- but I tried it just now and it worked perfectly.

Thank you.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/hold-territory-zip-codes-oracle-db-7336.html

Posted By For Type Date
Hold Territory Zip Codes in Oracle db? - MapPoint Forums This thread Refback 03-23-2008 09:10 PM
The Magazine for MapPoint - MP2K Magazine This thread Refback 03-20-2008 02:38 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Hold color on postalcode in any zoom level rlisario Development 0 11-07-2007 01:27 PM
Hold color on postalcode in any zoom level rlisario MapPoint 2006 Discussion 0 11-07-2007 01:21 PM
Connect to Oracle using UDL file msotres MapPoint 2006 Discussion 4 06-13-2004 09:31 PM
access Oracle db Jade MapPoint 2006 Discussion 3 04-25-2003 02:13 AM
Too Many Zip Codes to Create Territory Anonymous MapPoint 2006 Discussion 1 11-22-2002 01:20 PM


All times are GMT -5. The time now is 10:07 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5
MP2K Magazine
Visitor Map

Rome Flights
Rome flights can be costly flights if you don't know where to book. You can find the latest deals from the leading UK Tour Operators at Holiday Hypermarket.

Flights to Spain
Find and book flights to Spain. Travel Counsellors can help with travel to Spain including flights and accommodation.

Cheap Holidays to Turkey
If you’re looking for cheap holidays to Turkey then dealchecker.co.uk is the place for you! Our search helps you see real prices from the UK’s top holiday companies all in one go.

Holidays in Dubai
Holidays in Dubai are an eclectic mix of the ancient and the modern. Discover an oasis of luxury amid the Arabian desert. Book here now!

Cheap Spain Holidays
Stay well informed when you are searching for cheap holidays online. For useful advice on when to book cheap Spain holidays make sure you look on ulookubook.com

Travel Deals
Click here and read up on the travel deals available online.

Holidays to Goa
Golden beaches, coconut trees. Visit On The Beach for holidays to Goa, and experience India!


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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46