Skip to main content
Question

DBF reader problem with Character Encoding


ronmak
Contributor
Forum|alt.badge.img

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.

6 replies

nampreetatsafe
Safer
Forum|alt.badge.img+13

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?


ronmak
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • April 14, 2020

DB_COORD.zip

Here is a zip of a sample dbf


ronmak
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • April 14, 2020
ronmak wrote:

DB_COORD.zip

Here is a zip of a sample dbf

@nampreetatsafe Here it is.


nampreetatsafe
Safer
Forum|alt.badge.img+13

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?


ronmak
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • April 23, 2020
nampreetatsafe wrote:

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


nampreetatsafe
Safer
Forum|alt.badge.img+13
ronmak wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings