0

Met_Team Data Push or Pull From External Program

Has anyone experimented with doing a data push or pull to another program, such as Quickbooks or Peachjunk (a.k.a. Sage 50) to create invoices externally, or import or export data related to per incident calibrations?  Specifically, we are searching for a single-entry solution instead of re-entering data in several applications, and whether the information such as customer name, product manufacturer, model, serial, asset, etc. information, including per incident calibration price can be entered or bar-code scanned into Met/Team or another external program such as an accounting program, then selected fields exported or imported to/from Met/Team.  If this is not available, will Fluke/Danaher Boys make the code available to our programmer so he can create a software bridge to do this using ASCII or C#?

4 comments

Date Votes
0
Avatar
Debbie Olson

Hi,

Although there are no specific files created for importing from other applicatoins, there is an Import option under the File menu. The user sets up a definition file and setup and then runs the Import. The Import function is documented in the on-line Help.

0
Avatar
Kevin Griffis

I have done extensive push-pull data transfer in MetTrack.  I did this using database Events, which were created in Sybase Central.

With MetTeam, using Microsoft SQL Server Management Studio, look at the Database Triggers.  I believe you can accomplish your goal using triggered events.  Keep in mind that MS SQL Server can manage more than one database at a time.  I have found it handy in some cases to create additional tables for some of the events that I have used.  If you find this to be useful, it would probably be cleaner to create tables in a different database.

These events will be written in SQL.  If you don't have an SQL guy, it's really not that difficult.  There are excellent resources on line where you can learn pretty much anything you need to know.

 

0
Avatar
Kevin Haddock

Perhaps there is a way to push the data to another application program?  Can specific fields be selected for the "push?"

0
Avatar
Kevin Haddock

Good thought, kgriff.  I do have an SQL guy who is a coder working here, so I can try that approach with him.  I have too many other things on my plate at the moment to learn SQL, but it has intrigued me for years, and I hope someday to actually have the time to teach myself.

Please sign in to leave a comment.