add data from website api to excel for mac

Add Data From Website Api To Excel Zip File You

Also note the order number is automatically generated, and some error trapping is included that transcends xTuple logic (like making the contact information required) for this particular business need.

Tutorial includes examples of quick-and-dirty spreadsheet applications using Visual Basic for Applications (VBA) macros to connect to an xTuple database.

End users frustrated with the rigidity of highly structured database clients often resort to keeping separate spreadsheets of identical information because it allows them add formulas, highlights and other custom attributes at will.

If we can not bring the spreadsheet to xTuple, why dont we bring xTuple to the spreadsheet.

Though they are fully functional, they are not necessarily meant to be deployed in a production environment, but rather to give ideas as to how the xTuple API can be used to integrate office applications to xTuple ERP.

Add Data From Website Api To Excel Zip File You

A copy should have been included in the zip file you downloaded from the introduction page.

The actual values in column B should reflect your local database connection parameters.

Before we can add our macro code, we need to include a reference use ActiveX data objects.

Scroll down and select the Microsoft ActiveX Data Objects 2.5 library.

There will likely be several versions.

We used 2.5 library for this example so it would also work on older installations of Office, but you should be able to use the latest version available.

Click OK.

This discussion assumes the user has an understanding of Visual Basic and ActiveX data objects (ADODB).

We need to do this so Excel can maintain the connection and data between the time when we load our data, change it and send it back to the database.

Type or paste this code above the Load sub routine that was created.

Type or paste this code after the end of the Load procedure.

From Excel, go back to view the macros and run the Load macro.

Your spreadsheet should be populated with the list of customers from your database.

Try making changes to a customer name, then ctrls to save them.

Note the api has the same validation rules as the UI, but none of that had to be dealt with explicitly in the macro code.

Its all taken care of by the xTuple API and ActiveX objects.

With some improved security measures, this idea could also be the beginning of a solution where customers could fill out this form and email it to customer service where it could be uploaded into an xTuple database with only a keystroke.

You can review the comments in the macro code to see how it works.

However there is an important configuration change in xTuple ERP that needs to be made to allow this application to work.

This will allow the Excel application to assign an order number.

Add Data From Website Api To Excel For Mac