automatic export

Discussion in 'Optigold ISP' started by jmsuarez, Oct 17, 2005.

0
  1. #1
    hi,

    Can i export data automatically?
    I need to export data and put into another database. Really, I need to access data from a perl program and obtain a text file, in order to analize any things. It is possible?

    Jessica
     
    jmsuarez, Oct 17, 2005 IP
  2. davert

    davert Banned

    Messages:
    345
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yes, it's very easy to a programmer. Most databases are designed to import and export via a number of formats, particularly CSV (comma-delimited) and tab-delimited text.
     
    davert, Oct 17, 2005 IP
  3. jmsuarez

    jmsuarez Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Where do i find examples?

    I have a program in perl under unix and it executes with crontab, but i need to connect FMP in order to obtain optigold data and put into mysql.

    Jessica
     
    jmsuarez, Oct 17, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    The easiest way would be to access the data via HTTP and get XML results or something. Then your cron job can just pull the data when it feels like it.
     
    digitalpoint, Oct 17, 2005 IP
  5. jmsuarez

    jmsuarez Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    but

    I don't want to access the data via HTTP. I really need to access via perl script and put into another database like mysql.
     
    jmsuarez, Oct 17, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    There is no PERL module (that I know of) that would allow you to access FileMaker data directly.
     
    digitalpoint, Oct 17, 2005 IP