Re: [MacPerl] Need HELP!!!!!!

[Dick Applebaum <Dick@lacara.com>]

Alex, If I recall correctly, Both 4D & Claris allow you to export files in
CSV or other formats.

These can be read directly into Perl and manipulated as lists.

You can do a little more programming and convert them into hashes, which
then can be used in the Perl DBM modules to tie the hash to a database (a
hash saved to disk).

This works OK for small db's but is not recommended for large ones.

If you find an SQL db accessable to MacPerl, it is a fairly simple task to
write a general program to populate an SQL db from a CSV (or the like).  I
have done this with Cold Fusion MS SQL coming from CSV files such as Excel
spreadsheets, etc... no big deal.

It should be only slightly more involved to export a multi-table relational
db (such as 4D) to CSV, then populate  multiple tables in an
SQL-equivalent.  You will probably need to export/import/populate each
table separately, and be responsible for resolving the key fields which
interrelate the tables.

I haven't done much with the later versions of 4D, but years ago, when SQL
was gaining popularity, the ACIUS developers were programming 4D to conform
to SQL standards... so I'd be surprised if it did not qualify as an SQL db
that runs on the Mac.

Also there are at least 2 offerings (1 from ACIUS) that allow 4D to be used
as a [web] server db... and I think that Filemaker offers the same.

If the above is true, you may need only move your dbs to the equivalent
server version.

HTH

Dick

Please post what you find out!

At 4:05 PM -0700 12/3/98, Alex wrote:
>I have a problem:
>I need to get data from database and use it in MacPerl.
>I have 4D Dimension and Claris File Works.
>Do you have modules for they or any other database?
>
>Or, exists any SQL Servers on Mac?
>
>Alex.
>



***** Want to unsubscribe from this list?
***** Send mail with body "unsubscribe" to mac-perl-request@iis.ee.ethz.ch