Okay wicked smaht people-
Maritz' horribly antiquated and user un-friendly website does not appear to have a way to download your to-do list as a spreadsheet. I currently have about a hundred locations lined up for June but no way to map them out without copy/pasting every freaking address individually from their website. I called and they claim they have no way of sending out my list (even though they probably do just don't know how to figure it out).
Anybody have any creative ways of making this easy on myself? If you try to copy more than one address at a time you end up getting tons of line breaks and all the rest of the data for the shop so it doesn't seem to make sense to do it right from their site...

Doesn't seem like it would be that hard to copy the whole list and past into a spreadsheet and then toy with it to get rid of the superfluous information and import into streets and trips. Seems like the quickest way to me.

If you are doing that many locations with Maritz then they should be willing to send you the addresses either as a spreadsheet or at least as a text document which you can then manipulate.

Of course, you must telephone them because they don't answer e-mail -- then hopefully find a person who knows how to e-mail you the list. Perhaps they will have to print the list and snail mail it to you so that you can scan with OCR and then manipulate.

These people are technological clowns.

@bgriffin wrote:

Doesn't seem like it would be that hard to copy the whole list and past into a spreadsheet and then toy with it to get rid of the superfluous information and import into streets and trips. Seems like the quickest way to me.

The amount of superfluous crap that comes along when you do that takes longer to eliminate than just cutting and pasting. They make life so difficult. I just spoke to one of the supervisors who definitely knows how their systems work and even she couldn't make this happen from her end.



Edited 1 time(s). Last edit at 05/25/2016 08:27PM by Hoju.

@Hoju wrote:

Okay wicked smaht people-

First of all, you are a wicked pissah! Let's meet up for some clam chowdah, boiled lobstah, littlenecks and stuffed quahogs. And Magic Hat #9,

Second, if you log on to the Maritz CX website and go to "My Current Shops, open up the first page of any of the shops. Then scroll down and go to the "Print/View Complete List of Shops for this Project" where you can print the list. But before you do that, you can copy the entire list and paste it into MS Word. Besides adding an additional space or page break here and there, I had no major formatting issues. I believe you could also merge the list into Excel but I don't remember how to do that at the moment.

First of all, I've never once heard anyone use the term "wicked pissah" without saying it sarcastically.

Secondly, I was JUST able to copy/paste from that page right into Mac Numbers (the Mac version of Excel, it didn't work in Excel) and it got me 95% of the way there. That's my plan from now on.
Thanks, Sybil!

Wicked pissah is a good thing.

@Sybil2 wrote:

Let's meet up for some clam chowdah, boiled lobstah, littlenecks and stuffed quahogs.

WOO-HOO! I can't believe there's someone else out there who knows what a QUAHOG is!!! (I grew up in Mass. but live down South now! Quahogs down here are called little necks). As a little girl, we lived up the street from a small river. I would walk down the end of our street when it was low tide, walk FAR out into the water, sit down, scratch down in the muddy low-tide water with my hands, find a quahog in the mud, crack it on a rock, rinse it off in the salt water, and EAT it! Raw! It was SCRUMPTOUS!!! Sybil 2, you brought all that memory back just by what you typed above!! I know this was off topic, but I couldn't help myself!!!

That's ok! THe topic is essentially closed anyway.

I'm from the north of Boston suburbs and absolutely hate seafood. The only reason I know what a Quahog is is from watching Family Guy.

I know wicked pissah is a good thing, I still never hear anybody use it that isn't pretty much using it in the exact same way you are- to illustrate a Boston accent.



Edited 1 time(s). Last edit at 05/26/2016 01:25AM by Hoju.

@Hoju wrote:

I'm from the north of Boston suburbs and absolutely hate seafood. The only reason I know what a Quahog is is from watching Family Guy.

I could eat seafood until it was coming out my ears!!!!!!!!!!! (Except for eels!)

@guysmom, I am glad I could help for once. And you are not going off-topic. We are going to make an additional route of seafood delights for Hoju to add to his gas station route.

@Hoju wrote:

I know wicked pissah is a good thing, I still never hear anybody use it that isn't pretty much using it in the exact same way you are- to illustrate a Boston accent.

You have to remember, I am younger than you! Of course we speak a different language!

@guysmom, I love, love, love eel!

@Sybil2 wrote:

@guysmom, I love, love, love eel!

I ate it once.....with johnny cakes.....I can't say I hated it....just didn't enjoy it much.

I dated a fella once....many, MANY moons ago.....and we went eel-catching and caught one! I remember him taking a bat and whacking the eel in the head and then cutting his neck off...then peeling the skin down the length of its body---with PLIERS no less.....what a memory, huh???

Edited 1 time(s). Last edit at 05/26/2016 01:42AM by guysmom.

Sounds romantic. NOT!

I don't kill my own food. I eat eel as sushi.

I say I love seafood (and I DO!!!) but I have NEVER eaten sushi!!! Just can't bring myself to do it! Weird, coming from someone who could scoff down a dozen raw quahogs at one sitting! But even the quahogs I don't eat raw anymore, due to the polluted waters they come from.

Unagi (eel sushi) is peeled, cooked and served warm. No pliers needed.

I'm sure there are easier ways now of peeling eel skin off an eel than when I saw this, going back, oh, say, about 40 years ago! I guess the skin had to come off so it wouldn't be so chewy or something....I can't remember why....but I remember the pliers!!

This conversation is gross.

My husband says sushi in Texas is called bait. Our local grocery had an area devoted to sushi but I never saw anyone purchase it. Management removed it and expanded the coffee shop.

Hands Hoju some Ikura (Salmon roe, aka fish eggs) They squish in your mouth. Yummy!

I don't even know who you are anymore.

@mamx44 wrote:

My husband says sushi in Texas is called bait.

Ha Ha!! Funny!!

With Memorial Day being Monday, does MaritzCX have any fishing routes come up

From your My Current Shops page, copy all columns of the shops you want to map.
Paste into Excel spreadsheet, retaining original formatting.
Delete all columns except for the address column.
Copy that column.
Paste into Word document, text only.
Manually remove stray line breaks and insert a second line break after each zip code.
Use “Replace” to replace all double line breaks with @@@
Use “Replace” to replace all remaining line breaks with a comma followed by a space.
Use “Replace” to replace all “@@@” with a single line break.
Copy all.
Open new spreadsheet.
Enter a title into the first cell (e.g. Maritz 2016 Q2).
Paste starting at cell A2 the contents of your clipboard (what you copied from the spreadsheet).
Save with a name like Maritz 2016 Q2 and close spreadsheet.
Open Google Maps.
Create a new map.
Import locations from the spreadsheet that you just saved.
Use whatever you put in that first cell to answer the two questions that G-Maps asks you when placing the locations.
You now have a spotter map of all your locations.
I just created a map of 148 locations in under eight minutes.
I visually create my routes by just leaving them in the clusters that are already there.
You can also color code the spots by routes or days or whatever, add layers to the map for additional clients, use street view to verify the location before routing it, etc.

It took me longer than eight minutes to read your instructions.

It took me twice as long to type them.

In honor of @Hoju and @guysmom, I had an eel and avocado sushi roll appetizer followed by a boiled 1 1/4 lb lobster with melted butter. for dinner tonight. They did not have Magic Hat #9 so I made up for it by trying different microbrews. Do you know how hard it is to type right now and correct all those typos so the Grammar and Punctuation Police don't ticket me? And if you do, I'll just give you my MS'ing ID with my fake MS'ing name on it! Great start to MDW!

Although I figured out a system that works for me, I really appreciate @elcarev68 taking an hour to write that whole thing out!

Also, I'm pretty sure @Sybil2 is drunk.

@Hoju wrote:

Also, I'm pretty sure @Sybil2 is drunk.

Almost a week later and I'm still drunk! Jealous much, Hoju?