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?
Question
dBase tables including .dbt-files are not prozessed?
+1
+17- Supporter
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.
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 wrote:
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).
+1thank 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...
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.