Can ScribeDocReadValue Read Scientific Number Format?

[Joshua]

Hi,

 

I've been using ScribeDocLoad to load Excel sheets into Filemaker Pro 13 and ScribeDocReadValue to read it's values. It has been working very well for me until it hit a column with scientific number formatting in Excel where it returns "Error" as it's value.

 

Am I doing something wrong or do I have to take an extra step to bring in Scientific numbers? There are thousands of Excel documents, so, going in and changing the formatting for the column is not an option.

 

Any Help will be greatly appreciated.

[ryan360Works]

Hi Joshua,

I was able to replicate this behavior and it looks like you have uncovered a bug in Scribe. We are actively working to fix this and I will update this thread when we have a fix ready.

[ryan360Works]

Joshua,

Here is a new build that should correct the issue. Install it and let us know if you are still having issues.

[Joshua]

Hi Ryan,

Thank you for your response. I downloaded the zip file but when I extract it's contents I get an error message "The compressed (Zipped) folder is empty". The zipped file size is 22.9 MB so it does not seem to be empty but instead damaged. I am using Windows 8 unzip (I don't know if that makes a difference).

[ryan360Works]

Joshua,

For some reason that file was corrupt. Try this link and let me know if you run into anything.

[Joshua]

Thank you Ryan It's working perfect now.

[ryan360Works]

Joshua,

I'm glad that is working for you now! Of note, that build does contain the bug fix pertaining to your issue but is also a beta build. If you run into issues, please send an email to [email protected] and we will get you sorted out!

Regards,