Jump to content
BugsyOhar

Merging Multiple Databases into One

Recommended Posts

Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year

the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better

searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!

Share this post


Link to post
Share on other sites

What version are they in now?

Is each year a separate file?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Pavlk
      I've attached two files. The first one is INVOICE, that is generated by every establishment when you purchase, and is in xml format.
      The second one is XSLT file, that is provided by government fiscal institution and is used to "translate" xml.
      PROBLEM DESCRIPTION: when I try to decode xml using attached xslt scheme on any online xml-converter website the output looks fine. BUT when importing to Filemaker, I receive an error: "XML parsing error: invalid document structure".
       
      I would appreciate any help with the issue. Thanks.
      XML input.xml
      XSLT scheme.xslt
    • By MSPJ
      Hi - I'm developing a business solution to be hosted on FM Server.  It will be hosted on Soliant Cloud.  This is my first time developing for Server.  I read Steven and Wim's whitepaper on FM 16 security, which was very helpful.
      In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file. 
      I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impact that will have on import from previous versions.  I assume both files will have the same ID - but not sure if that means that FM will see the older version as trusted or not. 
      Thanks!
    • By Rob Ross
      I am not sure if I posted this in the correct place, so please forgive me if not.
      I have: FM16 Pro Advanced (Have both Mac and Windows, but I use a Mac to develop), FM16 Server.
      I am trying to have a drop down value list populate with information from two different tables.  Let me explain:
      I have a table called Products.  this table contains information required for an individual product that we sell.  Some of the fields inside the products table are: ID.pk, name, cost, price, etc..
      I have a second table called Bundles.  This table contains multiple items from the products table that become a single sellable bundled item.  Some of the fields inside the bundle table are: ID.pk, name, BundleCost, BundlePrice, etc.  As an example a product would be any one of these items (only one): Hamburger Patty, Lettuce, Pickle, Cheese.  A Bundle would be called a Cheese Burger and it would be made up of several products like Hamburger patty, cheese, lettuce, pickle, etc.
       
      I have sales people and they need to enter the items that they sell.  I have a value list (drop down) that populates from the product name field.  this is working perfectly, however I have two additional needs that I am struggling with.
       
      1. Each product within the product table has a number field called (sold individually).  i use it as a true / false field.  1 = true 0 = false.  some of the products we carry can not be sold individually but are still products.  Similarly you would not sell a piece of lettuce individually, but you would still need that product on a cheese burger.  I need to populate the value list with products that have the "individual sale" field set to 1.
      2. I want to include all bundle names within the bundles table in the value list as well.
      A salesperson will click on the drop down and get presented with a list of all Products that contain a 1 in the "individual sale" field and all bundle names.  Alternately I want to add some additional text in the value list to show a separator to delineate between products and bundles. This is optional at this point.
       
      Any direction you can point me in would really help out.  My initial thought process is to create a table that I can populate with all of the products that have the "individual sale" flag and all of the bundle names by looping through the table assigning everything to variables to be displayed.  I think this is a lot of work and could be prone to errors.
       
      thanks for your direction in advance.

      Rob
    • By DChord568
      I am not a FileMaker power user by any stretch of the imagination, nor does my question relate to any particularly sophisticated use of the program, so I hope others here will forgive and bear with me.
      I formed a band my junior year of college with guys who have remained my best friends throughout all of the subsequent 46 years. Though we’re scattered in different parts of the country now, we reunite at least twice a year to make music again, and for the past 23 years we have recorded songs together at these reunions.
      I created a FileMaker database to chronicle these recording sessions, and all of the songs done at each of them. The record for each song contains the fields you might expect: Title, Songwriter; Original Artist (for songs we didn’t write ourselves); Year; Session; Lyrics; and a repeating field for personnel — i.e., who sang and played what on each song. Each band member also has a Comment field so he can share his feelings about the song or memories of the recording session for it.
      We store the master copy of the database in Dropbox, and all can access it at any time — though I’ve put a system in place to ensure that no more than one person at a time can modify or add data to the file, to avoid the dreaded “conflicted copy” syndrome.
      Each record in the database also has a Container field for the recording it pertains to. To avoid the unthinkable bloat that would result in storing 23 years worth of .wav files in the database, I naturally used FileMaker’s “Store only a reference to this file” feature for this field.
      The music files themselves reside on a 128GB thumb drive. The plan was to strike exact copies of this Master thumb drive for each band member that they would physically insert into their own computers, so the the song associated with a given record would play when they access the database and double-click the Container field.
      Perspicacious readers may now guess where I’m headed. I am the only one of the five of us who is on a Mac system. My Master thumb drive, as well as a copy I struck from it, works perfectly for its intended purpose. I have taken the copied drive from home (where it was created) and used it with no problems whatsoever on my work Mac. No matter which Mac I use, as long as I access the database from Dropbox and have the thumb drive inserted in that Mac, all is well — since the Mac automatically “sees” and can instantly access any external device plugged into it.
      My bandmates, however, are all on Windows systems — and as my closest friend feared, when I sent that copy of the thumb drive to him. it did not work in the same way, due to Windows’ convention of assigning a letter to any external device plugged into a Windows-based machine. It appears a Windows system needs a strictly defined file path to locate the music files on the thumb drive. And a different letter is likely to be assigned to this drive in each person’s machine, based on how many other peripherals he has plugged into it at any given time.
      My obvious question: is there any way around this issue? Is there some way to tell a Windows system “Look for the music files referenced in this database on the ‘F:’ drive” (or whatever drive is appropriate)? Or is each individual member doomed to manually relinking each one of the 280 or so music files that I so carefully linked on the master thumb drive?
      Only my closest friend I referenced has a degree of computer savvy, so I was hoping to make this entire process as easy as possible for all concerned. Thank you very much in advance for any help that can be given.
       
      P.S. The database was created in FileMaker Pro 11.
    • By kolvorok
      I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
  • Who Viewed the Topic

    6 members have viewed this topic:
    melmitts707  doughemi  Steve Martino  jbante  wattmhite  Lee Smith 
×

Important Information

By using this site, you agree to our Terms of Use.