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 igservices
      I'm running FMPA 16.02.205 and ScriptMaster 5.05 in MacOS 10.12.6.
      ScriptMaster doesn't retain the activation state from one start of the app to another. It's not totally consistent either.
      Any ideas why the activation of the plug-in isn't being retained between app restarts?
    • By Jeff M
      Hello,
      I've done quite a bit with FileMaker in the past, but have never jumped into the XML arena. Now I have a need to do so, and I'm really needing some help with something I'm sure is quite basic...but still foreign to me. I have an external data source which export XML in a very specific format (see attached). I need to import that into FileMaker so I can manipulate the data, do some various lookups, etc. Once I've made my changes in the data, I need to export in the exact format it was when imported so the external data source can properly import.
      Not sure if it makes sense to import into 2 tables (workflows, workflow steps) or just a single table. I'm open either way. Once the data is in FileMaker I can get all my calculations and lookups and scripts going and make the data what I need it to be, but then I'll need to export it.
      Can someone point me in the right direction?
      Thanks so much in advance!
      Jeff
      workflows_export.xml
    • By Bartek
      Hi there,
      I am making cutom import and export from/to excel documents.
      Is there any way to merge excel cells in scribe?
      I can easly find out which fields are merged when importing.
      two nested loops and if second col or row is empty while reading i consider it merged.
      Problem is while exporting.
      I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical).
      Thanks in advance for any help.
      Have a nice day.
    • By 3rdparty
      I have been using the the scriptmaster plugin for sometime on a previous Mac, specifically for the Rotate Image function.  The instalation on the previous Mac would have been FMP12 advanced, Scriptmaster plugin from about Sept 2015, and Mac OS 10.11.xx    My solution used the function pasted into the startup script and although it wasn't fast, worked fine.
      I have now made a new installation of the Scriptmater Plugin, v5.05 on a new Mac running OS 10.12.5, FMP advanced 13, and there are a couple of strange things that appear to be assocaited with Java:
      1. When I launch FMP it does not come to the foreground.  Instead the foreground application is Java...
      2. When FMP is active, I see a Java application active in the dock.   This wasnt the case in my prevous installation of Scriptmaster where (if it was active), Java was not a foreground/visible process
      3. When I quit FMP, irrespective of whether the database that I was working on did or did not use a scriptmaster module or function, Java crashes and I get usual dialogue box "Java quit unexpectedly".  I have put a copy of the crash report here.
      Any ideas as to what is going wrong?
       
      Thanks in advance
       
       
    • By MikeKD
      Hi Folks,
      I've broken a pdf saving script which used to work. The filename itself hasn't changed so I don't think that's the problem (there are no /s for instance) - I'm pretty sure it's the file path and Mac OS re-organising itself to sync with iCloud.
      I'm trying to save PDFs to Dropbox and I think that the Dropbox folder on my my has changed location. According to info, the location is /Users/mikekentdavies/Dropbox/KJA Music Library.
      The calculation I'm using to set the location variable is below; can anyone see where I'm going wrong? (I've also tried various combinations of filemac: / file: / .. / : etc having read the FM creating file paths webpage.)
      "filemac:../Users/mikekentdavies/Dropbox/KJA Music Library/Set Lists/"  &  Gig::Gig Name & " - "  &  Gig::Version  &  " Set List.pdf"  
×

Important Information

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