Magnificent, I've been looking for something like this to auto fill voucher codes for a captive portal. I took a 4 by 2 ticket template and ordered the codes by 8 columns in the csv, works like a charm, thank you:)
Scribus Generator is now able to merge all output files from its mail-merge function into a single Scribus SLA or PDF file, and can be used from the command line as well. Great for batch use or integrating with other tools. Check out documentation for more: github.com/berteh/ScribusGenerator
I find this script super-useful. It will save dozens of hours in my next project. I, nevertheless, wonder if there is a way to use the scribus master pages (two, left and right minimum) so every line of the csv input file can be assigned sequentially to them in order to have a complete document prepared to commercially print and bind with gutters. Anyway, thanks for your time and effort. We all are grateful.
Bonjour Bertrand Merci beaucoup pour cette vidéo Un tuto en français serait beaucoup apprécié ! Mais je pense m'être débrouillé avec l'anglais. (et je pourrais faire ce tuto en français, aussi...) Cependant, concernant les images : j'ai suivi le pas à pas mais, à partir de 5:50 : j'ai, dans mon dossier : file > dessin.png dans mon document scribus : %VAR_titre% et %VAR_image% et dans mon fichier csv : titre,image whatever,dessin.png Les titres apparaissent bien, pas les images (plusieurs essais, en pdf, svg, png, jpg) Une idée d'où peut venir le problème ? Encore merci !
Hey Question, I am currently on scribus 1.4.8 and ghosscript 10.0.2 specifically to be sure images work as intended. The problem I'm running in to is that the merge requires I go back into th produced SLA document, and then I have to resize each image to fit the square. In CSS and web design you can normally set an image to "cover" the container instead of "containing." I can't seem to find a comparable feature in Scribus that allows me to match the smallest dimension of the image to the largest on the box so that the image covers the available container. This results in my images only containing and leaving empty marks on each file instead of filling to cover it. InDesign has this feature which is really nice and they have implemented it but is there any chance a workaround is available for me? The solution I've found is equally annoying to manually building it, which is cropping images to the same size BEFORE the merge so that they all match the container. This is not a viable option however because my client doesn't want the turnaround for these to be individually based.
thank you for making this. It looks very powerful, but also not that user friendly to use compared to Affinity Publisher or Adobe Indesign. Affinity is $40 one time fee and Adobe is about $30/month fee. I think I might buy Affinity Publisher. What do others think? This is just my first impression. I have not actually done any mail merges in any of these softwares.
I've just discovered this (late to the party!) - thanks! I am looking to use a URL in my brochure that will go to a web page when clicked. Is there a way to do this with the dynamic field as the URL?
11 หลายเดือนก่อน
yes, and the generated link is fullw clickable in the generated pdf. Detailed explanations in the Readme documentation file.
Hello. Is there any problem in using scribus 1.5.8? I'm not able to set the image field: after creating an image frame and after loading the very first image, I cannot set the variable %var_logo%, since there is no such file in the image folder and I cannot click OK. I'm stuck at this point and cannot go any further. Thanks for your help
Is there a way to use it on per-group basis, not per-page? For example, when I have a label sheet (an A4 page with 3x7 sticker grid you can print on), I should be able to design a single object group with replaceable variables, and that group should be merged with data, placed on page, then moved along that page with each data row, according to some defined spacing rules. Basically, what I'm asking is whether Scribus Generator can replace InDesign's data merge feature?
+Przemek Kobel not yet, but it's a planned feature. It's being discussed in github.com/berteh/ScribusGenerator/issues/11 the current blocking element is to find a user-friendly way to represent the "group" specification in the scribus file. to say for instance "the group should repeat horizontally, or vertically, or in an array of 3 columns". If you have any idea please join the discussion on github!
it is now possible using the %SG_NEXT-RECORD% token. you have to create your layout following a few ground rules to make sure the data sequence is kept. doc: github.com/berteh/ScribusGenerator#multiple-records-on-a-single-page walkthrough for complex multi-elements layout: github.com/berteh/ScribusGenerator/wiki#cards-deck-walkthrough
Saluts Mec!!!!, best regards from Spain, let me know if we can print whole job in an only .pdf or its imposible to make, thanks alot for your effort and nice job!!!.
3 ปีที่แล้ว
Sure can. Just check the "pdf" format output box in the ScribusGenerator dialog.
Okay, but where do the image files need to be? You don't mention where to put them. My project is quite large and I would absolutely hate to have to keep my hundreds of images in the same folder as the data file or scribus file...
3 ปีที่แล้ว +1
No need to move them: just create an placeholder image file named %VAR_image% in some root directory that is ancestor to all your images, select it in your template, and handle the relative sub-directories and image file name in the csv value.
@ Unfortunately this doesn't work if you have more than 1 variable image on the page in different folders. So for instance, in my case I have a folder with about 450 pieces of art. Each page will have a unique image. But on top of that, there are a few dozen other variable graphic elements I keep in a seperate folder. Scribus won't look in multiple folders for variable images. The only way I was able to achieve my goal in Scribus was to run the Generatr macro without my assets, save a pdf, then load my assets on top of the new pdf using another Generatr pass. The quality is lackluster.
3 ปีที่แล้ว
@@MassiveSwordAndCards I assure you it should work... i had a seemingly similar setup for a deck of 250+ serious game cards in 4 languages: - Use symbolic links to gather all resources (images, qrcodes,...) artificially as (preferably meaningful) subfolders of a 'root' directory where you then - create as many (dummy or real) placeholder image files as you need in this root directory (1 per variable use, eg %VAR_thumb%.jpg, %VAR_type%.jpg, %VAR_type%_variant.jpg, %VAR_flag%, %VAR_thumb%_QRcode.png ...), then - use these placeholder images in your template for the layout, picking them like normal images - put the relative paths to the real file in your csv, that is *without* the root directory part, only the subdirectories and filename bit (with or without extension depending on how you named your placeholder files) eg: thumb, type, flag paintings/surr/1928/magritte-pipe, icons/surrealism, flags/be.png sculptures/moore/bird-basket, icons/surrealism, flags/uk.png and finally generate the output SLA in the same output directory as your template (input SLA), to be able to check if there is any problem in the images paths before generating the final pdf. Scribus has a quality check feature that highlights missing pictures, cropped text and more, no need to view each page manually. I hope this helps. If not, preferably contact me using the dedicated issue tracker, with attached example CSV and SLA file: github.com/berteh/ScribusGenerator/issues
@ I didn't know about removing the root directory portion, though I'm not sure how the program would even know where to look if you do that. I'll try to figure out what you mean later.
3 ปีที่แล้ว
@@MassiveSwordAndCards Scribus will use as "root" the location of the placeholder image. You can nevertheless be interested in checking the generated SLA file with a text editor if your images don't display... to find out where a possible path problem lies. Some older version of Scribus used to take for root of all images in the document the URL of the first image found in the file, leading to issues when images where scattered in different disks or directories, but I think that has been solved. by the way I did upload a sample template that is a bit more complex, if you're interested: github.com/berteh/ScribusGenerator/wiki#serious-game-cards-deck hope this helps.
C'est vraiment super, mais j'ai une difficulté très bête: lorsque je change le nom de l'image en %VAR_image% , mon scribus (1.5, peut être est-ce là le problème?) refuse. Popup: " fichier introuvable, veuillez vérifier..." Une idée pour contourner cette difficulté?
3 ปีที่แล้ว
Bonjour Thomas. Le plus simple est de créer un simple fichier texte dans votre répertoire des images, le nommer %VAR_image% (ou %VAR_image%.jpg si vous n'utilisez qu'un type d'extensions), et le sélectionner dansn le dialogue de Scribus. Plus de détails: github.com/berteh/ScribusGenerator#dynamic-images
Old version of script can't generate documents with images, new one doesn't work at all: Is it only Windows issue? Traceback (most recent call last): File "", line 8, in File "C:\ScribusGenerator\ScribusGenerator.py", line 434, in main_wrapper(sys.argv) File "C:\ScribusGenerator\ScribusGenerator.py", line 423, in main_wrapper main(argv) File "C:\ScribusGenerator\ScribusGenerator.py", line 414, in main dlg.show() File "C:\ScribusGenerator\ScribusGenerator.py", line 408, in show self.__root.mainloop() File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1125, in mainloop self.tk.mainloop(n) File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1540, in __call__ self.widget._report_exception() File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1290, in _report_exception import sys TypeError: 'NoneType' object is not callable
+kiciafu images have been supported from the first version of the script... and I've got many reports of users for which this script works great, in both Linux and Windows. I personnally use it with great results with scribus 1.4.5 in Win8 (v6.3). for images a classic issue is that images are refered to with relative paths, meaning the location of your generated documents should be relatively similar to the location of your original template. the error you report on the other hand is not pointing me to one particular issue... could you please copy-paste the relevant lines of your scribusgenerator.log file in one issue report in github? github.com/berteh/ScribusGenerator/issues this is my favorite place to centralize support.
Bonjour Bertrand, super tuto. Est-ce possible d'utiliser "scribus generator" pour intégrer plusieurs lignes excel dans un même documents scribus, pour mettre en forme un annuaire par exemple. Hello Bertrand, marvellous tutoriel. Is it possible to use "scribus generator" to integrate several lines excel in the same documents scribus, to format a directory for example. Fred
Bonjour Frédéric. Il est possible d'inclure plusieurs entrées de données dans un seul document en choisissant de générer un document unique "fusionné" de toutes les pages générées, ou bien d'en inclure plusieurs dans une seule page en utilisant la balise %SG_NEXT-RECORD%. Voyez la documentation en ligne et le wiki (comme l'exemple du yearbook): document fusionné: github.com/berteh/ScribusGenerator#merged-output---single-document entrées multiples: github.com/berteh/ScribusGenerator#multiple-records-on-a-single-page yearbook: github.com/berteh/ScribusGenerator/wiki#gallery-of-examples--some-templates Désolé pour cette réponse tardive. J'espère que vous aveiez trouvé cette info entre temps.
Merci c'est exactement ce dont j'avais besoin !
Magnificent, I've been looking for something like this to auto fill voucher codes for a captive portal. I took a 4 by 2 ticket template and ordered the codes by 8 columns in the csv, works like a charm, thank you:)
Thank you so much for this script, it made my life so much easier :)
Excellent Tutorial. Exactly what I was looking for. I can easily use these techniques for making my game cards!
thank you so much !!! exactly what I needed !
Amazing thank you so much!
Scribus Generator is now able to merge all output files from its mail-merge function into a single Scribus SLA or PDF file, and can be used from the command line as well. Great for batch use or integrating with other tools.
Check out documentation for more: github.com/berteh/ScribusGenerator
I find this script super-useful. It will save dozens of hours in my next project. I, nevertheless, wonder if there is a way to use the scribus master pages (two, left and right minimum) so every line of the csv input file can be assigned sequentially to them in order to have a complete document prepared to commercially print and bind with gutters.
Anyway, thanks for your time and effort. We all are grateful.
Thanks! Great and useful
Bonjour Bertrand
Merci beaucoup pour cette vidéo
Un tuto en français serait beaucoup apprécié ! Mais je pense m'être débrouillé avec l'anglais. (et je pourrais faire ce tuto en français, aussi...)
Cependant, concernant les images :
j'ai suivi le pas à pas mais, à partir de 5:50 :
j'ai, dans mon dossier : file > dessin.png
dans mon document scribus : %VAR_titre% et %VAR_image%
et dans mon fichier csv :
titre,image
whatever,dessin.png
Les titres apparaissent bien, pas les images (plusieurs essais, en pdf, svg, png, jpg)
Une idée d'où peut venir le problème ?
Encore merci !
Hey Question,
I am currently on scribus 1.4.8 and ghosscript 10.0.2 specifically to be sure images work as intended.
The problem I'm running in to is that the merge requires I go back into th produced SLA document, and then I have to resize each image to fit the square.
In CSS and web design you can normally set an image to "cover" the container instead of "containing." I can't seem to find a comparable feature in Scribus that allows me to match the smallest dimension of the image to the largest on the box so that the image covers the available container.
This results in my images only containing and leaving empty marks on each file instead of filling to cover it.
InDesign has this feature which is really nice and they have implemented it but is there any chance a workaround is available for me?
The solution I've found is equally annoying to manually building it, which is cropping images to the same size BEFORE the merge so that they all match the container. This is not a viable option however because my client doesn't want the turnaround for these to be individually based.
thank you for making this. It looks very powerful, but also not that user friendly to use compared to Affinity Publisher or Adobe Indesign. Affinity is $40 one time fee and Adobe is about $30/month fee. I think I might buy Affinity Publisher. What do others think? This is just my first impression. I have not actually done any mail merges in any of these softwares.
I mean, I don't know if they can do this. This is a user added function. The reason it's complex is because it is very customisable.
can we use this to create dynamic qr codes in id card
I've just discovered this (late to the party!) - thanks! I am looking to use a URL in my brochure that will go to a web page when clicked. Is there a way to do this with the dynamic field as the URL?
yes, and the generated link is fullw clickable in the generated pdf. Detailed explanations in the Readme documentation file.
Hello. Is there any problem in using scribus 1.5.8? I'm not able to set the image field: after creating an image frame and after loading the very first image, I cannot set the variable %var_logo%, since there is no such file in the image folder and I cannot click OK. I'm stuck at this point and cannot go any further. Thanks for your help
Ok I will answer by myself: the image field only works with scribus 1.4.8. With Scribus 1.5 and over will not
@@giupi1966 thanks for commenting. i was very confused. did you find a workaround?
hi,,,i am missing at 3:43 , where can i download scribusgenerator.py?
click "download" at github.com/berteh/ScribusGenerator
Is there a way to use it on per-group basis, not per-page? For example, when I have a label sheet (an A4 page with 3x7 sticker grid you can print on), I should be able to design a single object group with replaceable variables, and that group should be merged with data, placed on page, then moved along that page with each data row, according to some defined spacing rules.
Basically, what I'm asking is whether Scribus Generator can replace InDesign's data merge feature?
+Przemek Kobel not yet, but it's a planned feature. It's being discussed in github.com/berteh/ScribusGenerator/issues/11
the current blocking element is to find a user-friendly way to represent the "group" specification in the scribus file. to say for instance "the group should repeat horizontally, or vertically, or in an array of 3 columns".
If you have any idea please join the discussion on github!
it is now possible using the %SG_NEXT-RECORD% token. you have to create your layout following a few ground rules to make sure the data sequence is kept.
doc: github.com/berteh/ScribusGenerator#multiple-records-on-a-single-page
walkthrough for complex multi-elements layout: github.com/berteh/ScribusGenerator/wiki#cards-deck-walkthrough
Saluts Mec!!!!, best regards from Spain, let me know if we can print whole job in an only .pdf or its imposible to make, thanks alot for your effort and nice job!!!.
Sure can. Just check the "pdf" format output box in the ScribusGenerator dialog.
Okay, but where do the image files need to be? You don't mention where to put them. My project is quite large and I would absolutely hate to have to keep my hundreds of images in the same folder as the data file or scribus file...
No need to move them: just create an placeholder image file named %VAR_image% in some root directory that is ancestor to all your images, select it in your template, and handle the relative sub-directories and image file name in the csv value.
@ Unfortunately this doesn't work if you have more than 1 variable image on the page in different folders. So for instance, in my case I have a folder with about 450 pieces of art. Each page will have a unique image. But on top of that, there are a few dozen other variable graphic elements I keep in a seperate folder. Scribus won't look in multiple folders for variable images. The only way I was able to achieve my goal in Scribus was to run the Generatr macro without my assets, save a pdf, then load my assets on top of the new pdf using another Generatr pass. The quality is lackluster.
@@MassiveSwordAndCards I assure you it should work... i had a seemingly similar setup for a deck of 250+ serious game cards in 4 languages:
- Use symbolic links to gather all resources (images, qrcodes,...) artificially as (preferably meaningful) subfolders of a 'root' directory where you then
- create as many (dummy or real) placeholder image files as you need in this root directory (1 per variable use, eg %VAR_thumb%.jpg, %VAR_type%.jpg, %VAR_type%_variant.jpg, %VAR_flag%, %VAR_thumb%_QRcode.png ...), then
- use these placeholder images in your template for the layout, picking them like normal images
- put the relative paths to the real file in your csv, that is *without* the root directory part, only the subdirectories and filename bit (with or without extension depending on how you named your placeholder files) eg:
thumb, type, flag
paintings/surr/1928/magritte-pipe, icons/surrealism, flags/be.png
sculptures/moore/bird-basket, icons/surrealism, flags/uk.png
and finally generate the output SLA in the same output directory as your template (input SLA), to be able to check if there is any problem in the images paths before generating the final pdf. Scribus has a quality check feature that highlights missing pictures, cropped text and more, no need to view each page manually.
I hope this helps.
If not, preferably contact me using the dedicated issue tracker, with attached example CSV and SLA file: github.com/berteh/ScribusGenerator/issues
@ I didn't know about removing the root directory portion, though I'm not sure how the program would even know where to look if you do that. I'll try to figure out what you mean later.
@@MassiveSwordAndCards Scribus will use as "root" the location of the placeholder image. You can nevertheless be interested in checking the generated SLA file with a text editor if your images don't display... to find out where a possible path problem lies.
Some older version of Scribus used to take for root of all images in the document the URL of the first image found in the file, leading to issues when images where scattered in different disks or directories, but I think that has been solved.
by the way I did upload a sample template that is a bit more complex, if you're interested: github.com/berteh/ScribusGenerator/wiki#serious-game-cards-deck
hope this helps.
C'est vraiment super, mais j'ai une difficulté très bête: lorsque je change le nom de l'image en %VAR_image% , mon scribus (1.5, peut être est-ce là le problème?) refuse. Popup: " fichier introuvable, veuillez vérifier..." Une idée pour contourner cette difficulté?
Bonjour Thomas. Le plus simple est de créer un simple fichier texte dans votre répertoire des images, le nommer %VAR_image% (ou %VAR_image%.jpg si vous n'utilisez qu'un type d'extensions), et le sélectionner dansn le dialogue de Scribus.
Plus de détails:
github.com/berteh/ScribusGenerator#dynamic-images
Old version of script can't generate documents with images, new one doesn't work at all:
Is it only Windows issue?
Traceback (most recent call last):
File "", line 8, in
File "C:\ScribusGenerator\ScribusGenerator.py", line 434, in
main_wrapper(sys.argv)
File "C:\ScribusGenerator\ScribusGenerator.py", line 423, in main_wrapper
main(argv)
File "C:\ScribusGenerator\ScribusGenerator.py", line 414, in main
dlg.show()
File "C:\ScribusGenerator\ScribusGenerator.py", line 408, in show
self.__root.mainloop()
File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1125, in mainloop
self.tk.mainloop(n)
File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1540, in __call__
self.widget._report_exception()
File "C:\Program Files (x86)\Scribus 1.4.6\lib\lib-tk\Tkinter.py", line 1290, in _report_exception
import sys
TypeError: 'NoneType' object is not callable
+kiciafu images have been supported from the first version of the script... and I've got many reports of users for which this script works great, in both Linux and Windows. I personnally use it with great results with scribus 1.4.5 in Win8 (v6.3).
for images a classic issue is that images are refered to with relative paths, meaning the location of your generated documents should be relatively similar to the location of your original template.
the error you report on the other hand is not pointing me to one particular issue... could you please copy-paste the relevant lines of your scribusgenerator.log file in one issue report in github? github.com/berteh/ScribusGenerator/issues this is my favorite place to centralize support.
+kiciafu details for using images which paths are relative are given here: github.com/berteh/ScribusGenerator/issues/36
Bonjour Bertrand, super tuto.
Est-ce possible d'utiliser "scribus generator" pour intégrer plusieurs lignes excel dans un même documents scribus, pour mettre en forme un annuaire par exemple.
Hello Bertrand, marvellous tutoriel.
Is it possible to use "scribus generator" to integrate several lines excel in the same
documents scribus, to format a directory for example.
Fred
Bonjour Frédéric. Il est possible d'inclure plusieurs entrées de données dans un seul document en choisissant de générer un document unique "fusionné" de toutes les pages générées, ou bien d'en inclure plusieurs dans une seule page en utilisant la balise %SG_NEXT-RECORD%. Voyez la documentation en ligne et le wiki (comme l'exemple du yearbook):
document fusionné: github.com/berteh/ScribusGenerator#merged-output---single-document
entrées multiples: github.com/berteh/ScribusGenerator#multiple-records-on-a-single-page
yearbook: github.com/berteh/ScribusGenerator/wiki#gallery-of-examples--some-templates
Désolé pour cette réponse tardive. J'espère que vous aveiez trouvé cette info entre temps.