Jump to content

Fedex Ship Manager ODBC Error message help


This topic is 1533 days old. Please don't post here. Open a new topic instead.

Recommended Posts

So, first of all I've done some searching and have seen some of the discussions regarding Fedex Ship Manager integration and I was wondering if anyone has successfully completed this?  I know that NRG has a product and we are looking into that too...

So, here's where I am...

I've got the two systems connected and the fields are all mapped but when i go to do the lookup I get this error message.  I was on the phone with Fedex for about an hour and they were no help.  Can someone help point me in the right direction?

IMG_6702_2.thumb.JPG.2ba5fe2dd0f6dc625998daec9c39e6bf.JPG

Thanks

Mark

 

Link to comment
Share on other sites

FileMaker, through External SQL Sources ( ESS ), is only compatible with specific databases.

https://support.filemaker.com/s/answerview?language=en_US&anum=000023433

 

You can do Imports/Exports through ODBC, but I've honestly never done that a lot, especially in the modern world where you can use an API to get/move data around to or from other services.

Link to comment
Share on other sites

This is one of those cases where I, personally, prefer to pay for a service like NRGSoft. Those APIs change enough, where I don't want to have to go figure out why something is broken, because "Surprise" FedEx changed something. Plus Andy has all that stuff figured out, no reason for me to torture myself. LOL

Link to comment
Share on other sites

I hear ya.  Integrating with anything comes at a cost.  You can either build or buy.  If you build, you bear the responsibility of keeping track of the FedEx changes, make sure you get early notifications and spend some time on those.  If you buy you have to do vendor risk management: is the vendor quick to support, are in for the long haul...

decisions, decisions...

  • Like 1
Link to comment
Share on other sites

So, here's what i just discovered....The issue is with the format of my import key which is our "sales order number" which in Filemaker is a created serial number field.  If I switch the import key to a text field, like customers last name...the import works.

Keep in mind, my skill level is minimal at this point...

So, is there a way to put a copy the sales order number into another field that is formatted at text and then I could set that as my import key?

Mark

Link to comment
Share on other sites

Careful with that, a text field behaves differently than a number field.  If your users (or your scripts) are using that field for searches then searching for 1 will also yield 10, 11, 100,...

And sorting will behave differently too.  So if you were relying on that field acting as a number then you are better off leaving it as a number and using a 'shadow' filed as I mentioned.

  • Like 1
Link to comment
Share on other sites

This topic is 1533 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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