Page 1 of 1

NEWBIE: importing from XLSX files?

PostPosted: Sat Jun 08, 2019 1:44 am
by chaput.yves
I have installed the latest version of Servoy.
I remember reading somewhere that importing from Excel sheets with the xlsx extension was a breeze.

Well, I created a form and did import from my excel sheet but not before resaving into an xls version.
It was a small sheet with only a bit over 2000 records.

Now, I have two more sheets with over 150,000 records each.
How am I supposed to import those?

By the way, the only way I managed to figure out how to import, is thru a form, run in SmartClient and do the import from there.
If there is another way to import directly into a table, I have yet to read about it.

Thanks for any help.

Yves

Re: NEWBIE: importing from XLSX files?

PostPosted: Sat Jun 08, 2019 11:15 am
by swingman
Hi Yves,

Since you have 150,000 records each, I recommend importing the records directly into your SQL database.
You need some tool to import into your SQL database, there are many to choose from -- you may already be familiar with one.
If you are using the standard PostgreSQL that comes with Servoy you can take a look at pgAdmin which is free.
Personally, I use DataGrip from JetBrains. It has a few quirks, like it does not display PostgreSQL indexes in the IDE, but it is very powerful.

Hope this helps,

Re: NEWBIE: importing from XLSX files?

PostPosted: Sat Jun 08, 2019 6:21 pm
by chaput.yves
Hello again Wingman,

thanks for your answer.

This is exactly what I wanted to do, use PgAdmin to populate my tables.
So that is what I did, install PgAdmin on my Win10 PC, where Servoy Developer is installed.
But now my problem is, how do I connect to my database?
I have no idea where the database I created thru Servoy is located.
I looked everywhere on my C: drive for the name of the DB to no avail.
So I cannot give a URL in the "host name/address" field.

Why is something like that so complicated?

Re: NEWBIE: importing from XLSX files?

PostPosted: Wed Jun 12, 2019 6:12 pm
by sbutler
If you took the default settings on install, then Postgres and the Postgres DB's are installed within your Servoy installation location. You can connect with localhost and the default 5432 port. You can also verify that by editing the connection in the Databases list in Servoy and it shows you the JDBC url being used for the connection.

Re: NEWBIE: importing from XLSX files?

PostPosted: Wed Jun 12, 2019 10:09 pm
by chaput.yves
goldcougar wrote:If you took the default settings on install, then Postgres and the Postgres DB's are installed within your Servoy installation location. You can connect with localhost and the default 5432 port. You can also verify that by editing the connection in the Databases list in Servoy and it shows you the JDBC url being used for the connection.

Thanks for the answer but it doesn't seem to help me.

See what I get when I try to connect PgAdmin in the attached image.

What am I doing wrong or, more likely, what don't I understand?

Edited to add:
Yes, I did use all the default settings at install.
From what I remember reading, DBA is the default username used by Servoy to access the databases.

Re: NEWBIE: importing from XLSX files?

PostPosted: Wed Jun 12, 2019 10:57 pm
by sbutler
You shouldn't need to guess at this. In Servoy, under Resources->Database Servers you can see what Servoy is connecting to. Double click on one of them and look at the exact connection information, which includes the username. I think it is usually 'DBA'

Re: NEWBIE: importing from XLSX files?

PostPosted: Wed Jun 12, 2019 11:02 pm
by chaput.yves
goldcougar wrote:You shouldn't need to guess at this. In Servoy, under Resources->Database Servers you can see what Servoy is connecting to. Double click on one of them and look at the exact connection information, which includes the username. I think it is usually 'DBA'

Well, I guess I still need to learn quite a bit on all this works.
I managed to get it going, all was needed was for me to use the proper names, in ALLCAPS!

But hey! What a newbie is for if not asking stupid questions and doing stupids mistakes. :roll:
Thanks for taking the time to answer. :D