Importing methods from another company

Yahoo Archive
1
That is essentially what I was planning to do. So far I have been
successful in the test database and will be doing some more trial runs
with the actual part lists that we need changed before I do this to
the live data. (over the weekend after a fresh backup, just in case...)

Here's my procedures:
1. Connect to the database via Access.
2. Open the PartRev table and filter by desired part number(s).
3. Highlight entries, copy and paste into Excel.
4. Rename Company field in Excel and copy back to clipboard.
5. Do a paste append in Access.
6. Repeat steps three through five using the PartOpr and PartMtl tables.

This leaves all of the original data intact and adds the extra records
needed to import methods from within the new company.

Thanks for your help.
John Mahala
I.S. Manager
KRB Machinery


--- In vantage@yahoogroups.com, "lonniedrew" <lonniedrew@...> wrote:
>
> I think you are on the right track. What I would do is not just move
> from one company to another, but copy from one to the other. You do
> not want to lose traceability and data integrity in the original
> company.
>
> Try exporting the records to text, changing the company fields,
> creating new blank records in the DB, then importing to fill. Check
> out the Progress export and import commands, and practice from Live
> to Test. It can be done.
>
> HTH
> Lonnie
>
>
>
> --- In vantage@yahoogroups.com, "John Mahala" <john@> wrote:
> >
> > We are running three different companies within our Vantage Database
> > and would like to begin manufacturing a number of parts within a
> > different company. However, there is no way to import the existing
> > methods in KRB (the main company) to KIM. Or is there?
> >
> > I was able to access the test database directly and by changing the
> > company record in the PartRev, PartMtl and PartOpr tables, I was
> able
> > to successfully import the necessary information. So far no
> > repurcussions that I have seen but I realize that it is our test
> > database. And I would be appending the new records to the database,
> > not modifying the existing part information. Either way I am still
> > rather apprehensive about doing that to our live data.
> >
> > So my question is this: any advice on how to proceed? I haven't
> > heard back from Epicor's custom programming yet, and I feel that
> they
> > wouldn't be able to have a solution for us quick enough anyway. Has
> > anyone else had this problem and was able to overcome it?
> >
> > John Mahala
> > I.S. Manager
> > KRB Machinery
> >
>
2
We are running three different companies within our Vantage Database
and would like to begin manufacturing a number of parts within a
different company. However, there is no way to import the existing
methods in KRB (the main company) to KIM. Or is there?

I was able to access the test database directly and by changing the
company record in the PartRev, PartMtl and PartOpr tables, I was able
to successfully import the necessary information. So far no
repurcussions that I have seen but I realize that it is our test
database. And I would be appending the new records to the database,
not modifying the existing part information. Either way I am still
rather apprehensive about doing that to our live data.

So my question is this: any advice on how to proceed? I haven't
heard back from Epicor's custom programming yet, and I feel that they
wouldn't be able to have a solution for us quick enough anyway. Has
anyone else had this problem and was able to overcome it?

John Mahala
I.S. Manager
KRB Machinery
3
Check with your CAM about Pervasive. They have partnerd with Epicor to move data between databases.


Kevin Kadamus
Due of IT
-----Original Message-----
From: "John Mahala" <john@...>
Date: Fri, 03 Feb 2006 17:11:01
To:vantage@yahoogroups.com
Subject: [Vantage] Importing methods from another company

We are running three different companies within our Vantage Database
and would like to begin manufacturing a number of parts within a
different company. However, there is no way to import the existing
methods in KRB (the main company) to KIM. Or is there?

I was able to access the test database directly and by changing the
company record in the PartRev, PartMtl and PartOpr tables, I was able
to successfully import the necessary information. So far no
repurcussions that I have seen but I realize that it is our test
database. And I would be appending the new records to the database,
not modifying the existing part information. Either way I am still
rather apprehensive about doing that to our live data.

So my question is this: any advice on how to proceed? I haven't
heard back from Epicor's custom programming yet, and I feel that they
wouldn't be able to have a solution for us quick enough anyway. Has
anyone else had this problem and was able to overcome it?

John Mahala
I.S. Manager
KRB Machinery





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links








BlackBerry service provided by Nextel
4
I think you are on the right track. What I would do is not just move
from one company to another, but copy from one to the other. You do
not want to lose traceability and data integrity in the original
company.

Try exporting the records to text, changing the company fields,
creating new blank records in the DB, then importing to fill. Check
out the Progress export and import commands, and practice from Live
to Test. It can be done.

HTH
Lonnie



--- In vantage@yahoogroups.com, "John Mahala" <john@...> wrote:
>
> We are running three different companies within our Vantage Database
> and would like to begin manufacturing a number of parts within a
> different company. However, there is no way to import the existing
> methods in KRB (the main company) to KIM. Or is there?
>
> I was able to access the test database directly and by changing the
> company record in the PartRev, PartMtl and PartOpr tables, I was
able
> to successfully import the necessary information. So far no
> repurcussions that I have seen but I realize that it is our test
> database. And I would be appending the new records to the database,
> not modifying the existing part information. Either way I am still
> rather apprehensive about doing that to our live data.
>
> So my question is this: any advice on how to proceed? I haven't
> heard back from Epicor's custom programming yet, and I feel that
they
> wouldn't be able to have a solution for us quick enough anyway. Has
> anyone else had this problem and was able to overcome it?
>
> John Mahala
> I.S. Manager
> KRB Machinery
>