Did you know that there is a topic in our Help system that will assist you with embedding your SQL queries into your Project Center templates when working on your Deltek Vision integration?
Click here for the reference
You will also notice in this link that there is a set of canned SQL queries that serve as examples for creating projects and importing contact information from Deltek Vision and Active Directory. These templates are located in C:\Program Files\Software\Newforma\Project Center\Templates\SQL Template.xls.
You’ve probably figured this out by now, but I figured I’d post for anyone else that my have this same question. If you click on the cell that just has “SELECT” you should see that it’s multiline with a very long SQL statment out of view.
By Gerald Cox on 10/20/2009 - 11:54AMPost your own comment
We just installed Newforma and I am looking at the SQL Template.xls. Where there should be SQL statements for the calendar items there is just SELECT, and that’s it. Do I just have a bad file?
By charkerr on 04/13/2009 - 6:25PM