Generated by All in One SEO v4.9.7.2, this is an llms.txt file, used by LLMs to index the site. # steepvalley.net Custom Application Development - Deltek Vision - ERP Management ## Sitemaps - [XML Sitemap](https://steepvalley.net/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Scripter - An SQL Tool to copy data between databases](https://steepvalley.net/2022/03/30/scripter-an-sql-tool-to-copy-data-between-databases/) - Scripter & ScriptEngine Library This tool allows you to either use the console app to extract inserts, updates, deletes and selects from a database into a scripting file. I use this tool a lot to copy settings and other information from one database to another when I do not have access to the target database. - [Planning Your Projects](https://steepvalley.net/2022/02/01/planning-your-projects/) - This is an ongoing series in collaboration with Rhodium Digital where we present a number of different topics in regards to the latest Deltek Vantagepoint version. Please follow us here where we will host the presentation or go over to Rhodium Digital to see videos of the webinars This is an embedded Microsoft Office presentation, - [Invoice Approvals in Vantagepoint](https://steepvalley.net/2022/01/29/invoice-approvals-in-vantagepoint/) - This is an ongoing series in collaboration with Rhodium Digital where we present a number of different topics in regards to the latest Deltek Vantagepoint version. Please follow us here where we will host the presentation or go over to Rhodium Digital to see videos of the webinars The Presentation [embeddoc url="https://steepvalley.net/wp-content/uploads/2022/01/Vantagepoint-Invoice-Approvals-BLOG.pptx"] - [Real World Vision API Solutions](https://steepvalley.net/2017/12/27/vi-66-real-world-vision-api-solutions/) - This is a transcript of my VI–66 session at 2017’s Deltek Insight Agenda Introduction Getting started with the Windows Service Adding reading capabilities to the service Using the VisionAPIHelper library Implementing the Vision API calls Tips & Tricks Introduction What do we cover in this session We will create a Windows service that will read - [Tips and Tricks for Creating Vision Custom Reports](https://steepvalley.net/2017/12/27/vi-68-tips-and-tricks-for-creating-vision-custom-reports/) - This is a transcript of my VI–67 session at 2017’s Deltek Insight Agenda Introduction On Premise vs. In The Cloud Getting with the report template Creating the report statement Using the selection feature Adding custom parameters Using the column selection feature Using the sorting/grouping feature Introduction What do we cover in this session? We will - [Introduction to the new Web API for Deltek Vantagepoint](https://steepvalley.net/2019/04/18/introduction-to-the-new-web-api-for-deltek-vantagepoint/) - This is a transcript of my Deltek Vantagepoint REST API session of the same name at 2018's Deltek Insight. Agenda IntroductionConnecting to the REST APIAvailable MethodsReading DataWriting DataWorking with JSONWhere to take it from hereTips & Tricks Introduction With the move to Vantagepoint, the API technology changes from SOAP to REST For the time being - [September 2020: The API Automation Series](https://steepvalley.net/2020/09/06/september-2020-the-api-automation-series/) - As of September, I will start a new multi-part series that explores a no-code approach to Vantagepoint integrations using API Integration Automation Platforms. This series will be exclusive to Patreon members and will consist of blog entries and some video tutorials that go into the various details of such an integration. - [Teaming Up With Patreon](https://steepvalley.net/2020/08/31/teaming-up-with-patreon/) - Please support me on Patreon to get access to all my content. This will also allow you to have direct influence on upcoming topics. - [VI–67: Best Practices for Building a Bridge to Unlock the Power of Vision APIs](https://steepvalley.net/2017/12/27/vi-67-best-practices-for-building-a-bridge-to-unlock-the-power-of-vision-apis/) - This is a transcript of my VI–67 session at 2017’s Deltek Insight Agenda Introduction Connecting to the Vision API Web Service Available Methods and Schemas Reading Data from Vision Writing Data to Vision Parsing XML Data Where to take it from here Tips & Tricks Introduction What is the Vision API (Vision XTEND) It’s a - [A New Online Tool To Get Started With Vision API](https://steepvalley.net/2017/03/17/visionapitestbench/) - Over the years I found that people always had a hard time getting started with Deltek Vision’s API. I do admit, it probably has a lot to do with the message structures the API is expecting. To jump-start your development I just created an online Test Bench that allows you to connect to your service, - [The Trouble with Job Costing](https://steepvalley.net/2017/12/26/the-trouble-with-job-costing/) - Over many years and many discussions I found that Deltek Vision’s concept of job costing is still a stumbling stone for many accounting specialist, especially when it comes to explain this to their accountant at year end. The main issue with this is probably because most consultants will tell these firms to offset the values - [Deltek Vision: Tracking Your Company Vehicle Costs With Units](https://steepvalley.net/2017/01/04/deltek-vision-tracking-your-company-vehicle-costs-with-units/) - Does your company track company vehicle cost? Did you ever wonder if you charge enough for their usage back to the client? One way of doing this is using some of the advanced features in the Units Info Center. In the unit definition there is a field called Credit Account. If you put a valid - [Deltek Vision: Things You Cannot Do With Workflows](https://steepvalley.net/2017/01/01/deltek-vision-things-cannot-workflows/) - User initiated work flows are the back bone of Vision's extensibility. You are able to react on every insert, update or delete for any info center record and create your own validations, field calculations or messages for the event. You can even call your own code functions, web services and stored procedures. But there's on - [Flashback to 2004- XP Common Controls (XPCC)](https://steepvalley.net/2016/12/29/flashback-to-2004-xp-common-controls-xpcc/) - While I was restarting my website this month I came across a funny fact: there are still sites out there that link to my XP Common Controls Project (XPCC) back from 2004. Don’t get me wrong, I was proud of my accomplishment. It had over 8000 downloads, got a “Code Hero” award from Microsoft and - [Deltek Vision: Project Structures Vs. Organizational Structures](https://steepvalley.net/2016/12/28/vision-project-structures-vs-organizational-structures/) - The longest and hardest fought over sessions in a Vision implementation are always project numbering and project structures. While project numbering is usually defined by a legacy application or legacy filing system (and it’s less of an issue as most people think) I came across some misconceptions on Vision’s Work Breakdown Structures (WBS) and how - [Deltek Vision: Custom Reporting](https://steepvalley.net/2016/12/25/custom-reporting/) - Did your finance department ever approach you to create them that one specific report that’s missing? Did you ever wonder if you could write a report that would take advantage of Deltek Vision’s ® reporting capabilities and allow you to create selections, set up your own grouping, show and hide columns and create your own - [Background Tasks in ASP.net (Web Services or API)](https://steepvalley.net/2016/12/22/background-tasks-in-asp-net-web-services-or-api/) - I just came across a System.Threading.Timer issue and thought I might share it with the community: As part of a background task that pulls data out of Vision and sends it to a 3rd party I implemented a background task into a ASP.net Web Service using the System.Threading.Timer and TimerCallback. [csharp] private static System.Threading.Timer AppTimer - [User Defined Fields, Grids and Info Centers](https://steepvalley.net/2016/12/21/user-defined-fields-grids-and-info-centers/) - The most used and by far the easiest way of customizing Deltek Vision is the User Defined Controls feature. This allows you to add new fields and grids to any existing info center (like projects, employees, vendors, etc..) or even create your own new info centers from scratch. Custom fields support all the data types ## Pages - [Welcome to Steepvalley, Inc.](https://steepvalley.net/) - Who We Are Steepvalley, Inc. is a consulting company that focuses on creating customizations and integrations of business software (ERP), especially focusing on Deltek Vision, Deltek Vantagepoint and Intuit QuickBooks. Team Michael Dobler is the owner of the firm and has been working in the IT industry for over 20 years, covering different roles from - [Blog](https://steepvalley.net/blog/) - C#/VB.net Code Scripter – An SQL Tool to copy data between databases Scripter & ScriptEngine Library This tool allows you to either use the console app to extract inserts, updates, deletes and selects from a database into Read More » March 30, 2022 No Comments Planning Your Projects This is an ongoing series in collaboration - [Services And Pricing](https://steepvalley.net/services/) - Courses / Learning We offer tailor-made training sessions specifically around customization and extensibility of Deltek Vision and Vantagepoint. This includes reporting, SQL scripting and API programming. Functional training for Deltek Vision and Vantagepoint can be provided as well. One-On-One training session $2000/session Sessions are topic specific and can range from 2 to 4 hours. Training - [Contact Us](https://steepvalley.net/contact-us/) - If you have any questions regarding our service offerings, or other ERP and IT-related topics, please fill out the form below and we will be in touch shortly. Name Email Phone Message Preferred Contact Option Email Phone Send - [Open Source Projects](https://steepvalley.net/opensource/) - The Passthrough-Connector Project While the new Deltek Vantagepoint REST API is secure and convenient, it is sometimes a hassle to set up a valid connection that include the Bearer token and takes care of all the authentication details.It’s especially tricky when you want to pull data into some data tools like Microsoft Excel, Microsoft PowerBI - [Presentations & Media](https://steepvalley.net/presentations/) - Page is currently updated. Please come back for more content - [About](https://steepvalley.net/about/) - Welcome to my web site! First things first: why the weird name “steepvalley.net”? Well, when I started looking for an online presence, dobler.com was of course already taken. So I picked the next best thing – the literal translation of my last name – “living in or near a steep valley” (according to a heraldic - [Search](https://steepvalley.net/search/) - Search - [Vantagepoint REST Queries](https://steepvalley.net/opensource/vantagepoint-rest-queries/) - This page will show a number of default Vantagepoint API queries for different scenarios. These queries can also be used with the new PassThrough Connector Project (documentation here) If you want to see more queries please comment on this site and I will try to add as many as I can. At this point I'm - [The PassThrough Connector Project](https://steepvalley.net/opensource/the-passthrough-connector-project/) - While the new Deltek Vantagepoint REST API is secure and convenient, it is sometimes a hassle to set up a valid connection that include the Bearer token and takes care of all the authentication details. It's especially tricky when you want to pull data into some data tools like Microsoft Excel, Microsoft PowerBI or other - [XP Common Controls](https://steepvalley.net/opensource/xp-common-controls/) - Getting "That WinXP Look" with XP Common Controls DISCLAIMER: This documentation has been written back in 2006. A lot of things have changed since then and not all statements are still true. Especially when it comes to some of the basic functionality of the current Form controls in .NET 4.6.1. Some of the functionality provided - [Privacy Policy](https://steepvalley.net/privacy-policy/) - Who we are Our website address is: http://steepvalley.net. What personal data we collect and why we collect it Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymized string created from ## My Templates - [Default Kit](https://steepvalley.net/?elementor_library=default-kit) - [2021_search_template](https://steepvalley.net/?elementor_library=search-results) - 2021_search_template C#/VB.net Code Scripter – An SQL Tool to copy data between databases Michael Dobler March 30, 2022 Planning Your Projects Michael Dobler February 1, 2022 Invoice Approvals in Vantagepoint Michael Dobler January 29, 2022 Search Michael Dobler April 12, 2021 Contact Us Michael Dobler April 12, 2021 Presentations & Media Michael Dobler April 11, - [2021_header](https://steepvalley.net/?elementor_library=header2021) - Content area - [2021_footer](https://steepvalley.net/?elementor_library=elementor-footer-2322) - Content area - [2021_singlepage_template](https://steepvalley.net/?elementor_library=2021_singlepage_template) - 2021_singlepage_template Courses / Learning We offer tailor-made training sessions specifically around customization and extensibility of Deltek Vision and Vantagepoint. This includes reporting, SQL scripting and API programming. Functional training for Deltek Vision and Vantagepoint can be provided as well. One-On-One training session $2000/session Sessions are topic specific and can range from 2 to 4 hours. - [2021_archive_template](https://steepvalley.net/?elementor_library=elementor-archive-2448) - 2021_archive_template APIs, reporting, Software Development, etc... C#/VB.net Code Scripter – An SQL Tool to copy data between databases Michael Dobler March 30, 2022 Planning Your Projects Michael Dobler February 1, 2022 Invoice Approvals in Vantagepoint Michael Dobler January 29, 2022 Featured September 2020: The API Automation Series As of September, I will start a new - [2021_singlepost_template](https://steepvalley.net/?elementor_library=elementor-single-post-2528) - 2021_singlepost_template Michael Dobler April 11, 2021 Share This Post Scripter & ScriptEngine Library This tool allows you to either use the console app to extract inserts, updates, deletes and selects from a database into a scripting file. I use this tool a lot to copy settings and other information from one database to another when - [2021_hero](https://steepvalley.net/?elementor_library=2021_hero) - 2021_hero APIs, reporting, Software Development, etc... - [2021_error404_template](https://steepvalley.net/?elementor_library=2021_error404_template) - 404 Oops! That page can't be found You can navigate through our menu or use this search bar: Search Search ## Categories - [Uncategorized](https://steepvalley.net/category/uncategorized/) - [C#/VB.net Code](https://steepvalley.net/category/dotnetcode/) - C#/VB.net coding related posts - [Featured](https://steepvalley.net/category/featured/) - [Open Content](https://steepvalley.net/category/open/) - Open Content - [Reporting](https://steepvalley.net/category/reporting/) - Reporting related posts - [SQL](https://steepvalley.net/category/sql/) - SQL Related Posts - [Vision API](https://steepvalley.net/category/visionapi/) - Vision API related Posts - [Vision Functional](https://steepvalley.net/category/vision-functional/) - [Workflows](https://steepvalley.net/category/workflows/) - Vision Workflow related posts - [XP Common Controls](https://steepvalley.net/category/xp-common-controls/) - [Patreon Only](https://steepvalley.net/category/patreon-only/) - [Vantagepoint API](https://steepvalley.net/category/vantagepoint-api/) ## Tags - [Accounting](https://steepvalley.net/tag/accounting/) - [Configuration](https://steepvalley.net/tag/configuration/) - [Customization](https://steepvalley.net/tag/customization/) - [Deltek Vantagepoint](https://steepvalley.net/tag/deltek-vantagepoint/) - [Deltek Vision](https://steepvalley.net/tag/deltek-vision/) - [featured](https://steepvalley.net/tag/featured/) - [Free Content](https://steepvalley.net/tag/free-content/) - [Job Costing](https://steepvalley.net/tag/job-costing/) - [net](https://steepvalley.net/tag/net/) - [Reporting](https://steepvalley.net/tag/reporting/) - [Stored Procedures](https://steepvalley.net/tag/stored-procedures/) - [Vision API](https://steepvalley.net/tag/vision-api/) - [Web Services](https://steepvalley.net/tag/web-services/) - [Workflows](https://steepvalley.net/tag/workflows/) - [XP Common Controls](https://steepvalley.net/tag/xp-common-controls/) - [XPCC](https://steepvalley.net/tag/xpcc/) - [API Automation](https://steepvalley.net/tag/api-automation/) - [Vantagepoint](https://steepvalley.net/tag/vantagepoint/) - [Zapier](https://steepvalley.net/tag/zapier/) - [Patreon](https://steepvalley.net/tag/patreon/) - [Webinar Series](https://steepvalley.net/tag/webinar-series/) - [New Features](https://steepvalley.net/tag/new-features/) - [Invoice Approvals](https://steepvalley.net/tag/invoice-approvals/) - [Billing](https://steepvalley.net/tag/billing/) - [webinar](https://steepvalley.net/tag/webinar/) - [Planning](https://steepvalley.net/tag/planning/) - [SQL](https://steepvalley.net/tag/sql/) - [Github](https://steepvalley.net/tag/github/)