Page 37 of 79 « First 273536 37 383947 Last »
Reply
Thread Tools
Palleman is offline Palleman
2010-02-13 , 17:39
Posts: 123 | Thanked: 33 times | Joined on Jan 2010 @ Stockholm
#361
Originally Posted by fake View Post
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 is offline fake
2010-02-13 , 18:21
Posts: 277 | Thanked: 348 times | Joined on Nov 2009 @ Fargo, North Dakota, USA
#362
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's Avatar
thp is offline thp
2010-02-13 , 18:27
Posts: 1,391 | Thanked: 4,272 times | Joined on Sep 2007 @ Vienna, Austria
#363
Originally Posted by fake View Post
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 is offline Palleman
2010-02-13 , 18:30
Posts: 123 | Thanked: 33 times | Joined on Jan 2010 @ Stockholm
#364
Originally Posted by fake View Post
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 is offline fake
2010-02-13 , 18:50
Posts: 277 | Thanked: 348 times | Joined on Nov 2009 @ Fargo, North Dakota, USA
#365
Originally Posted by Palleman View Post
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.

Originally Posted by Palleman View Post
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 is offline Palleman
2010-02-13 , 20:30
Posts: 123 | Thanked: 33 times | Joined on Jan 2010 @ Stockholm
#366
Originally Posted by fake View Post
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...
 

The Following User Says Thank You to Palleman For This Useful Post:
les_garten is offline les_garten
2010-02-13 , 22:05
Posts: 1,283 | Thanked: 370 times | Joined on Sep 2009 @ South Florida
#367
Yo,
Just got my 2 Black woods today. Superfast, UBER Perfect product!! Love it, THANX!
__________________
N900 as a Drive Letter in Windows, FULL Root access!!
Maemo! There's a BUG for that!
Cutomize Maemo!
Noobies - Noobies 2 - Maemo 5 - 101
Maemo FAQ
 
fake is offline fake
2010-02-13 , 22:13
Posts: 277 | Thanked: 348 times | Joined on Nov 2009 @ Fargo, North Dakota, USA
#368
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.
Last edited by fake; 2010-02-13 at 22:17.
 
kjmackey is offline kjmackey
2010-02-13 , 22:23
Posts: 151 | Thanked: 178 times | Joined on Oct 2009 @ SF Bay Area
#369
Got my one of each today (just now) - California.

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

The Following User Says Thank You to kjmackey For This Useful Post:
Pfuh3z's Avatar
Pfuh3z is offline Pfuh3z
2010-02-14 , 00:03
Posts: 37 | Thanked: 27 times | Joined on Feb 2010 @ Antwerp, Belgium
#370
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
__________________
Proud owner of
Macbook Pro 15" (Snow Leopard) // Mac Mini (Snow Leopard Server) // Desktop (Ubuntu 9.10, Windows 7)
Nokia N900 (Maemo 5 "Fremantle") // iPod Touch 3G

-- Loving my N900 and the Maemo community since Feb. 2010!
 
Reply
Page 37 of 79 « First 273536 37 383947 Last »

Tags
accessory, acrylic, awesome!, complex pricing structure, holder, inexpensive, n900, n900 stand, stand, stay in school!!!, wood

« Previous Thread | Next Thread »

 
Forum Jump


All times are GMT. The time now is 10:36.

Contact Us - Home - Archive - Top