maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Buy & Sell (https://talk.maemo.org/forumdisplay.php?f=27)
-   -   Laser-Cut Stand for N900 (https://talk.maemo.org/showthread.php?t=43593)

Palleman 2010-02-13 17:39

Re: Laser-Cut Stand for N900
 
Quote:

Originally Posted by fake (Post 524913)
Does anyone know anything about making Excel play nice with international characters? It keeps munging up addresses with umlauts and other special characters. I'm not about to ship items to addresses that aren't perfect... any advice would be most welcome.

It should work fine? What's it doing with your umlauts? UTF/ISO problems? Pasting from Firefox problems?

Anyway, you could just remove the umlauts and spell it Kristinebergsvagen instead of Kristinebergsvägen. Don't underestimate the European Postal Services!

/P

fake 2010-02-13 18:21

Re: Laser-Cut Stand for N900
 
Huh, I thought it was Excel, but it was Shopify. When I download a CSV of the orders, it has munged the text already! Here's an example:

Bäckaströmsgatan

Jeez, that looks horrible! I'll have to contact support, because changing 20+ addresses on every order is no fun. This morning, I forgot to check, and printed almost thirty bucks in bad postage. Agh.

thp 2010-02-13 18:27

Re: Laser-Cut Stand for N900
 
Quote:

Originally Posted by fake (Post 524975)
Bäckaströmsgatan

Looks like UTF-8 interpreted as Latin-1. Maybe you can tell Excel to import the CSV using the UTF-8 charset?

Palleman 2010-02-13 18:30

Re: Laser-Cut Stand for N900
 
Quote:

Originally Posted by fake (Post 524975)
Bäckaströmsgatan

That's UTF-8 characters, shown as ASCII. It's because CSV files only support ASCII. Renaming the file to something.txt and then importing it to Excel should probably make Excel recognize the UTF-8 characters.

Or you could send me the CSV file, and I'll send you a good-looking XLS back.

fake 2010-02-13 18:50

Re: Laser-Cut Stand for N900
 
Quote:

Originally Posted by Palleman (Post 524985)
That's UTF-8 characters, shown as ASCII. It's because CSV files only support ASCII. Renaming the file to something.txt and then importing it to Excel should probably make Excel recognize the UTF-8 characters.


Yep, you and thp are right - that was the issue. If I rename it as TXT and go through a slightly more painful process to open it, it works just fine.

Quote:

Originally Posted by Palleman (Post 524985)
Or you could send me the CSV file, and I'll send you a good-looking XLS back.

I wish I could do that, but I couldn't ever send or share everyone's personal info, even if it saves me a ton of pain...

Edit: But if you could send me a good-looking Swede...

Palleman 2010-02-13 20:30

Re: Laser-Cut Stand for N900
 
Quote:

Originally Posted by fake (Post 525005)
Edit: But if you could send me a good-looking Swede...

Actually, this site is hosted on my server, so I'll see what I can do...

les_garten 2010-02-13 22:05

Re: Laser-Cut Stand for N900
 
Yo,
Just got my 2 Black woods today. Superfast, UBER Perfect product!! Love it, THANX!

fake 2010-02-13 22:13

Re: Laser-Cut Stand for N900
 
OMG, seriously? That's great news!

Also, for people who bought the wood stands, be sure to really seat the back brace in place. It may take more force than you think... but it's designed so the back brace actually floats a fraction of a millimeter above the table.

kjmackey 2010-02-13 22:23

Re: Laser-Cut Stand for N900
 
Got my one of each today (just now) - California.

They look great - and seriously well packed. Many thanks! :D

Pfuh3z 2010-02-14 00:03

Re: Laser-Cut Stand for N900
 
Fake (wonderful nickname for a "tradesman" btw ;))

This is a perfect example of why I love the Maemo community!
Not only did I find numerous software mods for my N900 here, but now you actually found a way to make the N900 "hardware" experience even better! Really great work :)
I was wondering, I am planning to order a set of stands through your webshop, but would you accept a slightly larger payment then necessary (I really like what you're doing here and would like to give you the chance to benefit from your idea) or would that just mess up your system of managing orders and payments?
(For example 30$ for the mixed home&office set...)

Dries


All times are GMT. The time now is 13:14.

vBulletin® Version 3.8.8