00:00:08.710 --> 00:00:10.516 I'm with JC again and we
00:00:10.516 --> 00:00:11.720 just added this div.
00:00:11.720 --> 00:00:13.225 You can see the highlighted
00:00:13.225 --> 00:00:14.730 greeting on the left 3742.
00:00:14.730 --> 00:00:16.655 We are going to add a translation
00:00:16.655 --> 00:00:18.040 for programs and specials.
00:00:18.040 --> 00:00:19.244 Hopefully we're going to
00:00:19.244 --> 00:00:21.050 get it to actually show up.
00:00:21.050 --> 00:00:22.989 I have not had a lot of
00:00:22.989 --> 00:00:24.360 success with this lately,
00:00:24.360 --> 00:00:26.467 but we're going to do our best.
00:00:26.470 --> 00:00:28.588 First thing you're gonna do is
00:00:28.588 --> 00:00:30.481 you're going to delete programs
00:00:30.481 --> 00:00:32.935 and specials from inside this fan.
00:00:32.940 --> 00:00:33.590 Alright.
00:00:36.700 --> 00:00:39.697 And then just like you see on line 35,
00:00:39.700 --> 00:00:42.024 I guess that's not the best example.
00:00:42.030 --> 00:00:44.368 I guess 54 is a better example
00:00:44.368 --> 00:00:46.688 because the one on 35 is dynamic.
00:00:46.690 --> 00:00:48.692 The 154 is not gotcha, yeah.
00:00:48.692 --> 00:00:50.684 So copy that whole data translate.
00:00:50.690 --> 00:00:52.350 I'm sure you've seen these
00:00:52.350 --> 00:00:54.014 all over the place, right?
00:00:54.014 --> 00:00:55.751 Yeah, I've seen him, yeah.
00:00:55.751 --> 00:00:59.910 I'm going to show you kind of how they work.
00:00:59.910 --> 00:01:02.907 This is going to be looked out and basically.
00:01:02.910 --> 00:01:04.674 Whatever this translates
00:01:04.674 --> 00:01:07.614 to from a Jason file.
00:01:07.620 --> 00:01:09.489 And I'll show you where it is.
00:01:09.490 --> 00:01:10.742 What about translates to
00:01:10.742 --> 00:01:11.994 in the current language?
00:01:12.000 --> 00:01:15.393 It's going to put that inside of the span.
00:01:15.400 --> 00:01:17.370 Alright.
00:01:17.370 --> 00:01:19.435 So first thing we'll do is we'll
00:01:19.435 --> 00:01:21.608 change what the drapes translate is,
00:01:21.610 --> 00:01:23.240 because obviously we're not going.
00:01:23.240 --> 00:01:25.196 It's not going to my storage
00:01:25.196 --> 00:01:26.500 to program specialist right?
00:01:26.500 --> 00:01:29.108 So it should be UI dot storefront dots.
00:01:31.980 --> 00:01:36.050 Stop get rid of location, yeah?
00:01:36.050 --> 00:01:41.154 And then. Go down to like log out.
00:01:41.160 --> 00:01:44.534 I think log out is relatively normal.
00:01:44.540 --> 00:01:47.207 What is it? Have menu mini item
00:01:47.207 --> 00:01:50.714 log out so I would do you either
00:01:50.714 --> 00:01:52.984 storefront dot menu got many
00:01:53.075 --> 00:01:55.890 menu dot programs and specials.
00:01:55.890 --> 00:01:58.160 All one word camel case.
00:02:04.190 --> 00:02:06.008 No copy that string 'cause we're
00:02:06.008 --> 00:02:07.709 obviously going to need to copy.
00:02:07.710 --> 00:02:10.338 You put the exact same thing in the database,
00:02:10.340 --> 00:02:12.470 right? So you save that.
00:02:12.470 --> 00:02:14.678 Oh save and then.
00:02:14.678 --> 00:02:19.589 So now we need to go to Google.
00:02:19.590 --> 00:02:23.088 There is a Google translations sheet.
00:02:23.090 --> 00:02:28.515 I will let you find it again.
00:02:28.520 --> 00:02:30.860 Oh sorry, it's not like public.
00:02:30.860 --> 00:02:34.370 It's OK like the one that they were using.
00:02:34.370 --> 00:02:37.436 Yeah, set up saying uh-huh yeah so
00:02:37.436 --> 00:02:40.858 if you go to Azure you can go to
00:02:40.858 --> 00:02:43.044 where that link is through the repo
00:02:43.044 --> 00:02:45.428 you need to go to set config repo.
00:02:45.430 --> 00:02:48.568 Yep, you know where you going.
00:02:48.570 --> 00:02:52.690 Documentation, and then you'll find.
00:02:52.690 --> 00:02:57.526 That Google sheet some morning here.
00:02:57.530 --> 00:02:59.740 Yep. OK.
00:03:18.550 --> 00:03:21.174 So you can see that each of these
00:03:21.174 --> 00:03:23.295 have basically identical code, right?
00:03:23.295 --> 00:03:25.485 Yeah, so it starts with execute,
00:03:25.490 --> 00:03:27.315 which is a SQL command
00:03:27.315 --> 00:03:29.140 that it picks the table.
00:03:29.140 --> 00:03:31.330 Then it picks a executable function
00:03:31.330 --> 00:03:32.790 associated with that table.
00:03:32.790 --> 00:03:34.980 Then it says it's in USNUS,
00:03:34.980 --> 00:03:36.464 which is just being.
00:03:36.464 --> 00:03:40.090 This is the English one you see where I'm at,
00:03:40.090 --> 00:03:43.527 yeah? Then comma, then the translation key,
00:03:43.530 --> 00:03:46.120 then comma, then NI think indicates like.
00:03:46.120 --> 00:03:49.020 The next thing is to be taken as just a
00:03:49.095 --> 00:03:51.958 string and then you have single quotes
00:03:51.958 --> 00:03:54.599 while you wanted to translate them.
00:03:54.600 --> 00:03:56.445 So pick whichever one looks
00:03:56.445 --> 00:03:58.290 the most friendly to you,
00:03:58.290 --> 00:04:01.250 like don't pick you know like line 11,
00:04:01.250 --> 00:04:03.242 don't pick that one.
00:04:03.242 --> 00:04:05.732 Something like kind of straightforward.
00:04:05.740 --> 00:04:08.828 What movie 49 would be a good example?
00:04:12.230 --> 00:04:14.520 So copy just that cell.
00:04:25.670 --> 00:04:28.270 Awesome and then open SSMS.
00:04:35.910 --> 00:04:38.682 Never going to find the database
00:04:38.682 --> 00:04:40.838 that you are. You're working with.
00:04:44.210 --> 00:04:46.929 Which is obviously camp stuff, right?
00:04:46.929 --> 00:04:50.842 Yeah, camp stuff sounds like you can
00:04:50.842 --> 00:04:54.920 right click on that and click new query.
00:04:54.920 --> 00:04:57.125 Basically we're saying, hey, we want to
00:04:57.125 --> 00:04:59.400 run the following query on this database.
00:04:59.400 --> 00:05:01.758 OK, obviously if you tried to run it on
00:05:01.758 --> 00:05:04.308 DNN it would work because DNN doesn't
00:05:04.308 --> 00:05:06.296 have a globalization table, right?
00:05:06.296 --> 00:05:08.776 So yeah, we just fail.
00:05:08.780 --> 00:05:12.728 So paste your your line in there.
00:05:12.730 --> 00:05:15.256 And then go grab your 'cause.
00:05:15.260 --> 00:05:17.786 It's not actually little fun thing.
00:05:17.790 --> 00:05:19.900 Highlight UI to account holder.
00:05:23.780 --> 00:05:27.777 OK gotcha. Delete all that and then
00:05:27.777 --> 00:05:34.318 you're in windows, yeah? Windows and fee.
00:05:34.320 --> 00:05:36.595 And you have everything you copied today.
00:05:36.600 --> 00:05:40.236 Nice, so you can just pick the last thing.
00:05:40.240 --> 00:05:42.028 And then I'll paste that so
00:05:42.028 --> 00:05:43.670 you don't go copied again.
00:05:43.670 --> 00:05:46.001 Josh, I had it like paste over here on
00:05:46.001 --> 00:05:48.655 a different league sheet just in case.
00:05:48.660 --> 00:05:50.532 Alright, it's good to know that
00:05:50.532 --> 00:05:52.050 that's pretty cool, right? Easier?
00:05:52.050 --> 00:05:53.790 So then we'll just change account
00:05:53.790 --> 00:05:55.834 holder to programs and specials, right?
00:05:55.834 --> 00:05:57.962 Exactly how you want it to appear
00:05:57.962 --> 00:05:58.960 in that text.
00:06:07.850 --> 00:06:10.354 And then you hit F5 or you can
00:06:10.354 --> 00:06:12.188 click execute on the top left,
00:06:12.190 --> 00:06:13.418 whichever one floats remote,
00:06:13.418 --> 00:06:16.528 and then if we want to verify it showed up,
00:06:16.530 --> 00:06:18.390 we can go look for it,
00:06:18.390 --> 00:06:20.870 but it says it can complete it successfully.
00:06:20.870 --> 00:06:23.720 I'm gonna trust it if you wanted to just for
00:06:23.790 --> 00:06:26.446 the video sync you could drop camp stuff,
00:06:26.450 --> 00:06:28.000 database them, go to tables,
00:06:28.000 --> 00:06:29.705 criminalization and you would find
00:06:29.705 --> 00:06:31.410 1 called like globalization dot
00:06:31.470 --> 00:06:32.970 translations or translate UI or
00:06:32.970 --> 00:06:35.248 something and in there you could go look.
00:06:35.250 --> 00:06:37.146 Or your specific translation based added,
00:06:37.150 --> 00:06:40.174 but we're just going to test it.
00:06:40.180 --> 00:06:42.376 So now it's in the database,
00:06:42.380 --> 00:06:43.848 but these translations don't
00:06:43.848 --> 00:06:45.683 come directly from the database.
00:06:45.690 --> 00:06:48.329 They come from a Jason file that
00:06:48.329 --> 00:06:50.458 is created based on the base.
00:06:50.460 --> 00:06:53.754 I'm going to show you where that file is,
00:06:53.760 --> 00:06:56.826 and then we're going to recreate
00:06:56.826 --> 00:06:58.359 it essentially OK.
00:06:58.360 --> 00:07:01.678 So go to your File Explorer.
00:07:14.550 --> 00:07:17.076 Go to the front end alright.
00:07:17.080 --> 00:07:19.462 Go to your own network to
00:07:19.462 --> 00:07:21.720 have type in dot Jason.
00:07:25.560 --> 00:07:27.092 There you go. OK,
00:07:27.092 --> 00:07:29.007 where does that come from?
00:07:29.010 --> 00:07:30.542 Desktop modules 30 Commerce
00:07:30.542 --> 00:07:32.840 UI Lib stuff go to IIS.
00:07:36.780 --> 00:07:40.640 OK, drop down your site.
00:07:40.640 --> 00:07:43.490 And then the desktop modules.
00:07:43.490 --> 00:07:44.865 Clarity commerce yeah here we
00:07:44.865 --> 00:07:47.235 go now you see UI is a virtual
00:07:47.235 --> 00:07:48.785 directory that's why we couldn't
00:07:48.785 --> 00:07:50.816 find it and now you can follow.
00:07:50.820 --> 00:07:54.430 I think it's a Lib. SAP.
00:07:57.720 --> 00:08:03.575 JS I think yeah. I18 yeah and if you
00:08:03.575 --> 00:08:05.680 right click that and click Explorer
00:08:05.680 --> 00:08:08.256 it should take you to where it
00:08:08.256 --> 00:08:10.936 actually is in real like it's in Seth.
00:08:10.940 --> 00:08:13.739 OK, I thought it was and here you can
00:08:13.739 --> 00:08:16.525 see all of the actual files so when
00:08:16.525 --> 00:08:19.115 we update the UI to storefront in
00:08:19.115 --> 00:08:21.933 US Jason file that fourth one down.
00:08:21.933 --> 00:08:24.265 That's what's that's what's
00:08:24.265 --> 00:08:26.014 actually getting red.
00:08:26.020 --> 00:08:27.637 Like on the front end to say
00:08:27.637 --> 00:08:29.110 these are the translations,
00:08:29.110 --> 00:08:31.639 so open that you don't need to open it.
00:08:31.640 --> 00:08:33.326 We're going to. We're going to.
00:08:33.330 --> 00:08:35.004 We're going to replace it is
00:08:35.004 --> 00:08:36.420 we're going to get you,
00:08:36.420 --> 00:08:38.100 but not in a hard way.
00:08:38.100 --> 00:08:39.618 It's really easy.
00:08:39.618 --> 00:08:43.771 So what we need to do is we
00:08:43.771 --> 00:08:47.145 need to go back to your site.
00:08:47.150 --> 00:08:50.190 I just wanted you to see that we're
00:08:50.190 --> 00:08:52.733 not actually doing with it and then
00:08:52.733 --> 00:08:55.470 go to the admin side so it'll be.
00:08:55.470 --> 00:08:56.232 You know, yeah,
00:08:56.232 --> 00:08:58.010 I know you know it just for
00:08:58.078 --> 00:08:59.560 thevideo.com/admin slash.
00:08:59.560 --> 00:09:01.270 Clarity Dash e-commerce dash admin.
00:09:01.270 --> 00:09:03.535 You can see you've already
00:09:03.535 --> 00:09:05.347 typed it in before.
00:09:05.350 --> 00:09:07.038 The last recommendation there.
00:09:14.900 --> 00:09:17.056 And we've got to do two things,
00:09:17.060 --> 00:09:19.405 but the first thing is to clear
00:09:19.405 --> 00:09:22.930 out the cache because. Uhm?
00:09:22.930 --> 00:09:26.160 It caches things right, yeah?
00:09:26.160 --> 00:09:27.840 And translations are well sings,
00:09:27.840 --> 00:09:30.855 so we've got to go to home like that.
00:09:30.860 --> 00:09:31.868 That drop down.
00:09:31.868 --> 00:09:33.884 There's nothing ways to get there,
00:09:33.890 --> 00:09:35.900 but click that click site maintenance.
00:09:39.310 --> 00:09:42.019 Click young, go down, Scroll down to
00:09:42.019 --> 00:09:44.250 globalization is the last one, right?
00:09:44.250 --> 00:09:47.290 Right there and then click on the languages.
00:09:47.290 --> 00:09:49.190 Click on UI keys and
00:09:49.190 --> 00:09:50.710 click on UI translations.
00:09:50.710 --> 00:09:52.990 Those are clearing caches as you
00:09:52.990 --> 00:09:54.510 click those, OK, alright?
00:09:54.510 --> 00:09:57.170 And then we're going to go to.
00:09:59.650 --> 00:10:02.037 Click the dropdown again at the top.
00:10:04.100 --> 00:10:06.000 And go to schedule tasks.
00:10:09.710 --> 00:10:13.050 Check go to recurring jobs.
00:10:13.050 --> 00:10:15.840 Click the third one down.
00:10:15.840 --> 00:10:17.955 Update translations files.
00:10:17.955 --> 00:10:20.775 And click trigger down.
00:10:20.780 --> 00:10:23.507 And then go to jobs so that this that
00:10:23.507 --> 00:10:26.539 we just clicked is that just clearing?
00:10:26.540 --> 00:10:28.340 What exactly is this doing?
00:10:28.340 --> 00:10:30.914 What it's doing? Is it's saying
00:10:30.914 --> 00:10:34.069 hey go fetch the database again?
00:10:34.070 --> 00:10:35.595 And regenerate that Jason file
00:10:35.595 --> 00:10:37.490 and put it where it goes.
00:10:37.490 --> 00:10:39.667 Alright, cool 'cause we've done this before,
00:10:39.670 --> 00:10:41.938 but now that I actually know what's
00:10:41.938 --> 00:10:44.333 going on in my OK, I forgot that,
00:10:44.333 --> 00:10:46.199 but now I know yeah cool,
00:10:46.200 --> 00:10:47.750 alright that's what it does.
00:10:47.750 --> 00:10:50.930 So if we did it run it says it lasts
00:10:51.020 --> 00:10:54.820 execution few seconds go go to jobs though.
00:10:54.820 --> 00:10:57.255 So let's see if succeeded
00:10:57.255 --> 00:10:59.203 or what's what's scheduled.
00:11:02.740 --> 00:11:05.057 Oh, it's not that OK so succeeded.
00:11:05.060 --> 00:11:06.431 Go to succeeded.
00:11:06.431 --> 00:11:09.173 And it looks like it right?
00:11:09.180 --> 00:11:12.156 It just messing up like 50 OK alright,
00:11:12.160 --> 00:11:14.757 so now you should be able to.
00:11:14.760 --> 00:11:16.770 I think go back to the
00:11:16.770 --> 00:11:18.850 front end and just refresh.
00:11:22.060 --> 00:11:24.524 I think. I don't think you have
00:11:24.524 --> 00:11:26.814 to rebuild for this because the
00:11:26.814 --> 00:11:29.495 file like the file it fetches it,
00:11:29.500 --> 00:11:32.100 fetches it again, right?
00:11:32.100 --> 00:11:36.068 OK, so it's not going through right now.
00:11:36.070 --> 00:11:38.986 Go ahead and restart your apples.
00:11:38.990 --> 00:11:40.526 Then see if that makes it come in.
00:11:47.050 --> 00:11:48.920 Really, really ought to work.
00:12:28.100 --> 00:12:31.979 Put. OK, I just read the transcription and
00:12:31.979 --> 00:12:34.520 it says go ahead and restart your apples.
00:12:37.830 --> 00:12:40.440 OK, so it's not coming through.
00:12:40.440 --> 00:12:45.240 Let me go read my e97b850e-d4bd-4e23-a33a-73bf8b4b790a
00:12:45.240 --> 00:12:46.986 A while since I've done it.
00:12:46.990 --> 00:12:48.747 I'm pretty sure we did all all
00:12:48.747 --> 00:12:50.549 of the all the right steps.
00:12:56.540 --> 00:12:59.608 OK, I don't have it here. I have it here.
00:13:01.930 --> 00:13:03.600 OK, so.
00:13:09.990 --> 00:13:13.870 Yep, do that translation.
00:13:13.870 --> 00:13:16.588 OK, well probably a caching issue.
00:13:16.590 --> 00:13:18.806 Go ahead, try opening
00:13:18.806 --> 00:13:21.576 this in a new browser.
00:13:21.580 --> 00:13:24.086 Or I mean not a new browser.
00:13:24.090 --> 00:13:25.530 A new Incognito window?
00:13:25.530 --> 00:13:26.970 I didn't mean browser.
00:13:30.880 --> 00:13:33.046 See if for some reason the
00:13:33.046 --> 00:13:34.490 browsers caching that file.
00:14:09.560 --> 00:14:11.840 So it should be coming
00:14:11.840 --> 00:14:14.120 through the browser is done.
00:14:14.120 --> 00:14:15.384 And that's the problem.
00:14:15.384 --> 00:14:17.280 'cause if you if you inspect
00:14:17.344 --> 00:14:18.984 that just to be 100% sure.
00:14:18.984 --> 00:14:20.680 If you inspect that,
00:14:20.680 --> 00:14:24.180 does it have the translate on there?
00:14:24.180 --> 00:14:25.458 Yeah it does.
00:14:25.458 --> 00:14:27.870 So yeah, so that's how you do it.
00:14:27.870 --> 00:14:28.910 The browser is dumb.
00:14:28.910 --> 00:14:29.690 It caches eventually,
00:14:29.690 --> 00:14:31.559 it will just catch up and it
00:14:31.559 --> 00:14:32.906 will correct itself and you'll
00:14:32.906 --> 00:14:34.364 see it on the front end.
00:14:34.370 --> 00:14:35.150 But you know,
00:14:35.150 --> 00:14:36.450 it's it's like garbage collection.
00:14:36.450 --> 00:14:37.740 It's one of those things like
00:14:37.740 --> 00:14:39.308 not a lot of people really
00:14:39.308 --> 00:14:40.608 understand how it works,
00:14:40.610 --> 00:14:42.176 but we just trust it does
00:14:42.176 --> 00:14:43.730 and it does its job so.
00:14:46.770 --> 00:14:48.030 That's the whole.
00:14:48.030 --> 00:14:49.290 That's not process.
00:14:49.290 --> 00:14:51.390 No, I will add this.
00:14:51.390 --> 00:14:53.490 I would not do translations.
00:14:55.660 --> 00:14:57.900 In less, you're feeling really
00:14:57.900 --> 00:15:00.140 fast and comfortable with it.
00:15:00.140 --> 00:15:05.446 I wouldn't add them. To your local.
00:15:05.450 --> 00:15:08.530 Unless you just care about the layout.
00:15:08.530 --> 00:15:10.870 Because it's a waste of time
00:15:10.870 --> 00:15:13.195 because we're not going to copy
00:15:13.195 --> 00:15:15.589 your database to give it to them.
00:15:15.590 --> 00:15:19.748 Alright, so the mean, yeah so.
00:15:19.750 --> 00:15:21.628 If you're gonna add it anywhere,
00:15:21.630 --> 00:15:24.510 the place to add it is on like on the
00:15:24.590 --> 00:15:27.548 database that the project is actually.
00:15:27.550 --> 00:15:30.328 Using on QA.
00:15:30.328 --> 00:15:34.958 OK, that makes sense somewhat.
00:15:34.960 --> 00:15:37.165 So basically, like if you go ahead,
00:15:37.170 --> 00:15:39.465 I was just going to say 'cause I when
00:15:39.465 --> 00:15:41.890 it comes to changing their database.
00:15:41.890 --> 00:15:45.986 Like how do you go about doing that?
00:15:45.990 --> 00:15:48.228 Oh, it's exactly the same process.
00:15:48.230 --> 00:15:50.694 All that you have to do is find
00:15:50.694 --> 00:15:53.116 out what database the like silicon
00:15:53.116 --> 00:15:55.702 in this instance is camp Dash,
00:15:55.710 --> 00:15:56.378 QA right?
00:15:56.378 --> 00:15:56.712 Yeah,
00:15:56.712 --> 00:15:59.559 so you need to find out where which
00:15:59.559 --> 00:16:01.714 database that instance of stuff
00:16:01.714 --> 00:16:04.194 like that project is pointing at
00:16:04.194 --> 00:16:06.581 OK and then you would just run
00:16:06.581 --> 00:16:09.100 the exact same command on that
00:16:09.100 --> 00:16:11.716 database and then you would log
00:16:11.716 --> 00:16:14.572 into the admin side of camp Dash QA.
00:16:14.580 --> 00:16:17.310 Like you do all the same stuff.
00:16:17.310 --> 00:16:18.090 Gotcha, yeah,
00:16:18.090 --> 00:16:20.430 it's just obviously and then honestly,
00:16:20.430 --> 00:16:23.040 even then it's probably hardly even
00:16:23.040 --> 00:16:26.228 worth it because then when we push
00:16:26.228 --> 00:16:28.513 this into a production environment.
00:16:28.520 --> 00:16:31.380 It's going to or even like when it goes live,
00:16:31.380 --> 00:16:33.604 right like they might have to do it
00:16:33.604 --> 00:16:35.955 again unless they can copy that Jason file,
00:16:35.960 --> 00:16:37.955 but I don't think they can write,
00:16:37.960 --> 00:16:40.520 so they have to, I guess at that
00:16:40.520 --> 00:16:43.109 point they can back up the database.
00:16:43.110 --> 00:16:44.760 And then restore that database to
00:16:44.760 --> 00:16:46.760 a new instance and it would happen.
00:16:46.760 --> 00:16:49.570 So yeah, it's probably worth it to do on QA,
00:16:49.570 --> 00:16:51.390 but it's not really worth it to
00:16:51.390 --> 00:16:52.949 do it on your local.
00:16:52.950 --> 00:16:55.062 So I just did it with you so
00:16:55.062 --> 00:16:56.600 you know how it works.
00:16:56.600 --> 00:17:00.206 Both back not because you should.
00:17:00.210 --> 00:17:00.605 Alright,
00:17:00.605 --> 00:17:01.000 cool.