Slow entry when large number of ship to for a customer

system · April 26, 2011, 10:16am

Do you, by chance, have the ship to addresses formatted in a manner that the data could be updated by directly accessing the DB? If so, then a fairly straightforward .NET app can insert the records in a matter of seconds.

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On Apr 25, 2011, at 3:41 PM, DD wrote:

> The Ship To entry gets slower and slower the more ship to locations there are
> for a customer. This is a know issue with 8.03.407 up.
> They have decided that they are not going to fix the issue as it is fixed in
> 9.05.
> We have several customers that have thousands of ship to addresses.
>
> Has anyone done a service connect to create the ship to record? I am hoping that
> Service connect will bypass whatever the code is doing between fields (support
> said it was updating the tree - but every field not record?).
>
> Anyone done a service connect for ship to already and if so do you think it
> worked ok with large amounts of records already for the customer.
>
> Would you be willing to share it if you have one?
>
> Thanks for any suggestions.
> Doug
>
> PAGE: 5357ESC
> PROBLEM DESCRIPTION: When entering new ship to's for a customer with a large
> amount of ship to addresses; tabbing between fields takes an extraordinarily
> long time
> SCR 67818
>
> [Non-text portions of this message have been removed]
>
>

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

system · April 22, 2011, 11:51am

How have y'all handled attachments in Epicor when upgrading, specifically when switching to a new server? Epicor has such a goofy way of dealing with attachments, since you have to specify file associations internal to the application, rather than using the system file associations, and the attachments themselves are just linked out to the network somewhere.

Do you actually store your attachment in the UserData folder, or do you put them somewhere else?

system · April 22, 2011, 3:15pm

Right, so since it just stores the path to the attached file, what happens if/when you move all those files to a different server? How have you re-linked them? Our files currently are in such a poorly named location even to begin with...

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> See table XFileRef too...
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > As far as I know, Vantage just stores the path to the attached file.
> > Look at System Management, Company Management, External File Reference.
> >
> > --- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@> wrote:
> > >
> > > How have y'all handled attachments in Epicor when upgrading, specifically when switching to a new server? Epicor has such a goofy way of dealing with attachments, since you have to specify file associations internal to the application, rather than using the system file associations, and the attachments themselves are just linked out to the network somewhere.
> > >
> > > Do you actually store your attachment in the UserData folder, or do you put them somewhere else?
> > >
> >
>

system · April 22, 2011, 4:14pm

It's ugly and I am not even 100% sure it would work but it would be worth a
try in a test database.

First - I would use the MS Distributed File System(Service?) and setup a
network location to put them all.

Then, I believe all the references are stored in xfileref table, so you
could either do an SQL replacement, or possibly dump the xfileref table to
.d file as if doing a dump and load, and then change the base references
through a find\replace, then blank that table through SQL and do a re-load
of the data back into the table.

I know a lot of people setup the file references to a mapped drive, I always
find this to not be the smartest choice. If you use a DFS Location then you
can move it anywhere you want and just change the reference in Windows and
the end user and Epicor don't know the difference.

Unless specifically required by a program(bad program in the first place)
mapped drives should have stopped being used a long time ago from my POV for
any type of system wide user access.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cubcrafters_it
Sent: Friday, April 22, 2011 3:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Relinking/migrating attachments when upgrading
Epicor?

Right, so since it just stores the path to the attached file, what happens
if/when you move all those files to a different server? How have you
re-linked them? Our files currently are in such a poorly named location even
to begin with...

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> See table XFileRef too...
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > As far as I know, Vantage just stores the path to the attached file.
> > Look at System Management, Company Management, External File Reference.
> >
> > --- In vantage@yahoogroups.com, "cubcrafters_it" <jason.navarrete@>
wrote:
> > >
> > > How have y'all handled attachments in Epicor when upgrading,
specifically when switching to a new server? Epicor has such a goofy way of
dealing with attachments, since you have to specify file associations
internal to the application, rather than using the system file associations,
and the attachments themselves are just linked out to the network somewhere.
> > >
> > > Do you actually store your attachment in the UserData folder, or do
you put them somewhere else?
> > >
> >
>

------------------------------------

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/linksYahoo! Groups Links

system · April 22, 2011, 5:08pm

...

> Then, I believe all the references are stored in xfileref table, so you
> could either do an SQL replacement, or possibly dump the xfileref table to
> .d file as if doing a dump and load, and then change the base references
> through a find\replace, then blank that table through SQL and do a re-load
> of the data back into the table.

I actually wrote a program that uses business objects to change
locations. It's located in the C# section of this group.

http://tech.groups.yahoo.com/group/vantage/files/C%23/

It's called UpdateFileLocation.zip. You'll have to create a C# Project
using VisualStudio (any version including C# Express Edition) and make
sure the library references are set correctly, build or run from the
IDE. It has a "What If" mode and then prompts for the old starting
file reference and the new starting file reference. It also checks to
make sure the file exists in the new location.

It does a find to load the dataset and does a single update, so if you
have a lot of files it could take some time. I used this program to
learn the syntax of C# and if I were to do it again, I would break
updates up for every 1000 records or so.

Mark W.

system · April 25, 2011, 8:44am

While the DFS method will work, if you're not going to use the replication
features and such, I wouldn't mess with it.

Just create a new entry on your DNS server for epicorfiles.mydomain.com or
whatever suits you, and point it to the server that currently holds the
files. When you move the files to a new server in the future, just update
that DNS record and you're all set.

On Fri, Apr 22, 2011 at 5:08 PM, Mark Wonsil <mark_wonsil@...> wrote:

>
>
> ...
>
> > Then, I believe all the references are stored in xfileref table, so you
> > could either do an SQL replacement, or possibly dump the xfileref table
> to
> > .d file as if doing a dump and load, and then change the base references
> > through a find\replace, then blank that table through SQL and do a
> re-load
> > of the data back into the table.
>
> I actually wrote a program that uses business objects to change
> locations. It's located in the C# section of this group.
>
> http://tech.groups.yahoo.com/group/vantage/files/C%23/
>
> It's called UpdateFileLocation.zip. You'll have to create a C# Project
> using VisualStudio (any version including C# Express Edition) and make
> sure the library references are set correctly, build or run from the
> IDE. It has a "What If" mode and then prompts for the old starting
> file reference and the new starting file reference. It also checks to
> make sure the file exists in the new location.
>
> It does a find to load the dataset and does a single update, so if you
> have a lot of files it could take some time. I used this program to
> learn the syntax of C# and if I were to do it again, I would break
> updates up for every 1000 records or so.
>
> Mark W.
>
>
>

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

system · April 25, 2011, 11:32am

Sweet, good work Mark!

What version of Epicor did you originally create this for? Have you tried it with any other version since?

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> ...
> > Then, I believe all the references are stored in xfileref table, so you
> > could either do an SQL replacement, or possibly dump the xfileref table to
> > .d file as if doing a dump and load, and then change the base references
> > through a find\replace, then blank that table through SQL and do a re-load
> > of the data back into the table.
>
> I actually wrote a program that uses business objects to change
> locations. It's located in the C# section of this group.
>
> http://tech.groups.yahoo.com/group/vantage/files/C%23/
>
> It's called UpdateFileLocation.zip. You'll have to create a C# Project
> using VisualStudio (any version including C# Express Edition) and make
> sure the library references are set correctly, build or run from the
> IDE. It has a "What If" mode and then prompts for the old starting
> file reference and the new starting file reference. It also checks to
> make sure the file exists in the new location.
>
> It does a find to load the dataset and does a single update, so if you
> have a lot of files it could take some time. I used this program to
> learn the syntax of C# and if I were to do it again, I would break
> updates up for every 1000 records or so.
>
> Mark W.
>

system · April 25, 2011, 12:14pm

This was 9.04.504B. That's why it's important to relink your references for
each version. I didn't test for SharePoint links so that would be another
improvement.

Mark W.
On Apr 25, 2011 11:28 AM, "cubcrafters_it" <jason.navarrete@...>
wrote:

> Sweet, good work Mark!
>
> What version of Epicor did you originally create this for? Have you tried

it with any other version since?

>
> --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>>
>> ...
>> > Then, I believe all the references are stored in xfileref table, so you
>> > could either do an SQL replacement, or possibly dump the xfileref table

to

>> > .d file as if doing a dump and load, and then change the base

references

>> > through a find\replace, then blank that table through SQL and do a

re-load

>> > of the data back into the table.
>>
>> I actually wrote a program that uses business objects to change
>> locations. It's located in the C# section of this group.
>>
>> http://tech.groups.yahoo.com/group/vantage/files/C%23/
>>
>> It's called UpdateFileLocation.zip. You'll have to create a C# Project
>> using VisualStudio (any version including C# Express Edition) and make
>> sure the library references are set correctly, build or run from the
>> IDE. It has a "What If" mode and then prompts for the old starting
>> file reference and the new starting file reference. It also checks to
>> make sure the file exists in the new location.
>>
>> It does a find to load the dataset and does a single update, so if you
>> have a lot of files it could take some time. I used this program to
>> learn the syntax of C# and if I were to do it again, I would break
>> updates up for every 1000 records or so.
>>
>> Mark W.
>>
>
>

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

system · April 25, 2011, 6:41pm

The Ship To entry gets slower and slowerÂ the more ship to locations there are
for a customer. This is a know issue with 8.03.407 up.
They have decided that they are not going to fix the issue as it is fixed in
9.05.
We have several customers that have thousands of ship to addresses.

Has anyone done a service connect to create the ship to record? I am hoping that
Service connect will bypass whatever the code is doing between fields (support
said it was updating the tree - but every field not record?).

Anyone done a service connect for ship to already and if so do you think it
worked ok with large amounts of records already for the customer.

Would you be willing to share it if you have one?

Thanks for any suggestions.
Doug

PAGE:Â Â 5357ESC
Â PROBLEM DESCRIPTION: When entering new ship to's for a customer with a large
amount of ship to addresses; tabbing between fields takes an extraordinarily
long time
SCR 67818

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

system · April 26, 2011, 8:41am

I don't have a workflow, but Service Connect uses the Web Services which in
turn use the business objects and server back end logic which is what's
causing the slow down. Unfortunately I think you are out of luck on this
one.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Mon, Apr 25, 2011 at 6:41 PM, DD <ddavis4569@...> wrote:

>
>
> The Ship To entry gets slower and slower the more ship to locations there
> are
> for a customer. This is a know issue with 8.03.407 up.
> They have decided that they are not going to fix the issue as it is fixed
> in
> 9.05.
> We have several customers that have thousands of ship to addresses.
>
> Has anyone done a service connect to create the ship to record? I am hoping
> that
> Service connect will bypass whatever the code is doing between fields
> (support
> said it was updating the tree - but every field not record?).
>
> Anyone done a service connect for ship to already and if so do you think it
>
> worked ok with large amounts of records already for the customer.
>
> Would you be willing to share it if you have one?
>
> Thanks for any suggestions.
> Doug
>
> PAGE: 5357ESC
> PROBLEM DESCRIPTION: When entering new ship to's for a customer with a
> large
> amount of ship to addresses; tabbing between fields takes an
> extraordinarily
> long time
> SCR 67818
>
> [Non-text portions of this message have been removed]
>
>
>

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

system · April 26, 2011, 10:02am

I agree with Jose, the SC workflow won't be any faster than doing it by
hand. However, there's a huge difference to the end user, who isn't sitting
there with their screen frozen while entering new shipto's. SC won't get
it in any faster, but you'll likely have friendlier users.

Kevin

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, April 26, 2011 8:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Slow entry when large number of ship to for a
customer

I don't have a workflow, but Service Connect uses the Web Services which in
turn use the business objects and server back end logic which is what's
causing the slow down. Unfortunately I think you are out of luck on this
one.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Mon, Apr 25, 2011 at 6:41 PM, DD <ddavis4569@...> wrote:

>
>
> The Ship To entry gets slower and slower the more ship to locations there
> are
> for a customer. This is a know issue with 8.03.407 up.
> They have decided that they are not going to fix the issue as it is fixed
> in
> 9.05.
> We have several customers that have thousands of ship to addresses.
>
> Has anyone done a service connect to create the ship to record? I am
hoping
> that
> Service connect will bypass whatever the code is doing between fields
> (support
> said it was updating the tree - but every field not record?).
>
> Anyone done a service connect for ship to already and if so do you think
it
>
> worked ok with large amounts of records already for the customer.
>
> Would you be willing to share it if you have one?
>
> Thanks for any suggestions.
> Doug
>
> PAGE: 5357ESC
> PROBLEM DESCRIPTION: When entering new ship to's for a customer with a
> large
> amount of ship to addresses; tabbing between fields takes an
> extraordinarily
> long time
> SCR 67818
>
> [Non-text portions of this message have been removed]
>
>
>

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

------------------------------------

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/linksYahoo! Groups Links

system · April 26, 2011, 10:04am

An alternative method in 9.05, not sure if it exists in 8. There is a
separate "Customer Ship To Maintenance" screen that lets you add/modify
a single ship to address, without loading the entire customer record
with every single ship to address. We get to it via sales order entry,
right click in ship-to ID, open with -> customer ship to entry. We have
one customer with thousands of ship-to addresses, and this screen still
works quickly.

Brian.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of DD
Sent: Monday, April 25, 2011 6:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Slow entry when large number of ship to for a
customer

The Ship To entry gets slower and slower the more ship to locations
there are
for a customer. This is a know issue with 8.03.407 up.
They have decided that they are not going to fix the issue as it is
fixed in
9.05.
We have several customers that have thousands of ship to addresses.

Has anyone done a service connect to create the ship to record? I am
hoping that
Service connect will bypass whatever the code is doing between fields
(support
said it was updating the tree - but every field not record?).

Anyone done a service connect for ship to already and if so do you think
it
worked ok with large amounts of records already for the customer.

Would you be willing to share it if you have one?

Thanks for any suggestions.
Doug

PAGE: 5357ESC
PROBLEM DESCRIPTION: When entering new ship to's for a customer with a
large
amount of ship to addresses; tabbing between fields takes an
extraordinarily
long time
SCR 67818

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

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