fp and .net

Fri Jul 20 13:15:01 PDT 2012

Scott,

Sure no problem.  Actually we looked at Epicor amoung many others.

13 years ago we bought Intuitive MRP version 3.6  This was by authors by Intuitive Systems out of Kirkland WA.

Since then they were bought out by Made 2 Manage which is now owed by an umbrella company called Consona.  Made 2 Manage has about 10 ERP versions for different vertical markets.

We are now testing and will be implementing by the end of the year ERP version 8.6.  

Like most MRP / ERP systems I have seen, I hoping the mfg and scheduling functions are more robust than before.  We have been using my filePro programs for determining what to order, scheduling production, machine loading and job costing.  I am retiring 5/1/2014 and this has to be operational (non fp) before then.

Hope the above helps.

Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
http://www.deluxestitcher.com/

________________________________
 From: Scott Lepley <scott.lepley at mercuryelectronics.com>
To: Richard Hane <yoresoft at sbcglobal.net> 
Sent: Friday, July 20, 2012 1:08 PM
Subject: RE: fp and .net

Hello Rick,

Would you mind disclosing what ERP system you are running?  We are using
Epicor here at Mercury Electronics and are trying (slowly, VERY slowly) to
migrate from our filePro-based accounting/manufacturing system.

Regards,
Scott Lepley

Systems Analyst
Mercury Electronics Division
Diversified Traffic Products, Inc.
3846 Green Valley Road
P.O. Box 248
Seven Valleys, PA 17360
Tel.: 717-428-0222, ext. 250
Fax: 717-428-0333
Email: scott.lepley at mercuryelectronics.com

-----Original Message-----
From:
filepro-list-bounces+scott.lepley=mercuryelectronics.com at lists.celestial.c
om
[mailto:filepro-list-bounces+scott.lepley=mercuryelectronics.com at lists.cel
estial.com] On Behalf Of Richard Hane
Sent: Friday, July 20, 2012 9:15 AM
To: Walter Vaughan; filePro
Subject: Re: fp and .net

[ top posted ]

Walter,

Thanks for the feed back.  I raised the question because I was trying to
find an less time consuming way to get quality GUI / web screens for use
with fp.  The version of our new ERP system is totally .net framework and
I really like the way it looks and feels.

I also like the 'grids' functions.  I would love to be able to incorporate
that in to filePro processing for my plant mgt software.

However, the use of SQL (MySQL or Microsoft SQL server) really defeats the
purpose (IMHO).  I don't want to use another data base as a bridge only
because fp has not progressed over the past 15 years, again IMHO.

I really like fp programming and don't want to relearn the wheel, as it
where, of a new database with vba, etc.  At this point I'll just stick to
using html screens.

Again thanks for the reply,

Rick Hane
Controller
Deluxe Stitching Company Inc
ISP Stitching Products
http://www.deluxestitcher.com/

________________________________
From: Walter Vaughan <wvaughan at steelerubber.com>
To: filePro <filepro-list at lists.celestial.com>
Sent: Thursday, July 19, 2012 4:05 PM
Subject: Re: fp and .net

Richard Hane wrote:

>I'd like to start a new thread.  May be short if not possible but let's
see.
>
>This would be mainly for those running fp on Windows.
>
>
okay

>
>Has anyone tried to use Microsoft's .net screens and grids with filePro?
>
>
I have data that has been created/managed with filepro and now is used
differently with a .net app

>
>Where you able to do so without using a SQL program?
>
>
No.

> What success did you have?
>
>
I just export/import as needed into SQL Server 2005

On the otherhand, you can use the filePro mySQL interface
http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface
.htm
and use mySQL as the data store. You can't use LinQ (I think), but from an
application standpoint its just a different connection string...

This looks exactly how I would do a connection to SQL Server 2005, 'cept
below is for mySQL

// Get the MySQL connection string stored in the Web.config string
cnnString = ConfigurationSettings.AppSettings["ConnectionString"];

// Create a connection object and data adapter MySqlConnection cnx = new
MySqlConnection(cnnString); MySqlDataAdapter adapter = new
MySqlDataAdapter();

// Create a SQL command object
string cmdText = "usp_Verse_GetList";
MySqlCommand cmd = new MySqlCommand(cmdText, cnx);

// Set the command type to StoredProcedure cmd.CommandType =
CommandType.StoredProcedure;

// Create and fill a DataSet
DataSet ds = new DataSet();
adapter.SelectCommand = cmd;
adapter.Fill(ds);

>
>If using .net as input screens how was the speed and flow with filePro?
>
>
>
Well a poorly written web page will be mangintudes harder and slower for
an end user.
Well a poorly written filepro screen will be magnitudes harder and slower
for an end user

I don't understand the question.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20120719/9
36e7e8a/attachment.html
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20120720/0
5f34bc3/attachment.html
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120720/9eaa9c3b/attachment.html 