Progress Explorer Tool Fails to Start on Windows 2008

July 29th, 2010

It is well known the Progress Explorer does not start or run on Windows 2008, what is not well know is how easy this is to fix. The fix is technically unsupported but I have seen no problems with it.

This issue effects:
· OpenEdge 10.1B
· OpenEdge 10.1C
· OpenEdge 10.2A

To fix the issue make the following registry entry:
HKEY_CURRENT_USER\Software\Microsoft\Java VM –> EnableJIT = 0

This will allow Progress Explorer to run as Administrator.

DB2 Error SQL0668N after failed massload on WebSphere Commerce

April 21st, 2010

If you see the following error after a fail load with the massload command:

SQL0668N Operation not allowed for reason code "1" on table "<table-name>".
SQLSTATE=57016

It means the table is in the Set Integrity Pending No Access state. The integrity of the table is not enforced and the content of the table may be invalid. An operation on a parent table or an underlying table that is not in the Set Integrity Pending No Access state may also receive this error if a dependent table is in the Set Integrity Pending No Access state.

Essentially the table is locked and not accessible to read or write. You can “unlock” the table by issuing the following commands.

From the command line:

db2 connect to wcdbname user user_id using password
db2 set integrity for table_name immediate checked

or issue

set integrity for table_name immediate checked

from control center.

If this does not work you can run the following command:

SET INTEGRITY FOR tablename CHECK, FOREIGN KEY, MATERIALIZED QUERY, STAGING, GENERATED COLUMN IMMEDIATE UNCHECKED;

Which should remove the invalid items from the table and “unlock” it.

Datix Inc & Epicor Road Show June 17th 2010

April 18th, 2010
June 17th, 2010
8:45 am to 11:30 am
Hilton St. Louis at the Ballpark
1 South Broadway
St. Louis, MO
314-421-1776
Event Contact:
Chris Joliet
Datix Inc
Business Development
(314) 479-4032
chris@datixinc.com
Agenda
8:30 am Arrival, Introductions, Coffee and Donuts
9:00 am Who is Epicor Software Corporation/Datix Inc. Local Partner
9:15 am Key Software Evaluation
9:30 am Overview demonstration of Epicor 9
10:15 am Does it make sense to implement software in a recovering economy
10:45 am Customer Testimonial
11:10 am IBM Hardware Presentation
11:15 am Drawing for St. Louis Cardinal Tickets
11:30 am Conclusion

Key Takeaways:
• What is a good software evaluation process
• What is a compelling event and why is it important
• When is a good time to implement
• Out of the box functionality for Distribution
• What is new with Epicor 9
• Implementation and Support Approach
• Extraction of data
• Embedded vs. Integrated
• Ease of use, Ease of Use, Ease of Use
• Distribution: Key Performance Indicators / analytics / Dashboards
• .Net SOA Technology lending to ease of use and flexible workflows

To register, please email sales@datixinc.com with:
• Name, Title, Company, Number of Attendees

Datix Implements Epicor CRM

April 14th, 2010

     As an Epicor VAR we sell people on the idea that a single integrated system is easier to use and less expensive to maintain than multiple integrated systems. However, we suffer from the same issues many of our customers have; 3 separate systems that hold customer and prospect information. None of these systems talk to each other and data was being entered 3 and 4 times. We decided we need to practice what we preach so last month we moved all sales and prospecting activities into Epicor. We were already using Epicor for accounting and customer management but not during the sales cycle.

   Prior to moving to Epicor we used Business Contact Manager (BCM) from Microsoft. If you are familiar with BCM you know it does not work well in team environments, integration is not easy, larger data sets can crash Outlook among other issues. Reporting with BCM can also be a challenge, so we developed reports in Excel that pulled data directly from BCM for analytics. BCM tends to be very “clickey”. If a sales rep wants to review the customer history before placing a call it can take 3 -5 clicks to view this information. Three clicks might not seem like much but when you do this 70 – 100 times a day an extra click adds a lot of time. BCM does have its good points, because it is integrated into Outlook it is easy to learn and attaching emails is easy.

Goals:  

  • A simple efficient way to track all customers, prospects and opportunities from a single interface
  • Reduce the number of clicks
  • Provide real time analytics on marketing activities and opportunities

Process:
    The change over process was fairly simple. I sat down with one of the sales reps and mapped out the processes they were using in BCM. We then talked about how each process could be improved in Epicor and what data needed to be available on the main screen. I created a sample dash board that pulled all the required information on to a single screen. We then conducted a quick pilot with sample data and made some modifications to the layout and functioning of the dashboard. The initial design and construction effort only took 3 hours; the interface was refined over the next week and rolled out in production 7 days after the initial design. 

Results:

Sales Interface:
              
As you can see in the screen shot below all information has combined on a single screen. The sales rep can view a customer, all contacts and all notes associated with that contact from a single screen.
Epicor CRM Call List

 Analytics:
               
Each sales person and their manager can see their Key Performance Indicators directly from the main user interface. This information is refreshed every few minutes so mangers know if their staff is on target each day.

Epicor CRM Analytics

Conclusion:
      
Feedback from the sales team has been positive. They find Epicor easier to use and more tailored to their tasks than BCM and Outlook. The amount of time required to review an account and make a sales call has been cut in half. Mangers can quickly review each day’s activity without the sales person having to provide reports. The pipeline is now much easier to manage and we have greater visibility into pending opportunities. Because of Epicor’s industry leading technology it was extreamly simple for us to customize Epicor to our needs.

Export Catalog Data from WebSphere Commerce

March 15th, 2010

Below is an example of how to export catalog data from WebSphere Commerce. You will need to change STOREID to the store id that holds the catalog data. You will need to change CATALOGID to the catalog ID you want to export. If you have sales catalogs you will need to provide those as well.

extract_catalog_filter.xml

Use the following command to extract the data:

massextract.cmd -dbname [DATABASE] -dbuser [DB2USER] -dbpwd [PASSWORD] -filter extract_catalog_filter.xml -outfile catalog.xml

Tax Exempt Items in WebSphere Commerce

March 4th, 2010

To make certain items tax exempt in your store do this following.

  1. Login to Accelerator
  2. Click Store -> Change Tax
  3. Choose Sales Tax
  4. Enter NOTax in “New sales tax code” box and click add
  5. Click Category Assignment, make sure the NOTax code does not have a check box
  6. Click Merchandise
  7. Find the product that should have no tax
  8. Select this product
  9. Click Actions -> Change on the menu
  10. Choose Sales Tax
  11. Select NOTax and click Add