import feature

Classic Servoy
1

I really would like an enhancement of the import function

1.) I want to make a choice between:
import records
update records (with a matching field)
(The way it is done in Filemaker)

2.) If I now choose (in the import dialog) a table and match the names and than change to another table and set some fields there, than the fields of the previous table ar gone. So I can only import in one table at the same time.
I really would like to do this in multiple tables at ones!

3.) Is there any news, when this whole circus can be done by methods?
(setting fields, import order, etc..)

2

1> this would be very heavy, shouldn’t be done with thousands of records!!

2> so you have a dump in one file with 10 column for table X and 15 column for table Y. ? Why not just first do the table X. Start import, go back and do table Y? That is calculated in time almost the same thing.

3> after 2.0

3

  1. I had different source files, which had to be imported seperatly. So than you bump into this issue. (Maybe with a limit in records?)

  2. Yes, I did it now that way, but it would be nice, if you could do it in one step.

  3. ok!

4

I’d like to see #1 be added. Its convenient for simple/small updates
and something I miss from filemaker.

5

#1 is something that I also miss dearly from filemaker. I am going to have to research 3rd party tools for this until it is added into Sevoy. I’m told Navicat offers this but would appreciate any other suggestions. I’m using mySQL as the db.

6

You can write the functionality in #1 - but you have to do the methods yourself.

Basic flow:

  1. Locate import file
  2. Open file and read contents into variable
  3. Loop through variable - parse each line
  4. Check for a related value, if a match update it
7

Here is another approach to “update” style imports:

  1. Create an empty “import” table for your update
  2. populate using Servoy’s import (adds records)
  3. Use a method to loop over “import” table, copying match records into the table to be updated.
  4. Clear “import” table & keep for next time…
8

I would suggest the following, similar to above, that I had to use.

As Servoy is very slow at importing and it can’t really cope with thousands of records easily, I use Interactive SQL (if you are using the default Sybase install)
Import updated records into a temp file with the same PK and then use the ‘UPDATE’ SQL command to set each field in your real file to the temp field using the PKs as a match. The update statement might be a bit long if you have a lot of fields, but it should all happen a lot faster than a Servoy loop will.

Rafi.