Full Version: Import Text (Names)
From: logojohn [#6]
1 Aug 2006
To: Carl (CSEWELL) [#5] 1 Aug 2006
Thanks, this just gets better all the time.
:-)
.
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
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.
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.
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?
.
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
From: logojohn [#12]
1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006
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
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 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
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
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
I'm more of a good food, old clothes guy.