I’m currently looking for a solution for how to access the data contained within the Delivery Docket and Return Docket reports. We’re looking at a method for extracting data out of quantify for a generated picking list and then being able to write data back into quantify after said list has been picked. Currently it’s all a manual process but we’d like to automate the picking side of things so data captured manually when picking items can be entered directly into quantify after being approved.
Hi Gareth. I’ve attached a zip file that has a sample project for this. This shows how to fetch a shipment (by number) and view the parts. Once you’ve got your ‘picked’ quantities you can write these back by setting the ‘sent’ quantity next to the ‘reserved’.Quantify.API.zip (7.0 KB)
Thanks for this guys. I have the client installed on my local machine but the database resides on a different machine. Will the api run on my machine or do I have to change some of the parameters to point at the database server?
Yes, all you need to do is change the app.config file in your project. The server is probably ‘localhost’ right now. You can change it to your server name \SERVERNAME to point it there. If you have Quantify Web you can also tunnel the connection through the internet by commenting out the URL in the appsettings.xml file.
I’ve checked within the app.config file and can’t see it referencing a localhost within there? We’re currently not using Quantify Web so can’t use this option. I can see the appconnection.xml file referencing localhost so shoudl I be changing this setting to our dbserver?
Furthermore when running the debugger I’m met with an error regarding the import.txt file. I’ve tried creating the file (as it currently doesn’t exist in the extracted package) but still met with the same error.
Sorry, appconnection.xml, you’ll see Data Source=localhost there.
In the project you’ll see an ‘import.txt’ file referenced there that you can simply delete, it’s not needed.
Great that’s been done. I’ve also edited the Program.cs file to have the user client login details. It is erroring when it reaches the loop through all the products, a unhandled except “System.NullReferenceException” type.
In the appconnection.xml I haven’t changed the ASIUser password as I don’t know this. Could this be the issue or would the program not get to the first loop if this was incorrect?
In the Shipment.GetShipment() method there’s a string value for the shipment number. Have you switched that to one that exists in your database?
We’ve tried entering in a current delivery docket id but are now met with the following error:
Additional information: DataPortal.Fetch failed (DataPortal.Fetch failed (UseAWCBillingCycles)).
On a side note I also can’t upload images through here. Says ‘Sorry, new users can not upload images’.
I suspect that your server version of Quantify is a different version that what you’ve got installed locally. You can look at the dbversion table to confirm, there’s a single row in there. The current version can be downloaded from our support site in the downloads section: http://www.avontus.com/help/avontusassist/
You should also be able to upload images now.
That was correct. The local install was the older version. Both the local install and the database are running version .106 (see first two screenshots). After upgrading my client however it’s giving me the following error:
“An unhandled exception of type ‘System.IO.FileLoadException’ occured in mscorlib.dll.”
Additional info: could not load file or assembly ‘Avontus.Core, Version=22.214.171.124, Culture=neutral, PublicKeyToken=93be5fdc093e4c30’. Exception from HResult: 0x80131040.
I can upload the images but when I hit reply I’m still met with the same error as previously mentioned.
I’ll look into the site setup for the post attachments.
Sounds like your reference to Avontus.Core.dll isn’t correct. Can you try that? Also try switching around the copy local property on that file.
Can you copy/paste the code that you’re using into the post?
Hi Gareth. I’ve added a new post that shows how you can get a list of shipments in your database that I think you’ll find useful.