Import DDR files with Japanese filenames
Yuasa
via web
Problems occur when importing DDR files with Japanese filenames.
Although BE3 showed an error message, I could not read its
message because of character error. (see attached)
BE3 is not import any file in Japanese filenames. It includes
Summary.xml as well.
Japanese FMAD save it with Japanese filename
(集計.xml).
If I change the original database filename into English and then make DDR with saving the filename "Summary.xml", BE can import DDR.
However, I need to keep files in Japanese to make reports of multiple files.
All software I use is Japanese version
OS: Windows 7 (64bit)
FM: FileMaker Pro Advanced 11
BE: version 3 (MU license)
-
error_Jp.png
22.9 KB
-
error_Eng.png
27.3 KB
error_Jp.png
error_Eng.png
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by Nicholas Orr on 27 Jan, 2011 04:37 AM
Yuasa,
Thanks for this. Our main test platforms are Mac OS and Win XP and I know that Japanese paths work on the mac, so I assumed it also did on Win7. I've tested and can confirm the issue does happen. It's something in the plugin code, so I'll get the programmer to have a look at it and get back to you as soon as I can about a fix.
In the mean time, if you have a spare mac to run the imports on, then you can import there and host the files for the other machines.
I will be in touch.
Cheers,
Nick
3 Posted by Yuasa on 27 Jan, 2011 05:51 AM
Nick,
Thanks for your reply.
I'll wait for bug fix for now.
Yuasa
Support Staff 4 Posted by Nicholas Orr on 11 Feb, 2011 05:50 AM
Yuasa,
I've got an updated build for you. Can you give this one a try and let me know if it works :
http://www.goya.com.au/files/baseelements/3.0.9/BaseElements_Mac.dmg
http://www.goya.com.au/files/baseelements/3.0.9/BaseElements_Win.zip
http://www.goya.com.au/files/baseelements/3.0.9/BaseElements_Mac_Ru...
http://www.goya.com.au/files/baseelements/3.0.9/BaseElements_Win_Ru...
There are other changes as well, but the main one is a change to the plugin to better handle unicode paths.
Thanks,
Nick
5 Posted by Yuasa on 14 Feb, 2011 06:09 AM
Nick,
I tried 3.0.9, but an error occurred as attached. BE seems to stop import any files after that.
Tested db are FM Pro starter solustion file "To do list" and my own files.
Support Staff 6 Posted by Nicholas Orr on 14 Feb, 2011 11:34 PM
Yuasa,
Can you try with this updated version of the plugin? Make sure it's installed and that you don't have any other copies of the plugin in the user or app folders.
Thanks,
Nick
7 Posted by Yuasa on 15 Feb, 2011 02:14 AM
Nick,
I appreciate your prompt response, but I still get the same error message.
(I tried several times importing DDR with differenct solutions.)
I checked the extension directories as you mentioned. Is there anything else I can check or try by myself?
Thanks,
Yuasa
Support Staff 8 Posted by Nicholas Orr on 17 Feb, 2011 11:16 PM
Yuasa,
Do you mind doing some testing for me? I've attached a slightly newer version of the plugin. It should return "1.0.7" when you run the BE_Version function.
If you're able to create a new empty file, maybe on the desktop, and run the following functions and tell me what they return :
Get ( FilePath )
Also create a plain text file on the desktop, and then select it with :
BE_SelectFile ( "" )
then record what this returns. Finally do :
BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )
And select the text file again. That will overwrite the file though, so be careful which file you choose.
Let me know what each one returns at each point.
Thanks,
Nick
9 Posted by Yuasa on 02 Mar, 2011 11:18 AM
Nick,
Thanks for suggestion.
The only one thing I can answer for this moment is
Get ( FilePath ) returns
file:/C:/Users/09120/Desktop/BEtest.fp7
I could not find how to test them with "run the BE_Version function", "BE_SelectFile ( "" )", or "BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )", because I could not figure out how to access them.
To use these functions, do I have to use a script in the BaseElements_3_Data.fp7?
If so, I've read the BE 3.0 Instruction Manual (PDF file), but I
could not open the script manager which is dim.
(I don't have a problem opening the script manager in UI.)
Could you explain how in detail?
By the way, when decompress ehe downloaded BaseElements_Win.zip file, it displays something like this.
Do you copy this file without encryption?
Problem occurs, so this folder cannot be encrypted.
Other Licences
After I chose YES, the number of files in the zip file and that in decompressed folder are the same.
Thanks.
Support Staff 10 Posted by Nicholas Orr on 09 Mar, 2011 11:56 AM
Yuasa,
To run those functions, just type them into the Data Viewer and click "Evaluate Now" and tell me the result.
Was there meant to be a screenshot for the unzip of the BaseElements file? What does it show?
Thanks,
Nick
11 Posted by Yuasa on 09 Mar, 2011 12:50 PM
Nick,
Thank you for your reply.
Now I understood how.
BE_Version returned
1.0.7
Get ( FilePath ) returned
file:/C:/Users/09120/Desktop/BEtest.fp7
BE_SelectFile ( "" ) returned
C:\Users\09120\Desktop\BE.txt
BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )
returned 0 and
resulted in text "abc" added in the BE.txt file.
While unzipping the BaseElements_Win.zip, the message showed as attached.
Thank you,
Yuasa
12 Posted by Yuasa on 09 Mar, 2011 12:58 PM
Nick,
Thank you for your reply.
Now I understood how.
BE_Version returned
1.0.7
Get ( FilePath ) returned
file:/C:/Users/09120/Desktop/BEtest.fp7
BE_SelectFile ( "" ) returned
C:\Users\09120\Desktop\BE.txt
BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )
returned 0 and
resulted in text "abc" added in the BE.txt file.
Thank you,
Yuasa
13 Posted by Yuasa on 09 Mar, 2011 01:28 PM
Nick,
Thank you for your reply.
Now I understood how. Here is the results.
BE_Version returned
1.0.7
Get ( FilePath ) returned
file:/C:/Users/09120/Desktop/BEtest.fp7
BE_SelectFile ( "" ) returned
C:\Users\09120\Desktop\BE.txt
BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )
returned 0 and
resulted in text "abc" added in the BE.txt file.
Thank you,
Yuasa
14 Posted by $BEr@u!!NO(B on 09 Mar, 2011 01:33 PM
(sending this message because I posted to web discussion three times, but
none of them come up.)
Nick,
Thank you for your reply.
Now I understood how. Here is the results.
BE_Version returned
1.0.7
Get ( FilePath ) returned
file:/C:/Users/09120/Desktop/BEtest.fp7
BE_SelectFile ( "" ) returned
C:\Users\09120\Desktop\BE.txt
BE_WriteTextToFile ( BE_SelectFile ( "" ) ; "abc" )
returned 0 and
resulted in text "abc" added in the BE.txt file.
> Was there meant to be a screenshot for the unzip of the BaseElements file?
What does it show?
As I explained, while unzipping the BaseElements_Win.zip, the message showed
as attached.
Thank you,
Yuasa
Support Staff 15 Posted by Nicholas Orr on 10 Mar, 2011 04:14 AM
Yuasa,
I'm unable to come up for an explanation for why this would be an issue. There isn't anything in the paths that the plugin is generating or in the output that would cause issues. I'm at a loss to explain it.
Can you try one more thing : download the latest public release from http://www.goya.com.au/baseelements/download and see if that is any different. Make sure you delete any old versions of the plugin first.
If that doesn't work I'd have to setup a test environment for a Japanese Windows 7 install and see if I can replicate it.
Cheers,
Nick
16 Posted by Tsutomu Yuasa on 01 Apr, 2011 02:08 AM
Nick,
Sorry for delaying reply your message this time.
As you know we have a massive disaster by earthquake in Japan. We are safe, but we could not afford working this problem at all.
Although the latest public release behave the same as before, we found the way to import by chance. If I choose Xalan, BE can import the DDR, but Auto and LibXSL can't.
I'm not sure this is the case happened on this computer only. I think I need to run test on other machines. I'll report the result later.
Thanks,
Yuasa
Support Staff 17 Posted by Nicholas Orr on 01 Apr, 2011 05:45 AM
Yuasa,
I'm glad to hear you're well after the earthquake and give my best wishes to all your staff and family. As a fellow FileMaker developer if there's any help you need, let us know.
As for BaseElements, that's good to hear that you got it working. I've built in more error capturing into the import, but obviously there is one there I haven't been able to grab. I will keep looking at it though and will let you know if I find anything else.
Cheers,
Nick
Nicholas Orr closed this discussion on 20 Dec, 2011 12:40 AM.