Primavera ERP V7 Releases to Manufacturing February 2, 2007
Posted by Patricio in Primavera, Software Engineering.add a comment
Primavera ERP V7 + Vista January 2, 2007
Posted by Patricio in Primavera, Software Engineering.add a comment
Primavera Gadgets for Vista December 5, 2006
Posted by Patricio in Primavera, Software Engineering.5 comments
In order to create a Vista Gadget, you need:
- A “manifest” file named Gadget.xml that contains all the settings for your gadget.
- An HTML file with your scripting code.
The manifest file contains the gadget configuration and its format is something like this:
<?xml version=”1.0″ encoding=”utf-8″ ?>
<gadget>
<name>Primavera Gadget</name>
<author>Patricio Fernandes</author>
<description>Primavera BSS Gadget</description>
<icons>
<icon>MyGadgetIcon.jpg</icon>
</icons>
<version value=”1.0.0.0″ MinPlatformVersion=”0.1″></version>
<sidebar>
<type>html</type>
<permissions>full</permissions>
<code>PrimaveraGadget.html</code>
<website>www.primaverabss.com</website>
</sidebar>
</gadget>
here PrimaveraGadget.html is the HTML file with the scripting code.
This HTML file is nothing more than a web page that uses scripting (VBScript or Jscript) to retrieve data from a Primavera database (SQL Server) and display them. So, you can write your own HTML file that will contain something like this:
<html>
<head>
<title>My First Gadget</title>
<style>
body{width:120;height:160}
</style>
</head>
<script language=”VBScript”>
Set myConn = CreateObject(”ADODB.Connection”)
Set myRecordset = CreateObject(”ADODB.Recordset” )
myConn.Open = DB_CONNECTION_STRING
myRecordset.Open mySQLCmdText, myConn
myRecordset.MoveFirst
WHILE NOT myRecordset.EOF
Response.Write(myRecordset(”myField”) & “<br/>”)
myRecordset.MoveNext
WEND
myRecordset.Close
Set myRecordset = Nothing
myConn.Close
Set myConn = Nothing
</script>
</html>
where DB_CONNECTION_STRING is the connection string that connects to Primavera database and mySQLCmdText is the query that you want to execute (for example a query to retrieve the last 10 Orders).
To install the Gadget on your sidebar, open the Gadgets folder under %userprofile%\appdata\local\microsoft\windows sidebar\gadgets, then create a new folder for your newly created Gadget (called for example PrimaveraGadget.gadget). Remember that the .gadget extension is a must!!
Now place your HTML file and your gadget.xml file into this folder and restart the Windows Sidebar. If you try to add a new gadget on the sidebar, your newly created gadget should appear in the gadget picker dialog box.
