61 Conversion to V803

Following is a document that Epicor Tech Support gave me to convert our
database from ISO to UTF



Summary: How to convert your database to Unicode

Book: Support Solutions

Page: 6152MPS



PROBLEM DESCRIPTION: I would like to change my database from standard
iso8859-1 to Unicode, How do I do that.





PROBLEM RESOLUTION: Use the Steps below to convert your database to
Unicode.



Prerequisites:

A) You will need a Proword.2 file. This file can be found in your

\Epicor\Mfgsys80\Db\Newdb folder. If one is not there, have Tech Support
email one to you. Put the file into the \Epicor\oelOOb folder



B) WARNING: Before you start either process, have a good backup
of your database.

"%DLC%" is where OpenEdge is installed example E:\epicor\oelOOb





1) Go to Start --> Programs --> OpenEdge 10B --> proenv



2) Type: prompt <enter>



3) Change to the directory where the database exists and run the
following commands in the database while in the database directory.



4) To convert your database, type: proutil mfgsys -C convchar
convert UTF-8



5) Apply the new word-rules to the database, type: proutil mfgsys
-C word-rules 2



6) Next open the properties of the Progress/OpenEdge Data
Adminstration Tool:

Go to: Start --> Programs --> OpenEdge 10B --> Data Administration
tool, right mouse click and select Properties.



You will need to add a -rx switch to the target line of the Data
Administration tool.



example:

E:\epicor\OE100B\bin\prowin32.exe -p




Save the changes.



7) Now bring up the Start --> Programs --> OpenEdge 10B --> Data
Administration tool



Go to: Admin --> Load Data and Definitions --> Data Definitions (.df)



Load the "_tran.df" file located in your \Epicor\OelOOb\Prolang\utf
folder.



8) Finally, rebuild the indexes. Type the command:



proutil mfgsys -C idxbuild -TB 32 -TM 32 -cpinternal UTF-8 Answer "a" for
ALL from the popup menu



Press "n" to the question: "Do you have enough disk space for index
sorting?"



9) Once the reindex is complete, make sure of the following:

- -> The Proword.2 file is in the \Epicor\OelOOb directory before you
restart.

- -> Verify in the \Epicor\OelOOb\Startup.pf <http://startup.pf/> file
the correct code page is entered.



Bottom section of the Startup.pf <http://startup.pf/> should look like:



- cpinternal utf-8

-cpstream utf-8

- cpcoll Basic -cpcase Basic -d mdy

-numsep 44

- numdec 46



10) Start the Database, login.





[Non-text portions of this message have been removed]
Has anyone out there been able to convert from 61 to 803?
What I would like to know is
1) How many of you were able to convert from 61 to 803 using the convert utility?
2) If you were able to convert how did you handle the Resource and Resource Group rate and the Method of Manufacturing problem?
3) Did you run into other problem when converting. Such as shop employees not being able to log onto MES etc?
4) How did you handle security? When I did the conversion my users security didn't follow all the way thru because if the new security setup.
5) Where you able to convert on a week-end or did it take you longer? When I did the conversion from 61 to 80 then to 803 it took me 3 days just to do the conversion process not counting updating everything else that need to be done. My database is around 7.5 gig in size.
6) If you didn't do the conversion thing how did you migrate from 61 to 803? Did you key in all the info? Where you able to update any files somehow without keying in?

We have been working to upgrade to 803 but have been running into all kind of problems and issues. If anyone out there was able to convert I would love to hear from them and compare notes on how some of these issue where handled.

Thank you
Have a Happy and Safe Holiday

Larry Barriere
barriere@...


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
Larry,
I am testing 8.03.
I converted my 6.1 to 8.0 without any problems. But I was not able to
convert from 8 to 8.03.
So, using the pilot db I pasted data from my 8.0 into 8.03. I was able
to copy into excel...clean up the stuff I
did not want to bring into 8.03 and paste insert into 8.03. I started
with Div - Dept - Chart tables
then loaded the chart of accounts Then I was able to finish the company
configuration.(on the accounting tabs)
I then did reason codes, part class, whse, bin, customer group, memo
category, quote markup, country, workforce,
sales tax category MiscCharge and prodGrup.
The paste insert can be applied anywhere that there is a list tab.
(assuming that the master tables are in place)
You CANNOT paste insert part numbers, customers, vendors.
I spoke to Epicor and there are conversion programs and services
available for $. Because we have been on vantage
since 1997, I am taking this opportunity to get rid of the crap in our
system.
I may decide to get some temps in here to load part numbers, customers
and vendors and active jobs/PO's/invoices.
Anyway, best luck in your migration.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Larry Barriere
Sent: Friday, December 22, 2006 9:47 AM
To: Vantage Group
Subject: [Vantage] 61 Conversion to V803



Has anyone out there been able to convert from 61 to 803?
What I would like to know is
1) How many of you were able to convert from 61 to 803 using the convert
utility?
2) If you were able to convert how did you handle the Resource and
Resource Group rate and the Method of Manufacturing problem?
3) Did you run into other problem when converting. Such as shop
employees not being able to log onto MES etc?
4) How did you handle security? When I did the conversion my users
security didn't follow all the way thru because if the new security
setup.
5) Where you able to convert on a week-end or did it take you longer?
When I did the conversion from 61 to 80 then to 803 it took me 3 days
just to do the conversion process not counting updating everything else
that need to be done. My database is around 7.5 gig in size.
6) If you didn't do the conversion thing how did you migrate from 61 to
803? Did you key in all the info? Where you able to update any files
somehow without keying in?

We have been working to upgrade to 803 but have been running into all
kind of problems and issues. If anyone out there was able to convert I
would love to hear from them and compare notes on how some of these
issue where handled.

Thank you
Have a Happy and Safe Holiday

Larry Barriere
barriere@... <mailto:barriere%40polyvac.com>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
You can always use macro programs like ground control to read your excel
spreadsheet or access table and key the information. I have clean up 2
companies that way. Good luck and happy holidays to the group.

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of PLAMAN DICK
Sent: Friday, December 22, 2006 9:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61 Conversion to V803



Larry,
I am testing 8.03.
I converted my 6.1 to 8.0 without any problems. But I was not able to
convert from 8 to 8.03.
So, using the pilot db I pasted data from my 8.0 into 8.03. I was able
to copy into excel...clean up the stuff I
did not want to bring into 8.03 and paste insert into 8.03. I started
with Div - Dept - Chart tables
then loaded the chart of accounts Then I was able to finish the company
configuration.(on the accounting tabs)
I then did reason codes, part class, whse, bin, customer group, memo
category, quote markup, country, workforce,
sales tax category MiscCharge and prodGrup.
The paste insert can be applied anywhere that there is a list tab.
(assuming that the master tables are in place)
You CANNOT paste insert part numbers, customers, vendors.
I spoke to Epicor and there are conversion programs and services
available for $. Because we have been on vantage
since 1997, I am taking this opportunity to get rid of the crap in our
system.
I may decide to get some temps in here to load part numbers, customers
and vendors and active jobs/PO's/invoices.
Anyway, best luck in your migration.



________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Larry Barriere
Sent: Friday, December 22, 2006 9:47 AM
To: Vantage Group
Subject: [Vantage] 61 Conversion to V803

Has anyone out there been able to convert from 61 to 803?
What I would like to know is
1) How many of you were able to convert from 61 to 803 using the convert
utility?
2) If you were able to convert how did you handle the Resource and
Resource Group rate and the Method of Manufacturing problem?
3) Did you run into other problem when converting. Such as shop
employees not being able to log onto MES etc?
4) How did you handle security? When I did the conversion my users
security didn't follow all the way thru because if the new security
setup.
5) Where you able to convert on a week-end or did it take you longer?
When I did the conversion from 61 to 80 then to 803 it took me 3 days
just to do the conversion process not counting updating everything else
that need to be done. My database is around 7.5 gig in size.
6) If you didn't do the conversion thing how did you migrate from 61 to
803? Did you key in all the info? Where you able to update any files
somehow without keying in?

We have been working to upgrade to 803 but have been running into all
kind of problems and issues. If anyone out there was able to convert I
would love to hear from them and compare notes on how some of these
issue where handled.

Thank you
Have a Happy and Safe Holiday

Larry Barriere
barriere@... <mailto:barriere%40polyvac.com>
<mailto:barriere%40polyvac.com>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com> <http://mail.yahoo.com
<http://mail.yahoo.com> >

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Dick wrote:
> You CANNOT paste insert part numbers, customers, vendors.
> I spoke to Epicor and there are conversion programs and services
> available for $. Because we have been on vantage
> since 1997, I am taking this opportunity to get rid of the crap in our
> system.

We were not on a previous version of Vantage but I keep hearing that people
who start from scratch do better than those who convert - FWIW.

> I may decide to get some temps in here to load part numbers, customers
> and vendors and active jobs/PO's/invoices.
> Anyway, best luck in your migration.

You CAN load parts from VB and business objects. If you do like Dick suggests,
export your part information into Access, SQL, Excel, whatever, you can then
read that file and write to Vantage. It will NOT run as fast as a conversion
program because you are running all of the same logic that the client does, so
keep that in mind.

Mark W.
We had issues upgrading our database from 8.00 to 8.03. This database
had been upgraded through the years from Vantage 3.2.



We found that the schema change would not run, due to the codepage not
being the latest one. We updated our DB to UTF-8 and it upgraded fine.



2.5GB database took about an hour (8.00 to 8.03)



Gary Parfrey



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Larry Barriere
Sent: 22 December 2006 14:47
To: Vantage Group
Subject: [Vantage] 61 Conversion to V803



Has anyone out there been able to convert from 61 to 803?
What I would like to know is
1) How many of you were able to convert from 61 to 803 using the convert
utility?
2) If you were able to convert how did you handle the Resource and
Resource Group rate and the Method of Manufacturing problem?
3) Did you run into other problem when converting. Such as shop
employees not being able to log onto MES etc?
4) How did you handle security? When I did the conversion my users
security didn't follow all the way thru because if the new security
setup.
5) Where you able to convert on a week-end or did it take you longer?
When I did the conversion from 61 to 80 then to 803 it took me 3 days
just to do the conversion process not counting updating everything else
that need to be done. My database is around 7.5 gig in size.
6) If you didn't do the conversion thing how did you migrate from 61 to
803? Did you key in all the info? Where you able to update any files
somehow without keying in?

We have been working to upgrade to 803 but have been running into all
kind of problems and issues. If anyone out there was able to convert I
would love to hear from them and compare notes on how some of these
issue where handled.

Thank you
Have a Happy and Safe Holiday

Larry Barriere
barriere@... <mailto:barriere%40polyvac.com>


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Gary,

We have the same problem with going from 8 to 8.03. How did you
update the DB from ISO8859-1 to UTF-8?

Thanks,

Doug Oswald
MIS
FLEETWOOD


--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> We had issues upgrading our database from 8.00 to 8.03. This
database
> had been upgraded through the years from Vantage 3.2.
>
>
>
> We found that the schema change would not run, due to the codepage
not
> being the latest one. We updated our DB to UTF-8 and it upgraded
fine.
>
>
>
> 2.5GB database took about an hour (8.00 to 8.03)
>
>
>
> Gary Parfrey
>
>
>
> ________________________________
> We have the same problem with going from 8 to 8.03. How did you
> update the DB from ISO8859-1 to UTF-8?

When I ran the "Install Manufacturing Systems Server" step, there was a prompt
after you enter you select "Progress on Windows". That is where you have the
choice for Unicode Selection. IIRC, there was settings that get added to your
mfgsys.pf file:

-cpinternal -utf-8 -cpstream -utf-8 -cprccodein -utf

I believe this created an empty database with the Unicode options and then the
backup/restore in Appendix C of the install guide does the actual data
conversion.

HTH,

Mark W.