[mapguide-users] RE: Please help me

Ronnie Louie ronnie.louie at autodesk.com
Tue Dec 12 15:58:17 EST 2006


Hi Farzad,

Here's the steps I used to successfully create a layer from either the
CityLimit table or the SubCityLimit table from your Access database.  I
am also attaching some screenshots for your reference.

1.  Create an ODBC datasource for the database via
Start->Settings->Control Panel->Administrative Tools->Data Sources
(ODBC).  Click the System DSN tab.  2.  Click the Add button.  Select
Microsoft Access driver.  Click Finish.
3.  Enter a name for the datasource, and click Select button to pick the
.mdb file.  Click OK.
4.  Start MapGuide Studio and connect to a site.
5.  Click File->New->Data Connection.
6.  Select OSGeo FDO Provider for ODBC.
7.  Choose the Data Source Name radio button and click on the "..."
button to select the datasource you created in step 3.
8.  Under the Refine Data Setup, Click the Show Tables button.  Click on
the Geometry checkbox CityLimit and SubCityLimity.  The X and Y Columns
should be automatically populate with CityLat and CityLon.
9.  Save the datasource.  You should now be able to use this feature
source to define a new layer.  Select the table (Feature Class) to use
(either Default:CityLimit or Default:SubCityLimit), and you should see
the cities geometries displayed in the layer preview.


Ronnie


-----Original Message-----
From: farzad ghavam [mailto:ghavam at ehealth.ir] 
Sent: Monday, December 11, 2006 10:38 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: Please help me

 Hi Ronnie,
   please find attachments.
 Thanks
 Farzad.


> Farzad,
> 
> My email client (Microsoft Outlook) blocks attachments with .mdb
> extension for security reasons.  Can you rename your file to a 
different
> extension and resend it please?
> 
> Thanks
> Ronnie
> 
> -----Original Message-----
> From: farzad ghavam [mailto:ghavam at ehealth.ir] 
> Sent: Friday, December 08, 2006 11:28 PM
> To: users at mapguide.osgeo.org
> Subject: Re: [mapguide-users] RE: Please help me
> 
> Hi Ronnie,
> Thanks for reply, My .mdb file has 3 tables and I try by 1 table but 
> not worked,Now I send .mdb file and two pictures of my project,
> I don't know What do I do?
> 
> Farzad.
> 
> 
> > Hi Farzad,
> > 
> > Do you mind sending me your Access database file?  In the 
meantime, 
> Is
> > there more than one table in the database?  If yes, maybe you 
could 
> try
> > modifying your .mdb a bit such that it only contains one table and 
> let
> > me know what happens.
> > 
> > Ronnie
> > 
> > -----Original Message-----
> > From: farzad ghavam [mailto:ensejam at ns1.tak-host.com] On Behalf Of
> > farzad ghavam
> > Sent: Friday, December 01, 2006 9:32 PM
> > To: Ronnie Louie
> > Subject: RE: Please help me
> > 
> > hi Ronnie,
> >  Sorry fro my late,I reinstall Mapguideopensource 1.0.2 and 
> reinstall 
> > FDO.R071, then create an ODBC then create a connection to this ODBC
> > (test connection is OK).In database I have a table
> > (IDCity,NameCity,LatCity,LonCity).Now when I want create a layer 
> from 
> > this connection, cann't read the Geometry fields, I attached two 
> > pictures previous and Now status.
> > please help me.
> > thanks,
> > farzad
> > 
> > > Hi Farzad,
> > > 
> > > Have you tried reinstalling MapGuide?  Or maybe just re-
installing 
> > FDO?
> > > Is this only happening with ODBC, what about SDF?  
> > > 
> > > There are a bunch of fixes and enhancements in version 1.0.2.  
> Have 
> > you
> > > tried working with this latest version?
> > > 
> > > I will also suggest next time posting this to the mailing list
> > > users at mapguide.osgeo.org where we can draw on the collective 
> > knowledge
> > > of others.  There may be others who have seen this problem, and 
> > others
> > > who may have the solution to this problem.
> > > 
> > > Ronnie
> > > 
> > > 
> > > -----Original Message-----
> > > From: farzad ghavam [mailto:ensejam at ns1.tak-host.com] On Behalf 
Of
> > > farzad ghavam
> > > Sent: Sunday, November 05, 2006 5:28 AM
> > > To: Ronnie Louie
> > > Subject: Please help me
> > > 
> > > hi Ronnie,
> > >  How are you? I have a problem with data in a databse to view 
them.
> > >  I have a table in a xxx.mdb file that contain these filesd:
> > >   ID        -> Long (P)
> > >   Name      -> Text
> > >   Latitude  -> Double
> > >   Longitude -> Double
> > > ------------------------------------
> > >  before when this I create an ODBC and then create a connection 
in 
> > > Mapguide studio and then create a layer from this resource, I 
had 
> a 
> > > geometry filed(it was set itself) and I can change any style of 
> them.
> > > but now I cann't do it.I don't know why?
> > > I use MapGuide Server (Version 1.0.1.17812) and MapGuide Site 
> > > Administrator (Version 1.0.1.17812).
> > > 
> > > please help me.
> > > 
> > > thanks,
> > > farzad.
> > > 
> > > 
> > > 
> > 
> > -- 
> > 
> > 
> > 
> > -------------------------------------------------------------------
--
> > To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> > For additional commands, e-mail: users-help at mapguide.osgeo.org
> > 
> > 
> > 
> 
> -- 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 
> 
> 

-- 


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshots.zip
Type: application/x-zip-compressed
Size: 56468 bytes
Desc: Screenshots.zip
Url : http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061212/0603dcd3/Screenshots.bin


More information about the Mapguide-users mailing list