RE: Conversions

2004-04-05 Thread Glenn W. Paschal
Behalf Of Mark Johnson Sent: Friday, April 02, 2004 10:05 PM To: U2 Users Discussion List Subject: Conversions Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from

Re: Conversions

2004-04-05 Thread Mark Johnson
To answer the other questions: I would gain ODBC access with MS Access to the Invoice Header/Line Tables, Customer and Product Tables. I would maintain in Access a table of those Invoices already converted. I would then create a CSV export of the new Invoices and current Customer/Product tables an

Re: Conversions

2004-04-04 Thread Mark Johnson
t;[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Sunday, April 04, 2004 12:55 PM Subject: Re: Conversions > Mark, > Technically Overview: >Using some sort of a schedule, you identify new and modified data > on the Great Pl

Re: Conversions

2004-04-04 Thread Results
Mark, Technically Overview: Using some sort of a schedule, you identify new and modified data on the Great Plains system, and move just that data to the MV system, converting the layout and data. That leaves you with the following discreet tasks: How do you identify new or mod

Re: Conversions

2004-04-04 Thread Mark Johnson
This sounds very tempting, using MV as a data warehouse to a non-MV (or MV) primary application. Does anyone else have any insight on how this flies, management-wise or technically. I like it as all of the original reports are already written and tested and it keeps the customer a MV customer. Th

RE: Conversions

2004-04-03 Thread djordan
Hi Mark I have one client that uses Great Plains. Although an old version I felt that the system was not as aligned to the work flow as many PICK systems are. There was also a trap similar to the old spreasheets in the report generator, where the calculations are directional ir verticle or horiz

RE: Conversions

2004-04-03 Thread Dawn M. Wolthuis
bject: Re: Conversions Thanks to all who have provide some good ideas. The conversion has occurred and is in the growing pains. Still a mistmatch but there's no going back. Perhaps I'll take this approach to learn Crystal Reports or MS Access reports. There are many previous reports and

Re: Conversions

2004-04-03 Thread Results
Mark, Tell them you are re-purposing the old MV system as a data warehouse as a cost savings measure. That they'll understand and hopefully appreciate. Then do what you suggested: One strange thought occurred to me that may not fly. Export all the sales/customer/product data back to the MV sy

Re: Conversions

2004-04-03 Thread Mark Johnson
ot; <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Saturday, April 03, 2004 9:50 AM Subject: RE: Conversions Mark -- I don't have experience with Great Plains, but can definitely sympathize with your situation. I have been on

Humour: was Re: Conversions

2004-04-03 Thread FFT2001
In a message dated 4/2/2004 10:06:39 PM Pacific Standard Time, [EMAIL PROTECTED] writes: > Tony, > Stupid question... If you and I built a company which was strictly > Hey my name's not Tony but if there's money involved you can call me anything you want. Will -- u2-users mailing list [

RE: Conversions

2004-04-03 Thread Dawn M. Wolthuis
Mark -- I don't have experience with Great Plains, but can definitely sympathize with your situation. I have been on both the technical and management side of such conversions. Given that it sounds like the decision has been made, money has been spent, and work has been done, you could tack

Re: Conversions

2004-04-02 Thread Clif Oliver
You mean to overlap with what Clifton Oliver & Associates, Information Management Advisors offers? No. I don't think that would work. No market. Bad idea. When do the consulting fee wars begin? On Apr 2, 2004, at 10:06 PM, Results wrote: Tony, Stupid question... If you and I built a compa

Re: Conversions

2004-04-02 Thread Clif Oliver
Smack him about the left side of his head, Tony. I've been using the right side for the last couple of days on the U2UG list hosting issues. That area is desensitized by now. -- Regards, Clif ps. Yes. Header munging has its problems. Don't start a war again now. Wait for the new list hosts t

Re: Conversions

2004-04-02 Thread Clif Oliver
Post? What post? I don't see no stinkin' post. On Apr 2, 2004, at 10:10 PM, Results wrote: Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2

RE: Conversions

2004-04-02 Thread Tony Gravagno
Smooth bro. Real smooth. Excuse us ladies and gentlemen as I escort our colleague out by his ear and smack him around a little. >Please IGNORE last post. It was meant to be private. I was meant to be >asleep. > >Sincerely, > Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://

Re: Conversions

2004-04-02 Thread Results
Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

2004-04-02 Thread Results
Tony, Stupid question... If you and I built a company which was strictly Business Process Consulting, Workflow Consulting, and Business Change Consulting, (i.e. no direct programming) do you see a way for us to market it successfully? It would expand our market and I believe we could both do

RE: Conversions

2004-04-02 Thread Tony Gravagno
o:[EMAIL PROTECTED] On Behalf Of Mark Johnson >Sent: Friday, April 02, 2004 8:05 PM >To: U2 Users Discussion List >Subject: Conversions > > >Does anyone have a short paper on the care and feeding of both >the company and its employees during a conversion/migration >from one sy

Re: Conversions

2004-04-02 Thread Results
Mark, As a Business Process Consultant (one of my hats), here's how I would approach it. 1. You are already moving in the correct direction by pointing up productivity loss, but you have to frame the argument correctly: 1. "We have implied and explicit deadlines in serving our

Conversions

2004-04-02 Thread Mark Johnson
Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and Re

Re: Universe Date Conversions Using the SQL.B.INTDATE

2004-02-05 Thread Ray Wurlod
IL PROTECTED]> Date: Wed, 04 Feb 2004 21:17:11 -0600 To: [EMAIL PROTECTED] Subject: Universe Date Conversions Using the SQL.B.INTDATE > I've been trying to get a date conversion to work for data being inserted > into a SQL/Server table with no success. When I use the SQL.

Universe Date Conversions Using the SQL.B.INTDATE

2004-02-04 Thread Mark Warner
I've been trying to get a date conversion to work for data being inserted into a SQL/Server table with no success. When I use the SQL.B.INTDATE and SQL.DATE parameters in the SQLBindParameter statement, I get the following error: Status for SQLExecute call is: -1 SQLSTATE,NATCOD are:S1C00 0