DiZastor
-
Posts
42 -
Joined
-
Last visited
Everything posted by DiZastor
-
Thank you Mark. This works. The inner bleed is exactly what I was expecting. I'm feeling a little out of my depth here... I was just wondering whether this is the correct solution for my situation with wire bound calendars where page 2 is printed on the back of page 1... page 4 on the back of page 3... etc, etc. But I guess that might be part of the printing supplier's task. Thank you again Cheers -
Thank you Mark. I've just been trying it out and think I may not have set my original document up correctly to take advantage of this feature. I am creating a photo calendar where page one is the cover photo and the lower page of a vertical two page spread. Page 2 is the month photo and page 3 the month layout of a complex data merge. When I do an export to pdf, page 1 comes out as a full size spread in landscape, and pages 2 and 3 come out as a single page in portrait. See attached files. Satta's work around is still the only way it works for me. After I've done the merge to create and populate all the calendar pages and saved it, I then change document setup as per Satta and get individual pages with individual bleeds around each page (I think I've described that correctly). So in brief, the inner bleed, in its current format, hasn't worked for me. Cheers Double A4 calendar merge master beta testing inner bleed.afpub double A4 Calendar Beta 2.6 internal bleed.pdf
-
Data Merge Update Failed - could not open file
DiZastor replied to DiZastor's topic in Desktop Questions (macOS and Windows)
OK sorted... Beginner's mistake. I'd moved the old data merge source file to my old files location and hadn't updated the Affinity Publisher file to look for the updated data merge file. So now it's all working fine. 🙄 -
Data Merge Update Failed - could not open file
DiZastor replied to DiZastor's topic in Desktop Questions (macOS and Windows)
Oddly... I have succeeded in updating a different calendar layout from another Affinity Designer file which uses the same Excel data merge source file. Strange. -
I use Affinity Designer to create a calendar with a data merge from Excel. I have just updated my Excel merge file with some of this year's data and got the above message when clicking Update in the data merge source file window. The data source has been saved and closed, the merge file name is correct. The only thing changed from last time I successfully used this was the update to Affinity 2.5.5 and a small data change in the merge file. I have noticed a new file with the same name as my Affinity file with "~lock~" at the end of it. Can anyone help please.
-
Satta's work around worked for me. I'm still patiently waiting for Serif to sit up and take notice though!
-
Thank you Satta. I've just found this topic. I've been wrestling with this issue for over a year. Your work around solution is great. I'm surprised it's still even an issue in Affinity Publisher 2.
-
I'd also like to know if this has progressed as we are now in mid 2023.
-
Thank you. I've sorted it. I got Photo 2 to select the ON1 Plugins directory, then restarted Photo 2 and it appeared.
-
Hi, I've tried to add my ON1 plugin to Affinity 2 by copying the plugin file from directory 1.0 to directory 2.0, ticking unknown plugins box, and restarting Affinity 2. But no luck. I've also tried reinstalling the ON1 plugin but it only asks to be added to Affinity 1 and not Affinity 2. Any ideas?
-
Rounded corners on text frame
DiZastor replied to ConnectCreative's topic in Feedback for Affinity Publisher V1 on Desktop
Works for me! 🙂 DZ -
Thank you for all your help. I've tried both the emoji route and jpg route. They both work well. In my instance where I only need two variations, one black and one grey, the better option is to use the black emoji in both instances and reduce opacity for the grey instance. Cheers DZ
- 47 replies
-
- 1
-
-
- cell background
- data merge
- (and 3 more)
-
I've just created a light grey jpg in Affinity Designer. It was very easy and quick. I'll see how it works on the merge master and merge tomorrow. Cheers DZ
-
Sorry, I meant dynamically select...
-
Thank you Old Bruce. Does the "\1" open up the ability to dynamically create paragraph styles in a text box in the merge master file or is this a process I would have to do manually after creating each individual merged calendar?
-
Thank you. I'm on my mobile now. I'll do that Monday afternoon when I'm back home. Cheers DZ
-
I'm not sure. Excel I think I can handle, but I'm struggling with Affinity Publisher DML settings. Playing with emoji fonts and jpgs has so far led me nowhere except for the moon phases font. My Excel sheet has 372 records, which should exactly fill 12 pages with 31 DML fields. I can preview any record correctly in the Data Merge Manager but on merging get a weird fill. The grey fill and line separators are correctly triggered by the merge but I haven't yet worked out how to depict them in Publisher hence the struggle and discussions on emoji fonts and jpegs. Can you suggest how I can use find and replace interactively with my triggers to get a light grey filled text box and not have an underline on blank records at the end of short months? Cheers DZ
-
Here is a screen shot of the master showing the DML settings. Cheers DZ
-
I've been playing with DML and have successfully created a merge master which when I scroll through the fields for preview everything works well. Lines and shading is yet to be resolved, I've had a few goes but couldn't merge these even though they seemed to work when the correct record was selected. However... when I perform the merge, I get strange results. See attached file. It only produces some of the pages and starts around May and the days are out of sync with page layout. The merge master (below) has made the main merge feint thus difficult to see. I can't find a way of clearing this. It was fine but changed for some reason. I'm learning lots, but it's a bit semi-educated trial and error. Cheers DZ slim calendar mess.pdf
-
Just a thought... I'm going to make a few small jpg files of different colours and then use them instead of the emoji. If it works it opens up colour choices. Cheers DZ
-
Thank you again for your help and patience, I'm making progress Ok, I think I've managed to create the excel part of the data merge to use the DML control. I've tested it with different languages and years and also full and abbreviated day names. Tomorrow I shall work on Slim Calendar 2 using the DML command. Let's see what happens. I've attached a screenshot of the data page. All date related data is from an Excel date formula and format. I used EDATE() to give me a reference to generate the month names from a date (selected cell). Cheers DZ screenshot excel slim calendar2 data file.pdf
-
I found a list of Finnish bank holidays on the Internet. Sorted out the dates as some of them change annually, made a new array in my languages sheet added Finland to my Language selection array. So the answer is yes to both. I used Google translate and online listings in Finnish to double check translations so they should be correct. I also put in DST start and finish dates and times.
-
I printed just January and April to demonstrate the holidays.
-
I may not have got all the Finnish or the dates perfectly correct, but here are two months just to demonstrate. All field contents are merged from the excel file and I selected Finland from my dropdown list in Excel then updated the Merge Manager slim finnish calendar jan and april.pdf
-
I'll see if I can get my head around Data Merge Layout (DML). It seems to be much faster and simpler than the table method I am currently using. So in simple terms, everything you put in the first row of the DML will be filled in the rest until end of page and a new page started automatically. My current Excel Slim calendar layout has a block of columns for each month. I guess that I should change it to 12 x 31 rows for the days of each month plus another 12 x 1 for the month header row "January and Year". I change languages in Excel using a similar vlookup() to the one for the year where one of the columns is a number starting at 1 increasing by 1 for each each language, a column for country which internally deals with day and month names directly from the excel date number. I set out bank holidays for each chosen country on a grid based on 5 columns then use offset() to calculate which 5 column set to use for that language. This picks up the correct bank holidays for that particular country and puts them in the correct position in the calendar. I guess you are Finnish, so I will create one in Finnish and show you what I mean using my original slim calendar layout (because I know that works haha). Cheers DZ
