Import screen overview | Visual Importer ETL Tutorial 🎥

In this tutorial we give a detailed overview of Import screen

*Visual importer ETL* is the first software product we created.
Since then we have designed *Advanced ETL Processor* which is fully compatible with it and has much more features.
Most of *Advanced ETL Processor* videos are relevant to *Visual Importer ETL* except the ones describing how to work with transformations.

🔗 *Download Visual Importer ETL Enterprise*
Try it yourself:
https://www.etl-tools.com/products/visual-importer-etl-enterprise.html

❓ *Need Help with Data Transformation?*
Post questions in the support forum to get assistance:
https://www.etl-tools.com/forum.html

👍 *Enjoyed this Tutorial?*
If this video was helpful, consider giving it a thumbs up and *subscribe* to the channel for more tips and tutorials!

#ETL #Import

---

Closed Caption:

hi everyone let's talk about import
script import script it is a com screen
which has a lot of functionality let me
start from the top left so the first
button we have data Target
option this allows us to change
connection for data Target so we can
load data via DBC BD can load data SQL
ser Etc very important point I want to
make that if you love working with
multiple
databases as long as you keep the fields
order the same and the field names the
same you can easily switch from one
connection type to another without doing
remapping this is very important and
useful I
hope we have a transformation types
transation can be all all records which
is the fastest
options all new
records all new and update old records
update records and delete
records when add all records selected
depend on the database bu import is used
this why it is the fastest option for
the rest of them custom SK statement are
executed and it takes time to do that
for example if you want to add new
records first of all we need to check
that the record does not exist so it
will be select count from table and if
you have a million record that means
that you have to run a select count
million times and then to run insert
million times and that's very time
consum operation so it works very well
when you load in small amount of data
but if you want to uh load massive
amount of Records it the better option
is just to insert them into separate
table and later use um SK script to
update
it we also have uh ability to create
custom Ander
statements or update or delete this is
rather advanced stuff and not a lot of
users actually using
it ER
hand again it's most of expon so in for
example if primary keys viated we can
abort import and we can also write
records to rejected records files Etc
and we have also uh some options to
define a rejected records format so next
button is
U Notes so we can write some
notes about our inut
script after that we have uh open Button
save to the
file save us to the file save to the
repository uh refresh uh FS
list check script for example mapping is
Miss or something data
preview it's very handy tool which
allows us to
test the data or see how it will look
look like like once it is loaded into
the dat
this then we have a clear mapping
option once it is down you just use it
to clear
mapping let's M it again then we have
run then we have some buttons dedicated
to Version Control obviously we don't
want to lose
anything when you save
your mapping new version controls
created for automatically that allows
you to easily recover to previous
version for example so you just select
rever version number and click cancel
you can also add new version
Manu by using
checkin next option makes uh import
script
only we recommend using these options
once you finish it working with all your
import
scripts it prevents it from further
changes then we have shade of execution
button and we have uh view execution
block but since U this impros script was
never
executed from the package or schedule or
agent the execution log
okay below that we have a number of tops
so the first one is
obviously Lisa
fields we can uh use this
uh gap for
mapping using various
options or we can use mapping
panel and we can also set update key if
it is what we want or it basically for
loading new data it is just sort of
useless but for updating and loading all
new data it's very
useful then we have SQL which we can run
before uh running the import and after
running the import have the actual
template the transformation
loog you can sort the data you can do
some search
like this and they have we also have
rejected records Tab and rejected
records file is empty so therefore we
can't see
anything let's go back so below that we
have um
Source
toolbar so we just click on data source
options again we have a lot of uh
various data source type supported and
if you load in data from
Excel and then you decide to load from
same data from CSV provided that the
field s is the
same and the uh field names are the same
you don't have to do any remapping it
will just
work we also have data reading
instructions which can be very useful
when you're working with very large uh
Source data set and you just want to
load the
sample in if case of files data can be
Lo loaded from multiple
files and we can use the mask and we can
also search in sub
directories after that we have refresh
load refresh data button add new column
uh autom up data is very useful have
separate video for
it filter filter is a rather
primitive way of filtering the data uh
we recommend using it with like text
files or Excel files basically what you
can do you can write very
basic um expression which is similar to
Y
statement to filter the data the
documentation has
examples then we have open file
directory this is this is like a
shortcut because we don't want to
open browser or Explorer and find the
file double click on the file and see it
to just press this button will do it
well we also have number of uh popup
menus which can be very useful you can
say set if all error to reject
very handy for very large
tables then we have
um generate table creation script
basically it will create very basic
table creation
script which you can UNM later and copy
it into clip board
and we have Auto format GD set number
fields and then we have set first line
as the field names it's actually not
entirely correct because we can use any
line as the field
names again it saves time for very wide
uh
files or data
sources I hope you found this tutorial
useful if you uh have any questions or
suggestions please POS them on our
support Forum we always happy to help
you thank you for watching please like
And subscribe