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.
Posted in Epicor | No Comments »
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.
Posted in Uncategorized | No Comments »
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
Posted in Epicor, Events | No Comments »
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.

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.

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.
Tags: Epicor
Posted in Epicor, News | No Comments »
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
Posted in WebSphere Commerce | No Comments »
March 4th, 2010
To make certain items tax exempt in your store do this following.
- Login to Accelerator
- Click Store -> Change Tax
- Choose Sales Tax
- Enter NOTax in “New sales tax code” box and click add
- Click Category Assignment, make sure the NOTax code does not have a check box
- Click Merchandise
- Find the product that should have no tax
- Select this product
- Click Actions -> Change on the menu
- Choose Sales Tax
- Select NOTax and click Add
Posted in WebSphere Commerce | No Comments »