Importing word lists

Support forum for our fast, user-friendly offline Chinese language study apps for Google Android devices:

Hanping Chinese Dictionary (Lite & Pro)
Hanping Cantonese Dictionary
Hanping Chinese Camera
Hanping Chinese Popup
timtaiwan
Posts: 1
Joined: 25 Dec 2010, 02:47

Importing word lists

Post by timtaiwan »

Hello,

Is it possible to import lists into HanPing Pro? If so, how and what format (txt,xls)?

daluchris
Posts: 7
Joined: 04 Jan 2011, 14:03

Re: Importing word lists

Post by daluchris »

timtaiwan wrote:Hello,

Is it possible to import lists into HanPing Pro? If so, how and what format (txt,xls)?
Yeah, I tried to figure out how to do this... couldn't find a way. Is there one?

hanping
Site Admin
Posts: 470
Joined: 18 Mar 2010, 08:52

Re: Importing word lists

Post by hanping »

Currently it's not supported but it is on the todo list, and I'll post back here when it is done. Can't make any promises about "when" but it's something I would also like to see and so that increases its priority :)

daluchris
Posts: 7
Joined: 04 Jan 2011, 14:03

Re: Importing word lists

Post by daluchris »

oh that's great! I'm looking forward to the next updates! :)

***I looked everywhere except the SD card before, but today I found what looks like the word lists to me here: Android\data\com.embermitre.dictroid\zh\lists
I tried to open some lists with Notepad and Openoffice but it didn't really work. Is it working with Excel 2010? I don't have Excel here but the file that the Hanping Dictionary creates when I export my Userlist is a .TSV (tab separated values) file. If I would rename the .WLS and .ULS (Wordlists and Userlists? :)) to .TSV would it work?

***Another question: How can I add a new userlist?
I saw some screenshots of an earlier version of Hanping and there was a button to create new user lists in the list menu. It's missing in on my phone (Motorola XT702/Milestone with Firmware 2.1-update1) with the newest update of Hanping. I can only save words or characters in one list.

***Finally a little bit OT: Is it possible to use other dictionary files with Hanping?
My phone is rooted and I found a file called appcat_100.xml in \data\data\com.embermitre.hanping.app.pro\files\
It mentions CEDICT and also Chinesisch-Deutsch HanDeDict. I am familiar with HanDeDict and would love to use it together with Hanping. Is there a way to add it to the dictionaries?

hanping
Site Admin
Posts: 470
Joined: 18 Mar 2010, 08:52

Re: Importing word lists

Post by hanping »

The .TSV file is only useful in one-direction at the moment - i.e. if you want to take your starred lists elsewhere. Note, TSV is used instead of CSV (comma-separated value) because some of the dictionary definitions include commas (and I didn't want those to be encoded). The files in the lists directory are SQLite databases. So you could try to build one of those!

I've answered your other questions in the other posts.

chriskie
Posts: 14
Joined: 21 Nov 2011, 08:23

Re: Importing word lists

Post by chriskie »

Hi, just downloaded the Pro version .. it's a great app, however the description in Android Market led me to believe that lists could be shared .. I see now that this is not yet the case (at least not between apps :) As a learner I have alot of lists I would like to get in there!! Any chance of this feature being added soon? Will also take a look at SQLite, if you have any basic info on this then that would be a great help.. I'll think of that as the final remaining workaround to overcome in order to get my material on my phone :) Otherwise looks awesome

chriskie
Posts: 14
Joined: 21 Nov 2011, 08:23

Re: Importing word lists

Post by chriskie »

Ok, well found the database and tried the basic things, like the SQlite browser (won't import / export chinese chars properly via CSV), installing ODBC drivers and attempting to access from Excel or Access, neither of which appear able to read the database. Any ideas?

chriskie
Posts: 14
Joined: 21 Nov 2011, 08:23

Re: Importing word lists

Post by chriskie »

Ok I have figured out how to create a SQLite database, would you mind spending a couple of minutes explaining the structure needed?

I have copied the structure from one of your hsk lists, deleted all the list records, and inserted some of my own. But invariably, the app says the entry is not in the dictionary. I'm putting the traditional variant in key 1, simplified in key 2 and pinyin with numbers in 3.. It lists the character(s), and applies the colour according to the pinyin, but it does not find the entry in the dictionary itself. Only if I click on the character and then do a search will it find it.. Any thoughts?

hanping
Site Admin
Posts: 470
Joined: 18 Mar 2010, 08:52

Re: Importing word lists

Post by hanping »

Hi - and good work!

Try placing a single space before and after the pinyin.

chriskie
Posts: 14
Joined: 21 Nov 2011, 08:23

Re: Importing word lists

Post by chriskie »

That seems to work, thanks! I have to say it seems a little strange to have to provide the app with almost all the information that is already in the database, so I don't know if you have plans to change that. But for now it works for me, and it's worth it for the nice display, and hooking into related words and chars in the database, not to mention the widget! Cheers Chris

Post Reply