THE PROBLEM: Let's say you have a large store spread across several floors of a building, with many many aisles and sections. There are information kiosks located at various rooms in the store, oriented different directions. Each information kiosk has a map of the store on it, with the aisles and sections numbered and labeled, and the map rearranged and the text rotated to the viewpoint of the customer standing at the information desk. What is the most efficient way to create and update that map as sections change?
DETAILS: Right now, we have 8+ different files, one for each of the maps at each of the individual kiosks. We update them every year or so, so right now I'm taking the 100+ aisle/section changes in all the rooms and individually changing each one in one map's Adobe Illustrator file. I plan on using that map as a master, and it looks like I'll probably have to go from room to room in the different files, comparing every aisle with the corrected master map, and changing all those by hand. Le sigh.
COMPLICATION: Along with the rooms rearranging to the orientation of each map, on a few maps the entire layout is rotated, so the text is upside down (compared to the other maps).
THE ONLY IDEA I'VE HAD SO FAR: Making the map of each room an InDesign file, and then creating custom image boxes in the shape of each room on each map's master file, linking them to the individual room's file. Then, I can update the text in one room, and know that the image boxes in the other files will automatically update when I open the new file. I don't know that there will be any way to automatically rotate the text for the files that need that. I think I'd have to rotate each text box individually to keep it orientated to the shelf, yes?
BONUS POINTS: It would be AMAZING if there was a way to map individual aisle locations to a master list, so a person could change something in the master list (Shoes are now on Aisle 25) and have the text inside the map update accordingly. Or maybe the opposite would be possible; you change the master map and have a corrected list that exports with the aisle number.
FOR EXAMPLE: Here's an example room that shows the complexity of the map.