We've got a series of modules whose versions are controlled by a SYS module. We're trying to setup a nightly export so that only the most-recent forecast version exports. The problem is that if someone changes the version mid-day and doesn't change it back, we're exporting data for the incorrect version. The fix is obvious enough: create 2 cells - one that holds a copy of the Master Version Control and another the holds the most recent forecast version. Import Master Version Control to the Copy cell, then import the most recent forecast version into the Master Version control cell, export the data, then import the Copy of Master Version into the Master Version control to set it back to how it was. The problem is that what's actually copying into this cell is the cell name, not the value. See below image. Any ideas why this is happening and how I can resolve? There are no other dimensions involved and items should both be formatted as a list (as we don't use the native versions menu). I temporarily put the Copy cell to format as text to illustrate what is happening.
Hi @dspar001, you can see on the Mapping tab of the import window, the data values for your import are coming from column 1, your line item names. This is why the line item names are then populating the cell data on your import. I'm not sure how you've setup the saved view for each of the two imports in your process as you described, but you should be seeing two columns in your import screen, so you then get your Data Values from column 2, which would be your list item.
I d check how you initially setup your import action.
Make sure you are in data view and not in blueprint view when setting up the import.
I believe you are getting the line items names in your import instead of your actual content values because of that.
Thank you @david.savarin and @matthewreed for the responses. I deleted all the actions and import data sources associated with those actions, ensured that I was not in blueprint view, tried again and, unfortunately, I got the same results. I agree that the import window tab is off. I believe when one selects an option from "Data Values From:" on the right hand side of my 2nd snippet, the 2nd tab should pop up with a "Data Values To:" option, but that isn't happening
I hope it's not asking too much, but since this is a very simple setup, I'm wondering if you'd be willing to re-create this and tell me if it comes through correctly on your end.
Just to show that I'm not in blueprint view…
Hi @dspar001 perhaps create a system list with one item to dimension this model on. So you would create the dummy list, add an item ie. 'Version Selection', then choose that dummy list in the 'Applies To' section of your module. I'm sure we'll find a solution ;)
With @matthewreed 's help, I developed a solution. Things I learned and believe to be true:
Solution: After trying to piece these three things together to form what I wanted, I instead created a Boolean over-ride, using my 1st bullet-point to effect. I created three Boolean line items: Override?, TRUE and FALSE. I import TRUE and FALSE into Override? to get values I want. It works only because it's a Boolean
Thanks @matthewreed !
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
