A Piece of Cake store theme - xmpie-users/uStore-js GitHub Wiki
What is it?
The "A Piece of Cake Store" is a demo store created by XMPie Training team to demonstrate the features and functionality of uStore and assist with customer training.
What's special about this theme used by this store?
The A Piece of Cake store's theme features:
- AquaBlue's static banner image is replaced with three (3) banner slider/carousel which is customizable in uStore Admin via the theme editor. (From uStore v17.1, the theme will support up to five (3) banners/slides.)
- The footer area includes a logo and three columns of text (or links) that can be customized in uStore Admin via the theme editor. (Note uStoe v16.1 introduces a "widget" that can be used to customize the footer, and this may now be more relevant for you than using this theme.)
- There is a custom FAQ page that demonstrates how to add additional pages to the theme. If you don't want it or cannot modify the theme, you can remove the links to the FAQ by editing the footer in uStore Admin via the theme editor.
- uStore v16.1 introduces a new "widget" feature that allows you to inject small components into different areas of the theme. The Piece of Cake theme for 16.1 includes the "slots" for widgets to be added, but the slot in the footer is not included becasue of the custom footer included in this custom theme.
- From uStore v17.1, the "Piece of Cake" theme also allows editing of the About Us page text/HTML via the theme editor in the uStore admin backoffice.
How do you get it?
-
The "A Piece of Cake" store is installed on all new uStore installations by XMPie Support and used by XMPie training team when delivering customer training.
-
If you have an older uStore server that was installed before the "A Piece of Cake" store was available, you can request XMPie Support to install the new "A Piece of Cake" store onto your server. This is preferred because in addition to just the theme, the installer will setup a test store with several products (including kits and 3D packages) that you can use in conjunction with the uStore Tutorial available from XMPie Campus.
-
If you just want the theme and not the store and products, then you can download the theme package for your uStore version here:
- Download for uStore v17.1 with patches 6001-6019
- Download for uStore v17.1 with patches 6001-6003
- Download for uStore v17.1 with patch 6001
- Download for uStore v17.1
- Download for uStore v17.0 with patches 5701-5721
- Download for uStore v17.0 with patches 5701-5712
- Download for uStore v17.0 with patches 5701-5708
- Download for uStore v17.0
- Download for uStore v16.1 with patches 4801 & 4802
- Download for uStore v16.1
- Download for uStore v16.0
- Download for uStore v15.3
- Download for uStore v15.2
- Download for uStore v15.1 with patches 3002-3007 or later
- Download for uStore v15.1
- Download for uStore v15.0 with patch 2715 or later
- Download for uStore v15.0 with patch 2714 or later
- Download for uStore v15.0 with patch 2712 or later
- Download for uStore v15.0 with patch 2710 or later
- Download for uStore v15.0 with patch 2705 or later
- Download for uStore v15.0
- Download for uStore v14.1 with patch 2522 or later
- Download for uStore v14.1 with patch 2514 or later
- Download for uStore v14.1 with patch 2502 or later
- Download for uStore v14.1
- Download for uStore v14
- Download for uStore v13.4 with patch 1961 or later
- Download for uStore v13.4
- Download for uStore v13.2
- Download for uStore v13.1
- Download for uStore v13
- Download for uStore v12.3
How do you install the Theme? (for the first time on a server)
- Download the theme for your uStore version.
- Login to your uStore admin and go to Presets -> Theme Management.
- Click "New Theme" and upload the zip file.
- Run the SQL Script (provided below) to add the resource texts needed in the theme editor.
- Restart IIS on the uStore server by running "iisreset" in a command prompt, or using the IIS control panel to stop/start the service, or reboot the server. (This is needed to get uStore admin to re-read in the resources texts from the database.)
How do you update/replace the Theme? (to update the theme after a uStore upgrade)
- Download the theme for your new uStore version.
- Login to your uStore admin and go to Presets -> Theme Management.
- Select "A Piece of Cake NG v2" and click "Replace" and upload the new zip file. (Note re-running the SQL and restarting IIS is not required when updating.)
SQL script required for first time installation only
Note that XMPie does not recommend customers to directly touch the SQL database. If you are not comfortable with SQL, please request XMPie Support to install the "A Piece of Cake" store for you. If you decide to go ahead, please take a backup of the uStore SQL database before making any changes.
use uStore
-- This script adds rows to the uStore database Resources and ResourceCulture tables to support the
-- StringIDs that are used by the uStore Theme Editor for the A Piece Of Cake NG v2 Theme
declare @locs table([id] int identity(1,1), name nvarchar(50), [en-US] nvarchar(200), [en-GB] nvarchar(200), [de-DE] nvarchar(200), [es-ES] nvarchar(200), [fr-FR] nvarchar(200), [ja-JP] nvarchar(200), [nl-NL] nvarchar(200), [pt-BR] nvarchar(200))
insert into @locs ([name], [en-US], [en-GB], [de-DE], [es-ES], [fr-FR], [ja-JP], [nl-NL], [pt-BR])
select 'ThemeEditor_BannerGeneralSection', 'General', 'General', 'Allgemeine', 'General', 'Général', N'一般的な', 'Algemeen', 'Geral' union
select 'ThemeEditor_BannerSlide1Section', 'Slide 1', 'Slide 1', 'Folie 1', 'Diapositiva 1', 'Diapositive 1', N'スライド 1', 'Dia 1', 'Diapositivo 1' union
select 'ThemeEditor_BannerSlide2Section', 'Slide 2', 'Slide 2', 'Folie 2', 'Diapositiva 2', 'Diapositive 2', N'スライド 2', 'Dia 2', 'Diapositivo 2' union
select 'ThemeEditor_BannerSlide3Section', 'Slide 3', 'Slide 3', 'Folie 3', 'Diapositiva 3', 'Diapositive 3', N'スライド 3', 'Dia 3', 'Diapositivo 3' union
select 'ThemeEditor_BannerSlide4Section', 'Slide 4', 'Slide 4', 'Folie 4', 'Diapositiva 4', 'Diapositive 4', N'スライド 4', 'Dia 4', 'Diapositivo 4' union
select 'ThemeEditor_BannerSlide5Section', 'Slide 5', 'Slide 5', 'Folie 5', 'Diapositiva 5', 'Diapositive 5', N'スライド 5', 'Dia 5', 'Diapositivo 5' union
select 'CarouselTransitionSpeedTitle', 'Transition Speed (seconds)', 'Transition Speed (seconds)', 'Übergangsgeschwindigkeit (Sekunden)', 'Velocidad de transición (segundos)', 'Vitesse de transition (secondes)', N'遷移速度 (秒)', 'Overgangssnelheid (seconden)', 'Velocidade de transição (segundos)' union
select 'CarouselSlideDurationTitle', 'Slide Duration (seconds)', 'Slide Duration (seconds)', 'Foliendauer (Sekunden)', 'Duración de la diapositiva (segundos)', 'Durée de la diapositive (secondes)', N'スライドの長さ (秒)', 'Diaduur (seconden)', 'Duração do slide (segundos)' union
select 'CarouselTransitionSpeedDesc', 'A number between 1 and 5. (Default: 2)','A number between 1 and 5. (Default: 2)','Eine Zahl zwischen 1 und 5. (Standard: 2)','Un número entre 1 y 5. (Por defecto: 2)','Un nombre compris entre 1 et 5. (Défaut: 2)',N'1 から 5 までの数値。 (デフォルト: 2)','Een getal tussen 1 en 5. (Standaard: 2)','Um número entre 1 e 5. (Padrão: 2)' union
select 'CarouselSlideDurationDesc', 'A number between 3 and 15. (Default: 6)','A number between 3 and 15. (Default: 6)','Eine Zahl zwischen 3 und 15. (Standard: 6)','Un número entre 3 y 15. (Por defecto: 6)','Un nombre compris entre 3 et 15. (Défaut: 6)',N'3 から 15 までの数値。 (デフォルト: 6)','Een getal tussen 3 en 15. (Standaard: 6)','Um número entre 3 e 15. (Padrão: 6)' union
select 'ThemeEditor_HomePageCarouselSlide2_Title', 'Image 2', 'Image 2', 'Bild 2', 'Imagen 2', 'Image 2', N'画像2', 'Afbeelding 2', 'Imagem 2' union
select 'ThemeEditor_HomePageCarouselSlide3_Title', 'Image 3', 'Image 3', 'Bild 3', 'Imagen 3', 'Image 3', N'画像3', 'Afbeelding 3', 'Imagem 3' union
select 'ThemeEditor_HomePageCarouselSlide4_Title', 'Image 4', 'Image 4', 'Bild 4', 'Imagen 4', 'Image 4', N'画像4', 'Afbeelding 4', 'Imagem 4' union
select 'ThemeEditor_HomePageCarouselSlide5_Title', 'Image 5', 'Image 5', 'Bild 5', 'Imagen 5', 'Image 5', N'画像5', 'Afbeelding 5', 'Imagem 5' union
select 'ThemeEditor_TextColorCarousel_Title2', 'Text color 2', 'Text color 2', 'Textfarbe 2', 'Color del texto 2', 'Couleur du texte 2', N'テキストの色2', 'Tekstkleur 2', 'Cor do texto 2' union
select 'ThemeEditor_TextColorCarousel_Title3', 'Text color 3', 'Text color 3', 'Textfarbe 3', 'Color del texto 3', 'Couleur du texte 3', N'テキストの色3', 'Tekstkleur 3', 'Cor do texto 3' union
select 'ThemeEditor_TextColorCarousel_Title4', 'Text color 4', 'Text color 4', 'Textfarbe 4', 'Color del texto 4', 'Couleur du texte 4', N'テキストの色4', 'Tekstkleur 4', 'Cor do texto 4' union
select 'ThemeEditor_TextColorCarousel_Title5', 'Text color 5', 'Text color 5', 'Textfarbe 5', 'Color del texto 5', 'Couleur du texte 5', N'テキストの色5', 'Tekstkleur 5', 'Cor do texto 5' union
select 'ThemeEditor_HomePageCarouselSlide2Title_Title', 'Title 2', 'Title 2', 'Bezeichnung 2', 'Título 2', 'Titre 2', N'タイトル2', 'Titel 2', 'Título 2' union
select 'ThemeEditor_HomePageCarouselSlide3Title_Title', 'Title 3', 'Title 3', 'Bezeichnung 3', 'Título 3', 'Titre 3', N'タイトル3', 'Titel 3', 'Título 3' union
select 'ThemeEditor_HomePageCarouselSlide4Title_Title', 'Title 4', 'Title 4', 'Bezeichnung 4', 'Título 4', 'Titre 4', N'タイトル4', 'Titel 4', 'Título 4' union
select 'ThemeEditor_HomePageCarouselSlide5Title_Title', 'Title 5', 'Title 5', 'Bezeichnung 5', 'Título 5', 'Titre 5', N'タイトル5', 'Titel 5', 'Título 5' union
select 'ThemeEditor_HomePageCarouselSlide2Subtitle_Title','Subtitle 2', 'Subtitle 2', 'Untertitel 2', 'Subtítulo 2', 'Sous-titre 2', N'サブタイトル2', 'Ondertitel 2', 'Legenda 2' union
select 'ThemeEditor_HomePageCarouselSlide3Subtitle_Title','Subtitle 3', 'Subtitle 3', 'Untertitel 3', 'Subtítulo 3', 'Sous-titre 3', N'サブタイトル3', 'Ondertitel 3', 'Legenda 3' union
select 'ThemeEditor_HomePageCarouselSlide4Subtitle_Title','Subtitle 4', 'Subtitle 4', 'Untertitel 4', 'Subtítulo 4', 'Sous-titre 4', N'サブタイトル4', 'Ondertitel 4', 'Legenda 4' union
select 'ThemeEditor_HomePageCarouselSlide5Subtitle_Title','Subtitle 5', 'Subtitle 5', 'Untertitel 5', 'Subtítulo 5', 'Sous-titre 5', N'サブタイトル5', 'Ondertitel 5', 'Legenda 5' union
select 'ThemeEditor_ShopButtonText_Title2', 'Button text 2', 'Button text 2', 'Schaltflächentext 2', 'Texto del botón 2', 'Texte du bouton 2', N'ボタンのテキスト2', 'Knoptekst 2', 'Texto do botão 2' union
select 'ThemeEditor_ShopButtonText_Title3', 'Button text 3', 'Button text 3', 'Schaltflächentext 3', 'Texto del botón 3', 'Texte du bouton 3', N'ボタンのテキスト3', 'Knoptekst 3', 'Texto do botão 3' union
select 'ThemeEditor_ShopButtonText_Title4', 'Button text 4', 'Button text 4', 'Schaltflächentext 4', 'Texto del botón 4', 'Texte du bouton 4', N'ボタンのテキスト4', 'Knoptekst 4', 'Texto do botão 4' union
select 'ThemeEditor_ShopButtonText_Title5', 'Button text 5', 'Button text 5', 'Schaltflächentext 5', 'Texto del botón 5', 'Texte du bouton 5', N'ボタンのテキスト5', 'Knoptekst 5', 'Texto do botão 5' union
select 'ThemeEditor_ShopButtonUrl_Title2', 'Button URL 2', 'Button URL 2', 'Schaltflächen-URL 2', 'URL del botón 2', 'URL du bouton 2', N'ボタンのURL 2', 'URL van knop 2', 'URL do botão 2' union
select 'ThemeEditor_ShopButtonUrl_Title3', 'Button URL 3', 'Button URL 3', 'Schaltflächen-URL 3', 'URL del botón 3', 'URL du bouton 3', N'ボタンのURL 3', 'URL van knop 3', 'URL do botão 3' union
select 'ThemeEditor_ShopButtonUrl_Title4', 'Button URL 4', 'Button URL 4', 'Schaltflächen-URL 4', 'URL del botón 4', 'URL du bouton 4', N'ボタンのURL 4', 'URL van knop 4', 'URL do botão 4' union
select 'ThemeEditor_ShopButtonUrl_Title5', 'Button URL 5', 'Button URL 5', 'Schaltflächen-URL 5', 'URL del botón 5', 'URL du bouton 5', N'ボタンのURL 5', 'URL van knop 5', 'URL do botão 5' union
select 'ThemeEditor_ShopButtonUrl_Hint2', 'Type a relative URL', 'Type a relative URL', 'Relative URL eingeben', 'Escriba una URL relacionada', 'Tapez une URL relative', N'相対URLを入力してください', 'Typ een relatieve URL', 'Digite um URL relativo' union
select 'ThemeEditor_ShopButtonUrl_Hint3', 'Type a relative URL', 'Type a relative URL', 'Relative URL eingeben', 'Escriba una URL relacionada', 'Tapez une URL relative', N'相対URLを入力してください', 'Typ een relatieve URL', 'Digite um URL relativo' union
select 'ThemeEditor_ShopButtonUrl_Hint4', 'Type a relative URL', 'Type a relative URL', 'Relative URL eingeben', 'Escriba una URL relacionada', 'Tapez une URL relative', N'相対URLを入力してください', 'Typ een relatieve URL', 'Digite um URL relativo' union
select 'ThemeEditor_ShopButtonUrl_Hint5', 'Type a relative URL', 'Type a relative URL', 'Relative URL eingeben', 'Escriba una URL relacionada', 'Tapez une URL relative', N'相対URLを入力してください', 'Typ een relatieve URL', 'Digite um URL relativo' union
select 'ThemeEditor_ShopButtonUrl_Description2', 'e.g. /category/10/ or /product/102/','e.g. /category/10/ or /product/102/','z.B. /Kategorie/10/ oder /Produkt/102/','por ej. /categoría/10/ o /producto/102/','Par exemple : /catégorie/10/ ou /produit/102/',N'例: /category/10/ または /product/102/','bijv. /categorie/10/ of /product/102/','por exemplo: /categoria/10/ ou /produto/102/' union
select 'ThemeEditor_ShopButtonUrl_Description3', 'e.g. /category/10/ or /product/102/','e.g. /category/10/ or /product/102/','z.B. /Kategorie/10/ oder /Produkt/102/','por ej. /categoría/10/ o /producto/102/','Par exemple : /catégorie/10/ ou /produit/102/',N'例: /category/10/ または /product/102/','bijv. /categorie/10/ of /product/102/','por exemplo: /categoria/10/ ou /produto/102/' union
select 'ThemeEditor_ShopButtonUrl_Description4', 'e.g. /category/10/ or /product/102/','e.g. /category/10/ or /product/102/','z.B. /Kategorie/10/ oder /Produkt/102/','por ej. /categoría/10/ o /producto/102/','Par exemple : /catégorie/10/ ou /produit/102/',N'例: /category/10/ または /product/102/','bijv. /categorie/10/ of /product/102/','por exemplo: /categoria/10/ ou /produto/102/' union
select 'ThemeEditor_ShopButtonUrl_Description5', 'e.g. /category/10/ or /product/102/','e.g. /category/10/ or /product/102/','z.B. /Kategorie/10/ oder /Produkt/102/','por ej. /categoría/10/ o /producto/102/','Par exemple : /catégorie/10/ ou /produit/102/',N'例: /category/10/ または /product/102/','bijv. /categorie/10/ of /product/102/','por exemplo: /categoria/10/ ou /produto/102/' union
select 'ThemeEditor_FooterSetupName', 'Footer Setup', 'Footer Setup', 'Fußzeile einrichten', 'Configuraciones de pie de página', 'Configuration du pied de page', N'フッターの設定', 'Instellingen voor voettekst', 'Configuração de rodapé' union
select 'ThemeEditor_FooterSectionName-column1', 'Column 1', 'Column 1', 'Spalte 1', 'Columna 1', 'Colonne 1', N'列1', 'Kolom 1', 'Coluna 1' union
select 'ThemeEditor_FooterSectionName-column2', 'Column 2', 'Column 2', 'Spalte 2', 'Columna 2', 'Colonne 2', N'列2', 'Kolom 2', 'Coluna 2' union
select 'ThemeEditor_FooterSectionName-column3', 'Column 3', 'Column 3', 'Spalte 3', 'Columna 3', 'Colonne 3', N'列3', 'Kolom 3', 'Coluna 3' union
select 'footer-logo-title', 'Footer Logo', 'Footer Logo', 'Fußzeile Logo', 'Logotipo de pie de página', 'Logo de pied de page', N'フッターのロゴ', 'Logo voettekst', 'Logotipo do rodapé' union
select 'footer-column1-header-title', 'Heading', 'Heading', 'Überschrift', 'Bóveda', 'Titre', N'見出し', 'Titel', 'Título' union
select 'footer-column1-row1-title', 'Text Line 1', 'Text Line 1', 'Textzeile 1', 'Línea de texto 1', 'Ligne de texte 1', N'テキスト行1', 'Tekstregel 1', 'Linha de texto 1' union
select 'footer-column1-row1-link-title', 'URL Line 1', 'URL Line 1', 'URL-Zeile 1', 'URL línea 1', 'URL ligne 1', N'URL行1', 'URL-regel 1', 'Linha 1 do URL' union
select 'footer-column1-row1-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column1-row1-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column1-row2-title', 'Text Line 2', 'Text Line 2', 'Textzeile 2', 'Línea de texto 2', 'Ligne de texte 2', N'テキスト行2', 'Tekstregel 2', 'Linha de texto 2' union
select 'footer-column1-row2-link-title', 'URL Line 2', 'URL Line 2', 'URL-Zeile 2', 'URL línea 2', 'URL ligne 2', N'URL行2', 'URL-regel 2', 'Linha 1 do 2' union
select 'footer-column1-row2-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column1-row2-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column1-row3-title', 'Text Line 3', 'Text Line 3', 'Textzeile 3', 'Línea de texto 3', 'Ligne de texte 3', N'テキスト行3', 'Tekstregel 3', 'Linha de texto 3' union
select 'footer-column1-row3-link-title', 'URL Line 3', 'URL Line 3', 'URL-Zeile 3', 'URL línea 3', 'URL ligne 3', N'URL行3', 'URL-regel 3', 'Linha 1 do 3' union
select 'footer-column1-row3-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column1-row3-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column2-header-title', 'Heading', 'Heading', 'Überschrift', 'Bóveda', 'Titre', N'見出し', 'Titel', 'Título' union
select 'footer-column2-row1-title', 'Text Line 1', 'Text Line 1', 'Textzeile 1', 'Línea de texto 1', 'Ligne de texte 1', N'テキスト行1', 'Tekstregel 1', 'Linha de texto 1' union
select 'footer-column2-row1-link-title', 'URL Line 1', 'URL Line 1', 'URL-Zeile 1', 'URL línea 1', 'URL ligne 1', N'URL行1', 'URL-regel 1', 'Linha 1 do 1' union
select 'footer-column2-row1-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column2-row1-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column2-row2-title', 'Text Line 2', 'Text Line 2', 'Textzeile 2', 'Línea de texto 2', 'Ligne de texte 2', N'テキスト行2', 'Tekstregel 2', 'Linha de texto 2' union
select 'footer-column2-row2-link-title', 'URL Line 2', 'URL Line 2', 'URL-Zeile 2', 'URL línea 2', 'URL ligne 2', N'URL行2', 'URL-regel 2', 'Linha 1 do 2' union
select 'footer-column2-row2-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column2-row2-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column2-row3-title', 'Text Line 3', 'Text Line 3', 'Textzeile 3', 'Línea de texto 3', 'Ligne de texte 3', N'テキスト行3', 'Tekstregel 3', 'Linha de texto 3' union
select 'footer-column2-row3-link-title', 'URL Line 3', 'URL Line 3', 'URL-Zeile 3', 'URL línea 3', 'URL ligne 3', N'URL行3', 'URL-regel 3', 'Linha 1 do 3' union
select 'footer-column2-row3-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column2-row3-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column3-row1-title', 'Text Line 1', 'Text Line 1', 'Textzeile 1', 'Línea de texto 1', 'Ligne de texte 1', N'テキスト行1', 'Tekstregel 1', 'Linha de texto 1' union
select 'footer-column3-row1-link-title', 'URL Line 1', 'URL Line 1', 'URL-Zeile 1', 'URL línea 1', 'URL ligne 1', N'URL行1', 'URL-regel 1', 'Linha 1 do 1' union
select 'footer-column3-row1-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column3-row1-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column3-row2-title', 'Text Line 2', 'Text Line 2', 'Textzeile 2', 'Línea de texto 2', 'Ligne de texte 2', N'テキスト行2', 'Tekstregel 2', 'Linha de texto 2' union
select 'footer-column3-row2-link-title', 'URL Line 2', 'URL Line 2', 'URL-Zeile 2', 'URL línea 2', 'URL ligne 2', N'URL行2', 'URL-regel 2', 'Linha 1 do 2' union
select 'footer-column3-row2-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column3-row2-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com' union
select 'footer-column3-row3-title', 'Text Line 3', 'Text Line 3', 'Textzeile 3', 'Línea de texto 3', 'Ligne de texte 3', N'テキスト行3', 'Tekstregel 3', 'Linha de texto 3' union
select 'footer-column3-row3-link-title', 'URL Line 3', 'URL Line 3', 'URL-Zeile 3', 'URL línea 3', 'URL ligne 3', N'URL行3', 'URL-regel 3', 'Linha 1 do 3' union
select 'footer-column3-row3-link-hint', 'Type a URL', 'Type a URL', 'Geben Sie eine URL ein', 'Escribe una URL', 'Entrez une URL', N'URLを入力してください', 'Typ een URL', 'Digite um URL' union
select 'footer-column3-row3-link-description', 'e.g. /product/10/ or http://www.company.com','e.g. /product/10/ or http://www.company.com','z.B. /Produkt/10/ oder http://www.company.com','por ej. /producto/10/ o http://www.company.com','Par exemple : /produit/10/ ou http://www.company.com',N'例: /product/10/ または http://www.company.com','bijv. /product/10/ of http://www.company.com','por exemplo: /produto/10/ ou http://www.company.com'
declare @prefix nvarchar(10)
declare @i int
declare @cnt int
declare @name nvarchar(50)
declare @stringId nvarchar(60)
select @prefix = 'POC',
@i = min(id) - 1,
@cnt = count(*) from @locs
while @i < @cnt
begin
select @i = @i + 1
select @name = name from @locs where id = @i
set @stringId = @prefix + '_' + @name
IF NOT EXISTS (SELECT * FROM [dbo].[Resource] WHERE StringID = @stringId)
BEGIN
DECLARE @ResourceID INT
,@ResourcesCultureID INT
,@LocalizedText_en_US nvarchar(4000)
,@LocalizedText_en_GB nvarchar(4000)
,@LocalizedText_de_DE nvarchar(4000)
,@LocalizedText_es_ES nvarchar(4000)
,@LocalizedText_fr_FR nvarchar(4000)
,@LocalizedText_ja_JP nvarchar(4000)
,@LocalizedText_nl_NL nvarchar(4000)
,@LocalizedText_pt_BR nvarchar(4000)
,@Project varchar(60)
,@Page varchar(100)
,@Control varchar(50)
,@Property varchar(50)
,@ApplicationTypeID int
SELECT @ResourceID = MIN(ResourceID + 1) FROM [dbo].[Resource] t1
WHERE not exists (SELECT * FROM [dbo].[Resource] t2 WHERE t1.ResourceID + 1 = t2.ResourceID)
AND ResourceID >= 15000
IF @ResourceID IS NULL BEGIN SET @ResourceID = 15000; END
SET @ResourcesCultureID = @ResourceID;
SET @ApplicationTypeID = 2; --admin=2 customer=1
SET @Project = NULL;
SET @Page = NULL;
SET @Control = NULL;
SET @Property = NULL;
-- localized values
SELECT @LocalizedText_en_US = [en-US] from @locs where id = @i;
SELECT @LocalizedText_en_GB = [en-GB] from @locs where id = @i;
SELECT @LocalizedText_de_DE = [de-DE] from @locs where id = @i;
SELECT @LocalizedText_es_ES = [es-ES] from @locs where id = @i;
SELECT @LocalizedText_fr_FR = [fr-FR] from @locs where id = @i;
SELECT @LocalizedText_ja_JP = [ja-JP] from @locs where id = @i;
SELECT @LocalizedText_nl_NL = [nl-NL] from @locs where id = @i;
SELECT @LocalizedText_pt_BR = [pt-BR] from @locs where id = @i;
-- Add rows to [dbo].[Resource]
SET IDENTITY_INSERT [dbo].[Resource] ON
INSERT INTO [dbo].[Resource]
([ResourceID],
[Project],
[Page],
[Control],
[Property],
[StringID],
[ApplicationTypeID])
VALUES (@ResourceID, @Project, @Page, @Control, @Property, @StringID, @ApplicationTypeID)
SET IDENTITY_INSERT [dbo].[Resource] OFF
-- Add en-US rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 1, @LocalizedText_en_US)
-- Add en-GB rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 8, @LocalizedText_en_GB)
-- Add de-DE rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 3, @LocalizedText_de_DE)
-- Add es-ES rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 5, @LocalizedText_es_ES)
-- Add fr-FR rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 2, @LocalizedText_fr_FR)
-- Add ja-JP rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 4, @LocalizedText_ja_JP)
-- Add nl-NL rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 6, @LocalizedText_nl_NL)
-- Add pt-BR rows to [dbo].[ResourcesCulture]
INSERT INTO [dbo].[ResourcesCulture]
([ResourceID],
[CultureID],
[LocalizedText])
VALUES (@ResourceID, 7, @LocalizedText_pt_BR)
END
end
How do you get support for this theme?
While the "A Piece of Cake" store and the store's theme are used by XMPie Support and Training teams, they were not created by XMPie R&D or Products team, and so the official support channel may or may not help, depending on the problem you have. If you have questions or problems that support cannot help with, please try asking via the XMPie Users Google Group.