Geeks With Blogs

News Welcome to my blog, I hope to have here some interesting content for you all to read. However, I'm just starting out in this, so be patient with me.

Moshe Eshel The eye in the sky - just fell down

Just resolved an issue we had here at work.


In one of the applications we make, we have an Import Users function, that takes the data from a CSV file. When installing the application we demand that some I18N settings on the machine will be preset. such as the Language, the structure of the date format, and also the sList (list seperator character)

However when installed by one of our customers in Germany, we encountered a problem were this function was failing and giving out a weird error message. Analysis showed that it wasn't using , (comma) as the seperator. This caused it to take the whole Line as a single column (we are using Microsoft Text Driver to perform this action)


Apparently, it is not enough to set the sList character, you also need to go to a Key under Jet/4.0/../Text and set a seperator there (which had the value of ;) - apparently when setting up the machine they started with a german setup and that key was set to that value.

Eventually I solved this by using a special feature of the Text Driver called schema.ini which specifies defaults for runing imports from a specific directory. However, it was re-assuring to detect the original source of the problem and understand why it didn't come up during the testing phases. (just released the patch :-)  )

Posted on Sunday, August 22, 2004 12:26 PM | Back to top

Comments on this post: Just a small problem I had, I wanted to share

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Moshe Eshel | Powered by: