Visual Studio Blank Title 84540

Yahoo Archive
1
We are building a console application for mass labor reporting (thermal
cutting applications where dozens of operations are 'nested' together.
They'll scan a Nest number and it queries vantage, finds associated
operations, then starts activity, and ends activities (via service
connect).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jen Triftshauser
Sent: Thursday, October 29, 2009 11:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Visual Studio





Thanks! That sounds somewhat similar to what we are trying to do.

What we want:

Run Cycle Count, export to Excel file (list of cycle count tags
w/pertinent information).
Upload this Excel file to a handheld via Active Sync.
Scan the barcodes for the required parts that are listed in the Excel
file. (The bar code information is being updated on the Excel sheet)
Then take the completed sheet and sync back to PC.
Then use Service Connect to put info back into Epicor.

We are doing all of this because we do not plan to install wireless in
our building. So essentially, we are using the handheld as a store and
forward.

Right now, we need an easy to use form for the people scanning. We would
like to have two options - (1) list of serialized parts - prompt for
serial number, (2) list of non-serialized parts - prompt for quantity.

I have someone trying to write a form in Excel, and I have someone
telling me I have to buy Visual Studio to accomplish this.

Would you recommend Visual Studio?
Anything to be concerned about with this software?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich " <bspolarich@...> wrote:
>
> Care to post those examples? :-)
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
/ Picometrix
> bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of bw2868bond
> Sent: Thursday, October 29, 2009 12:18 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Visual Studio
>
> I use VS2005 and have made a couple asp.net web front ends that accept
Excel sheets and perform various lookups against the db using the BOs.
The results are returned in a datagrid on the page and can then be
exported back to Excel at the click of a button.
>
> Example 1: A customer gives us a BOM with their part numbers on it. We
submit that BOM in Excel format to the web app and it then returns the
sheet with our P/Ns if they exist. Saves the engineering folk from
having to look up one by one and keeps from creating duplicates for
something that already exisits.
>
> Example 2: Customer gives us a list of open POs and wants a status
update. We submit list to web app and it returns our SO numbers (and
other data).
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Jen Triftshauser" <jennifertriftshauser@> wrote:
> >
> > Hi,
> >
> > Is anyone using Visual Studio with Epicor? If so, what are you using
it for and why?
> >
> > TIA,
> > Jennifer
> >
>
>
>
>
> ------------------------------------
>
> 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/.
<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
>





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

Is anyone using Visual Studio with Epicor? If so, what are you using it for and why?

TIA,
Jennifer
3
I use VS2005 and have made a couple asp.net web front ends that accept Excel sheets and perform various lookups against the db using the BOs. The results are returned in a datagrid on the page and can then be exported back to Excel at the click of a button.

Example 1: A customer gives us a BOM with their part numbers on it. We submit that BOM in Excel format to the web app and it then returns the sheet with our P/Ns if they exist. Saves the engineering folk from having to look up one by one and keeps from creating duplicates for something that already exisits.

Example 2: Customer gives us a list of open POs and wants a status update. We submit list to web app and it returns our SO numbers (and other data).

--- In vantage@yahoogroups.com, "Jen Triftshauser" <jennifertriftshauser@...> wrote:
>
> Hi,
>
> Is anyone using Visual Studio with Epicor? If so, what are you using it for and why?
>
> TIA,
> Jennifer
>
4
Care to post those examples? :-)

--
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 bw2868bond
Sent: Thursday, October 29, 2009 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Visual Studio

I use VS2005 and have made a couple asp.net web front ends that accept Excel sheets and perform various lookups against the db using the BOs. The results are returned in a datagrid on the page and can then be exported back to Excel at the click of a button.

Example 1: A customer gives us a BOM with their part numbers on it. We submit that BOM in Excel format to the web app and it then returns the sheet with our P/Ns if they exist. Saves the engineering folk from having to look up one by one and keeps from creating duplicates for something that already exisits.

Example 2: Customer gives us a list of open POs and wants a status update. We submit list to web app and it returns our SO numbers (and other data).

--- In vantage@yahoogroups.com, "Jen Triftshauser" <jennifertriftshauser@...> wrote:
>
> Hi,
>
> Is anyone using Visual Studio with Epicor? If so, what are you using it for and why?
>
> TIA,
> Jennifer
>




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

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
5
Thanks! That sounds somewhat similar to what we are trying to do.

What we want:

Run Cycle Count, export to Excel file (list of cycle count tags w/pertinent information).
Upload this Excel file to a handheld via Active Sync.
Scan the barcodes for the required parts that are listed in the Excel file. (The bar code information is being updated on the Excel sheet)
Then take the completed sheet and sync back to PC.
Then use Service Connect to put info back into Epicor.

We are doing all of this because we do not plan to install wireless in our building. So essentially, we are using the handheld as a store and forward.

Right now, we need an easy to use form for the people scanning. We would like to have two options - (1) list of serialized parts - prompt for serial number, (2) list of non-serialized parts - prompt for quantity.

I have someone trying to write a form in Excel, and I have someone telling me I have to buy Visual Studio to accomplish this.

Would you recommend Visual Studio?
Anything to be concerned about with this software?

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Care to post those examples? :-)
>
> --
> 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 bw2868bond
> Sent: Thursday, October 29, 2009 12:18 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Visual Studio
>
> I use VS2005 and have made a couple asp.net web front ends that accept Excel sheets and perform various lookups against the db using the BOs. The results are returned in a datagrid on the page and can then be exported back to Excel at the click of a button.
>
> Example 1: A customer gives us a BOM with their part numbers on it. We submit that BOM in Excel format to the web app and it then returns the sheet with our P/Ns if they exist. Saves the engineering folk from having to look up one by one and keeps from creating duplicates for something that already exisits.
>
> Example 2: Customer gives us a list of open POs and wants a status update. We submit list to web app and it returns our SO numbers (and other data).
>
> --- In vantage@yahoogroups.com, "Jen Triftshauser" <jennifertriftshauser@> wrote:
> >
> > Hi,
> >
> > Is anyone using Visual Studio with Epicor? If so, what are you using it for and why?
> >
> > TIA,
> > Jennifer
> >
>
>
>
>
> ------------------------------------
>
> 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
>
6
Jen,

Check out ASPRunner Pro.

http://www.xlinesoft.com/asprunnerpro/

I use it to make queries public to Vantage and non-Vantage users via an intranet webpage. It will do what you need and also, by default, it exports VERY easily to CSV, XLS, DOC, etc.

Download a free trial and test it out. It generates and compiles all the necessary ASP code for you and then just copy up the Output folder to a webserver and BINGO...... you're done.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jen Triftshauser
Sent: Thursday, October 29, 2009 12:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Visual Studio

Thanks! That sounds somewhat similar to what we are trying to do.

What we want:

Run Cycle Count, export to Excel file (list of cycle count tags w/pertinent information).
Upload this Excel file to a handheld via Active Sync.
Scan the barcodes for the required parts that are listed in the Excel file. (The bar code information is being updated on the Excel sheet)
Then take the completed sheet and sync back to PC.
Then use Service Connect to put info back into Epicor.

We are doing all of this because we do not plan to install wireless in our building. So essentially, we are using the handheld as a store and forward.

Right now, we need an easy to use form for the people scanning. We would like to have two options - (1) list of serialized parts - prompt for serial number, (2) list of non-serialized parts - prompt for quantity.

I have someone trying to write a form in Excel, and I have someone telling me I have to buy Visual Studio to accomplish this.

Would you recommend Visual Studio?
Anything to be concerned about with this software?

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Care to post those examples? :-)
>
> --
> 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 bw2868bond
> Sent: Thursday, October 29, 2009 12:18 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Visual Studio
>
> I use VS2005 and have made a couple asp.net web front ends that accept Excel sheets and perform various lookups against the db using the BOs. The results are returned in a datagrid on the page and can then be exported back to Excel at the click of a button.
>
> Example 1: A customer gives us a BOM with their part numbers on it. We submit that BOM in Excel format to the web app and it then returns the sheet with our P/Ns if they exist. Saves the engineering folk from having to look up one by one and keeps from creating duplicates for something that already exisits.
>
> Example 2: Customer gives us a list of open POs and wants a status update. We submit list to web app and it returns our SO numbers (and other data).
>
> --- In vantage@yahoogroups.com, "Jen Triftshauser" <jennifertriftshauser@> wrote:
> >
> > Hi,
> >
> > Is anyone using Visual Studio with Epicor? If so, what are you using it for and why?
> >
> > TIA,
> > Jennifer
> >
>
>
>
>
> ------------------------------------
>
> 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
>




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

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