►
Description
Recording of the import/export weekly call from the 30th of July 2018.
This project focuses on the https://github.com/magento-engcom/import-export-improvements repository with the aim to provide some key bug fixes in the 2.3 release of Magento 2.
If you would like to get involved in the project please see the github issues or contact the Magento Community Engineering team for more information.
A
A
You
should
be
able
to
see
this
is
the
import/export
specific
statistics
for
the
requests,
so
we
have
processed
already
so
far
yeah
so
far
this
month,
seven,
which
is
great-
we
had
a
few
more-
we
had
one
more
come
in
and
which
has
been
processed
today,
I
believe
which
was
nice
so
yeah.
It's
it's
been
pretty
good.
So
far,
I
am
for
today's
meeting.
We
are
gonna
talk
through
a
few,
a
few
updates
and
from
Ty's
testing
today
right.
A
B
B
Cool
so
37,
so
this
is
an
interesting
run,
so
duplicate
skew.
Okay,
so
there's
quite
a
history
to
this
one.
But
let
me
just
go
straight
down
to
some
of
the
tests
that
I
did
so
so
the
original
issue
was
linked
to
the
facts
with
skiers
with
trailing
spaces.
So
most
of
my
testing
so
far
has
been
linked
to
the
trailing
spaces
side,
because
some
interesting
results
coming
back
from
my
SQL
on
this
one.
B
So
we
and
what
was
decided
previous
to
my
testing-
was
that,
for
example,
if
if
it
finds
a
duplicate
SKU
on
a
save
I'm,
sorry
another
entity
with
the
same
SKU
it'll
append
a
minus
one
to
the
end
or
a
minus
two
or
whatever.
That
is
whichever
one
it
finds.
But
we
kind
of
agreed
that
we
were
going
to
stop
that
so
I
believe
Carson.
You
were
going
to
look
into
that
side
of
things.
Yes,
okay,
okay!
B
Well,
what
I
found
was
there's
sort
of
function,
so
they-
let
me
just
go
down
here
so
there's
a
function
called
generate
unique
SKU
and
that
what
that
caused
is
it
actually
caused
another
function
and
check,
attribute
unique
value
and
that's
in
the
eav
abstract
entity
class.
Now,
if
we
take
skew,
for
example,
that's
a
static
now
in
there,
it's
it's
running,
a
query
to
you
know
have
I
got
another
skew
of
the
same
value.
B
So
the
you'll
see
here
in
my
examining
one
of
my
tests,
where
the
skew
is
equal
to
de
F.
Now
that
will
actually
return
a
record
if
the
skew
was
de
f
space
and
de
F
or
de
F
space
space.
So
that's
where
the
duplicate
skew
issue
occurs
and
as
a
sequence
you
have
to
go
through
and
the
sequences
first
of
all
you'd
have
to
create
so
in
test.
Four
here
you
create
ABC,
and
then
you
import
another
school
called
ABC
space,
and
then
you
can
import.
You
know
space
ABC,
so
the
import
works.
B
Fine
and
I
had
no
issues
with
the
import
so
far,
and
even
in
test
seven
I
deleted
ABC
and
tried
to
re
important
as
always
fine,
but
it's
when
you
go
into
the
admin
panel
and
try
and
edit
ABC
and
change
you
know
something
else:
product
name
description'.
You
then
try
and
save
it.
It
will
append
a
minus
one
to
the
end
of
that
school.
B
B
B
C
B
Now
it
will
accept
that
change
simply
because
the
query
at
the
moment
is
finding
itself
it's
finding
de
F
space,
because
the
the
query
has
actually
stripped
out
the
trailing
space.
So
it's
coming
back
to
your
function,
Carsten
and
going
yeah.
It's
ok,
I,
don't
need
to
I,
don't
need
to
increment
it,
which
is
wrong
so
yeah.
That's
the.
B
So
that
will
that
would
exclude
the
DF
trailing
space
skew
from
the
from
the
query,
and
it
would
return
back
the
correct
okay
and
it
would
then
return
false
and
then
the
function
generate
unique
skewed
before
sort
of
go.
Sorry,
I
can't
do
that
and
we're
obviously
going
to
be
replacing
generate
unique,
SKU
with
well,
actually
we're
not
generating
any
excuse.
We're
just
actually
gonna
tell
you
it's
a
problem.
I.
B
Might
you
know
my
testing
so
far
the
import
hasn't
been
a
problem,
because
port
the
import
is
slightly
easier.
Now,
if
it
finds
the
existing
skew,
it
will
just
update
it,
because
that's
what
it
is.
It's
an
ad
update
but
I've,
yet
to
I
want
to
do
more,
a
lot
more
testing
with
the
import
with
leading
spaces
and
trailing
spaces
and
import.
You
know
five
or
six
of
them
and
then
re
important
and
make
sure
they
all
are
place
that
doesn't
suddenly
find
other
ones
yeah.
A
A
So
yeah
so
I'm,
just
looking
at
the
MySQL
documents
for
character,
characters
and
operations
with
characters,
and
it
says
that
the
values
of
var
charge
columns
are
stored
and
compared
according
to
the
character
set.
Correlation
collation
assigned
to
the
column
by
the
these
are
set
to
pad
space,
which
means
valleys
in
MySQL
were
compared
with
out
regard
for
trailing
spaces,
which
is
what
you
found
right.
Yeah.
B
A
Says
the
per
the
SQL
standard
which
I
didn't
know
about
the
like
performs,
are
matching
per
character
basis.
So
I
wonder
if,
in
this
case,
for
at
least
the
checking
of
the
values
we
need
to
actually
do
a
like,
rather
than
an
equal,
because
that
will
that
will
do
with
spaces
like
comparison
with
all
spaces
left
in
yeah.
B
B
A
A
A
B
A
A
A
B
B
A
B
A
B
I
said
my
next
up,
there's
a
few
more
test
cases
I
want
to
try.
I
want
to
do
a
little
bit
more
around
the
leading
the
leading
spaces.
They're
less
of
an
issue,
especially
MySQL,
so
I
think
would
be
ok
there
and
it
was,
but
if
Carson's
looking
into
the
generate
unique
SKU
thee
well,
it
is
we're
probably
gonna
rhenium
that
function
to
not
generate
unique.
Sku
yeah.
C
A
C
C
Think
and
I
think
it's
I
don't
know
and
I,
don't
think
that
we
programmed
it
and
then
we
had.
For
example,
we
had
the
issue
that
we
wanted
to
import
certain
schools
and
they
had
it.
Actually
they
had
a
line
break
at
the
end,
so
the
import
wouldn't
find
them,
and
it
was
so
horrible
and
I
have
no
idea
how
they
managed
to
do
a
line
break
at
the
end
of
these
schools.
C
B
C
B
A
A
C
And
when
you
showed
the
tests,
you
were
showing
that
you
had
an
in
a
school
school
with
a
white
space
and
then
you
imported
it
without
white
space.
And
then
you
wrote
all
fine.
In
my
opinion,
that's
not
all
fine
if
it
works
to
import
it
without
or
without
a
white
space
that
doesn't
exist
or
does
exist
in
the
original
school.
C
A
B
So
the
so
right
now
what
the
because
I
think
it
it
triggers
the
end.
It
does
an
event
for
the
SKU
like
it
before
save
or
something
to
generate
unique,
SKU
yeah,
so
that
probably
we
must
be
changing
that
to
check
unique
SKU
or
something
yeah,
because
we
still
need
to
run
the
query
to
check
that
it
there's
no
others
out
there.
Yeah.
A
A
A
A
So
this
is
the
pull
request
that
came
in
from
Federico
a
while
ago,
and
it
went
through
review
and
testing
and
everything
and
the
only
issue
we
found
was
if
you're
in
the
admin
section
you
couldn't
duplicate
the
the
product
yeah.
This
is
what
I'm,
because
it
failed,
because
the
SKU
is
not
unique.
So
this
is
what
costume
is
is
looking
at
at
the
moment
is
seeing
how
we
can
get
it
working
with
duplicate.
So
what
the?
What?
A
A
So
this
is
this
is
the
plan
here
is
if
we
can
get
this
working
with
the
duplication
and
then
I
think
this
is
a
good
way
of
doing
it,
because
we
we
shouldn't
be
manipulating.
In
my
opinion,
we
shouldn't
be
manipulating
the
SKUs.
No,
we
should
be
the
error
until
the
user.
You
can't
have
X
Y
or
Z
characters
in
your
like
white
space
and
return,
or
we
should
be
doing
it
like
this,
which
is
just
saying
I,
think
what
check-check
for
a
valid
SKU
is
that
it's
actually
got
a
lens
to
it.
A
So
it's
not
empty,
it's
not
bigger
than
the
maximum
length,
and
in
this
case
it's
not
already
in
use,
and
in
that
case
we
could
add
in
more
validation,
later
saying,
like
no
return,
characters,
no
trailing
white
spaces,
you
know,
so
we
can
build
on
that
as
you
were
suggesting,
but
in
this
way
we
would
bring
the
back
end
save
in
line
with
the
import
save
as
well,
which
I
think
is
important.
So
as
we
don't
confuse,
we
don't
kind
of
confuse
it
err,
a
users
cause
angle.
A
B
A
A
B
B
B
So
this
one
was
when
options
contain
commas
or
pipes
or
equal
signs,
what
happens
and
you,
basically
you
get
an
error,
so
it
was.
It
was
to
be
able
to
pretty
import
to
be
able
to
accept
these
values.
Mm-Hm
now
initially
I
went
down
the
wrong
road.
I
taught
us
to
do
a
configurable
variations,
but
it's
not
it's
actually
to
do
with
custom
options.
So
it's
quite
feasible.
You
could
have
a
custom
option
that
you
know
it
contains
a
sentence.
Mm-Hmm.
C
B
B
A
A
B
A
Can
wear
it
with
right
now,
cool
all
right.
So
if
that
is
the
updates,
then
I
guess
at
some
point.
Having
much
longer
meeting
like
I
said
the
next
two
weeks,
I'm
traveling,
so
I
don't
think
we
will
have
meetings.
But
if
there
is
anything
drop
me
a
message
in
slack
or
an
email
or,
however,
you
feel
and
I
will
and
I
will
be
working
I'll
just
be
in
a
different
time
zone
so
might
make
a
communication.