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.
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?
DB_COORD.zip
Here is a zip of a sample dbf
DB_COORD.zip
Here is a zip of a sample dbf
@nampreetatsafe Here it is.
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?
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
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.