incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephan Bardubitzki <step...@bardubitzki.com>
Subject Re: Filemaker to CouchDB
Date Wed, 20 Feb 2013 22:54:56 GMT
Thanks for your insides Miles, much appreciated.

Yes, a friend of mine told me about his struggle with repeating fields 
when he had the task to convert Filemaker to SQLServer.

I thinks looking into FM web service is the route I'm going to try first.


On 13-02-20 02:04 PM, Miles Fidelman wrote:
> Probably a little more complicated than that.
>
> Filemaker is interesting in that, unlike SQL, it allows for repeating 
> fields - so you have to worry about more than exporting tables, you 
> have to worry about records that have some structure.
>
> While it provides for export to a lot of formats, including CSV and 
> Excel, if your database includes repeating fields, you need to figure 
> out how to export into something that lets you maintain the structure 
> of complicated records. You could, for example:
> - export to a format that does support repeating fields (Filemaker 
> seems to support export of repeating fields to XML), then do something 
> to convert to json for use w/Couch
> - Filemaker will expose data via a web service - so you could write 
> something that sucks data out of Filemaker then puts it into Couch
>
> There does seem to be a lot of information available if you Google 
> Filemaker, export, "repeating fields," JSON, XML, and so forth.
>
> Filemaker also is sort of a programming environment - people write 
> fairly fancy applications that can go well beyond what people do with 
> Excel macros.  If you also want to export those, you're on your own.  
> (Not that long ago I was faced with an application written in an 
> obsolete version of Filemaker, old enough that it will no longer run 
> on newer versions of Mac OS.  Converting to something else was a right 
> royal pain.)
>
> Miles Fidelman
>
> Mark Hahn wrote:
>> CSV?
>>
>>
>> On Wed, Feb 20, 2013 at 1:34 PM, Stephan Bardubitzki <
>> stephan@bardubitzki.com> wrote:
>>
>>> I don't even exactly know what Filemaker (seems to be not SQL based) is
>>> about, however, it is heavily used in some government departments.
>>>
>>> So, I just through out this question in case someone has done that 
>>> before:
>>>
>>> Is there any feasible procedure to convert/transfer data from 
>>> Filemaker to
>>> CouchDB?
>>>
>>> Thanks in advance.
>>>
>>> Stephan
>>>
>>>
>>>
>>>
>
>


Mime
View raw message