4 Replies Latest reply on Mar 3, 2009 9:25 AM by JimmyRayBob

    Rookie Needs help with a new database

    JimmyRayBob

      Title

      Rookie Needs help with a new database

      Your post

      Hi –

      I need help building a database for FileMaker Pro and FileMaker Server

      Summary: I need help getting data off remote computers, onto a server and then into a new database.

      Here is what I have.
      Lotus Approach on remote computers. Can export the data in just about any format.
      FileMaker Pro Advanced 9.0
      FileMaker Server 9.0 on a dedicated server, with a static IP address.
      Windows Server 2003

      We currently have one database running on this server, but would like to add a second, completely different database. This is the one I need help with.

      I need to collect information from 15 or so remote sites around the country, on a daily basis. I would like a database to gather the info so I can create the reports I need. I don’t need help creating the reports.

      The information that will be collected remotely are daily sales figures – and are entered into a simple Lotus Approach database. Lotus Approach can export the data in just about any format. The remote sites do NOT have FileMaker, and for cost considerations, will not have FileMaker. The information collected daily will be approximately 250 items per site, primarily numeric but some text fields. All remote locations will be using the same underlying table. Field one is location, field two is the date, and the rest are the daily sales figures and other information.

      Unfortunately the remote locations do not have constant connections to the internet – most are on dial-up. I would like to have my managers connect to the internet once per day and transmit data to the server. I don’t know anything about FTP servers, but I wonder if that might be an option. Or e-mail?

      1. Have managers actively export data to the server somehow.
      2. Server saves the information on the server
      3. FileMaker “finds” the data on the server and imports it into the new database automatically

      I would then like a FileMaker database that can go out and “import” the data automatically. I can worry about creating reports later … I just need help getting the information off the remote computers, onto the server and then into the new database.

      I don’t know if each remote site should have its own data table or if everything can go in one table (I’m a real rookie at databases).

      Our server right now is only 1.5 years old, and is hardly used at all. We have plenty of hard drive space and the server is not worked hard at all.



















        • 3. Re: Rookie Needs help with a new database
          Kundinger
            

           
          There are numerous solutions to what you are trying to accomplish...
           
          A.  Get 'persistent' Internet connections for each office and FMP for each remote user accessing the FMS hosted FileMaker file. 
           
          B.  Get 'persistent' Internet connections for each office and let each remote user access the IWP with FMSA hosted FileMaker file.
           
          C.  Use your FMPA to create a runtime solution that will 'export' the data to your WIN server sharepoint.  Use your FMPA to
               'import' the data into your 'master db'.
           
          D.  Use your FMPA to create a runtime solution that will 'export' the data and e-mail you the file.  Use your FMPA to 'import' the
               data into your 'master db'.
           
          E.  Use Approach to 'export' the data to your WIN server sharepoint.  Use your FMPA to 'import' the data into your 'master db'.
           
          F.  Use Approach to 'export' the data and your user's e-mail you the file.  Use your FMPA to 'import' the data into your
               'master db'.
           
           
          Given your current situation, I would probably recommend "Solution C"...  Create a FileMaker runtime solution where each remote user would enter the data.  They would 'then click' the "BUTTON" to export the data onto the WIN server.  The main office DB admin would then 'click' the "BUTTON" to import the data into the Main FileMaker DB.
           
          The advantage to this solution relative to your situation... each remote user has an application that they would use to enter data at anytime of the day.  The remote user only has to 'click' the "BUTTON" to perform all the other processes... they are 'automated'!
           
          For security reasons, I would 'encrypt' the data before exporting.  Additionally, for data integrity reasons, I would create a data redundancy system in case new data should overwrite old data or get corrupted in the processes.
           
           
          I have created such solutions for some of my clients and with a little fine tuning these systems function very well.  If you would consider the option, I would be very interested in creating such a solution for your organization.  You or your superiors may contact me through this forum.
           
           
          I hope this helps you and any other interested readers... Good Luck!!!

          Kundinger 

          • 4. Re: Rookie Needs help with a new database
            JimmyRayBob
              

            Kundinger -

             

            Thanks for the reply ... i appreciate it.  I'm afraid i haven't had time to digest it yet, but i'm sure i'll have some questions soon. 

             

            Thanks again.