News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Adding new shapes after refresh data from excel source

Started by WCTICK, December 04, 2023, 06:11:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

WCTICK

I have a Visio Org Chart that is linked to an Excel spreadsheet with Position Number being the unique identifier.

Since the last refresh, our company has gotten approval to add multiple new positions under an existing manager.  After performing the data refresh, the new rows show in external data, but are not linked to an existing shape in the chart since they are new.

I am having a difficult time trying to figure out how to get those new positions added to the org chart page the manager is currently on.

When I click on the external data row, containing a new row, that doesn't show the Link icon and try to drag it on the page, I get the message, "One or more of the shapes are already linked to a row in the same data source.  Would you like to continue and replace the existing Links?"

If I select yes, I don't see the shape added to the page.  If I search for the PN, which is contained in the shape text, it shows in a lighter background and then "disappears" after I close out the search window.

Can someone tell me how I can add the new data rows containing the new positions to the Org Chart and link the data so they will update if necessary when another refresh is performed?  Thanks!

WCTICK

I found if I copied/pasted an existing shape, I could then select an unlinked row and drop it on the copied shape and it would update with the correct shape text fields and shape data.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 151 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1049KB.
Tokens: post-login.
Cache hits: 13: 0.00164s for 26,732 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]