Scriptcase 8 - XLS, CSV and Access converter

This video shows how to import and convert spreadsheets (.xls), ACCESS and CSV files to a database and use the data inside Scriptcase to create new applications.

During the example also we used two blanks to make the .txt file reading and import the files manually. Please find the codes here:

http://www.scriptcase.net/forum/showt...

---

Closed Caption:

and today we'll talk about the new
scriptcase converters i will show you
how how to manage the converters for
excel files that CSV and access and i'll
also show you another example for you to
import files with the using application
manually ok using the code so we will
see how scriptcase manage the
importation and conversion and then we
also manage my local version then you
will be able to import any type of file
. there d XD and so on
I'd like to know if you have any initial
question or comment for this
presentation today if you don't have we
can start i'll give you a couple of
seconds for four questions you can use
the tool that we have for chatting you
will find the check option you can take
your question and then i will read it
here and answer or you can also raise
your rent your hand you we have a raise
rent the raise hand feature you can
click on the raised hand and then i can
open the microphone for you to ask the
question I have a Jefferson today from
technical support he's gonna help us
with the technical questions so please
if you have any we can stop the example
and then we can also open for general
questions that you have
ok let me just go here to my script case
i will looking as administrator
ok shoot him hair season has questions
we can start as you can see my script
case here is outdated
I'd like to get this opportunity to show
you how to manage also the mono update
okay but we will do this after the
example I was just closed and then i
will update my my scriptcase to show you
how to make them update took to make
them the example I will have to create a
new project you will find the option to
import access exhale and csv here inside
the database and they have equal access
exhale and CSG it is not it's not the
neighbor because if we didn't create a
project the options they will they will
be available just if you have a if you
are inside a project so that's why we
need to create a project so let's create
the new project our name here covert
project language english that's fine let
me just change here the the shower set
encoding to utf-8 this is the one I have
on my database
okay then here i will create a Michael
action let me open here my my manager
and then you can follow here what is
happening
also inside the database
ok so first instead of using the
database that there that i already have
i'm going to create a new one so it will
be a blank one let's go here to neil i
will name it
webinar and Cody utf-8 also ok create
save and now i can come here to database
and see that the options are already
available for me okay it means that you
can import tables and and producers to
existing database that you already have
I could go there to my database for
example create a new connection using
another database and then enter the
table student success and database i can
create a new one as I did here let's
start with the CSV so I have here some
files to import okay i have CSV XML
files and access so let's use here the
Select files to select the file
mm so this is csv the CSV fire is this
one then next so very important to to to
mention here discrete case will import
the files and then if you don't inform
in which row you have the fields is good
case we create like this field day if
you'd be if you'd see and so on
you are able here to change the SQL time
also size to define primary key and so
on but for this table let me open here
to show you okay
as you can see we don't have fields i
have only resistors so the table and the
xml file here is not showing any I don't
have fields inside this this file so
that's why I don't need to inform here
in which each row i have the field
because i don't have filled i will
create just like this scriptcase will
automatically informed the fields and
create the the fields for me okay i can
also change here that the Demeter and
offline and so on
I have this in advance that to define if
i want to create a determined to bring
only the data or instructor and that and
data
ok let's go next click here to connect
with the connection that we already
indeed I could also create a new
connection here no problem but we can
use this one and convert ok done if we
go to the database
let me look here for the table its
webinar this one we can see that we have
already the CSV table
okay done let's go for the second one
excel file you can stop me anytime okay
if you have questions let's go here for
the excel file I've also this one and
then differently from the csv file
inside the XO file i do have fields let
me open here for you as you can see i
have here the field inside the line one
login password and mayo and so on so for
this case i want to inform the the the
fields instead of having the fields like
these Foo day if you'd be food see i'm
going to use this option to inform
where I have the field it is in the line
1 over 1 so i can list the table and
then I see that now scriptcase is
getting the names in the same way that I
have inside the excel file I can also
change here for example I can translate
this one as change here the SQL type set
the primary key and so on
ok choose the connection and convert the
converters that they are very simple
just step by step
the good thing from the webinar today
will be you to learn how to import and
also to bring of resistors 202 your
tables
ok last option will be access we can use
here this access access file same thing
you don't need to inform the rose
that's because access is already all
it's also a database you will have the
fields so I don't need to reform here if
you hurt you if you want to bring or not
the feel different to create or not the
fields the fields are already there
ok we can save you you can inform the
password if you have it my case my
access my access database doesn't have a
password so i don't need to feel that
option and convert ok so the converters
they are very simple you just need to be
to pay attention to the records
sometimes that the converter it doesn't
treat it doesn't read the the records so
before is that the the conversion you
need to see inside you have some for
example me I was trying to import here
let me open the excel file again
I did hear a chair i was just letting
the fields and then I forgot and I can
edit on a space so that's why i had
ahead and there and they always said my
name my conversion so it's really
important for you to pay attention
inside the file if the producers are ok
for them have any special thing or
anything to change and then you bring to
your tables any questions into now is it
ok so no secret here now we are going to
start the the best part i'm going to
show you how to make the how to import
how to convert files using here the
codes when the fires are txt for example
okay for the next example i have a txt
file here have the file and then I want
to make the same thing I want to import
this fire to my database and create a
table so far we have here treat tables
one from csv another one from xml file
and axis okay for this one you're going
to create to make applications the first
one will be just too big for me an
interface i could also use control but
then let's do it here just for me to
show you here how to integrate your for
example 80ml inside the events inside
the blank application as you know its
case inside this areas where you called
events or blank application you already
have the PHP tags you don't need to die
the PHP tags so if i want to start 80ml
i will have to close that that the tag
and then open again that's the opposite
ok this is unimportant the unimportant
tea for you
so here let me just go i'm i'm going to
create another blank and then i will
call this blank here
this application is very simple let me
just translate send file the buttons
here file and then the button sent ok so
this is just an interface for us you
send the file
okay here we have
ok guys i suffered here the problem with
the language i had my browser importance
and then I had to close the the whole
browser just said it
thanks for the for the help and let's go
to create the second blank
well this first blank is just fast you
have done interface and then bring the
file
ok the second one will be the main one
let me call it too because inside the
blank one we are choosing here this
application
the blank too ok so i go out of the
folder and then go into the folder blank
to let's let me create the new one blank
to its already
it
hello can you hear me can you hear me
now
ok guess my audio failed so let me go
back here to the code so here we did
open a local variable just to get the
the session variable with the file
okay this one is to open the file and
the 30 local variable is just fast you
change the name we will separate the the
filename and the extension for example
that the txt foot for this example we
have the file like this that one it is
dark . the d XD so here just for a
separate and then we will treat just as
a name and then we are using for each
function to go through the the whole
file and then verify what is happening
let me just open here and then you will
check for this case we are using here
the connection but if you're using the
same connection of the project you don't
need to inform the connection
ok this is optional so what we are doing
first in the first line which is
$OPERAND line 0 for this case this is
the file it's very important for this
example that you in that you read the
file inside of five and you see how the
fire is treating the information like
for this case we have the we have the
fields and we have spaces here and then
solid for the line 2 and 3 and so on we
have the reducers and we have also
spaces so we're going to treat those
information inside them the code so the
more so the most important function here
will be the replace we need to know how
two people to play with this function so
first we're going to create the file the
the table if it's not exist and then you
treat this space to organize the in the
fields like this like columns inside the
table and then for the from the second
line on will in fact the producers ok
when we finish that we will just check
if the if the average users using SC
look up and then show hear the message
we can say success using sdelat and let
me run just to show if to see if it's
working
go back to the blank to the first one
hey I was translating here this code but
I did the wrong thing but now it's
working let me run again because this
part of the code that Jefferson did for
me to show you the example we can choose
here we can choose here and then we see
that its success
let me check inside the database
here we have the dark one
ok so the code is now working well the
the most important thing here as i said
is the replace function for you to
identify what you have inside the file
and then treat here inside the cold
supposing that you already have the
table that lets say that now we just
want to bring producers to stable using
a file then you don't need to use this
first part you will treat just the
resistors the painting on the type of
file that you have it can be a the dark
it can be dxd as we did
ok I'd like to know if you have
questions
Jefferson is here with us to help with
your questions you can also make general
questions about scriptcase i'm going to
publish this coding and also the video
inside the form let me show you the
topic we have a topic for the webinars
when we finish here i will send the
discarding that we did and also the
video to this topic
ok so please let me know if you have
questions regarding this the example or
any other questions that you have
OKC's you have no questions I'd like to
thank you all for coming today and I see
you next week bye bye