Full Version: Import Text (Names)

From: Carl (CSEWELL) [#7]
 1 Aug 2006
To: logojohn [#6] 1 Aug 2006

Of course, it was YOUR idea!

Let me know if you have any problems with the two macros. If you think others will benefit from them, I'll post them. I'm concerned that it has become a 4-step process: 1) create the plate layout; 2) CopyXY the layout, 3) SortObjects the text, 4) Cut-n-Paste the data (okay, 5 if you call Cut and Paste each one step). And step 4 would have to be repeated for multiple columns. I guess if that becomes a 'standard' procedure, we could roll all the macros into one. And the sort could be improved to sort the columns in one-step. Or, perhaps Shaddy's object naming macro could be used to eliminate the SortObjects.

It sure is a lot easier, faster, and more accurate (hopefully) than manually entering the data. Now, if I can only get my customers to supply the data in electronic form! Would customers balk at paying 10 cents (20?) per letter for data entry? Or, would they see a benefit in supplying electronic data if it saved them 20 cents per letter and ensured the accuracy.

I'm not seeing a lot of feedback on the macros, but a few people are downloading them. Hopefully, they are beginning to see the benefits. And you certainly can't beat the price!

---

From: Mike (MIKEN) [#8]
 1 Aug 2006
To: Carl (CSEWELL) [#7] 1 Aug 2006

Carl:

I thank you for your efforts and will try them as soon as possible. As I mentioned earlier some solution to print merge would be very valuable.

---

From: logojohn [#9]
 1 Aug 2006
To: Carl (CSEWELL) [#7] 1 Aug 2006

You can lead a horse to water . . .


How about that for "stunt" quoting.
But after creating toolbars for the macros in coreldraw the 4 steps would be very quick with a little practice. . .and a lot faster than pasting 20-30 lines in one at a time like I sometimes had to.
Now you figured out why I do most of my work in Xenetech. It does do all than in 1 or 2 steps. And it will even create multiple pages will multiple items on each that can be printed or sent to the laser at once. And you can customize your right click menu so the things you use most are always there.

A few years ago it was rare to get an electroinc file and even printed lists weren't the norm.
Lately it has gotten a lot better. A lot of people are emailing orders so they usually have a file or if they type it in the email you can copy and paste from that.

Our prices were set before it was possible for most people. Luckily in this market the per letter price is high enough to cover the typing and setup if needed. We do require it for some double wholesale with lots of names if they want the lower price. Either/or pricing is sometimes a problem. For example if someone sends you a list
and it is Lastname, Firstname, and an initial they don't want and they want it lasered in all caps and the list is Upper/Lower, is that going to save much time?

Many of the great inventors were rediculed at first for things that became essential later.

.

---

From: Dave Jones (DAVERJ) [#10]
 1 Aug 2006
To: logojohn [#9] 1 Aug 2006

Sounds like a good place for a macro. ;-) 

---

From: Carl (CSEWELL) [#11]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

Naw, you could probably do it quicker by importing it into Excel as comma delimited file, deleting the middle initial column, changing the column order, and converting all to upper-case. Far too easy for a macro.

---

From: logojohn [#12]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

Even I thought that was a stretch.
Luckily it doesn't happen real often, mostly names on a sports team so there are usually under 20.

Corel x3 can change the case.


.

---

From: Carl (CSEWELL) [#13]
 1 Aug 2006
To: logojohn [#9] 1 Aug 2006

LogoJohn;

So your satisfied with the way the Cut-n-Paste macro works? Have you tried it in v12 and X3?

---

From: logojohn [#14]
 1 Aug 2006
To: Carl (CSEWELL) [#11] 1 Aug 2006

I have copied and pasted a whole excel column to a different place before processing. Worked pretty good.

I really meant the times where it is just typed in a single column like they did before computers.

Lastname, Firstname I.

.

---

From: logojohn [#15]
 1 Aug 2006
To: Carl (CSEWELL) [#13] 1 Aug 2006

It works great in ver 11 and x3.

.

EDITED: 1 Aug 2006 by LOGOJOHN

---

From: MR C (MOSHE) [#16]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

If a customer calls and wants to come in, I ask them to first email the text.

If a customer is in the shop, I ask them to email the file when they get back to their computer

I tell them that it is more accurate, there is no room for typos

If a customer is in a rush, I have them email the text.
If we are too busy and they are in a big rush, I have them type it on the front computer.

It is very easy to convert all caps to caps and small in the Xenetech or in Word

---

From: Carl (CSEWELL) [#17]
 1 Aug 2006
To: logojohn [#15] 1 Aug 2006

And it was developed on v12.

Thanks for the excellent idea on which the macro is based! I'll tidy it up a bit and post it for the forum. It's definitely not a replacement for Print Merge, but I think it's a couple of steps closer. If nothing else, it's an improvement over manual methods.

---

From: Mike (MIKEN) [#18]
 2 Aug 2006
To: Carl (CSEWELL) [#17] 3 Aug 2006

Carl:

Just got around to trying your import text macro--by necessity--I might add.

If you want to know how it worked--next time you're in St. Louie dinner's on me.

Thanks very much.

---

From: Carl (CSEWELL) [#19]
 3 Aug 2006
To: Mike (MIKEN) [#18] 3 Aug 2006

Excellent. You're very welcome. Thanks for the feedback.

Now, just out of curiosity, would that dinner be McD's, TGI Friday's, or someplace that I'd have to buy new clothes to go to? ;^)

---

From: Mike (MIKEN) [#20]
 3 Aug 2006
To: Carl (CSEWELL) [#19] 3 Aug 2006

Carl:

I'm more of a good food, old clothes guy.

---

Show messages: All  1-6  7-20

Back to thread list | Login

© 2024 Project Beehive Forum