This .aia gallery version is provided without API keys for fusion tables, but you can load a running version (.apk) of this App from : http://www.letustry.org/CSPCA/PizzApp/PizzaFusionTablesMapping.apk

It uses a shared database of Customers and Pizza Orders (around Paris). Feel free to use it, but please do not add more than one or two customers and orders, so that we can keep the tables reasonably clean. We will check and clean fusion tables once a week.

To get the .aia source code fully working you need to :

· duplicate or create the PizzaOrders and PizzaCustomers fusion table on your own google drive,

· duplicate or create a PizzaMergeTableOrdersAndCustomers table (on Customer’s name)

· create a project and generate a service API key.

· Create the API Key file (.p12)

· load this key file in the designer and set it as the keyFile for the fusion table components (FusionTableOrders AND FusionTableCustomers)

· Get a service account email and set the SERVICE_ACCOUNT_EMAL variable value

· Get table ids and set the PIZZA_ORDERS_TABLE_ID, PIZZA_ORDERS_TABLE_ID, PIZZA_MERGE_ORDERS_CUSTOMERS_ID variables values

This process is well described in http://appinventor.mit.edu/explore/ai2/pizzaparty.html for a case which is more simple (uses a single table with no merge)

· You will also have to check or update the MapOrdersURL procedure for column numbers (which may not be the same : use right click publish on the merged table map to see which column names are used)

All this is fairly difficult and should be explained in a tutorial to come.