Blogs

 

jrogelstad's picture

Open source working for you

It's easy for us full time developers to get sucked into blogging mostly about our own achievements in a release cycle. However, as an open source project I don't think we should neglect shining the spotlight on contributions from our community.  After all, these are the people using the software in the real world and trying to solve real world problems with it.  In fact well over 100 contributions have been implemented in the core in the 3.5.x series already.  Project Time & Expense, Support for electronic banking in Austrailia, saving files directly to the database,  G/L Account mappings for cost elements, a new Incident report, more ubiquitous use of the Job Costing report, increasing price precision for P/O and an API view for accounts payable memos are some of my favorites.

 
Project Time & Expense Lite
This was an enormous contribution from our partner szuke at Core Services Group who was incidentally the winner of the 2010 haxTuple bug derby (final results here). He submitted the extension package for a Time & Expense tracking system for CRM Project that is now part of the xTuple core project on Source Forge (no pun intended).  Core Services also offers a premium version that can used for billing purposes.  Both the free and commercial versions are available for download from our xChange app. store.
Support for Electronic Banking in Australia
We have had support for generating electronic checks for some time... but only for North America (NACHA format).  Thanks to this contribution from dataforge we now support the ABA electronic check format for Australia.  Implementing this one also forced our hand a bit to find a way to implement hooks to allow for users to create and implement functions to support any local banking format.  Now those hooks are in the system as a configuration option.  We're hoping more people will submit functions to support additional formats in the future.
Saving Files to the Database
Power user and xTuple partner benson liked our ability to link documents to each other using our Documents widget, but didn't like so much that we only supported URL linking for external documents.  So he submitted code to enable saving external files directly in the database.  That way users don't have to worry about links getting broken because of inaccessible file server paths (especially a problem in a mixed OS environment) or users moving a file and therefore breaking the link.  We got so excited about this one that we even enhanced it ourselves a little further by adding a file watcher to the file when it's opened. When you open a file from the database the file is exported to a temporary directory; if you make changes to the file and click save, the file watcher sees the changes and quietly imports the new version of the file back into the database. That keeps the copy of the file in the database current.
G/L Mapping support for user defined cost elements
This is another contribution by benson.  We have supported user defined costing elements almost from the beginning, but one big shortcoming is they didn't really have any impact on the General Ledger.  This got kind of ugly when they were used on a manufactured item because any cost attributed to one of these elements had no place to go so always ended up being recorded as a variance.  Now you can specify a G/L account mapping on the cost element so costs associated with that automatically get expensed to the proper account when production is posted.  Hooray!
Ability to print an Incident report
U-Haul power user pallavi noticed a functional hole in that there was no way to physically print an Incident.  That's kind of a problem if you've got a red hot one that you want to get on a piece of paper to show someone who may not have quick access to xTuple (say a shop floor worker... or a CEO? ;)  ).  Problem is now solved.
Make the job costing report work for any work order
It used to be that the Job Costing report only worked for work orders that were for job costed items.  xTuple Partner lcarteeat Magical Custom Programming asked, "Why can't we see that job data for ANY work order regardless of cost method?"  The answer is, there's no good reason not to allow that, so he submitted a change to remove that restriction.
Increase the price precision for purchased items
This is a prime example of something that dogged us for a long time but always seemed to sit on the back burner.  To be honest most of our development is driven by users who sponsor it, or architectural changes we think will increase use and/or sales of our product.  Increasing the precision of P/O price handling was one of those things that people often complained about, but just wasn't getting bumped up in priority.  Power user and winner of the 2009 xTuple bug derbyjstandring finally took it upon himself to address this one.  This is the kind of contribution that reminds me why I first fell in love with the concept of open source in the first place.
API view for Accounts Payable Memos
This one from our Canadian partner asplus is a great example of the kind of thing that can help with 3rd party integration, and can also make life much easier for someone going live.  Instead of keying in 1,500 open payables two days before you go live, why not just import them?
Special Mention:
I can't build a list like this without mentioning our power user and partner in Mexico malfredo32, the runner up contentestant in haxTuple 2010.  Not only has he contributed about a dozen patch features and fixes, he resolved many more dozens of outstanding issues in the haxTuple competition.  He also was the first one to reach 100% on the translation portal.  Finally,  we also jokingly call him our Mexican QA department as he is always the first to jump in and thoroughly test beta and release candidate versions of our software.  His bug finds are typically the best in our community, and I guarantee result in better software releases for everybody.
There are so many more people who have made great patch contributions.  At some point I'd like to have a "Hall of Fame" page so they can all be listed and get credit.  In the mean time I just want offer this public "Thank You" to everyone in the community who has submitted code, a bug or even a forum posting.  All these activities are contributing to making xTuple the best open source business system available.
 
Project Time & Expense Lite
This was an enormous contribution from our partner szuke at Core Services Group who was incidentally the winner of the 2010 haxTuple bug derby (final results here). He submitted the extension package for a Time & Expense tracking system for CRM Project that is now part of the xTuple core project on Source Forge (no pun intended).  Core Services also offers a premium version that can used for billing purposes.  Both the free and commercial versions are available for download from our xChange app. store.
Support for Electronic Banking in Australia
We have had support for generating electronic checks for some time... but only for North America (NACHA format).  Thanks to this contribution from dataforge we now support the ABA electronic check format for Australia.  Implementing this one also forced our hand a bit to find a way to implement hooks to allow for users to create and implement functions to support any local banking format.  Now those hooks are in the system as a configuration option.  We're hoping more people will submit functions to support additional formats in the future.
Saving Files to the Database
Power user and xTuple partner benson liked our ability to link documents to each other using our Documents widget, but didn't like so much that we only supported URL linking for external documents.  So he submitted code to enable saving external files directly in the database.  That way users don't have to worry about links getting broken because of inaccessible file server paths (especially a problem in a mixed OS environment) or users moving a file and therefore breaking the link.  We got so excited about this one that we even enhanced it ourselves a little further by adding a file watcher to the file when it's opened. When you open a file from the database the file is exported to a temporary directory; if you make changes to the file and click save, the file watcher sees the changes and quietly imports the new version of the file back into the database. That keeps the copy of the file in the database current.
G/L Mapping support for user defined cost elements
This is another contribution by benson.  We have supported user defined costing elements almost from the beginning, but one big shortcoming is they didn't really have any impact on the General Ledger.  This got kind of ugly when they were used on a manufactured item because any cost attributed to one of these elements had no place to go so always ended up being recorded as a variance.  Now you can specify a G/L account mapping on the cost element so costs associated with that automatically get expensed to the proper account when production is posted.  Hooray!
Ability to print an Incident report
U-Haul power user pallavi noticed a functional hole in that there was no way to physically print an Incident.  That's kind of a problem if you've got a red hot one that you want to get on a piece of paper to show someone who may not have quick access to xTuple (say a shop floor worker... or a CEO? ;)  ).  Problem is now solved.
Make the job costing report work for any work order
It used to be that the Job Costing report only worked for work orders that were for job costed items.  xTuple Partner lcarteeat Magical Custom Programming asked, "Why can't we see that job data for ANY work order regardless of cost method?"  The answer is, there's no good reason not to allow that, so he submitted a change to remove that restriction.
Increase the price precision for purchased items
This is a prime example of something that dogged us for a long time but always seemed to sit on the back burner.  To be honest most of our development is driven by users who sponsor it, or architectural changes we think will increase use and/or sales of our product.  Increasing the precision of P/O price handling was one of those things that people often complained about, but just wasn't getting bumped up in priority.  Power user and winner of the 2009 xTuple bug derbyjstandring finally took it upon himself to address this one.  This is the kind of contribution that reminds me why I first fell in love with the concept of open source in the first place.
API view for Accounts Payable Memos
This one from our Canadian partner asplus is a great example of the kind of thing that can help with 3rd party integration, and can also make life much easier for someone going live.  Instead of keying in 1,500 open payables two days before you go live, why not just import them?
Special Mention:
I can't build a list like this without mentioning our power user and partner in Mexico malfredo32, the runner up contentestant in haxTuple 2010.  Not only has he contributed about a dozen patch features and fixes, he resolved many more dozens of outstanding issues in the haxTuple competition.  He also was the first one to reach 100% on the translation portal.  Finally,  we also jokingly call him our Mexican QA department as he is always the first to jump in and thoroughly test beta and release candidate versions of our software.  His bug finds are typically the best in our community, and I guarantee result in better software releases for everybody.
There are so many more people who have made great patch contributions.  At some point I'd like to have a "Hall of Fame" page so they can all be listed and get credit.  In the mean time I just want offer this public "Thank You" to everyone in the community who has submitted code, a bug or even a forum posting.  All these activities are contributing to making xTuple the best open source business system available.
anderson's picture

Automatically uploading Exchange Rates from a Web Service with Pentaho Data Integration

The Pentaho Data Integration tool is an extremely powerful open source tool for moving data from application to application.  I use it for automating data transfer between various applications and databases.  Why do things manually when you can automate smiley

One of my current projects involved a requirement to upload exchange rates into xTuple's PostBooks application.   This is a mundane task that required someone to remember to do this on a regular basis and a prime candidate for automation.  As we are using the Pentaho suite of tools for data warehousing, reporting, and application integration, automating the exchange rate upload into PostBooks was easy. 

This has proved a very useful solution and so I am offering it back to the community. Read more »

cryan's picture

3.5.2 and beyond: a paradigm shift

We recently released version 3.5.2 of our xTuple ERP application. This release fixes a couple of discreet, yet significant , issues that were discovered after the 3.5.1 release was sent into production. While on the surface this release does not appear to be a significant departure from previous releases, it is. Our goal is to provide the best products and services possible and in order to do that a change is being made.

Starting with 3.5.2 we will be doing regular patch releases for the most recent minor release. These releases will be small in scope, minimize the impact to your business, and be easy to upgrade to. Read on to find out how this is different from our previous methods and how it will benefit you. Read more »

ned's picture

Back-to-back training in August for international users!

August 16-27 will be a very special two weeks at xTuple.  We're having our two most popular training classes - our weeklong Introductory class, and our four-day Power User advanced class - back to back for the first time!  We've set it up this way especially for the benefit of the many international community members who are traveling great distances to join us.  And we're offering a $1,000 discount if you can join us for both classes!
 
This is a one of a kind opportunity for xTuple users to make one trip and learn a lot! If you're interested in learning all there is to know about the product, the technology, and how to customize xTuple to meet your specific market and customer requirements, you don't want to miss this unique opportunity.
 
Of course, xTuple summer training wouldn't be complete without a sunset cruise on the American Rover tall ship, with local specialty foods and our world-renowned OpenBar (TM).  We'll also see the Norfolk Tides (AAA baseball club team for the Baltimore Orioles) take on the Durham Bulls at beautiful Harbor Park.

You can even squeeze in two days at the nearby Virginia Beach resort the weekend in-between! Read more »

tchumatchato's picture

complications on the uninstall...

I installed this program and then I uninstalled it but now I have a "postgres" user which I'm not able to delete. Would appreciate instructions on how to delete this user. Tks.

tchumatchato's picture

complications on the uninstall...

I installed this program and then I uninstalled it but now I have a "postgres" user which I'm not able to delete. Would appreciate instructions on how to delete this user. Tks.

tchumatchato's picture

complications on the uninstall...

I installed this program and then I uninstalled it but now I have a "postgres" user which I'm not able to delete. Would appreciate instructions on how to delete this user. Tks.

annecote's picture

DIY with QuickStart Wizard for 3.5.1

How many times have you excitedly downloaded a new software application and thought to yourself, this looks great, but where do I start?  After trial and error, sorting through help documents, and skimming user manuals eventually you get the hang of it.

Well, when it comes to xTuple software we want to help you move this process along so you can get your enterprise system set up and focus on what you do best - growing your business.  For some time, we've made available a Quickstart database which is pre-loaded with generic master data such as a chart of accounts. With the introduction of the new 3.5.1 release, featuring the xTuple Desktop, we've expanded the Quickstart concept and developed a Quickstart Wizard add-in package which walks you through each step required for system configuration, master data entry, and set up review in the Quickstart database. Read more »

ptyler's picture

The GOOOOOOOOOALLLLLLL!

UPDATE: Congratulations to the translation team for Spanish:Mexico. They are the first project to reach 100%. Ole! Ole! Ole! Ole!

While the world has been watching the 2010 FIFA World Cup in South Africa, we at xTuple have also been following another international competition which is unfolding on the xTuple Translation Portal. The race is on to see which country will be the first to translate the xTuple GUI interface 100% complete. Read more »

ned's picture

Introducing xTuple Web Portal

The wait is over.

The first fully productized website integration with xTuple ERP is now available.  The Web Portal integrates a Drupal website with an xTuple backend, by linking Drupal users with xTuple Contacts and CRM Accounts.  (Remember that CRM Accounts can be customers, vendors, partners, or any other organization you do business with.)

So individuals associated with a particular CRM Account can come to your website, and create an Incident which you can manage in your internal xTuple CRM.  (Here's the demo video that covers CRM Incident Management.)

Contact us today to take advantage of special introductory pricing for existing xTuple commercial customers!

 

Syndicate content