[Date Prev][Date Next][Thread Prev][Thread Next] [Search] [Date Index] [Thread Index]

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





Dick Applebaum wrote:

> 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.
> >


Thanks, but CSV is temporary format. As I think:
One Operator makes changes in the database and my web-page automatically
refreshes
(MacPerl from SQL gets new data). It is only one possible variant. It is
because of I make my diplom project.

Thanks & bye.
Alex.

P.S. If I'll do this work I'll send sources in chat (newsgroup) or I'll write
where you will get it.


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