Solved

FME Desktop 2022.1 - 64-bit Personal Geodb Reader (PERSONAL_GEODATABASE) not fetching the data attributes

  • 24 August 2022
  • 4 replies
  • 6 views

Badge +7

Attached workspace created using workflow option "Single Merged Feature Type" for Personal Geodb Reader.

 

Esri Geodatabase (Personal Geodb) 

Steps to experience the issue.

  1. Execute the enclosed workspace in FME Desktop 2022.1
  2. View the cached features of reader (Click on the tiny magnifier icon on the reader)
  3. Even though FEATURE_TYPES published parameter was set to Highways, data attributes of Highways feature class were not shown in the table under Visual Preview panel.
  4. You may check the issue by passing a different Personal Geodb and Feature type(s)
icon

Best answer by ranga_tolapi 26 August 2022, 08:57

View original

4 replies

Badge

Try open it with a MS Access reader as Personal GeoDB stores and manage data as MS Access file ?

Badge +7

Try open it with a MS Access reader as Personal GeoDB stores and manage data as MS Access file ?

I want to extract the Geometry also from Personal Geodb, with MS Access reader is it possible?

Badge

I want to extract the Geometry also from Personal Geodb, with MS Access reader is it possible?

Never tried as we don't use Personal GeoDB, only FileGeoDB in staging and Enterprise GeoDB in production.

The geometry tables must be somewhere in the Access file. If you have any ArcGIS software to deal with your files, create a simple File GeoDB which is the standard (in latest ArcGIS Pro, Personal GeoDB don't even exists anymore) and import your Personal GeoDB content into it.

If you don't have any ArcGIS soft, use QGIS which is free and allow such tranformation easily. Then you can go back to FME for further actions

Badge +7

Never mind, job was done with the Generic (Any Format) reader.

  • Dataset: D:\\Data\\usa.mdb
  • Input Format: Esri Geodatabase (Personal Geodb)

 

Anyway, Esri Geodatabase (Personal Geodb) reader was supposed to do the job, seems like it's a BUG.

Reply