solution export

Classic Servoy
1

Because my solution uses multiple databases, I like to see an option which sample-data from which database is exported

I use for example a zipcode-datebase with 600.000 records.
This one I, don’t want to export!

2

-sample data exports only data from tables used in your solution
-exports only 10K records
-imports nothing if table not empty on import

3

Jan I know how it works now,
but if I build a release of my solution, I do want to export my sample data in database: Directbeheer, but I don’t want to export the data of my database: ZIPCODENL (very time-consuming)

Because ZIPCODENL is a readonly-used database and is placed by hand in the folder: servoy\databases by the customer.
So it would be handy, if I could specify that.

4

Sample data xport will be enhanced after Servoy 2.0 release

5

Is this one still for 2.2?

I really like to see enhancement here in sample-data.
I also like to set on option for (which I call) system tables.
What I mean is that I want specific tables(that I use in the solution) to be synchronized (overwritten) with the tables by my customer.
Exactly the same way, how i18n exporting is working.

6

Hello Harjo,

I totally agree, especially for those “system tables”. A year ago I made this proposal:

What I think we would need is this:

  1. when exporting a solution you get a dialog similar to the method editor’s form tree.
  2. the tree shows you what is “inside” that form (elements, methods and data).
  3. you can then check which forms or parts of that form (elements, methods and data) you want to be exported
  4. for the data part, a query editor would be very helpful, too. I enter a query for the data exported. Then you can even go on record level…

This would solve lots of potential problems:

  1. you can export the data you want (for example some of my data is solution relevant; I would like to be able to update that on a customer’s solution without touching the other data)
  2. you export only those forms and/or methods, that you really want to be updated, everything else is untouched (for example a customer’s own form)

It doesn’t have to be that detailed and some things are very well possible using modules today, but wouldn’t this be nice?

7

yes indeed!

Servoy, help us! :lol: