Fastest Way to Create Tables?

Classic Servoy
1

Hi Again:

Another newbie question.

I’m trying to prototype/convert my FM7 solution to Servoy. Is there an easy way to Import my data AND create the Tables in one shot from Filemaker/Excel/Tab file? I see the Export function, but it only seems to allow me to import to an existing table. I do not want to setup all my tables by hand if I can avoid it. My FM7 table names are SQL Complient.

Thanks,
Lee Snover

2

You can export your fm (or other db) tables to excel, csv, tab del and import them into Sybase Central (if you use the standard setup of Servoy). Sybase Central allows you not only to import data but also create a new table from the import. Don’t forget to export including headers or create them yourselves if you want to change the names…

3

IT2BE:
You can export your fm (or other db) tables to excel, csv, tab del and import them into Sybase Central (if you use the standard setup of Servoy). Sybase Central allows you not only to import data but also create a new table from the import. Don’t forget to export including headers or create them yourselves if you want to change the names…

Marcel:

Thanks, but we are using Oracle at the moment. I can probably write some scripts to handle this, but if there’s some speedy tools, that would be preferable.

Regards,
Lee Snover

4

I am not familiar with Oracle, but I can create a table by doing a import (as Marcel said), though enterprize manager in sql server 2000. You can also save the import by creating a DTS package.
Erich

5

I also found it allot easier to export as XML from Filemaker, it makes the import into Servoy (or backend) allot more seemless, I was having allot of date formating issues

6

ebrandt:
I also found it allot easier to export as XML from Filemaker, it makes the import into Servoy (or backend) allot more seemless, I was having allot of date formating issues

Is there a mechanism to import XML tables into Oracle via Servoy?

Thanks,
Lee

7

I don’t know about that one, I am sure you can export the data if you have the data (xml, csv, etc…), and you are planning on using oracle as you backend, you will need to create the tables in oracle, and import.

I can not imagine oracle being too different from sql server 2000. You should be able to create table during the import in oracle, providing you have the correct permissions. You may have to further define your data types after the import.

8

You can import data directly from servoy, which will populate your backend table, but I would not reccomend this approach with large data sets it is way too slow. If thats what you where asking

9

ebrandt:
You can import data directly from servoy, which will populate your backend table, but I would not reccomend this approach with large data sets it is way too slow. If thats what you where asking

No, I have ways of loading data into the tables once they exists.

I’m just trying to replicate my FM structure into my Oracle/Servoy solution in as fast a way possible.

Thanks,
Lee

10

If you have Oracle, I would imagine that you have a few people there managing it, ask them. From what I have heard, its a high maintainence data source. I am sure it is possible to create the tables during the import.

11

ebrandt:
If you have Oracle, I would imagine that you have a few people there managing it, ask them. From what I have heard, its a high maintainence data source. I am sure it is possible to create the tables during the import.

Yeah, a entire host of people (can you say "me, myself and I). ;-)

I run all the Oracle DBs here. I relatively verse in the core technologies, and I even know SQL Loader, etc. Yes, I have other tools, but I was just trying to get an idea of what I can do purely within the Servoy tool set. I can write scripts that create the tables from Filemaker, etc. but that wasn’t what I was trying to do.

I have to deal with users who are used to working with Filemaker. They can create a table from a spreadsheet in about 10 seconds flat. I would like to have that OPTION with some users in the Oracle/Servoy environment as well. Going to another tool is outside of their realm.

Thanks for the suggestions.

Regards,
Lee Snover

12

There is a great FMP to many flavors of SQL utility called FMProMigrator. Check it out at http://www.fmpromigrator.com. We’ve used it for several projects (the last one with over 40 related FMP files/tables) and it has worked great. Even normalizes repeating fields for you on the fly!

It does require some work–such as running one script that gets you the maximum data length in every field in a given table so you can decide what you want as the maximum length in the corresponding SQL table to be on a field by field basis.

I’ve written a utiltity that takes the output from the field lengths report script and creates an FMProMigrator CreateTables script with each of the maximum field values rounded up to the next integer divisible by 5 (e.g. max data in field is 57 chars; my util rounds max length up to 60). If anyone starts using FMPProgMigrator and needs the utilty, give me a call.

One more thing: We had to modify FMProMigrator’s handling of textual data that contains line breaks to correctly remap those breaks for MS SQL Server. I have that code snippet available, too if anyone needs it.

13

JerryR:
There is a great FMP to many flavors of SQL utility called FMProMigrator. Check it out at http://www.fmpromigrator.com. We’ve used it for several projects (the last one with over 40 related FMP files/tables) and it has worked great. Even normalizes repeating fields for you on the fly!

It does require some work–such as running one script that gets you the maximum data length in every field in a given table so you can decide what you want as the maximum length in the corresponding SQL table to be on a field by field basis.

I’ve written a utiltity that takes the output from the field lengths report script and creates an FMProMigrator CreateTables script with each of the maximum field values rounded up to the next integer divisible by 5 (e.g. max data in field is 57 chars; my util rounds max length up to 60). If anyone starts using FMPProgMigrator and needs the utilty, give me a call.

One more thing: We had to modify FMProMigrator’s handling of textual data that contains line breaks to correctly remap those breaks for MS SQL Server. I have that code snippet available, too if anyone needs it.

Sounds good, I’ll check it out.

Now if I can just figure out how to get the HTTP server stuff working on my machine with the Oracle DB.

Thanks,
Lee Snover

Thanks,
Lee Snover