DATA MERGE ICON UPDATE
DATA MERGE ICON CODE

If the anchored image goes in overset because the text frame cannot hold it you have no access anymore to properties like position, width and height and therefore you have problems to scale it.Ī script could circumvent this issue by first placing the image not in a text frame, then do the scaling action and afterwards will anchor the container frame at the right position. If the frames that are prepared for the merge are anchored this would also require a text frame big enough to hold any placed image from the start. An image that is placed that the container fits the image.Ģ.

It would require at least a two-step process:ġ. I gave Andy's problem some thoughts yesterday and also tested a bit with the data.Īs far as I can see there is no solution without using to script the placed image containers in the merged document. I have uploaded a link here with test data: I have been trying for a few hours now with various content fitting options etc to no avail. So when I ask it to fit frame to content it brings the image in at 100% (way too big) and if I fit images proportionally then they come in at 19.7% but the frame is whatever it is set in the orginal indesign file. It is worth mentioning that all of the images are the same height but their widths are different (Eg some square and some rectangular) (not creating loads of different sized icons for use with different templates). Now heres the issue im having, I need the images to come in a specific percentage (19.7%) to be precise, as I have used the icons on another template and need to be able to reuse these in multiple varying sized templates. I have created a text box that contains image boxes so I can make the images align to the right, and as the icons come in, the frame fits to them and they can all sit nicely next to each other (clever ay?)

DATA MERGE ICON UPDATE

The map in the merged table will update the next time it is loaded.Im hoping you can help me with a data merge image issue?īasically, I want to import icons into a file and then the frame to fit the image so they all but up nicely together.

Choose the new 'Icon name' or 'Color' column from the pull-down menu.īonus! To change the icon style, simply edit the legend table.

Make sure the radio button is selected next to 'by column.'.

With ' Icon' or ' Polygon fill' as appropriate selected on the left, click ' by column.'.

In the merged table, click Visualize > Map.

The merged table will show the new column with a different background color.

Give the table a new name, and click ' Merge.'.

On the right, make sure the ' Category' radio button is selected.

On the left, select the radio button next to the column with categories.

Paste the URL into ' merge with:' and click Get.Copy the URL for this new table from the URL bar in your browser.Create a new Fusion Table by importing your new file.

DATA MERGE ICON CODE

In the 'Color' column, use the hex code or color name. To color a line or polygon instead, make a table like this one. The file can be a Google Spreadsheet, Excel spreadsheet, or .csv file. Make sure the text in the Category column exactly matches the entries in your original data table: It's easy to use Google Spreadsheets or any spreadsheet editor. Create a second table with the legend information.The same features are supported in the New look. These steps describe Classic Fusion Tables. You can then create a map and style it using the icon names column. If you create a second table with this legend and merge it with your original table, you'll have a new, merged table with the icons assigned to each category. You'd like to use a different icon for each row on the map: For example, it may contain either 'Republican', 'Democrat' or 'Independent' like the Sponsoring party column shown below.ġ000 Avenida Independencia, South Maintown

Let's say that one column in your data always contains one of a short list of values. You can use the merge tables feature in Fusion Tables to quickly assign icon names or color names to rows in a table based on categories, and avoid laboriously editing the original table. As introduced in set map styles, you can tell Fusion Tables to look in a particular column to determine the icon or color of map features.

Data merge icon