NEWBIE: importing from XLSX files?

Questions and answers for designing and implementing forms in Servoy

NEWBIE: importing from XLSX files?

Postby chaput.yves » Sat Jun 08, 2019 1:44 am

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
Happiness is a choice
chaput.yves
 
Posts: 11
Joined: Sat Jun 08, 2019 12:47 am
Location: Montreal, Quebec, Canada

Re: NEWBIE: importing from XLSX files?

Postby swingman » Sat Jun 08, 2019 11:15 am

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,
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1479
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: NEWBIE: importing from XLSX files?

Postby chaput.yves » Sat Jun 08, 2019 6:21 pm

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?
Happiness is a choice
chaput.yves
 
Posts: 11
Joined: Sat Jun 08, 2019 12:47 am
Location: Montreal, Quebec, Canada

Re: NEWBIE: importing from XLSX files?

Postby sbutler » Wed Jun 12, 2019 6:12 pm

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.
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 768
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Re: NEWBIE: importing from XLSX files?

Postby chaput.yves » Wed Jun 12, 2019 10:09 pm

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.
Attachments
pgadmin.PNG
pgadmin.PNG (52.79 KiB) Viewed 7982 times
Happiness is a choice
chaput.yves
 
Posts: 11
Joined: Sat Jun 08, 2019 12:47 am
Location: Montreal, Quebec, Canada

Re: NEWBIE: importing from XLSX files?

Postby sbutler » Wed Jun 12, 2019 10:57 pm

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'
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 768
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH

Re: NEWBIE: importing from XLSX files?

Postby chaput.yves » Wed Jun 12, 2019 11:02 pm

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
Happiness is a choice
chaput.yves
 
Posts: 11
Joined: Sat Jun 08, 2019 12:47 am
Location: Montreal, Quebec, Canada


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests