00:00:07:19 - 00:00:08:03
The ability
00:00:08:03 - 00:00:11:22
to upload product data in bulk via CSV
00:00:11:29 - 00:00:15:19
or Excel documents has long been available
within MegaEdit.
00:00:16:24 - 00:00:20:20
This function is used, for example,
to easily populate multiple
00:00:20:20 - 00:00:24:00
different business cards
without having to manually type
00:00:24:00 - 00:00:26:23
in the data
for each individual staff member.
00:00:28:07 - 00:00:30:12
This functionality
has now been incorporated
00:00:30:12 - 00:00:35:11
into our Invent plugin as well,
allowing you to set this capability
00:00:35:12 - 00:00:39:08
prior to bringing your templates into MegaEdit. In this tutorial, we
00:00:39:09 - 00:00:43:23
discuss how this is achieved.
00:00:43:23 - 00:00:47:29
So what we've got on our screen at
the moment is a pre-configured product.
00:00:48:15 - 00:00:51:01
We're assuming at this stage
that you do already have
00:00:51:01 - 00:00:53:26
some knowledge on
how to configure your MegaEdit products.
00:00:54:06 - 00:00:58:04
So this is things such as creating
resources, creating variables,
00:00:58:13 - 00:01:01:18
setting up field properties,
all that kind of thing.
00:01:02:00 - 00:01:03:12
This is just focusing
00:01:03:12 - 00:01:06:14
on the additional steps
that you'll need to configure the batch
00:01:06:14 - 00:01:08:29
functionality.
00:01:10:18 - 00:01:13:10
So let's start off
by clicking on the setup tab
00:01:13:10 - 00:01:17:02
within an Invent
and then going to the mode sub-tab
00:01:20:01 - 00:01:20:16
on there.
00:01:20:16 - 00:01:23:21
You'll see that we have a dropdown
which is the operation mode
00:01:24:14 - 00:01:27:25
and by default that will be on single,
which is the default behavior
00:01:27:25 - 00:01:31:13
of Invents in the classic behavior
that you've already seen.
00:01:32:00 - 00:01:34:23
And then the other option
we have is batch.
00:01:35:02 - 00:01:38:01
And this enables the batch capability
and reveals
00:01:38:01 - 00:01:41:20
a range of additional settings.
00:01:42:19 - 00:01:44:22
So just going down these settings
and what they do,
00:01:44:23 - 00:01:46:29
first of all, we have batch sources.
00:01:46:29 - 00:01:50:24
This allows us to select
whether you wish for the users to upload
00:01:50:24 - 00:01:54:19
via a CSV, Excel document or both.
00:01:54:25 - 00:01:56:26
If you wish to allow that
00:01:58:28 - 00:02:00:17
next down we have mapping.
00:02:01:22 - 00:02:02:15
So this
00:02:02:15 - 00:02:08:09
specifies whether a field mapping
screen appears upon upload of a CSV
00:02:08:16 - 00:02:11:07
or Excel data file within MegaEdit.
00:02:12:02 - 00:02:15:09
This allows manual specification
of the relationship
00:02:15:09 - 00:02:18:26
between CSV columns
and variable template fields.
00:02:19:16 - 00:02:24:04
Disabling this feature will mean that
very specific data formats are required.
00:02:24:15 - 00:02:28:06
So for example, variables, fields
and CSV columns
00:02:28:14 - 00:02:32:02
with identical naming conventions.
00:02:33:29 - 00:02:36:29
Next down, we have records
so we can specify the minimum
00:02:36:29 - 00:02:40:04
and maximum
allowable number of records in a provided
00:02:40:04 - 00:02:43:01
data file.
00:02:44:20 - 00:02:47:00
Next is validation enabled.
00:02:47:00 - 00:02:51:00
So what this means
00:02:51:00 - 00:02:56:26
is that records up to a maximum of 1000
from your Excel or CSV document
00:02:57:08 - 00:03:02:13
will be validated upon upload
and any invalid records based
00:03:02:13 - 00:03:08:11
on the information in the configuration
that you provided will be rejected.
00:03:12:18 - 00:03:14:25
We then have sample download,
00:03:14:25 - 00:03:18:16
so enabling this option will mean
that an additional button is available
00:03:18:16 - 00:03:22:14
within the MegaEdit editor
when viewing the actual product.
00:03:23:02 - 00:03:27:15
So this will allow users to download
a sample version of the required CSV
00:03:27:20 - 00:03:33:15
or Excel template with correct column
headers and rows of sample entries.
00:03:34:19 - 00:03:37:23
This helps to ensure that only relevant
data is uploaded
00:03:37:29 - 00:03:42:26
and reduces
potential problems with incorrect formats.
00:03:47:29 - 00:03:49:29
Next we have the upload button,
00:03:49:29 - 00:03:52:15
so it's
highly recommended to have this selected.
00:03:52:28 - 00:03:56:21
It provides an upload button
within MegaEdit, allowing users
00:03:56:21 - 00:03:59:19
to select the required data files
that they wish to
00:04:00:24 - 00:04:03:08
provide information with.
00:04:03:08 - 00:04:06:10
The alternative is to handle the upload
via scripts,
00:04:06:15 - 00:04:09:17
which we do not recommend.
00:04:13:28 - 00:04:14:09
Okay,
00:04:14:09 - 00:04:17:28
so with those options covered, we're
now going to go over to our Variables tab.
00:04:18:14 - 00:04:21:00
So we're going to look at any special
considerations
00:04:21:00 - 00:04:24:12
when setting up the variables
for our batch mode.
00:04:25:11 - 00:04:28:27
So you'll see in my case that I've got
a few variables already configured.
00:04:28:27 - 00:04:31:14
We can create new variables.
Of course it doesn't matter.
00:04:31:25 - 00:04:34:21
I'm just going to go in and press edit
next to one of my existing
00:04:34:21 - 00:04:38:01
variables.
00:04:38:01 - 00:04:38:21
And the option
00:04:38:21 - 00:04:43:01
I want to draw your attention to here
is this controlled by batch source.
00:04:43:16 - 00:04:46:26
So this confirms to the variable
that it will be controlled
00:04:46:26 - 00:04:50:06
by the uploaded batch data
and will not appear
00:04:50:06 - 00:04:53:24
within the MegaEdit form
as a customizable variable.
00:04:54:01 - 00:05:02:20
And we'll see this in action
a little bit later on.
00:05:03:09 - 00:05:03:20
Okay.
00:05:03:20 - 00:05:04:04
So next,
00:05:04:04 - 00:05:08:10
we need to do a little bit of work inside
InDesign itself and away from Invent.
00:05:08:25 - 00:05:11:06
And this is by navigating
to the Layers tab.
00:05:11:11 - 00:05:15:07
If you can't see it here,
you can activate it from the window
00:05:15:07 - 00:05:19:08
section at the top.
00:05:19:08 - 00:05:22:24
And what we need to do
is ensure that our relevant layers
00:05:23:01 - 00:05:27:00
so the text and image fields
that we wish to make dynamic are named
00:05:27:00 - 00:05:31:17
identically to the Invent variables
that we wish to link them to.
00:05:32:14 - 00:05:34:19
So you'll see, for example,
I have three variables
00:05:34:19 - 00:05:37:10
created here text, number and image.
00:05:37:19 - 00:05:40:15
I need to make sure
that the relevant fields on here,
00:05:40:22 - 00:05:43:22
which we want to be populated,
have the same names.
00:05:44:27 - 00:05:47:16
If I go to my layers tab
00:05:47:16 - 00:05:48:26
click on the relevant field.
00:05:48:26 - 00:05:49:20
You'll see that
00:05:49:20 - 00:05:53:24
it gives you a little indicator to show
which field that is within the layers tab.
00:05:54:13 - 00:05:57:21
And then we can just sort of slow
double click on that to rename it
00:05:58:01 - 00:06:07:14
and then make sure it has the relevant
name.
00:06:09:02 - 00:06:12:04
Once you've completed that,
go back to the Invent tab
00:06:12:13 - 00:06:17:03
and now we're going to go to Properties.
00:06:17:03 - 00:06:20:16
We need to ensure that our text and image
fields are linked
00:06:20:23 - 00:06:22:25
to the correct variables.
00:06:23:26 - 00:06:26:29
So this is the same as we'd
see with any standard Invent product.
00:06:27:08 - 00:06:30:28
Just make sure that any of the fields
that you want to be linked to a variable
00:06:31:06 - 00:06:36:03
have got that required mapping.
00:06:36:03 - 00:06:42:29
And this includes images as well.
00:06:42:29 - 00:06:45:12
So on the topic of images, image
00:06:45:12 - 00:06:49:05
images can also be controlled
by the batch mode tool.
00:06:49:05 - 00:06:52:01
So if you select an image field
that you wish to control,
00:06:52:09 - 00:06:58:02
we'll take a look
at how to configure this functionality.
00:06:58:02 - 00:06:59:27
So first off, we'll go to set up
00:07:04:01 - 00:07:08:04
click on the image sub tab.
00:07:08:04 - 00:07:12:04
What we're going to do first of all,
is to make sure that we've got the show
00:07:12:04 - 00:07:15:18
image upload area set to automatically
00:07:15:22 - 00:07:18:28
in contrast to the false option.
00:07:19:24 - 00:07:24:05
So this option means a tab will be visible
within the MegaEdit editor window,
00:07:24:13 - 00:07:27:29
allowing users to upload their own imagery
into galleries.
00:07:28:18 - 00:07:30:19
This does not have to be done here.
00:07:30:19 - 00:07:34:11
It's equally possible to enable this later
within MegaEdits itself
00:07:35:13 - 00:07:39:16
to utilize images via
the batch mode, users will need to upload
00:07:39:16 - 00:07:43:29
or have access to images they wish to use
within the tab that this creates.
00:07:44:07 - 00:07:52:14
And again,
we'll see this a little bit later.
00:07:52:14 - 00:07:52:25
Okay.
00:07:52:25 - 00:07:55:19
So at this point,
we're ready to export our templates.
00:07:55:27 - 00:07:58:05
That's the same process
as you would normally see.
00:07:58:05 - 00:08:02:08
So just go to the export tab,
start your validations, fix
00:08:02:08 - 00:08:10:11
any problems,
and then continue to the export.
00:08:10:11 - 00:08:14:07
We then going to load that
into a MegaEdit product
00:08:14:16 - 00:08:17:23
and then launch that product.
00:08:20:27 - 00:08:25:22
So our product has now been loaded in
as a MegaEdit product.
00:08:25:22 - 00:08:29:18
And what we can see over on the left hand
side is our images tab.
00:08:30:01 - 00:08:35:17
Now this tab is what is shown
when you enable that automatically option.
00:08:35:26 - 00:08:38:24
This allows users
to actually upload their own images
00:08:38:24 - 00:08:41:25
or artwork
to use on the actual product itself.
00:08:42:22 - 00:08:45:00
So what we've done in
this case is we've uploaded
00:08:45:00 - 00:08:51:01
a few simple images into a album
within our images.
00:08:51:01 - 00:08:53:03
Tab users can do this themselves.
00:08:53:03 - 00:08:55:00
They can create multiple albums.
00:08:55:00 - 00:08:58:03
And again,
this kind of functionalities, general
00:08:58:03 - 00:09:01:15
MegaEdit functionality
that is covered in different tutorials,
00:09:03:03 - 00:09:06:05
your users will utilize the names
of these images
00:09:06:15 - 00:09:10:03
to draw them into the product via
the batch mode.
00:09:10:13 - 00:09:13:12
So you do want to make sure
that you understand the naming convention
00:09:13:12 - 00:09:16:02
of those particular images,
00:09:16:02 - 00:09:17:19
and then we'll move on
00:09:20:04 - 00:09:21:07
the next change
00:09:21:07 - 00:09:24:00
from a standard MegaEdit
set up that you'll see
00:09:24:07 - 00:09:28:10
is this download sample button
at the top of the screen clicking this.
00:09:28:10 - 00:09:31:23
This will provide you
with a simple template document
00:09:32:05 - 00:09:34:22
ensuring that your users provide data
00:09:34:28 - 00:09:40:06
in the correct format.
00:09:40:06 - 00:09:40:25
You see there
00:09:40:25 - 00:09:45:10
We've got a few columns available
from the three different variables
00:09:45:10 - 00:09:52:23
that we specified,
and also with a sample row data.
00:09:52:23 - 00:09:56:29
Now what we want to do now is complete
the sample document or modify
00:09:56:29 - 00:10:00:24
your existing data to be
in this required format.
00:10:01:20 - 00:10:03:07
So to do this,
I'm just going to switch to one
00:10:03:07 - 00:10:07:05
that I've created a little bit earlier on.
00:10:07:05 - 00:10:12:27
So there's a few sample entries in here,
so ensure the data you enter
00:10:12:27 - 00:10:16:25
is in the correct format
for utilizing an image uploaded
00:10:16:25 - 00:10:21:05
into your image galleries
ensure you utilize the full image
00:10:21:05 - 00:10:25:04
name for the file type extension
so you can see this one.
00:10:25:04 - 00:10:27:05
For example, I have Ben.png
00:10:29:18 - 00:10:31:22
I want to make sure
that that is in the relevant column
00:10:32:04 - 00:10:36:02
in my data file.
00:10:36:02 - 00:10:37:10
If your image is contained
00:10:37:10 - 00:10:41:11
within the default image gallery
such as these are here, we can see that
00:10:41:11 - 00:10:46:01
we can simply put the name such
as the image on the extension.
00:10:46:01 - 00:10:47:05
So Ben.png. And
00:10:48:16 - 00:10:51:22
if your image is contained
within alternate image galleries,
00:10:52:04 - 00:10:55:08
which is possible when you start adding
additional files in here,
00:10:55:20 - 00:10:59:05
you will need to enter that location
as part of this field.
00:10:59:20 - 00:11:08:04
So for example, it might be a gallery
00:11:08:04 - 00:11:11:03
if that's the name of the alternate
gallery we've made,
00:11:12:12 - 00:11:23:05
/Ben.png
00:11:23:05 - 00:11:27:11
Okay, so when this data is ready
and we've saved it, then all we need to do
00:11:27:11 - 00:11:31:21
is go back to our MegaEdit product
and we're going to say import spreadsheet.
00:11:31:21 - 00:11:34:00
And of course our customers
are going to be able to do this as well.
00:11:35:08 - 00:11:38:23
Select the relevant file
00:11:38:23 - 00:11:41:25
and then we'll see this placeholder mapping screen pop up.
00:11:42:11 - 00:11:47:02
So if you selected to enable mapping
during the batch mode setup inside
00:11:47:02 - 00:11:50:22
Invent itself, you will be presented
with a screen to specify
00:11:50:22 - 00:11:54:01
how the fields
relate to the different CSV columns.
00:11:55:12 - 00:11:58:20
So entries with matching
names will be paired up automatically.
00:11:58:20 - 00:12:01:08
So we can see that it has been done
in many of these cases.
00:12:01:08 - 00:12:03:14
So all of these cases,
00:12:03:19 - 00:12:05:12
however, you can alter them further
00:12:05:12 - 00:12:08:14
if they are incorrect.
00:12:08:14 - 00:12:14:13
If you didn't enable mapping an Invent,
you won't see this screen.
00:12:14:13 - 00:12:16:25
Once you're happy, click on okay.
00:12:16:25 - 00:12:20:05
And that will map the data.
00:12:20:05 - 00:12:23:06
We can see that we have a message
box on the top right hand side in our case
00:12:23:06 - 00:12:26:14
showing that it's successfully mapped
seven records.
00:12:26:22 - 00:12:30:21
If there was a problem with the upload,
it might show you some additional prompts
00:12:30:21 - 00:12:33:27
here, some additional information
and possible ways to fix it
00:12:33:27 - 00:12:38:22
as well.
00:12:38:22 - 00:12:43:19
Now you won't see anything of the imported
data inside the main MegaEdit viewer.
00:12:43:26 - 00:12:46:24
However, if you go to the preview section
up on the top right,
00:12:47:15 - 00:12:51:06
you will see those populated documents.
00:12:51:17 - 00:12:53:16
So I can see a few sample records.
00:12:53:16 - 00:12:55:05
I won't be able to see all of them.
00:12:55:05 - 00:12:59:11
So if I go to next record
and start working my way
00:12:59:19 - 00:13:07:19
through the alternate
versions of that product.