Participating Frequently

Question

Automating a Product Style Catalog

Forum|Forum|1 year ago
September 6, 2024
3 replies
2263 views

I am creating a very simple table orientated product style catalog for work. Starting off with 250 products and growing up to 6K. I use photoshop mostly, and not very fluid with InDesign. I figured this would be dead simple to automate, but keep hitting barrier after barrier. I'll explain the problems I am having to see is there are any soltutions. I am using a parent page with header, footer and page count.

First off, data merge doesn't work with tables. Not sure why Adobe hasn't updated this. I found a script that I thought was going to bridge that gap, but I cannot get it to work. Found the script here:

https://www.youtube.com/watch?v=AD2NwzTAN7w&t=1s

Seemed to be cake and this is exactly what I am tryign to do, but maybe the newest update broke it. In fact, I get the same error referenced in this article:

https://community.adobe.com/t5/indesign-discussions/quot-referenceerror-object-is-invalid-102-quot-with-script-csv2table/m-p/14841013#M587705

After abandoning that, I thought of maybe doing two different merges, one table data and the other with thier respective images. Placing the table with the data worked just fine, even though the saved formating I used really didn't take. But, trying to place multiple images is giving mixed results. Reference:

https://www.youtube.com/watch?v=ylw6_6keG30&t=186s

Using data merge and create merge document, sometimes the "multiple records" is greyed out. When going through the process, it creates multiple pages, placing one image per page and also duplicating the data table. Very annoying and not sure where the problem is coming from.

In the meantime, I am going to manually create this catalog. But find it very disappointing that InDesign doesn't have built in automation to pull data and images from a table to create a simple formatted layout. On Win 11 Pro with newest version of InDesign 2024.

Any help is greatly appreciated. Here is an example image of what I am tryign to accomplish.

AlanGilbertson

Community Expert

As simple as this application is, it isn't how Data Merge works. I can recommmend em Software's WordsFlow, which allows you to place Excel spreadsheets and maintain your InDesign formatting when the spreadsheet updates, and InData, which is tailor-made for simple catalog work.

However, you say you're a beginner with InDesign and from the tone of your post it doesn't seem like this project is on a tight deadline, so I'm going to suggest doing something else first: master the basics of InDesign before you tackle something that is decidedly not part of "InDesign 101." None of the catalog options discussed here are hard unless you are not familiar with InDesign. Their user documentation assumes an intermediate level of knowledge, so it will be a tough slog for a relative newbie.

I would strongly recommend taking the time to go through David Blatner's InDesign Essential Training title on LinkedIn Learning, or an equivalent on SkillShare. You should be able to complete the training within the free intro period, and you will set yourself up for successful implementation.

In general, it isn't productive to try to find out how to do one isolated thing with any professional-grade tool like InDesign. Learn the overall functioning of the tool first, then get into more complex operations.

Dave Creamer of IDEAS

Community Expert

Technically, one can do the Excel link without additional software; where WordsFlow shines is with two-way workflow with Word documents.

The other problem is the automatic placement of graphics.

David Creamer: Community Expert (ACI and ACE 1995-2023)

AlanGilbertson

Community Expert

@AlanGilbertson Cell styles, connected to Paragraph styles are retained using the built-in Excel linking.

In addition to Cell styles, WordsFlow does retain directly-applied Paragrpah style, Character style, and manual formatting.

Also, with WordsFlow, one has to be careful with edits made directly in InDesign. If the same cell is edited with different data, both data is retained in the cell. Strange things can happen with conflicting merging of cells too.

It's strictly one-way now, iirc. On the WF page, they call it "one and a half way," but the bottom line is changes made inside InDesign are not propagated back to Excel.

Robert at ID-Tasker

Legend

@NMX_00

Unfortunately, built in DataMerge is limited to either long tables or business cards / leaflets.

You have multiple tables with different number of rows.

Your options are:

1) expensive 3rd party solution - what @Dave Creamer of IDEAS mentioned,

2) import Excel as one long table, then use a dedicated script that will either format headers or split it into separate tables,

3) less expensive, dedicated 3rd party solution 😉

Which option you choose depends on your budget and how many bells and whistles you need.

Dave Creamer of IDEAS

Community Expert

1. Regarding expensive 3rd party solutions...

That is subjective depending on the job. I was producing 800-page directories about every two weeks for 1-1/2 years with the InData plugin. At the time, the plugin was around $400 US which more than paid for itself. (Em Software has a different price structure now and you can subscribe for 6 months for $129 US if it's a short schedule; longer terms have more savings.)

TeaCup Software's Datalinker is $149 per year--again not outragous if one values one's time.

65bit Easy Catalog Lite is $299 but appears to need updates for new ID versions. They have (much) more expensive option but that probably wouldn't be necessary.

2. You don't have to import as one long table--you can use named regions. You can bring images in from an Excel file with some restrictions: it can't be placed into a cell oddly enough, it must be placed over the cell and sized to the cell. InDesign will anchor it to the cell upon import.

3. We wouldn't be talking about one of your scripts--would we? 😜

David Creamer: Community Expert (ACI and ACE 1995-2023)

Robert at ID-Tasker

Legend

Then looks like I was looking at wrong price lists - what I saw was at least $600-1200 / year for a basic version plus $200-300 for additional modules?

Named regions would require manual importing of each one?

I was suggesting using DataMerge to import everything in one go - then either formatting or splitting + formatting.

Yes, my IDT 😉 not free but overall should provide much more versatility.

With correctly prepared data - step that would've to be done anyway - it could be one-click-solution - import + post-processing = ready-to-print.

Dave Creamer of IDEAS

Community Expert

I would look at a third-party plugin for database publishing. They come in two categories: import from a delimited or Excel file; or connect directly to database(s). Some companies are Em Software, Teacup Software, and 65bit. There are others, but these are the ones I use, with Em Software InData being my go-to solution.

David Creamer: Community Expert (ACI and ACE 1995-2023)

Brad @ Roaring Mouse

Community Expert

I also recommend a third-party dedicated plugin. I tried out several several years ago to assemble large company directories on a regular basis. Em Software's InData was the one I ended up with for MY specific purposes (not necessarily promoting theirs over others), and it saved me so much time, and did very much pay for itself very quickly the first year. In fact, once I worked out the template for my info (which will be the longest time involvement), it literally generated a 200-page catalog in less than 20 minutes, and it only got easier each year.

That being said, these plug-ins work best on very well shaped data sources, so it might take you awhile to tweak your CSV file.

Robert at ID-Tasker

Legend

[...]

That being said, these plug-ins work best on very well shaped data sources, so it might take you awhile to tweak your CSV file.

By @Brad @ Roaring Mouse

That's always the MOST important part of the whole workflow - and the person preparing data - does at least 80% of the overall work.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded