Getting started with databases

[Bob Sneidar]

To my knowledge, it exports just the tables and indexes. It may also export relationships, I don't know. I just know that after I purchased it, I was a bit disappointed because I thought I could take a fully functional Filemaker Database, complete with forms and everything, and it would create a fully functional revolution stack for me. Perhaps my expectations were a bit hi. 

Things may have improved since then. At the time the developer told me that there was no easy way to get information about forms from Filemaker in any kind of meaningful way, but perhaps he has that figured out now. 

Also be aware, (and I don't want to sound too negative) but apparently there were some issues with my data, and I never even got the tables ported. I think it had something to do with blank data or carriage returns or something. 

As far as CSV, if there are any delimiters in your data in Filemaker, such as commas, quotes, tabs or returns, a CSV export will be very problematic. You should first try to convert anything that might be be construed as a delimiter in your filemaker data to some other character, or unlikely combination of characters, so that whatever you use to import with can convert them back before shipping them off to an SQL database. This is just the nature of export/import with dissimilar data structures. 

Bob

 
On Sep 16, 2010, at 12:37 PM, Peter Alcibiades wrote:

> 
> Bob, are you saying, just the tables...?   So why not export the tables as
> csv....?   Am I missing something to do with relations?
> 
> Peter
> -- 
> View this message in context: http://runtime-revolution.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2542837.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution