When you upload a custom HTML section file to a web skin, it is saved in the Enterprise database for use on all public online applications that use the web skin. There are times where you may need to export this file.
To export a custom HTML section file, you need the Query and Reporting module. You can then use EZWriter with an EZWriter Data Source that uses one of the below SQL statements. You can modify below to use the EZWriter parameters to make the EZWriter page more dynamic.
When exporting the custom HTML section file, you need to know if the web skin is a Template Web Skin or a Custom Web Skin because the SQL statement changes slightly.
Export a Template Web Skin
To export a custom HTML section file for a Template Web Skin, use the following SQL statement, replacing the values for @ORG_CODE and @WEB_SKIN_ID. You can find the web skin ID in the Web Skin ID column on the Web Skins screen from the Main Menu. Once exported, you can save the HTML data for the custom HTML section file on your computer.
DECLARE @ORG_CODE VARCHAR(2)
SET @ORG_CODE = '10'
DECLARE @WEB_SKIN_ID INT
SET @WEB_SKIN_ID = 123
SELECT
[MM469_DESC] AS 'Web Skin Description',
[MM476_WEB_SKIN_ID] AS 'Web Skin ID',
[MM476_SETTINGS] AS 'HTML'
FROM [MM476_CONFIG_PRES] LEFT JOIN [MM469_WEB_SKINS]
ON [MM476_WEB_SKIN_ID] = [MM469_WEB_SKIN_ID]
WHERE [MM476_ORG_CODE] IN (@ORG_CODE, '@N')
AND [MM476_RCD_TYPE] = 'EBM'
AND [MM476_APP_GROUP] = 'WB'
AND [MM476_APP_CODE] = 'TMP'
AND [MM476_WEB_SKIN_ID] = @WEB_SKIN_ID
Export a Custom Web Skin
To export a custom HTML section file for a Custom Web Skin, use the following SQL statement, replacing the values for the @ORG_CODE and @EVENT_ID.
DECLARE @ORG_CODE VARCHAR(2)
SET @ORG_CODE = '10'
DECLARE @EVENT_ID INT
SET @EVENT_ID = 12345
SELECT
[MM476_WEB_SKIN_ID] AS 'Web Skin ID',
[MM476_EVT_ID] AS 'Event ID',
[MM476_SETTINGS] AS 'HTML'
FROM [MM476_CONFIG_PRES] LEFT JOIN [MM469_WEB_SKINS]
ON [MM476_WEB_SKIN_ID] = [MM469_WEB_SKIN_ID]
WHERE [MM476_ORG_CODE] = @ORG_CODE
AND [MM476_RCD_TYPE] = 'EBM'
AND [MM476_APP_GROUP] = 'WB'
AND [MM476_EVT_ID] = @EVENT_ID
Once exported, you can save the HTML data for the custom HTML section file on your computer.
Comments
8 comments
Will there be a way in the hopefully near future to export the HTML webskin for those who are hosted with no SQL access? as with the push towards hosting a solution needs to be in the pipeline.
5 upvotes
+1 on this one.
1 upvotes
Any update on this?
We can export rpt files from the Report Master with a simple click - there should be no need to go through the above to extract web skin configs.
2 upvotes
Bumping this again - PLEASE add an export option.
This process is not very practical.
Thanks.
1 upvotes
Hi this needs to be re-raised now this is on the Cloud.
1 upvotes
Would be great if we can have some sort of export function on the web skin screen - any news?
0 upvotes
Hi Jerry,
We do not have any news at this time.
Thanks,
Mike
0 upvotes
Thanks Mike
Can we push for a solution for this as current process is not practical. Been 6 days since logging a support ticket for a copy of the file, and still waiting. And to be fair to support, this sort of request shouldn't be top priority for them, or even on their queue!
Cheers
Jerry
0 upvotes
Please sign in to leave a comment.