baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from Gary Heyen on 2/24 2004, 15:34 +00:00
    EMail: garybev@autin.rr.com

    Create a new data base


      We currently are using another piece of software to house our address book database. We want to take the data from that data base and put it in a baseportal database. We can put the current into an excel spread sheet. How do we get the spread sheet data into the baseportal data base. If anyone has perl to do this or has done it in the past I would appreciate if you would share this with me.

      Thanks

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 All messages from this thread: To the list 
    Message from Tim on 2/24 2004, 20:09 +00:00
    EMail: fire.storm@sbcglobal.net

    Copy data from one database to another


      How can I copy data from one database to another without having to copy and paste each entry.?
     Post a reply

    Message from Jose Torres on 2/25 2004, 18:55 +00:00
    EMail: josetman@cox.net

    Re: Copy data from one database to another


      Why don't you export the records and import into the other?
     Post a reply

    Message from Christoph Bergmann on 2/26 2004, 03:21 +01:00
    EMail: info@baseportal.com

    Re: Copy data from one database to another


      Jose Torres answer works, but a more direct method is to write a little script like this:

      <loop code=perl db=database1>
      %_put=%_loop;
      $_put{_amount}=1;
      put undef, "database2";
      </loop>

      thats it ;-) just copy this code into a baseportal page and call the url of this page to run it...

      in this case both databases must have the same field names, if you have different field names you need sth. like this:

      <loop code=perl db=database1>
      put ["Field1_database2", $Field1_database1, "Field2_database2", $Field2_database1, ... ], "database2";
      </loop>

      ok?

     Post a reply
     
 Messages from 2700 to 2850: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



baseportal.com