Excel Look up Blank Title 80695

Within the Configurator we've had good luck using the .csv look-ups.

--- On Tue, 7/21/09, Paul E. Millsaps <paulm@...> wrote:


From: Paul E. Millsaps <paulm@...>
Subject: RE: [Vantage] Excel Look up
To: vantage@yahoogroups.com
Date: Tuesday, July 21, 2009, 3:48 PM


Â



I know on Configurator usage we had a real performance hit when trying
to do the excel lookups when we first started. We eventually went to
csv file lookups instead.


Paul Millsaps
Time Manufacturing
254.399.2170
paulm@timemfg. com <mailto:paulm@timemfg. com>

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient.

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of gmack110256
Sent: Tuesday, July 21, 2009 2:37 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Excel Look up

Sorry I didn't word this right Yesterday. What I am trying to find out
is if anyone has a code example on how to use the excel lookup function
that is in Vantage. (I have the spreadsheet all set to use but can't
seem to get Vantage to pull anything in from it).

Do We have to have excel on the server to get this to work or just on
the local machines?

Thank You
Gene

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



















[Non-text portions of this message have been removed]
Sorry I didn't word this right Yesterday. What I am trying to find out is if anyone has a code example on how to use the excel lookup function that is in Vantage. (I have the spreadsheet all set to use but can't seem to get Vantage to pull anything in from it).

Do We have to have excel on the server to get this to work or just on the local machines?

Thank You
Gene
Gene, what is it you're trying to accomplish specifically and what tools are you using?

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gmack110256
Sent: Tuesday, July 21, 2009 3:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Excel Look up

Sorry I didn't word this right Yesterday. What I am trying to find out is if anyone has a code example on how to use the excel lookup function that is in Vantage. (I have the spreadsheet all set to use but can't seem to get Vantage to pull anything in from it).

Do We have to have excel on the server to get this to work or just on the local machines?

Thank You
Gene




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

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
Hi Gene,

> Sorry I didn't word this right Yesterday. What I am trying to
> find out is if anyone has a code example on how to use the
> excel lookup function that is in Vantage. (I have the
> spreadsheet all set to use but can't seem to get Vantage to
> pull anything in from it).
>
> Do We have to have excel on the server to get this to work or just on
> the local machines?

I have been warned by other PC gurus out here to avoid Excel Lookup. The
performance is terrible. Go ahead and maintain the Excel file but export it
as a delimited text file and use the text file lookup functions provided by
Epicor.

Mark W.
I know on Configurator usage we had a real performance hit when trying
to do the excel lookups when we first started. We eventually went to
csv file lookups instead.


Paul Millsaps
Time Manufacturing
254.399.2170
paulm@... <mailto:paulm@...>

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of gmack110256
Sent: Tuesday, July 21, 2009 2:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Excel Look up




Sorry I didn't word this right Yesterday. What I am trying to find out
is if anyone has a code example on how to use the excel lookup function
that is in Vantage. (I have the spreadsheet all set to use but can't
seem to get Vantage to pull anything in from it).

Do We have to have excel on the server to get this to work or just on
the local machines?

Thank You
Gene






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