...not directly with quark, however you can export a numbered tab delimited file from excel and import into quark linked text boxes...
...the first step is to create a numbered row in excel, copy across using the 'fill series' option...
...set up linked text boxes on a master page (four in total), big enough to hold the size of font and length of the longest number you might have...
...to link text boxes you need to use the link tool in the tools palette, the one above the broken link icon...
...the first text box needs to be linked to that link symbol on the top left of the page (click the top left link symbol then the first text box), then link the other three in the sequence you want the numbers to fall. This allows any new pages created for the numbers to flow into automatically...
...on your first page (linked to the master you have created), click in the first box and choose file > get text, then find your tab delimited text file...
...when imported each number will have a tab character after it, so choose edit > find/change and enter:
\t
...and in the change to field enter:
\c
...click on 'find next'...
...then just click 'change all' button far right of the dialog...
...this will force each number into it's own text box, once it gets to the last box quark created a new page based on the master, this continues until you run out of numbers from the excel file...
...another way is to use this applescript to generate numbers, then import to quark with style sheets enabled (in the get text dialog), copy and paste this script into applescript editor and save as an application (NOTE: For Mac users only):
repeat
set StartDialog to display dialog "What is your start number for this serie?" default answer "1" with icon note
try
set StartNum to (text returned of StartDialog) as integer
exit repeat
on error
display dialog "Integers only please!" with icon caution
end try
end repeat
repeat
set EndDialog to display dialog "What is your end number for this serie?" default answer "100" with icon note
try
set EndNum to (text returned of EndDialog) as integer
exit repeat
on error
display dialog "Integers only please!" with icon caution
end try
end repeat
repeat
set IncrementDialog to display dialog "What is the increment betwenn each number?" default answer "1" with icon note
try
set Increment to (text returned of IncrementDialog) as integer
exit repeat
on error
display dialog "Integers only please!" with icon caution
end try
end repeat
if (StartNum < EndNum and Increment > 0) or (StartNum > EndNum and Increment < 0) then
set NumList to {}
repeat with i from StartNum to EndNum by Increment
set end of NumList to i
end repeat
set oldDelims to AppleScript's text item delimiters
set AppleScript's text item delimiters to {"<\\b>"}
set NumString to NumList as string
set AppleScript's text item delimiters to oldDelims
set NumFile to choose file name with prompt "Where would you like to save this serie?" default name "*.xtg"
set aFile to open for access NumFile with write permission
try
write NumString to aFile
close access aFile
on error
close access aFile
end try
else
display dialog "Sorry, I cannot serialize " & StartNum & " to " & EndNum & " by " & Increment & "!" with icon stop
end if
...and another way to generate numbers via excel is as follows:
In Quark:
Set up your master page with the layout of your tickets, as many up as required.
Create a text box that will hold the unique number on each ticket, ensuring your text box is adequate for long numbers.
Chain link the text boxes in sequence to the master chain (that chain icon at the top left of the master page).
Ensure your document has auto page insertion turned on in the preferences of Quark.
In Excel:
Type a digit "1" in cell A1.
Type a digit "2" in cell A2.
Select these two cells and extend your selection downward by dragging the little square dot at the bottom right of your selection. (You should see a little text box next to your pointer showing the value of the adjacent cell, drag downward until it reaches a number you require).
Save your document as Tab Delimited Text (file > save as).
Using Word or another text editor with a find/change function:
Open your Tab Delimited text file and replace all Paragraph Marks with "<\b>" (without the quotes).
Save your document as Text Only.
Back in Quark:
Select the first text box on page 1 that will receive the first number.
Choose File > Get text (locate your edited text file) and turn on "Include style sheets".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.