Importing price lists, 6.1

I would seriously consider buying Macro Express ($30 or $40). You could
make a csv file with the part number and updated price. Macro Express would
parse the csv, assign variables and "type" all the appropriate Vantage
commands. Fast and ensures Vantage business logic is followed. We use it
to run reports at night and other repetitive tasks.


David Gartner
EPG Companies Inc.


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mitchell Kirby
Sent: Thursday, January 04, 2007 10:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Importing price lists, 6.1



I have the price list import working correctly. I think I will update the
sales price in the part file by hand. Thanks for the information about the
Data Conversion Tool. My guess is the time to change 1500 parts will be
less than the cost of the software from Epicor.

Sincerely,

Mitchell Kirby

Riten Industries, Inc.

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

740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
stephenscotney
Sent: Thursday, January 04, 2007 10:51 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Importing price lists, 6.1

We have just run a price increase on 23,542 parts using Epicor's Data
Conversion Tool.

It took a while to get it running right last year but I was able to
update the prices in 15mins from stopping the DB to restarting.

Hope this helps

Steve

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Steve
Lee" <slee@...> wrote:
>
> Mitchell
>
> I ran into this same problem while doing our conversion. It
appears
> EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
> does. We downloaded Open Office from openoffice.org and used the
calc
> program (similar to EXCEL) and it works fine. I also understand MS
> ACCESS will perform this task correctly unlike EXCEL, but I have
not
> used Access for this.
>
> Hope this helps.
>
> Steve Lee
> ASC1, Inc.
>
> >
> > To clarify this a little. The part numbers I have in my pricing
> spreadsheet
> > are formatted as numeric. Even if I format them as text the ""
> doesn't
> > carry over when you convert the file. The price list import is
> looking for
> > "12102" not a 12102.
> >
> >
> >
> > How can I convert 1500 part numbers easily?
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten <http://www.riten.com/> com/>
com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> > _____
> >
> > From: Mitchell Kirby [mailto:m.kirby@...]
> > Sent: Tuesday, January 02, 2007 4:49 PM
> > To: 'vantage@yahoogroup <mailto:%27vantage%40yahoogroups.com> s.com'
> > Subject: Importing price lists, 6.1
> >
> >
> >
> > I vaguely remember doing this several years ago. I exported the
> file into
> > excel to review the format. I tweaked my pricing spreadsheet and
> saved it
> > as a .csv file. That didn't work. I opened the exported .txt
file
> and
> > compared it to my .csv file. The text file had quotes around the
> text. I
> > can edit my file to add the quotes easily enough except for our
part
> > numbers. We use numeric part numbers. Excel will format a 12102
> part
> > number as text but is doesn't convert to "12102", which is the
> format I need
> > to import. How do I easily get the double quotes around 1,500
> numeric part
> > numbers?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten <http://www.riten.com/> com/>
com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> Steve Lee
> ASC1, Inc.
> 608-241-6805
>

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







[Non-text portions of this message have been removed]
I vaguely remember doing this several years ago. I exported the file into
excel to review the format. I tweaked my pricing spreadsheet and saved it
as a .csv file. That didn't work. I opened the exported .txt file and
compared it to my .csv file. The text file had quotes around the text. I
can edit my file to add the quotes easily enough except for our part
numbers. We use numeric part numbers. Excel will format a 12102 part
number as text but is doesn't convert to "12102", which is the format I need
to import. How do I easily get the double quotes around 1,500 numeric part
numbers?



Any help would be greatly appreciated.



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX





[Non-text portions of this message have been removed]
To clarify this a little. The part numbers I have in my pricing spreadsheet
are formatted as numeric. Even if I format them as text the "" doesn't
carry over when you convert the file. The price list import is looking for
"12102" not a 12102.



How can I convert 1500 part numbers easily?



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Tuesday, January 02, 2007 4:49 PM
To: 'vantage@yahoogroups.com'
Subject: Importing price lists, 6.1



I vaguely remember doing this several years ago. I exported the file into
excel to review the format. I tweaked my pricing spreadsheet and saved it
as a .csv file. That didn't work. I opened the exported .txt file and
compared it to my .csv file. The text file had quotes around the text. I
can edit my file to add the quotes easily enough except for our part
numbers. We use numeric part numbers. Excel will format a 12102 part
number as text but is doesn't convert to "12102", which is the format I need
to import. How do I easily get the double quotes around 1,500 numeric part
numbers?



Any help would be greatly appreciated.



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX





[Non-text portions of this message have been removed]
I don't know if it's the best way, but in Excel you could try creating a
new column with a formula to add the quotes around the part # then
autofill your formula down, then past special value on top of your
original part#.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mitchell Kirby
Sent: Tuesday, January 02, 2007 4:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing price lists, 6.1

I vaguely remember doing this several years ago. I exported the file
into
excel to review the format. I tweaked my pricing spreadsheet and saved
it
as a .csv file. That didn't work. I opened the exported .txt file and
compared it to my .csv file. The text file had quotes around the text.
I
can edit my file to add the quotes easily enough except for our part
numbers. We use numeric part numbers. Excel will format a 12102 part
number as text but is doesn't convert to "12102", which is the format I
need
to import. How do I easily get the double quotes around 1,500 numeric
part
numbers?



Any help would be greatly appreciated.



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX





[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/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
Mitchell

I ran into this same problem while doing our conversion. It appears
EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
does. We downloaded Open Office from openoffice.org and used the calc
program (similar to EXCEL) and it works fine. I also understand MS
ACCESS will perform this task correctly unlike EXCEL, but I have not
used Access for this.

Hope this helps.

Steve Lee
ASC1, Inc.

>
> To clarify this a little. The part numbers I have in my pricing
spreadsheet
> are formatted as numeric. Even if I format them as text the ""
doesn't
> carry over when you convert the file. The price list import is
looking for
> "12102" not a 12102.
>
>
>
> How can I convert 1500 part numbers easily?
>
>
>
> Sincerely,
>
>
>
> Mitchell Kirby
>
> Riten Industries, Inc.
>
> <http://www.riten.com/> www.riten.com
>
>
>
> 740-333-8719 Direct
>
> 800-338-0027 Sales
>
> 800-338-0717 FAX
>
> _____
>
> From: Mitchell Kirby [mailto:m.kirby@...]
> Sent: Tuesday, January 02, 2007 4:49 PM
> To: 'vantage@yahoogroups.com'
> Subject: Importing price lists, 6.1
>
>
>
> I vaguely remember doing this several years ago. I exported the
file into
> excel to review the format. I tweaked my pricing spreadsheet and
saved it
> as a .csv file. That didn't work. I opened the exported .txt file
and
> compared it to my .csv file. The text file had quotes around the
text. I
> can edit my file to add the quotes easily enough except for our part
> numbers. We use numeric part numbers. Excel will format a 12102
part
> number as text but is doesn't convert to "12102", which is the
format I need
> to import. How do I easily get the double quotes around 1,500
numeric part
> numbers?
>
>
>
> Any help would be greatly appreciated.
>
>
>
> Sincerely,
>
>
>
> Mitchell Kirby
>
> Riten Industries, Inc.
>
> <http://www.riten.com/> www.riten.com
>
>
>
> 740-333-8719 Direct
>
> 800-338-0027 Sales
>
> 800-338-0717 FAX
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>


Steve Lee
ASC1, Inc.
608-241-6805
In my experience with Excel, if you have the numeric data in Excel
and want to format it to be treated as text for a CSV file, the
easiest way is:

Step 1 go to an unused column, and enter the following formula
(assume numbers in col A beginning in cell A1):

="'"&A1&"'"

Step 2 copy the formula down the entire new column.

Step 3 format the entire new column as text.

Step 4 convert all the formulas in new column to values.

Step 5 copy the new column over the old column and delete the new
column. (you can combine steps 4 and 5 if you like)

Step 6 delete new column

Then save as CSV. This will give you your data surrounded with
single quotes. If you really need the double quotes as the
deliminator, just do a search and replace (Ctrl-H) in Excel on the
data and replace the singles with doubles.

--- In vantage@yahoogroups.com, "Steve Lee" <slee@...> wrote:
>
> Mitchell
>
> I ran into this same problem while doing our conversion. It
appears
> EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
> does. We downloaded Open Office from openoffice.org and used the
calc
> program (similar to EXCEL) and it works fine. I also understand
MS
> ACCESS will perform this task correctly unlike EXCEL, but I have
not
> used Access for this.
>
> Hope this helps.
>
> Steve Lee
> ASC1, Inc.
>
> >
> > To clarify this a little. The part numbers I have in my pricing
> spreadsheet
> > are formatted as numeric. Even if I format them as text the ""
> doesn't
> > carry over when you convert the file. The price list import is
> looking for
> > "12102" not a 12102.
> >
> >
> >
> > How can I convert 1500 part numbers easily?
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten.com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> > _____
> >
> > From: Mitchell Kirby [mailto:m.kirby@...]
> > Sent: Tuesday, January 02, 2007 4:49 PM
> > To: 'vantage@yahoogroups.com'
> > Subject: Importing price lists, 6.1
> >
> >
> >
> > I vaguely remember doing this several years ago. I exported the
> file into
> > excel to review the format. I tweaked my pricing spreadsheet
and
> saved it
> > as a .csv file. That didn't work. I opened the exported .txt
file
> and
> > compared it to my .csv file. The text file had quotes around
the
> text. I
> > can edit my file to add the quotes easily enough except for our
part
> > numbers. We use numeric part numbers. Excel will format a
12102
> part
> > number as text but is doesn't convert to "12102", which is the
> format I need
> > to import. How do I easily get the double quotes around 1,500
> numeric part
> > numbers?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten.com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> Steve Lee
> ASC1, Inc.
> 608-241-6805
>
Thanks for your help, the formula worked. I still had to edit the file in
notepad, but the replace feature made that easy to do.



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
patrick.weaver
Sent: Wednesday, January 03, 2007 12:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Importing price lists, 6.1



In my experience with Excel, if you have the numeric data in Excel
and want to format it to be treated as text for a CSV file, the
easiest way is:

Step 1 go to an unused column, and enter the following formula
(assume numbers in col A beginning in cell A1):

="'"&A1&"'"

Step 2 copy the formula down the entire new column.

Step 3 format the entire new column as text.

Step 4 convert all the formulas in new column to values.

Step 5 copy the new column over the old column and delete the new
column. (you can combine steps 4 and 5 if you like)

Step 6 delete new column

Then save as CSV. This will give you your data surrounded with
single quotes. If you really need the double quotes as the
deliminator, just do a search and replace (Ctrl-H) in Excel on the
data and replace the singles with doubles.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Steve
Lee" <slee@...> wrote:
>
> Mitchell
>
> I ran into this same problem while doing our conversion. It
appears
> EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
> does. We downloaded Open Office from openoffice.org and used the
calc
> program (similar to EXCEL) and it works fine. I also understand
MS
> ACCESS will perform this task correctly unlike EXCEL, but I have
not
> used Access for this.
>
> Hope this helps.
>
> Steve Lee
> ASC1, Inc.
>
> >
> > To clarify this a little. The part numbers I have in my pricing
> spreadsheet
> > are formatted as numeric. Even if I format them as text the ""
> doesn't
> > carry over when you convert the file. The price list import is
> looking for
> > "12102" not a 12102.
> >
> >
> >
> > How can I convert 1500 part numbers easily?
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten.com/> com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> > _____
> >
> > From: Mitchell Kirby [mailto:m.kirby@...]
> > Sent: Tuesday, January 02, 2007 4:49 PM
> > To: 'vantage@yahoogroup <mailto:%27vantage%40yahoogroups.com> s.com'
> > Subject: Importing price lists, 6.1
> >
> >
> >
> > I vaguely remember doing this several years ago. I exported the
> file into
> > excel to review the format. I tweaked my pricing spreadsheet
and
> saved it
> > as a .csv file. That didn't work. I opened the exported .txt
file
> and
> > compared it to my .csv file. The text file had quotes around
the
> text. I
> > can edit my file to add the quotes easily enough except for our
part
> > numbers. We use numeric part numbers. Excel will format a
12102
> part
> > number as text but is doesn't convert to "12102", which is the
> format I need
> > to import. How do I easily get the double quotes around 1,500
> numeric part
> > numbers?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten.com/> com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> Steve Lee
> ASC1, Inc.
> 608-241-6805
>





[Non-text portions of this message have been removed]
We have just run a price increase on 23,542 parts using Epicor's Data
Conversion Tool.

It took a while to get it running right last year but I was able to
update the prices in 15mins from stopping the DB to restarting.

Hope this helps

Steve

--- In vantage@yahoogroups.com, "Steve Lee" <slee@...> wrote:
>
> Mitchell
>
> I ran into this same problem while doing our conversion. It
appears
> EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
> does. We downloaded Open Office from openoffice.org and used the
calc
> program (similar to EXCEL) and it works fine. I also understand MS
> ACCESS will perform this task correctly unlike EXCEL, but I have
not
> used Access for this.
>
> Hope this helps.
>
> Steve Lee
> ASC1, Inc.
>
> >
> > To clarify this a little. The part numbers I have in my pricing
> spreadsheet
> > are formatted as numeric. Even if I format them as text the ""
> doesn't
> > carry over when you convert the file. The price list import is
> looking for
> > "12102" not a 12102.
> >
> >
> >
> > How can I convert 1500 part numbers easily?
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten.com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> > _____
> >
> > From: Mitchell Kirby [mailto:m.kirby@...]
> > Sent: Tuesday, January 02, 2007 4:49 PM
> > To: 'vantage@yahoogroups.com'
> > Subject: Importing price lists, 6.1
> >
> >
> >
> > I vaguely remember doing this several years ago. I exported the
> file into
> > excel to review the format. I tweaked my pricing spreadsheet and
> saved it
> > as a .csv file. That didn't work. I opened the exported .txt
file
> and
> > compared it to my .csv file. The text file had quotes around the
> text. I
> > can edit my file to add the quotes easily enough except for our
part
> > numbers. We use numeric part numbers. Excel will format a 12102
> part
> > number as text but is doesn't convert to "12102", which is the
> format I need
> > to import. How do I easily get the double quotes around 1,500
> numeric part
> > numbers?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten.com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> Steve Lee
> ASC1, Inc.
> 608-241-6805
>
I have the price list import working correctly. I think I will update the
sales price in the part file by hand. Thanks for the information about the
Data Conversion Tool. My guess is the time to change 1500 parts will be
less than the cost of the software from Epicor.



Sincerely,



Mitchell Kirby

Riten Industries, Inc.

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



740-333-8719 Direct

800-338-0027 Sales

800-338-0717 FAX

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
stephenscotney
Sent: Thursday, January 04, 2007 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Importing price lists, 6.1



We have just run a price increase on 23,542 parts using Epicor's Data
Conversion Tool.

It took a while to get it running right last year but I was able to
update the prices in 15mins from stopping the DB to restarting.

Hope this helps

Steve

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Steve
Lee" <slee@...> wrote:
>
> Mitchell
>
> I ran into this same problem while doing our conversion. It
appears
> EXCEL puts add'd ""QUOTES"" on CSV files - I don't know why but it
> does. We downloaded Open Office from openoffice.org and used the
calc
> program (similar to EXCEL) and it works fine. I also understand MS
> ACCESS will perform this task correctly unlike EXCEL, but I have
not
> used Access for this.
>
> Hope this helps.
>
> Steve Lee
> ASC1, Inc.
>
> >
> > To clarify this a little. The part numbers I have in my pricing
> spreadsheet
> > are formatted as numeric. Even if I format them as text the ""
> doesn't
> > carry over when you convert the file. The price list import is
> looking for
> > "12102" not a 12102.
> >
> >
> >
> > How can I convert 1500 part numbers easily?
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten.com/> com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> > _____
> >
> > From: Mitchell Kirby [mailto:m.kirby@...]
> > Sent: Tuesday, January 02, 2007 4:49 PM
> > To: 'vantage@yahoogroup <mailto:%27vantage%40yahoogroups.com> s.com'
> > Subject: Importing price lists, 6.1
> >
> >
> >
> > I vaguely remember doing this several years ago. I exported the
> file into
> > excel to review the format. I tweaked my pricing spreadsheet and
> saved it
> > as a .csv file. That didn't work. I opened the exported .txt
file
> and
> > compared it to my .csv file. The text file had quotes around the
> text. I
> > can edit my file to add the quotes easily enough except for our
part
> > numbers. We use numeric part numbers. Excel will format a 12102
> part
> > number as text but is doesn't convert to "12102", which is the
> format I need
> > to import. How do I easily get the double quotes around 1,500
> numeric part
> > numbers?
> >
> >
> >
> > Any help would be greatly appreciated.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Mitchell Kirby
> >
> > Riten Industries, Inc.
> >
> > <http://www.riten <http://www.riten.com/> com/> www.riten.com
> >
> >
> >
> > 740-333-8719 Direct
> >
> > 800-338-0027 Sales
> >
> > 800-338-0717 FAX
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> Steve Lee
> ASC1, Inc.
> 608-241-6805
>





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