jump to navigation

Primavera ERP V7 Releases to Manufacturing February 2, 2007

Posted by Patricio in Primavera, Software Engineering.
add a comment

Primavera ERP V7 is RTM!

v7.JPG

www.primaverabss.com

Advertisements

Primavera ERP V7 + Vista January 2, 2007

Posted by Patricio in Primavera, Software Engineering.
2 comments

Some nice pictures of Primavera ERP V7 in Vista:

More details (in portuguese) from Hugo’s blog .

V7-Vista-Admin

V7-Vista-BusinessMonitor

V7-Vista-ERP

V7-Vista-Switch

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:

  1. A “manifest” file named Gadget.xml that contains all the settings for your gadget.
  2. 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.