Jump to content
You must now use your email address to sign in [click for more info] ×

h_d

Members
  • Posts

    1,472
  • Joined

  • Last visited

Reputation Activity

  1. Like
    h_d got a reaction from kenmcd in Affinity Publisher - "simple" datamerge task   
    Taking it step by step:
    1) Create a single-page document. 
    2) Select the Data Merge Layout tool and drag a rectangle over the printable area of the page. In the Context Toolbar, set the desired number of rows and columns (and gutters as in your .afpub file).

    3) Make sure the Data Merge Layout layer is selected in the Layers panel, as above. Switch to the Frame Text tool and draw a frame in the top left-hand area of the Data Merge area. In the Layers panel, the Frame Text will be 'nested' inside the Data Merge Layout. Double-click in the text frame and type "Your ticket number is..." The text will appear in all eight areas of the Data Merge Layout:

    4) From the Document menu, choose Data Merge Manager. Click the minuscule, near-invisible Add Data Merge Source button and select your .csv.

    5) Make sure that your text-editing cursor is in the top-left frame (ie in editing mode), and then double-click the TicketNumber field in the Fields panel:
     
     
    Again, the <TicketNumber> field name will appear in all eight sections of the layout.
    6) In the Data Merge Manager, click the Generate button. This will create a new untitled document with all your numbered tickets, and as many pages as necessary to accommodate all the data:
     .............>
     
    7) If you want to add additional text, graphics etc then do it in the Data Merge Layout document, with the layout selected in the layers panel and the content in the top left corner. Then generate a new merged document.

     
    Hope this helps.
     
     
     
     
  2. Like
    h_d got a reaction from Alfred in Affinity Publisher - "simple" datamerge task   
    Taking it step by step:
    1) Create a single-page document. 
    2) Select the Data Merge Layout tool and drag a rectangle over the printable area of the page. In the Context Toolbar, set the desired number of rows and columns (and gutters as in your .afpub file).

    3) Make sure the Data Merge Layout layer is selected in the Layers panel, as above. Switch to the Frame Text tool and draw a frame in the top left-hand area of the Data Merge area. In the Layers panel, the Frame Text will be 'nested' inside the Data Merge Layout. Double-click in the text frame and type "Your ticket number is..." The text will appear in all eight areas of the Data Merge Layout:

    4) From the Document menu, choose Data Merge Manager. Click the minuscule, near-invisible Add Data Merge Source button and select your .csv.

    5) Make sure that your text-editing cursor is in the top-left frame (ie in editing mode), and then double-click the TicketNumber field in the Fields panel:
     
     
    Again, the <TicketNumber> field name will appear in all eight sections of the layout.
    6) In the Data Merge Manager, click the Generate button. This will create a new untitled document with all your numbered tickets, and as many pages as necessary to accommodate all the data:
     .............>
     
    7) If you want to add additional text, graphics etc then do it in the Data Merge Layout document, with the layout selected in the layers panel and the content in the top left corner. Then generate a new merged document.

     
    Hope this helps.
     
     
     
     
  3. Like
    h_d got a reaction from Brian_J in Numbers from excel - Publisher   
    There was a similar question a few days back. I think my answer would work here too, although your spreadsheet would need a header row.
  4. Like
    h_d got a reaction from Lyndhurst in Placing screenshots into A4 magazines and improving image quality   
    If I print the web page to PDF I get a printer-friendly version, without the original sidebar. I can then Place it in Publisher and trim it with the Vector Crop tool without needing to open in Photo:

     

  5. Haha
    h_d got a reaction from Petar Petrenko in Typo in Publisher's Workbook   
    I found a typo too. 😉
     
  6. Like
    h_d got a reaction from lacerto in How to make an image consisting of film grains (using Affinity Photo)?   
    I really am no expert, but...
    If you are using one of the free film grain images from the site you quoted above, how are you converting it to greyscale? (The originals are RGB and at 72dpi.) Are you matching the resolution and size of the film grain image to the resolution and size of the photo before compositing? Are you viewing the composite at 100%? You're applying a Gaussian Blur Effect rather than a filter, and not preserving Alpha, so there will be vignetting. You're also applying multiple effects and adjustments to the base image. Are you perhaps over-cooking it? You're simulating the film grain, but what about the paper grain?
    Unless you upload your .afphoto document, with all adjustments, effects and layers in place, it's really hard for anyone to tell what (if anything) you might change to improve your results. 
    Personally I would simplify things. I downloaded the Ilford HP5 sample and converted it to Grey/16 using a Greyscale D50 ICC profile. I then opened an RGB image, ran the same greyscale conversion, downsampled it from 180 dpi to 72. I then cropped the film grain image to the same dimensions as my base image (5184x3888). Then I combined the two images.
    I then applied a Levels adjustment to the film grain image, nothing too drastic:

    and set its blend mode to Soft Light (because experimentation suggested to me that Overlay gave too harsh a result).
    Before:

    After:

    Both the above were grabbed at 100%. The forum software will probably mush them a bit. 
    Whether you, or I, or anyone thinks this is a correct representation of true film grain is totally subjective. 
    Original RGB:

    Layers panel:

    I've attached the full .afphoto document in case you're interested.
    But ultimately, the only way to get film grain is to shoot b/w film, process b/w film, print b/w film. Manipulating a digital original is a simulation, however you do it, and the 'realism' of the result is subjective.
     
     
    film grain.afphoto
  7. Like
    h_d reacted to Old Bruce in What do all these mean?   
    Like any experienced photographer will say "The best camera for that shot is the one you have."
  8. Like
    h_d got a reaction from Old Bruce in How to make an image consisting of film grains (using Affinity Photo)?   
    I really am no expert, but...
    If you are using one of the free film grain images from the site you quoted above, how are you converting it to greyscale? (The originals are RGB and at 72dpi.) Are you matching the resolution and size of the film grain image to the resolution and size of the photo before compositing? Are you viewing the composite at 100%? You're applying a Gaussian Blur Effect rather than a filter, and not preserving Alpha, so there will be vignetting. You're also applying multiple effects and adjustments to the base image. Are you perhaps over-cooking it? You're simulating the film grain, but what about the paper grain?
    Unless you upload your .afphoto document, with all adjustments, effects and layers in place, it's really hard for anyone to tell what (if anything) you might change to improve your results. 
    Personally I would simplify things. I downloaded the Ilford HP5 sample and converted it to Grey/16 using a Greyscale D50 ICC profile. I then opened an RGB image, ran the same greyscale conversion, downsampled it from 180 dpi to 72. I then cropped the film grain image to the same dimensions as my base image (5184x3888). Then I combined the two images.
    I then applied a Levels adjustment to the film grain image, nothing too drastic:

    and set its blend mode to Soft Light (because experimentation suggested to me that Overlay gave too harsh a result).
    Before:

    After:

    Both the above were grabbed at 100%. The forum software will probably mush them a bit. 
    Whether you, or I, or anyone thinks this is a correct representation of true film grain is totally subjective. 
    Original RGB:

    Layers panel:

    I've attached the full .afphoto document in case you're interested.
    But ultimately, the only way to get film grain is to shoot b/w film, process b/w film, print b/w film. Manipulating a digital original is a simulation, however you do it, and the 'realism' of the result is subjective.
     
     
    film grain.afphoto
  9. Haha
    h_d reacted to MaryAnne in Kayboard Shortcut for Switching Between Personas   
    OMG!  You are brilliant!  I'm going to call the Pope right now and get you elevated to sainthood.     Works perfectly.  yippee, skippy!  Thank you, thank you, thank you!
  10. Like
    h_d reacted to Furry in Applying strokes to graphics in Publisher   
    Thank you, h_d, for that information. My remark was simply to say that, regardless of how many posts I have made, I am still very much a newbie at the Affinity suite. I have had a reasonable go at learning AffPub and have got to the stage where I now use it more often than InDesign. I have begun learning the culture of AffDesigner but there is still much that eludes me about it. I am struggling to get my head around being able to work with vectors and pixels in the one document. At this stage I am still strongly addicted to Photoshop but have carefully dipped my toe into the AffPhoto pond and shuddered because the water is still too chilly for me.
    Thank you, Joachim_L for your explanation. Where do I look to find the distinction between documents and rasters? The Finder certainly doesn’t tell me that. Your suggestion about converting to a picture frame makes a lot of sense.
  11. Like
    h_d got a reaction from Old Bruce in Pasting text into Publisher causes formatting issues (split)   
    Hi @Keithyd and welcome!
    First thing to check: in the Context Toolbar, with the text frame selected, make sure the vertical justification is set to Top Align, not Justify Vertically, or the text in the final frame of the flow will spread out vertically to fill that frame, as in the two linked frames below.

    Beyond that, if you can supply a small sample of your .afpub file it will probably make it easier to troubleshoot.
  12. Like
    h_d reacted to Failix in Publisher / Table: Row order changed unintentionally   
    Yes, it was, it is! And it's in the top right of the second of two columns in my table.
    Now I know that I have to be careful when I work with tables - I guess I clicked around a little too carelessly.
    Thank you both for your support!
  13. Like
    h_d got a reaction from Failix in Publisher / Table: Row order changed unintentionally   
    As far as I can see there is no way of dragging columns, rows or cells around the spreadsheet. There's nothing in the help to suggest this as a method, and I've given up trying to achieve it myself. 
    What I think has happened is that @Failix has clicked in a row header and accidentally chosen one of the Sort options:
    From this:

    To this:

    It's the only way I can see of moving whole columns around. Are your columns now in alphabetical (or reverse alphabetical) order?
  14. Like
    h_d reacted to lacerto in Data Mail merge Auto size fit to a table   
    (...)
     
  15. Like
    h_d reacted to Dan C in I give up   
    I hate to be the one to point this out - but how are we expecting the OP to see the replies to this thread, suggesting disabling the 1Password Plugin? 
    I'll DM the user, in the hope that they can see text there!
  16. Like
    h_d reacted to Furry in Graphics supported in Affinity Publisher   
    Thanks for your contribution, h_d.
    I have had Graphic Converter for many years as I keep stumbling across unusual graphic formats that Photoshop won’t open. I use GC to convert them to a format I can use in Photoshop. I haven’t investigated GC’s ability to do batch coversions and will look into it.
    Now, of course, I am in the process of learning how to use the Affinity suite of apps so that I can eventually shed my addiciton to Adobe. I have been using AfPublisher for a while and am reasonably happy with it. I have started using AfDesigner and, whilst I can mostly achieve what I want, I am still not *comfortable* with Designer. Affinity Photo is still on my “yet to grapple” list. But learning is slower when you get older and I am about to turn 80!
    Because I have posted the requisite number of posts in these fora, I am no longer listed as a Newbie. But, believe me, that is still an apt description of my abilities!
  17. Thanks
    h_d got a reaction from tépè in Advanced search/replace   
  18. Like
    h_d reacted to R C-R in Affinity Publisher - "simple" datamerge task   
    Not exactly what you asked about but with the permission of @h_d I adapted that answer to this data merge step by step.afpub file, partially because I need the practice using APub & partially because I myself could use a good guide to using data merge. 🙂
    Errors & omissions are my responsibility.
  19. Thanks
    h_d got a reaction from Aaron M in Line Break Removal - Affinity Designer - Windows   
    Text editing in Designer has its limitations. If you open the file in Publisher, even temporarily, you can choose to display the line breaks (and other special characters), which can make resolving issues like this a lot simpler:

    As far as I'm aware that option doesn't exist in Designer.
  20. Like
    h_d reacted to Old Bruce in Affinity Publisher - "simple" datamerge task   
    There are a lot of really good answers here on the forums, personally I think the best way to call attention to them is when people do as you do and reply that a particular answer has solved their problem. In future folks will do a search and read about that solution from the original poster.
  21. Like
    h_d reacted to Paul Martin in Affinity Publisher - "simple" datamerge task   
    That is absolutely first class, thank you h_d. About twenty times more helpful than what is availble via Help or the tutorial.
    If there is a way of preserving this anwer for posteriority, I would support that.
  22. Like
    h_d got a reaction from Dan C in Affinity Publisher - "simple" datamerge task   
    Taking it step by step:
    1) Create a single-page document. 
    2) Select the Data Merge Layout tool and drag a rectangle over the printable area of the page. In the Context Toolbar, set the desired number of rows and columns (and gutters as in your .afpub file).

    3) Make sure the Data Merge Layout layer is selected in the Layers panel, as above. Switch to the Frame Text tool and draw a frame in the top left-hand area of the Data Merge area. In the Layers panel, the Frame Text will be 'nested' inside the Data Merge Layout. Double-click in the text frame and type "Your ticket number is..." The text will appear in all eight areas of the Data Merge Layout:

    4) From the Document menu, choose Data Merge Manager. Click the minuscule, near-invisible Add Data Merge Source button and select your .csv.

    5) Make sure that your text-editing cursor is in the top-left frame (ie in editing mode), and then double-click the TicketNumber field in the Fields panel:
     
     
    Again, the <TicketNumber> field name will appear in all eight sections of the layout.
    6) In the Data Merge Manager, click the Generate button. This will create a new untitled document with all your numbered tickets, and as many pages as necessary to accommodate all the data:
     .............>
     
    7) If you want to add additional text, graphics etc then do it in the Data Merge Layout document, with the layout selected in the layers panel and the content in the top left corner. Then generate a new merged document.

     
    Hope this helps.
     
     
     
     
  23. Like
    h_d got a reaction from R C-R in Affinity Publisher - "simple" datamerge task   
    Taking it step by step:
    1) Create a single-page document. 
    2) Select the Data Merge Layout tool and drag a rectangle over the printable area of the page. In the Context Toolbar, set the desired number of rows and columns (and gutters as in your .afpub file).

    3) Make sure the Data Merge Layout layer is selected in the Layers panel, as above. Switch to the Frame Text tool and draw a frame in the top left-hand area of the Data Merge area. In the Layers panel, the Frame Text will be 'nested' inside the Data Merge Layout. Double-click in the text frame and type "Your ticket number is..." The text will appear in all eight areas of the Data Merge Layout:

    4) From the Document menu, choose Data Merge Manager. Click the minuscule, near-invisible Add Data Merge Source button and select your .csv.

    5) Make sure that your text-editing cursor is in the top-left frame (ie in editing mode), and then double-click the TicketNumber field in the Fields panel:
     
     
    Again, the <TicketNumber> field name will appear in all eight sections of the layout.
    6) In the Data Merge Manager, click the Generate button. This will create a new untitled document with all your numbered tickets, and as many pages as necessary to accommodate all the data:
     .............>
     
    7) If you want to add additional text, graphics etc then do it in the Data Merge Layout document, with the layout selected in the layers panel and the content in the top left corner. Then generate a new merged document.

     
    Hope this helps.
     
     
     
     
  24. Like
    h_d got a reaction from MikeTO in Data Merge: Resize Font to fit Text Frame   
    I don't think there's any way of doing this automatically.
    (A purist might argue that it would lead to typographical inconsistency and, given the small type sizes, a perceived diminishing of the importance of longer names.
    Who's more important?

    One alternative might be to design the data merge document based on the length of the longest name, possibly allowing for two or three lines of text for really long ones.)
  25. Like
    h_d got a reaction from Aaron Cass in Perspective Matching for the same subject on different shoots   
    Hi @Aaron Cass and welcome.
    I think this is possible. With nothing open in Affinity Photo, go to File and New Stack...
    Click Add, select both images and leave the default settings in the Stack dialog as they are:

    Click OK, wait for it to process.
    You'll now get an Affinity Photo document with a Live Stack Group. Click the x with the wavy line over it and set to Median.

    Right-click on the Live Stack Group and choose Ungroup (or cmd-shift-G on a Mac).
    This will give you two separate aligned layers, one with the old view, one with the new.


    You'll need to crop the document to remove the blank canvas behind - I suspect the client won't notice the trimming - and you should now be able to export the two layers as individual images.
    Really hope this helps, no doubt others will have better ideas.

     
     
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.