WEBVTT

00:10.610 --> 00:11.580
- [ Explainer] Welcome.

00:11.580 --> 00:13.880
This is one in a series of "How-to" videos

00:13.880 --> 00:15.820
for IMD2.

00:15.820 --> 00:16.900
In this video,

00:16.900 --> 00:19.300
we will cover how to extract a FULL table

00:19.300 --> 00:21.453
using the IMD2 BATCH feature.

00:22.470 --> 00:25.910
First, browse your installation folder.

00:25.910 --> 00:29.680
Then, double click the IMD2 application.

00:29.680 --> 00:31.200
From the main page,

00:31.200 --> 00:33.883
We'll use this menu to select batch.

00:34.990 --> 00:36.710
Once in the batch feature,

00:36.710 --> 00:38.910
you'll see there are
many options available.

00:40.400 --> 00:44.010
This drop-down contains the primary keys.

00:44.010 --> 00:46.233
In this example, we'll choose NIN.

00:47.300 --> 00:50.820
This information box tells
us we can use an input file

00:50.820 --> 00:52.420
to search specific items

00:52.420 --> 00:56.880
or we can give this a job
name to pull the full tables.

00:56.880 --> 00:59.710
In this example, we would
like to pull full tables

00:59.710 --> 01:01.423
so we will give it a job name.

01:03.830 --> 01:06.130
Below that, you will see tables with NIN

01:06.130 --> 01:07.423
as the primary key.

01:08.270 --> 01:11.263
Click on the table name to
view included data fields.

01:12.810 --> 01:14.020
In this example,

01:14.020 --> 01:17.240
we'll choose only Freight and Packaging.

01:17.240 --> 01:18.660
Scroll down,

01:18.660 --> 01:20.470
De-select all

01:20.470 --> 01:23.223
and select only the Freight
and Packaging tables.

01:24.120 --> 01:26.290
Once the tables are selected,

01:26.290 --> 01:28.000
click the Output Folder button

01:28.000 --> 01:30.633
and browse to the desired output location.

01:44.170 --> 01:46.163
Click Run to start the pull.

01:49.010 --> 01:50.440
At the top of the screen,

01:50.440 --> 01:53.570
the information bar has
changed to a progress bar.

01:53.570 --> 01:56.350
This will indicate that
the job is processing,

01:56.350 --> 01:58.100
what file it's processing,

01:58.100 --> 02:00.340
how many tables have been processed

02:00.340 --> 02:02.690
and how long the job is taking.

02:02.690 --> 02:05.170
Batch jobs will vary in time to completion

02:05.170 --> 02:08.080
as each table can vary greatly in size.

02:08.080 --> 02:09.110
Because of this,

02:09.110 --> 02:10.520
we will pause the video

02:10.520 --> 02:12.743
and pick up at job completion.

02:17.420 --> 02:18.670
And we're back.

02:18.670 --> 02:21.920
As you can see, the job
finished successfully

02:21.920 --> 02:24.980
and in 20 minutes, 35 seconds.

02:24.980 --> 02:27.693
Click HERE to open the output folder.

02:29.010 --> 02:30.410
In the output folder,

02:30.410 --> 02:34.000
you will see files named to
include the Job Name you gave

02:34.000 --> 02:36.760
along with the Table Names you selected.

02:36.760 --> 02:39.350
Each of these files can
be opened in Notepad,

02:39.350 --> 02:41.400
Excel, Access

02:41.400 --> 02:43.513
or imported into another database.

02:45.800 --> 02:46.780
Inside each file,

02:46.780 --> 02:48.680
you will see the full dataset

02:48.680 --> 02:50.670
with the data fields at the top

02:50.670 --> 02:52.563
in comma-separated format.

02:56.060 --> 02:58.130
That was how to extract a FULL table

02:58.130 --> 03:00.373
using the IMD2 BATCH feature.

03:01.260 --> 03:02.550
Check out our other videos

03:02.550 --> 03:04.610
on How To Use IMD2.

03:04.610 --> 03:05.610
Thanks for watching.