Value Mapping data is stored in the MIGRATE Database. You don’t need a User Interface to load the values as they can be loaded directly into the MIGRATE.dbo.XTVALUEMAP table in the working database.
John Munkberg
Team•
Oct 23, 2024
You can use the generic SPREADSHEET IMPORT to load the data directly into MIGRATE.dbo.XTVALUEMAP. That feature supports a full REPLACE or APPEND option, so you can append new values to the existing table.
That same feature allows you to easily import data from any spreadsheet into any existing or new table (will create the table automatically if it doesn’t exist). So please use that if it’s easier than loading directly into the database.
Hi John, You can use the generic SPREADSHEET IMPORT: I have checked on a couple of tenants and MIGRATE does not seem available in the drop down list of Datasources.
John Munkberg
Team•
Nov 15, 2024
Thank you. I created a Jira ticket to address this. I’m sure you can trick it by making another datastource point at the migrate database (wrkmigrate). But I will work on getting this resolved so a hack is not needed.
Log in to comment and vote
Comments4
John Munkberg
Oct 23, 2024
Value Mapping data is stored in the MIGRATE Database. You don’t need a User Interface to load the values as they can be loaded directly into the MIGRATE.dbo.XTVALUEMAP table in the working database.
John Munkberg
Oct 23, 2024
You can use the generic SPREADSHEET IMPORT to load the data directly into MIGRATE.dbo.XTVALUEMAP. That feature supports a full REPLACE or APPEND option, so you can append new values to the existing table.
That same feature allows you to easily import data from any spreadsheet into any existing or new table (will create the table automatically if it doesn’t exist). So please use that if it’s easier than loading directly into the database.
https://skthelp.syniti.com/docs/en/excel-import
Ana Garcia Rubio (Syniti)
Nov 14, 2024
Hi John,
You can use the generic SPREADSHEET IMPORT:
I have checked on a couple of tenants and MIGRATE does not seem available in the drop down list of Datasources.
John Munkberg
Nov 15, 2024
Thank you. I created a Jira ticket to address this. I’m sure you can trick it by making another datastource point at the migrate database (wrkmigrate). But I will work on getting this resolved so a hack is not needed.