Re: Getting started with databases
Sorry, sloppy, I meant tab delimited. I do tend to wrongly say csv and automatically assume that tab delimited will be understood. Peter -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Getting-started-with-databases-tp2540312p2543958.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
Filemaker tabbed delimited export converts returns to vertical tab characters. You can still retain your returns. On 16 September 2010 13:25, Bob Sneidar b...@twft.com wrote: 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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Stephen Barncard San Francisco Ca. USA more about sqb http://www.google.com/profiles/sbarncar ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
Aye, but we were talking about CSV, Comma Separated Values I think is what it stands for. Bob On Sep 16, 2010, at 1:36 PM, stephen barncard wrote: Filemaker tabbed delimited export converts returns to vertical tab characters. You can still retain your returns. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Getting started with databases
Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? TIA Tim ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
Hi Tim, Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? first of all: Leanr and get used to SQL! Here is a good start, if you not already know SQL: http://www.w3schools.com/sql/default.asp At least this one got me started with SQL :-) TIA Tim Best Klaus -- Klaus Major http://www.major-k.de kl...@major.on-rev.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? Hi Tim Good schema design is very important and I find MySQL Workbench a great cross platform tool for data modelling. Cheers -- Monte Goulding M E R Goulding Software Development Bespoke application development for vertical markets InstallGadget - How to create an installer in 10 seconds revObjective - Making behavior scripts behave ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
On Sep 15, 2010, at 4:56 AM, Tim Lambert wrote: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? Tim, I created a series of lessons on databases in Rev for my students. You may find it helpful. Just go to http://revolution.byu.edu and click on the link Introduction to Programming in Revolution. Then look for a section, near the bottom called Database Access in Revolution. Regards, Devin Devin Asay Humanities Technology and Research Support Center Brigham Young University ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
Tim, also take a look at David Simpson FMPro Migrator tool which is able to convert from FMPro to Revolution. It might help you port your old FMPro solutions to new Revolution solutions. http://www.fmpromigrator.com/ :D On Wed, Sep 15, 2010 at 7:56 AM, Tim Lambert tim.lamb...@addat.com wrote: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? TIA Tim ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- http://www.andregarzia.com All We Do Is Code. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
I would seriously consider sqlYoga from Mango Learning. It takes a while to master it, but then it beats SQL syntax, which btw is NOT AT ALL standardized. sqlYoga hides most (if not all) of the syntactical differences between the supported engines, and they have methods for relational joins which really take the headaches out of working with SQL. Bob On Sep 15, 2010, at 3:56 AM, Tim Lambert wrote: Hello I am a long time user of Rev but have always developed databases with FMPro advanced. Time to try to make the move to Rev. With big amounts of data and lots of tables joining etc, it all looks pretty arcane to me. Can anyone recommend any aids memoire or templates or anything to help a database slow-coach along? TIA Tim ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Getting started with databases
Not to dis anyone's product, but it should be plainly stated, unless things have improved, that by Filemaker Databases, the developer means ONLY the Filemaker Databases. If you have scripts, I do not think it imports those, and last time I tried it, forms were also not imported. I'll say no more. Bob On Sep 15, 2010, at 9:00 AM, Andre Garzia wrote: Tim, also take a look at David Simpson FMPro Migrator tool which is able to convert from FMPro to Revolution. It might help you port your old FMPro solutions to new Revolution solutions. http://www.fmpromigrator.com/ :D ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution