Skip to main content
Question

dBase tables including .dbt-files are not prozessed?

  • October 21, 2016
  • 4 replies
  • 26 views

chrishoh
Forum|alt.badge.img+1

When reading from dbase-Tables FME skips processing them when there is also a .dbt file (because of memo-fields including more than 254 characters in the dbase-table)

Does anybody knows how to solve this problem?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • October 21, 2016

Not really, but a workaround could be to have a workspace copy all the dbase files (without the bdt files) into another location, and read from that location.


david_r
Celebrity
  • October 21, 2016

A couple of suggestions

  • Using Google, see if there are any utilities that can convert your dBase tables to something else that FME can read (e.g. CSV or Excel, there seems to be a few)
  • Use e.g. this Python module (which apparently supports memo fields) in a PythonCreator (inspiration here).

david_r
Celebrity
  • October 21, 2016

A couple of suggestions

  • Using Google, see if there are any utilities that can convert your dBase tables to something else that FME can read (e.g. CSV or Excel, there seems to be a few)
  • Use e.g. this Python module (which apparently supports memo fields) in a PythonCreator (inspiration here).
Actually, I think Excel can read dbf files natively. Maybe try that first, save as xlsx and then read with FME.

 


chrishoh
Forum|alt.badge.img+1
  • Author
  • October 21, 2016

thank you for your quick response! Actually my workaround is to save the dbase as Excel-file and then remove the dbase from this folder. So the process isn`t interrupted and I am able to use the memo-fields. But this isnt the most beautyful way to do when publishing this process...