Integration»File Maker Integration

File Maker Integration





The FedEx FileMaker Toolkit is an ideal solution for FileMaker consultants and in-house developers who want to add FedEx shipping capabilities to their FileMaker solutions.

Manage all of your FedEx domestic and international shipping right from your existing contact, order or invoice layouts. Or use a script to set all the shipping fields in the toolkit and manage your shipping from our simple user interface. Whichever method you choose, you can provide visibilty to tracking information in your layouts.

NRGship Files

NRGship FedEx consists of three database files:

NRG_Package_FedEx_Data.fp7
Interface, Shipment, Rates & Tracking tables

NRG_Package_FedEx_Blackbox.fp7
Preferences interface file and external comm to FedEx

NRG_Package_FedEx_Prefs.fp7
End-user preference Data

All data is stored in the database file NRG_Package_FedEx_Data.fp7 which open for developing relationships to the tables, but not for data modifications. The file is open to edit layouts, add new scripts and call existing scripts. Both of these files cannot be modified due to the nature of this being a FedEx Certified product.

The data file contains the following tables:

  1. Ship
  2. RatesAndServices
  3. GroundClose
  4. Track
  5. Log
  6. InternationalCommodities
  7. ShipmentContent_ShipmentContentRecord
  8. PickupRequest
  9. AddressBook

Note that future updates of NRGship may modify structure, layouts and scripts in any or all database files in order to accommodate new features.

Minimum Required Fields

Accountname
billtoradio
labeltype
shipper_name
shipper_addressline1
shipper_city
shipper_stateprovince
shipper_postalcode
shipper_phonenumber
Shipto_name
shipto_addressline1
shipto_city
shipto_stateprovince
shipto_postalcode
shipto_phonenumber
service
packaging (In ship_packages table)
weight (In ship_packages table - If using “Package” as the packaging type)

Note: for any checkbox fields the value should be “1” if checked, else empty if unchecked

Required Value Lists: Service, Package and Country Fields

Note: All package and service types may not be available in all areas

Service Field

FedEx Next Day Air® Early A.M.®
FedEx Next Day Air®
FedEx Next Day Air Saver®
FedEx 2nd Day Air A.M.®
FedEx 2nd Day Air®
FedEx 3 Day Select®
FedEx Ground
FedEx Worldwide Express Plus(sm)
FedEx Express
FedEx Worldwide Expedited(sm)
FedEx Standard To Canada
FedEx Express Saver(sm)

Package Field

FedEx Letter
FedEx 10 Kg Box®
FedEx 25 Kg Box®
FedEx PAK
FedEx Tube
FedEx Express Box
Package

Country Field

If you are populating the country field, please use the text file Countries.txt