I am able to open a dbf with excel with no prompts, and with libreoffice it prompts me to use Arabic (ibm864) coding and then opens fine. But when I specify that with FME, the table is scrambled. Sorry - I tried to upload it but dbf are not allowed.
Question
DBF reader problem with Character Encoding
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.
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.
+14- Safer
Hi @ronmak. Sorry to hear that you are having challenges bringing in your dbf. Can you try zipping up your dbf and try uploading the resulting the .zip?
+14- Safer
Hi @ronmak, thanks for providing the sample file and your patience as we've looked into this. I managed to reproduce the issue and quickly check in with our dev team. Was there a .cpg file stored in the same directory as this .dbf on your end?
+5- Contributor
Hi @ronmak, thanks for providing the sample file and your patience as we've looked into this. I managed to reproduce the issue and quickly check in with our dev team. Was there a .cpg file stored in the same directory as this .dbf on your end?
Sorry @nampreetatsafe - no .cpg file.
These files come from Microsurvey (just down the road from you in Kelowna!) and the format goes way back to their dos version. There is an accompanying .mdx but I doubt that would be helpful. I have attached a csv file which may contain a clue though. I can open it in excel and see that several columns are padded with an unrecognized character. If I open it in a Notepad++, I get binary gibberish.
db_coord.csv
+14- Safer
Sorry @nampreetatsafe - no .cpg file.
These files come from Microsurvey (just down the road from you in Kelowna!) and the format goes way back to their dos version. There is an accompanying .mdx but I doubt that would be helpful. I have attached a csv file which may contain a clue though. I can open it in excel and see that several columns are padded with an unrecognized character. If I open it in a Notepad++, I get binary gibberish.
db_coord.csv
Thanks @ronmak! I've created a ticket for the dev team to take a close at this for you (internal reference FMEENGINE-64091). We'll post any updates or follow-ups here. Thanks for bringing this to our attention.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.