Curved Text in Round Label Stickers

[fairchance]

I have set up the Round Label Stickers 25 mm size and 70 per sheet. I need to display the text in curved form.

Here are the template and data files:

https://www.dropbox.com/s/dgpvwc6eo8...late.docx?dl=0
https://www.dropbox.com/s/my51bbbi2d...0now.xlsx?dl=0



Regards

[macropod]

fairchance: If you want people to look at your files, it's time you learnt to upload them here - like most people do. Since we have our own file-hosting facility, it's unreasonable to keep expecting people to go to other websites to access them. You can attach files via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

[fairchance]

Dear Sir,

My required sample is attached how I want to get the output. I have added the file through required method. Kindly help me out.

Regards

[macropod]

Your attached document is not suitable for a label mailmerge, which is what you'd need. Label merges use tables and the mergefields must go in the table cells, not in shapes on the page.

As for generating curved text, that requires some complex field coding using PRINT fields, which have to be encoded to suit your particular printer's code language. For example, the following PRINT field could be use with a postscript printer to print text around a circle anywhere on the page:

{PRINT \p page "
/pi 3.14159265358979 def
% The circletext routine describes how to print text in a circle
/circletext
      {cirtextdict begin
           /radius exch def
           /centreangle exch def
           /ptsize exch def
           /str exch def
           /xradius radius ptsize 3 div sub def
           gsave
             centreangle str findhalfangle sub rotate
             str
               {/charcode exch def
                ( ) dup 0 charcode put placechar
               } forall
           grestore
         end
      }def
/cirtextdict 20 dict def
cirtextdict begin
  /findhalfangle
    {stringwidth pop 2 div
      2 xradius mul pi mul div 360 mul
    }def
/placechar
 {/char exch def
   /halfangle char findhalfangle def
   gsave
     halfangle rotate
     radius 0 translate
     90 rotate
     char stringwidth pop 2 div neg 0 moveto
     char show
   grestore
   halfangle 2 mul rotate
 }def
end
% Define the circle's size, position and text
wp$x wp$right sub wp$left add 2 div wp$y wp$top sub wp$bottom add 2 div translate
/Right 0 def                           % Set the circle's horizontal position
/Up 0 def                              % Set the circle's vertical position
/CRadius 45 def                        % Set the circle's radius
/TRadius CRadius 4 sub def             % Position the text inside the circle
/Text (The quick brown fox jumps over the lazy dog.) def
/MyCircle {/saveobj save def           % save current state
            .5 setlinewidth            % set thickness of line
            newpath                    % create a new path
            Right Up CRadius 0 360 arc % define the circle's arc
            closepath stroke           % close the path and draw it
            /Courier findfont          % select the font
            9 scalefont setfont        % set the font size & make it current
            Right Up translate         % set a new origin to match the circle
            Text        % the text to output
            180 rotate Text
            8 270 TRadius circletext   % use the circletext to write the text
            saveobj restore} def       % restore current state
% Output the result
MyCircle"}

The above PRINT field contains the postscript commands to both generate the circle and print the curved text. Colour is not catered for - and I'm not sufficiently well versed with postscript to add it; I haven't worked with postscript for a decade.

There are a numerous variables in the latter parts of this code that you could adjust. First off, for a mailmerge, you'd replace the 'The quick brown fox jumps over the lazy dog.' text with your merge fields. You could also change the circle’s position, defined by the ‘Right’ and ‘Up’ coordinates, its radius ‘Cradius’ and the radius of the text ‘TRadius’ – in this case, ‘CRadius 4 sub’ puts the bottom edge of the text 4pts inside the circle, whereas ‘CRadius 5 add’ would put it 5pts outside the circle. These units are all in points. Similarly, you could change the ‘0 360’ to alter the start and end points of the arc, which you can also leave open by deleting ‘closepath’.

[fairchance]

Sir, the page I set up is a template given by the manufacturer of the label. Physically, label stickers have already circles and we need to populate text in such a manner which I show you with sample file attached with my last message. I have also removed the outlines of circles by changing of its color to white. All are fine but I am unable to generate the curving of text which you tell me about printer coding commands. Different printers behave differently and contains their own drivers.

Is there any other way to populate text on these circles on curving way?

Regards

[macropod]

As I said in post #4, the only way you could produce such curved text via a mailmerge would be to set the document up for a label merge and use PRINT fields to curve the output. Although the PRINT field my previous post demonstrates can produce both the circle and the text (which is the surest way of getting the alignment right), it could produce just the curved text.

By their very nature, PRINT fields have to be encoded with the language (e.g. postscript, PCL, PDL, KPDL, etc.) used by the target printer.

For what you want, most commercial printers should have the ability to take your data as a CSV file and use their own software to parse and curve it onto the labels.

[fairchance]

Sir, Here is the output file which I desire.

[macropod]

Please read my previous reply. There is no point continuing with this as what you want to do isn't feasible unless you're prepared to invest the effort it requires to: (a) find out what print language your printer works with; and (b) encode the logic for the curved output into a PRINT field. And, since you can't see what the PRINT field will produce, any debugging of the field code to: (a) confirm that it works; and (b) get the positioning right on the page, will require a lot of time sending output files to the printer to see whether it works and code corrections and what fine-tuning might be required.