Looks like the Great Firewall or something like it is preventing you from completely loading www.skritter.com because it is hosted on Google App Engine, which is periodically blocked. Try instead our mirror:

legacy.skritter.cn

This might also be caused by an internet filter, such as SafeEyes. If you have such a filter installed, try adding appspot.com to the list of allowed domains.

Export word bug

atdlouis   June 17th, 2012 7:00p.m.

There seems to be a recent bug with exporting words, and copying & pasting into excel.

If an English definition is too long, it will run over into the next row. For example, the character 倒 will take up two rows in excel:

1) 倒 dǎo, dào to collapse; to fall; fail; to exchange
2) to pour; contrary to expectations

atdlouis   June 17th, 2012 7:06p.m.

So apparently it's not happening with "My Words" exporting, but exporting from word lists.

For example, the 倒 example I gave above will happen if you export NPCR section 51.

Byzanti   June 17th, 2012 8:35p.m.

It's probably something to do with the carriage returns and line feeds that are left in the export (/r /n). I'm on Mac, and I see the opposite to you: with My Words I get new lines, but I don't with the list export. I'm not entirely clued up on it, but I am aware Linux/Mac/Windows use different characters to denominate new lines. The two export tools are handling these differently, evidentally.

The important thing is that both export tools separate by tab, even if there is a new line, so perhaps you can find some way in Excel to paste by tab? Eg, the export tool looks like:

汉字 [tab] pin1yin3 [tab] Definition [tab]
下一个字 [tab] ...

And if there's a carriage return/new line feed:

汉字 [tab] pin1yin3 [tab] Definition line 1
Definition line 2 [tab]
下一个字 [tab] ...

Which would correlate with what you're seeing... Hence the need to split it up by tabs.

(PS, Scott, if you change the way the My Words export works, don't strip out new lines please!).

scott   June 18th, 2012 6:09p.m.

I believe what's standard for csv is to put in quotes around fields that are multiple lines. I could tweak it to do that. Would that work for you?

russell359   August 19th, 2012 2:45a.m.

I've had the same problem, when trying to export a word list, such as this one, http://beta.skritter.com/vocab/list?list=91215598
There are some entries that have definitions that are too long, so run over onto the next row. I found you could extend the popup box using the bottom right corner extension thing, but it still doesn't fix the problem for the longest entries. Here's an example image of what I mean, under ba1 http://goo.gl/BWWLP
Could the popup be set to open in a new window, so it could be enlarge to fullscreen, that should fix the problem for the longest entries I guess...

scott   August 19th, 2012 10:22p.m.

The text if you copy and paste it into a larger document will retain the proper new lines. The export box itself isn't really intended to be large enough to make sure it can contain the lines no matter how large they can get. When I update this I'll probably just have it serve a file instead of the raw text to be copied and pasted anyway...

russell359   August 19th, 2012 10:44p.m.

I noticed now that the definitions are moving to a new row because some of the ';' characters that separate the definitions are being replaced with 'returns', thus moving part of the definitions to the new lines/rows. Would be nice to be served with files like you suggest, save copying and pasting...

lechuan   September 2nd, 2012 2:53a.m.

Standard csv formatting would be great!
Would also be nice to have an option to include/exclude category names.

This forum is now read only. Please go to Skritter Discourse Forum instead to start a new conversation!