Infrastructure Map Server Developer

Reply
New Member
arthurabbie
Posts: 1
Registered: ‎10-01-2008
Message 1 of 2 (74 Views)

Oracle to sdf

74 Views, 1 Replies
10-01-2008 09:07 AM
Hi,

Newbie question...

I am trying to get data (road sections) from Oracle 10g into an sdf file that can be used by Mapguide 6.5. I have tried FME2004 and fdo2fdo. I have tried exporting from Oracle to a csv and using sdfloader.

FME can't read the Oracle table list.
fdo2fdo says it has copied 16000+ records but nothing is visible when I view the file in FME Universal Viewer.
sdfloader can't read/process the 'csv'

Question is how would you folks tackle this? Oh and we can't purchase any more software...

Thanks,
Arth.
*Kalman Albert
Message 2 of 2 (74 Views)

Re: Oracle to sdf

10-06-2008 12:29 AM in reply to: arthurabbie

is not very clear what you want ... is your data
in oracle datebase as spatial data ?

 

take care fdo2fdo create sdf3  and it's not readable
by sdfloader and mg6.5 you must make a new fdo2fdo task  to translate sdf3
 to shp then with sdfloader can generate sdf2

 

Translate Oracle to SDF3 or SHP  with
fdo2fdo

Translate SHP to SDF2  with sdfloader or use in mg
6.5 shp provider

 

It's little stupid worktask but for me works using batch
file, you can run fdo2fdo as command line, I use a batch program agent like
Cobian .

 

 

Kalmy

 

 


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Hi,
Newbie question... I am trying to get data (road sections) from Oracle 10g
into an sdf file that can be used by Mapguide 6.5. I have tried FME2004 and
fdo2fdo. I have tried exporting from Oracle to a csv and using sdfloader. FME
can't read the Oracle table list. fdo2fdo says it has copied 16000+ records
but nothing is visible when I view the file in FME Universal Viewer. sdfloader
can't read/process the 'csv' Question is how would you folks tackle this? Oh
and we can't purchase any more software... Thanks,
Arth.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community