Importing .servoy file to server not creating tables

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

Importing .servoy file to server not creating tables

Postby alasdairs » Thu Mar 14, 2024 6:34 pm

Hi all,

I've been working with servoy for the past couple months and have set up a server that has been working fine until now. Yesterday when I tried uploading a .servoy file to the server, I noticed that the new table doesn't exist on the server after import. It hasn't been created in the postgres database on the server and I'm wondering whether anybody knows what's going on?
When importing there are no errors.

To my knowledge I havent changed any settings, but may have clicked something accidentally when importing or exporting.

I have attached some screenshots from my export/import settings:
Screenshot 2024-03-14 at 16.28.38.png
Screenshot 2024-03-14 at 16.28.38.png (372.08 KiB) Viewed 2121 times

Screenshot 2024-03-14 at 16.29.06.png
Screenshot 2024-03-14 at 16.29.06.png (42.57 KiB) Viewed 2121 times


Thanks!
Alasdair
Software Engineer
alasdairs
 
Posts: 63
Joined: Wed Dec 27, 2023 10:06 pm
Location: The Internet

Re: Importing .servoy file to server not creating tables

Postby rafig » Thu Mar 14, 2024 6:49 pm

Hi Alasdair,
Welcome to Servoy!
Servoy will only export the information about a database table if there is a form that references it (directly or indirectly).
You could otherwise check the box(es) that say
Export all tables for referenced servers
or
Export based on DBI files only
Servoy Certified Developer
Image
rafig
 
Posts: 724
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: Importing .servoy file to server not creating tables

Postby alasdairs » Fri Mar 15, 2024 11:53 am

Hi Rafig,

Thank you, that fixed it.
I tried an export based on DBI files only which didn't work, and I was wondering, if I used 'Export all tables for referenced servers' would it also import the tables from the cloud sample solution or would it only take tables from my solution?
I'm importing all the modules (not including the cloud sample solution itself).

Thanks again!
Alasdair
Software Engineer
alasdairs
 
Posts: 63
Joined: Wed Dec 27, 2023 10:06 pm
Location: The Internet

Re: Importing .servoy file to server not creating tables

Postby rafig » Fri Mar 15, 2024 12:25 pm

Hi,
I think it best to make sure any tables from your solution have forms (even if unused) connected to them. that way only the correct tables will be exported/imported ;-)
Servoy Certified Developer
Image
rafig
 
Posts: 724
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: Importing .servoy file to server not creating tables

Postby alasdairs » Fri Mar 15, 2024 12:27 pm

Ok, thank you!
Software Engineer
alasdairs
 
Posts: 63
Joined: Wed Dec 27, 2023 10:06 pm
Location: The Internet


Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: Bing [Bot] and 25 guests