Forum Replies Created
-
AuthorPosts
-
Scott Irwin
MemberThanks David,
When I did some more digging to find out why this was happening, my designer told me that they were trying to copy from CS6 to CC and I said, “Just open the CS6 file into CC and do your copy / paste, and don’t save the CS6 file.” Which works of course.
I just didn’t know if it was some setting on her machine that I wasn’t familiar with, or a compatibility issue. So CC to CC it is!
Member@Obi-wan – lol, I figured there was a script that could do it, but I haven’t found one that’s “Free” and work probably wouldn’t pay for it.
@Kai – Nothing wrong with the book option other than the fact that you have to open each file from the book and click on the Auto page numbering option. I was opening up all the files manually and doing that, but realized that the book option will open the document AND menu allowing me to just click the box for auto numbering. But when you’re working with 40-60 files it’s still time consuming.
I was hoping there was some script or built-in Indesign command that I missed that would do that. I’ve corrected my templates so that going forward when I start building my files they will be set to Auto page number, but all the books (files) built up to when that happens will have to be done the way I’m doing it now.
MemberI’m pretty sure having to make a separate excel file would be way to time consuming, when I can just change the numbers manually. But if you can make the script allow the user to select what character style to apply the change too, that would be the better solution. I would also request that if you start the script and then click cancel that it doesn’t zero out the pricing, but instead just leaves it as-is.
I’d also like to thank everyone for all the help and fast response to my initial question. You guys are awesome!
MemberWe don’t put any of the sale pricing information into the database because it constantly changes from book to book. So when the initial copy block is pushed onto the page it comes in with just the regular price (which is NOT barred).
When the item goes on sale I then use find/change queries to “add” all that information to the copy block as you’ve seen in previous screenshots. Once the copy block has the Red Save $0 in the first paragraph, and the Sale Price in RED in the other paragaraphs, I use the scripts to change the pricing.
So the database doesn’t contain anything but the basic information and regular price. Everything after that is added in Indesign on the fly when it needs to change.
MemberYes, but the Sale discount is always in the first paragraph of the copy block, BUT I have to manually type that in. So when I do my find change to insert the sale pricing it will put a SAVE $0 in the first paragraph, and I then go through and either change it by hand, or use the price adjuster to add the correct amount of money. But when it comes to adding the % amount to that first paragraph I always type it in by hand.
MemberYes, but the Sale discount is always in the first paragraph of the copy block, BUT I have to manually type that in. So when I do my find change to insert the sale pricing it will put a SAVE $0 in the first paragraph, and I then go through and either change it by hand, or use the price adjuster to add the correct amount of money. But when it comes to adding the % amount to that first paragraph I always type it in by hand.
@ Peter – Thanks for the correction. The script works great! I now have Price Adjuster (set to 3 decimal places for my percents) and Number adjuster (set to two for dollars), and the GREP script setup on their own keyboard shortcuts, so it’s just the press of 2 or 3 buttons now to format a page of sale prices!! Very fast, and very efficient.
EDIT – sorry, I replied to the post, instead of putting this in it’s own at the bottom.
MemberObi – I made a character style called “SALE” which is basically nothing more than a RED version of the normal font. But because it’s its own style I can then use the Number Adjuster or Price Adjuster script to change the price of any number with just that character style. So I just shift-click all the copy blocks that are going to have the same sale pricing and use the script. It works fantastic when I have to add or subtract amounts.
The copy block that I used in the pictures is just one of many on a spread. usually anywhere from 1 to 12 copy block are on a spread. Not all items will be on sale, which is why I use Shift-Click to select only the copy blocks I need to change the pricing.
You’ll notice in the screenshot that there is an area in the script that allows me to select what style I want to apply the math too.
The result ends up looking like this:
Then I would use Peter’s GREP query to remove the 3rd decimal place number and end up with the correct pricing.
Using your script – before:
After (you can see it changes the first number and not the sale price)
Also, if you cancel the script, it changes the first price to $0.00
MemberI changed both of those quotes to the single quote, but it still didn’t work. Though it did give me a different error.
The GREP string in the script is different than the on I used in Find/Change, but I figured it had something to do with scripting.
Member@ Obi-wan – here is a sample sale copy block. The NOW prices are in red and are the ones that are changed to reflect the sale pricing. Those are the ones that have the % off.
@ Peter – thanks for the link. I’ve done everything correctly but the script gives me errors. Here are two screen shots. One is the script in the ExtendScript toolkit and the second is the error the script gives me
Member@ Peter – Thanks for your help! I saved your GREP query when I was testing this a few days ago. As far as your script to automate that, I don’t know where I’m suppose to type that script into, to make it a script? I tried Script Editor, but it comes up with an error. Is there some other place / program I need to use to make it a script I can use in Indesign?
@ Obi-wan – That’s pretty cool! and does indeed give me the correct price with the correct number of decimal places. The only issue with it is that it will only change the first set of numbers in my price line, and not the actual sale pricing. lol. If there was a way to have it give you the option to select a specific character style (which I use for sale pricing) and have it only change that price, that would save a lot of time. As of right now I’d have to highlight each price and use the script. Is that an easy addition?
MemberPeter,
I’ve got both Number Adjuster and Price Adjuster scripts now. I’ve ran tests with both of them, and each one yields almost exact results. I believe the problem stems from the fact that both scripts round UP to the next number, hence changing the final price.
Number Adjuster has a section that is says “how many decimals to round to?” while Price Adjuster call that “Number of Decimals” but they both do the same thing.
Both of the scripts set to 2 decimal places give me this:
Number Adjuster – 70% of 79.99 = 24
Price Adjuster – 70% of 79.99 = 24.00 (I like this format better)
What I need is 23.99Doing the same thing with each script set to 3 decimal places:
Number – 70% of 79.99 = 23.997
Price – 70% of 79.99 = 23.997So it seems that the 3rd decimal number is being rounded up, and skewing the final result. Is there a way to prevent that from happening? So it just doesn’t round the number at all, and leaves the 2 decimal places alone?
or should I leave one of the scripts set to 3 decimal places and use the GREP find/change to remove the 3rd number. I can do that, and I’ve tested it and it works so far, but it’s still another step (albeit faster than doing the pricing by hand).
MemberDavid,
50% of 49.99 = 24.995, so I use 24.99.
50% of 56.99 = 28.495, so I use 28.49.Using those 2 prices as an example for number adjuster and multiplying by 0.5, rounding to 2 decimal places, I get the following:
0.5 X 49.99 = 25
0.5 X 56.99 = 28.5Rounding to 3 decimal places yields me the same results as the calculator, but would require me to manually remove the 3rd decimal place number.
Hope that makes sense.
MemberAdd 15% to all items and make more money, I’m down with that!
Each copy block can have anywhere from one or more price lines. The general look for one copy block is:
Item description
Body Copy
Size / price line $49.99
Size / price line $49.99
Size / price line $56.99Each of those items is its own paragraph (with the appropriate paragraph / character styles added)
That is really the whole thing, only sometimes there is just one price line. But each copy block is always the same discount. So if those prices are Save $5, they are all $5 off, if they are 20% off, all of them would be reduced 20%.
That’s why the number adjuster script works so well. I just select all the copy blocks on a page and tell the script to subtract $10 or whatever from the Sale Price character style, and all of them are done.
MemberSomeone else may have a better solution, but for a quick fix you can make a new character style in your document and name it Superscript.
Edit the character style and go to “Basic Character Formats” and leave everything blank except the POSITION field – change that to Superscript.
Click OK
Now you have a character style that will superscript stuff.
Now do a find change:
Put your registration mark in the find field: ®
and then at the bottom under the Change Format box, change it your character style.It should find all your registration marks and change them to Superscript.
If there are paragraph styles associated with those paragraphs already, you can edit the paragraph style and go down to the GREP Style section:
Click NEW GREP STYLE
Where it says APPLY STYLE NONE – change it to your superscript character style
in the TO TEXT FIELD: Type in your ® symbol.
Click OKNow anytime your have a registration mark in that paragraph style it will automatically be superscript.
Those are the two solutions I can think of right off the bat.
Hope that helps.
SIGH – Dwayne beat me to it.
MemberMore files would look like this because each spread has a spread # and page # associated in the file name…so you’d end up with a 76 page book and files that looked like this:
5CATPWS1_02-03_701.P02.pdf
5CATPWS1_02-03_701.P03.pdf
5CATPWS1_04-05_724.P02.pdf
5CATPWS1_04-05_724.P03.pdf
5CATPWS1_06-07_710.1.P02.pdf
5CATPWS1_06-07_710.1.P03.pdf
5CATPWS1_08-09_740.P02.pdf
5CATPWS1_08-09_740.P03.pdfAll the way to the last page numbers.
-
AuthorPosts