- Posts
I would like to be able to set up a master page background of sorts that can be called for in by a datasource. I have a spreadsheet containing main manufactures and have specific brand guidelines to follow as far as layout and fonts go. Right now i would just have multiple template documents but i would love it i could combine them in to one document with multiple master pages and run it all together. That way i could run the entire batch overnight and just do all my fixups in the morning. This file can contain more than 10,000 records and making multiple passes means alot of waiting until one is finished moving to the next one starting it and waiting… Which is a bit more babysitting than i would like to do.
If Data source contains HONDA use the HONDA masterpage element then populate the Variables contained in that Master Page with the data and export individual file.
If Data source contains Subaru use the Subaru masterpage element then populate the Variables contained in that Master Page with the data and export individual file.
and so on
Hi rskinner and welcome to the support forum.
- Do the data fields itself change between (master) layouts or are they the same? Example: For Honda you have the same fields than for Subaru but another layout.
- Do you have all fields in one database or do you have different databases for different brands? Or do you have the possibility to split them by brand?
Regards
John
Official MyDataMerge Team
Currently this does not work. However we have batch processing on our roadmap.
Here is how you would do it today:- Prepare your layout for one brand e.g. Honda.
- Create a new project in MyDataMerge
- Drag & Drop your layout and FULL database
- Setup all placeholders or use autolink feature
- Setup export Options e.g. one document per record and setup individual filenames if needed
- Go to export > extras > record filter and setup a filter so that only Honda records get processed
- Save the project
Now duplicate the project for every other brand and rename it e.g. Subaru
- Open the Subaru project.
- Replace the layout with Subaru layout by just drag and drop it – as long as it contains the same placeholders this will run flawlessly
- Go to export > extras > record filter and setup a filter so that only Subaru records get processed
Repeat the above steps for every brand. Then you will end up with
- 1 project for every brand
- 1 shared data source with all brands
- 1 layout for every brand
In future all you have to do is to load a project and run it. MyDataMerge will automatically recognize changes in layout and data source. Give it a try.
The batch processing I mentioned will process multiple projects in a row. This keeps the layouts clean, the projects clean and the data source in one piece.
Official MyDataMerge Team
Next to the batch processing I will still take your idea to our developers.
:)
Regards John
Official MyDataMerge Team
Almost :)
But you got the idea – we try to keep it as clean as possible and also not to force users to change the datasource.
Did you try the solution proposed?Regards,
JohnOfficial MyDataMerge Team
This is the nice thing about saved projects (MyDataMerge project files) what i mentioned above.
You have one project for Subaru which includes the GLOBAL (onliest) datasource and the layout for Subaru. The project file itself is set up so that it only processes Subaru records. You need to setup a project only once. Then you open it and run it. That’s it. It will recognized an updated data source automatically.
The batch processing we plan is the processing of multiple project files in a row.
- Subaru project
- Honda project
- Whatever project
- …
All of them have their own layout and own setup due to the project file (which basically is the same except for the Brand filter) but share one global datasource.
Handling of multiple thousands of records is the same than handling 20 records. It just takes longer. Memory management is optimized. MyDataMerge will scan all records before pocessing them to identify potential job-killers like missing fields and gives you the opportunity to add custom scenarios for different cases. So before you leave the office, press “Export” and make sure the mac doesn’t start sleep mode, installs updates at night […] :D
And it should be done.
Official MyDataMerge Team
We also help customers to set up projects. That means you may send us (maybe anonymized) data source and layout and we help you building a project. We also can do a websession by screen and me or one of my colleagues helps you setting it up right on your mac.
Official MyDataMerge Team
Hi there,
FF Chartwell works – although there are limitations which come from the font itself:
(Source: colecandoo.com)- Most charts represent figures from 0-100. This is fine for percentile charts such as pie, rose, ring or radar charts, but limits the use of bar and line graphs;
- While the font allows a pie graph to turn into a donut, be aware that the hole is made using a fill colour rather than being transparent;
- The data in the charts must be integers (e.g. whole numbers, no fractions) and this means rounding results up or down accordingly. For percentile charts it is also important to make sure the total of figures in the data adds up to 100.
If you have one placeholder like “<<graph>>” and MyDataMerge returns something like “a+10+20+30” this will produce a graph in ONE COLOR.
If you need multicolored graphs you need to add a placeholder for each value: “a+<<value1>>+<<value2>>+<<value3>>” then you can color each placeholder differently. But that might end up in a really complex setups if you have like 10 graphs with 10 values each you have 100 placeholders to set up. MyDataMerge still can handle that.
Official MyDataMerge Team
I will close this post as feature suggestions are already made. For support on more specific topics like ff chartwell please open a thread in the support forum.
Regards
Pat
Official MyDataMerge Team
- The topic ‘Master Page Based Layouts’ is closed to new replies.