E9: Exporting data from EPICOR to excel

From the sounds of it there is data they are exporting that already has returns in it. Is that correct? Do you need to export it as a BPM? If you use C# in a customization you have some of those regex functions available to you to do something like that.

 

Joshua Giese

CIO

 

Direct:     920.593.8299

IT Dept:   920.437.6400 Ext. 337

Site ID:    27450-E905702A-SQL64

Wisconsin Converting, Inc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, July 7, 2015 8:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: Exporting data from EPICOR to excel

 

 

A BPM can do it, it would validate it as part of a pre-processing BPM probably on Update. They would be able to enter whatever they like and the BPM would raise an error condition. 

 

To prevent them from entering while it is happening you might attach code to the KeyDown/KeyPress events for that control or the Column Change event for the field. 

 

There are quite a number of examples of handling this at the control level both on the Infragistics and other websites.  (Epicor controls are based on Infragistics controls).

Jim Kinneman

Encompass Solutions, Inc.

At times the text in the fields might have a special character and excel takes them as a return.  Is there is way to prevent these characters to be entered?

Would you write a BPM to allow [a-z][A-Z][0-9][,-] only?

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

A BPM can do it, it would validate it as part of a pre-processing BPM probably on Update. They would be able to enter whatever they like and the BPM would raise an error condition. 

To prevent them from entering while it is happening you might attach code to the KeyDown/KeyPress events for that control or the Column Change event for the field. 

There are quite a number of examples of handling this at the control level both on the Infragistics and other websites.  (Epicor controls are based on Infragistics controls).

Jim Kinneman
Encompass Solutions, Inc.