I found it in the step 3 of 3 for importing txt. Thank you for your help.
Sorry to bother.
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
-----Original Message-----
From: Amy MacKay [mailto:amackay@...]
Sent: Monday, June 03, 2002 5:37 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Digest Number 1897
You can't format the cells ahead of time, b/c it just overwrites the file
(first export to txt, then save as xls OR get external data within xls).
You can't change the text once it's in the xls file. The cell has already
deleted the leading zero.
Reference simple report attached.
19. Report Builder Export - Cutting off leading zeros
From: "Amy MacKay" <amackay@...>
20. RE: Report Builder Export - Cutting off leading zeros
From: "Malcolm Spann" <Malcolm@...>
21. RE: Report Builder Export - Cutting off leading zeros
From: "Giallombardo, Ed" <egiallombardo@...>
________________________________________________________________________
________________________________________________________________________
Message: 19
Date: Mon, 3 Jun 2002 15:29:02 -0400
From: "Amy MacKay" <amackay@...>
Subject: Report Builder Export - Cutting off leading zeros
Can someone tell me a way around this problem? I'm using the Report Builder
"Export" function (open RB, click on "Report", "Export"). This function
exports the information I need into Excel, but it cuts off leading zeros for
fields that are all numeric. For example, if my part number is "00930156",
I get a part number exported as "930156". But if my part number has
alphabetic characters, such as "00930156A", I would get the correct part
number exported. Any thoughts? Thank you.
Amy
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
________________________________________________________________________
________________________________________________________________________
Message: 20
Date: Mon, 3 Jun 2002 12:35:56 -0700
From: "Malcolm Spann" <Malcolm@...>
Subject: RE: Report Builder Export - Cutting off leading zeros
Amy,
It's not in the way Report Builder exports it, it's in the way Excel imports
it. You need to tell Excel that the column is 'text' or 'general', not
numeric.
Malcolm Spann
MIS
Malmberg Engineering
Malcolm@...
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
________________________________________________________________________
________________________________________________________________________
Message: 21
Date: Mon, 3 Jun 2002 14:55:17 -0500
From: "Giallombardo, Ed" <egiallombardo@...>
Subject: RE: Report Builder Export - Cutting off leading zeros
You could try converting the numeric fields to text using a calculated field
with the function:
STRING(NumericField)
This will force all your part numbers to come across as text and so Excel
should not cut off the leading zeros.
If that doesn't work you could also try formatting the cells as text within
Excel.
- Ed
-----Original Message-----
From: Amy MacKay [mailto:amackay@...]
Sent: Monday, June 03, 2002 2:29 PM
To: 'Egroup'
Subject: [Vantage] Report Builder Export - Cutting off leading zeros
Can someone tell me a way around this problem? I'm using the Report Builder
"Export" function (open RB, click on "Report", "Export"). This function
exports the information I need into Excel, but it cuts off leading zeros for
fields that are all numeric. For example, if my part number is "00930156",
I get a part number exported as "930156". But if my part number has
alphabetic characters, such as "00930156A", I would get the correct part
number exported. Any thoughts? Thank you.
Amy
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 22
Date: Mon, 03 Jun 2002 19:56:56 -0000
From: "meco_inc_paris" <admin@...>
Subject: Anyone use a product called Double Take
I am looking at ways to provide disaster recovery in the event our
server is taken out
Aka Manufacturing firm and the IT Room is unlocked - Go Figure
Anyway I am looking at putting in a second server for redundency and
found this software called Double Take by Sunbelt Software
Here is the info and the URL
Double-Take provides real-time (and open file) data protection,
reducing downtime for Windows NT and 2000 networks. It is an industry
leading "two-in-one" type of product as it provides both High
Availability and Disaster Recovery.
http://www.sunbelt-software.com/product.cfm?id=111
Anybody have any experience using this?
Thanks
James Piper - Systems Administrator
MECO, Inc
2121 S. Main St
Paris, IL 61944
(217) 465-7575 ext 201
Fax (217) 465-5230
Email: admin@...
________________________________________________________________________
________________________________________________________________________
Message: 23
Date: Mon, 03 Jun 2002 19:58:21 -0000
From: "meco_inc_paris" <admin@...>
Subject: Re: NORTON ANTI-VIRUS
YES
As long as the end useres remember
Sorry to bother.
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
-----Original Message-----
From: Amy MacKay [mailto:amackay@...]
Sent: Monday, June 03, 2002 5:37 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Digest Number 1897
You can't format the cells ahead of time, b/c it just overwrites the file
(first export to txt, then save as xls OR get external data within xls).
You can't change the text once it's in the xls file. The cell has already
deleted the leading zero.
Reference simple report attached.
19. Report Builder Export - Cutting off leading zeros
From: "Amy MacKay" <amackay@...>
20. RE: Report Builder Export - Cutting off leading zeros
From: "Malcolm Spann" <Malcolm@...>
21. RE: Report Builder Export - Cutting off leading zeros
From: "Giallombardo, Ed" <egiallombardo@...>
________________________________________________________________________
________________________________________________________________________
Message: 19
Date: Mon, 3 Jun 2002 15:29:02 -0400
From: "Amy MacKay" <amackay@...>
Subject: Report Builder Export - Cutting off leading zeros
Can someone tell me a way around this problem? I'm using the Report Builder
"Export" function (open RB, click on "Report", "Export"). This function
exports the information I need into Excel, but it cuts off leading zeros for
fields that are all numeric. For example, if my part number is "00930156",
I get a part number exported as "930156". But if my part number has
alphabetic characters, such as "00930156A", I would get the correct part
number exported. Any thoughts? Thank you.
Amy
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
________________________________________________________________________
________________________________________________________________________
Message: 20
Date: Mon, 3 Jun 2002 12:35:56 -0700
From: "Malcolm Spann" <Malcolm@...>
Subject: RE: Report Builder Export - Cutting off leading zeros
Amy,
It's not in the way Report Builder exports it, it's in the way Excel imports
it. You need to tell Excel that the column is 'text' or 'general', not
numeric.
Malcolm Spann
MIS
Malmberg Engineering
Malcolm@...
> -----Original Message-----http://groups.yahoo.com/group/vantage/messages
> From: Amy MacKay [mailto:amackay@...]
> Sent: Monday, June 03, 2002 12:29 PM
> To: 'Egroup'
> Subject: [Vantage] Report Builder Export - Cutting off leading zeros
>
>
> Can someone tell me a way around this problem? I'm using the
> Report Builder
> "Export" function (open RB, click on "Report", "Export").
> This function
> exports the information I need into Excel, but it cuts off
> leading zeros for
> fields that are all numeric. For example, if my part number
> is "00930156",
> I get a part number exported as "930156". But if my part number has
> alphabetic characters, such as "00930156A", I would get the
> correct part
> number exported. Any thoughts? Thank you.
>
> Amy
>
>
> Amy T. MacKay
> Engineering Manager
> Parkinson Technologies
> amackay@...
> (p) 401-762-2100 x 324
> (f) 401-762-2295
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Tied to your PC? Cut Loose and
> Stay connected with Yahoo! Mobile
> http://us.click.yahoo.com/QBCcSD/o1CEAA/sXBHAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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:
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
________________________________________________________________________
________________________________________________________________________
Message: 21
Date: Mon, 3 Jun 2002 14:55:17 -0500
From: "Giallombardo, Ed" <egiallombardo@...>
Subject: RE: Report Builder Export - Cutting off leading zeros
You could try converting the numeric fields to text using a calculated field
with the function:
STRING(NumericField)
This will force all your part numbers to come across as text and so Excel
should not cut off the leading zeros.
If that doesn't work you could also try formatting the cells as text within
Excel.
- Ed
-----Original Message-----
From: Amy MacKay [mailto:amackay@...]
Sent: Monday, June 03, 2002 2:29 PM
To: 'Egroup'
Subject: [Vantage] Report Builder Export - Cutting off leading zeros
Can someone tell me a way around this problem? I'm using the Report Builder
"Export" function (open RB, click on "Report", "Export"). This function
exports the information I need into Excel, but it cuts off leading zeros for
fields that are all numeric. For example, if my part number is "00930156",
I get a part number exported as "930156". But if my part number has
alphabetic characters, such as "00930156A", I would get the correct part
number exported. Any thoughts? Thank you.
Amy
Amy T. MacKay
Engineering Manager
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Message: 22
Date: Mon, 03 Jun 2002 19:56:56 -0000
From: "meco_inc_paris" <admin@...>
Subject: Anyone use a product called Double Take
I am looking at ways to provide disaster recovery in the event our
server is taken out
Aka Manufacturing firm and the IT Room is unlocked - Go Figure
Anyway I am looking at putting in a second server for redundency and
found this software called Double Take by Sunbelt Software
Here is the info and the URL
Double-Take provides real-time (and open file) data protection,
reducing downtime for Windows NT and 2000 networks. It is an industry
leading "two-in-one" type of product as it provides both High
Availability and Disaster Recovery.
http://www.sunbelt-software.com/product.cfm?id=111
Anybody have any experience using this?
Thanks
James Piper - Systems Administrator
MECO, Inc
2121 S. Main St
Paris, IL 61944
(217) 465-7575 ext 201
Fax (217) 465-5230
Email: admin@...
________________________________________________________________________
________________________________________________________________________
Message: 23
Date: Mon, 03 Jun 2002 19:58:21 -0000
From: "meco_inc_paris" <admin@...>
Subject: Re: NORTON ANTI-VIRUS
YES
As long as the end useres remember
--- In vantage@y..., Lydia Coffman <lcoffman@c...> wrote:
> So, your clients leave their computers on 24-7?
>
> Lydia
> Canyon Engineering Products, Inc.
>
> -----Original Message-----
> From: meco_inc_paris [mailto:admin@m...]
> Sent: Friday, May 31, 2002 11:23 AM
> To: vantage@y...
> Subject: [Vantage] Re: NORTON ANTI-VIRUS
>
> This is our configuration and it runs quite well
> We have Norton Corporate installed on the same server as Vantage
> (Actually on a seperate partition)
> NAV goes out every night and checks & if necessary, grabs the
latest
> virus definitions
> Then performs a virus sweep on the whole network (AKA Server Drives
> and Clients PC's) at 3am
>
> On the client side we have chosen to exclude any heavily used
network
> drives such as the Vantage drives
>
>
> Many a time I have come in and first thing on my PC is a warning
that
> a virus was found, virus name, client's name etc
>
> This works VERY Well for us
>
> Hope this helps
>
> James Piper - Systems Administrator
> MECO, Inc
> 2121 S. Main St
> Paris, IL 61944
> (217) 465-7575 ext 201
> Fax (217) 465-5230
> Email: admin@m...
>
>
>
>
> --- In vantage@y..., Fausto Filippi <ffilippi@n...> wrote:
> > I am going to install Norton Anti-Virus Corporate Edition on my
> Vantage 5.1
> > Server running Windows 2000. What directories should be excluded
> from the
> > daily scan?
> >
> > Thanks,
> >
> > Fausto
> >
> >
> >
> >
> > [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
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
________________________________________________________________________
________________________________________________________________________
Message: 24
Date: Mon, 03 Jun 2002 16:31:27 -0400
From: Wayne Cox <wmc20@...>
Subject: VNC (was: OT - License Control Software for Terminal)
>VNC is great. I use it to work on most workstations here. And of course,
>free. And easy to use. Search on VNC - I can't remember the web site.
There are a couple versions of VNC floating around now. AT&T U.K. that
originated it seems to have stopped doing any upgrades.
An enhanced spin-off "Tight VNC" added data compression and some other
optimizations to improve performance over slow and/or high latency links
like modems or some WAN connections. The original VNC is great on a LAN,
but woefully slow on a dial-up connection (unlike PCAW). Tight VNC may
have also fallen into stagnation.
Probably the best one is "Tridia VNC" -- I believe it incorporates all the
Tight VNC optimizations, plus many of its own. The company behind it still
offers it for free (have to per the GPL on the original) but would like you
to purchase the "Pro" version that has on line help, documentation, and
tech support.
Tridia is at www.tridiavnc.com or just Google for any of the other flavors.
-Wayne Cox
Twenty Three - Information Technology Consulting
828-685-2338
________________________________________________________________________
________________________________________________________________________
Message: 25
Date: Mon, 3 Jun 2002 15:19:14 -0500
From: Todd Anderson <tanderson@...>
Subject: RE: Anyone use a product called Double Take
You can also check out "SurviveIT" from CA.
I've looked at both and my preliminary gut instinct is that Double-Take is
the better of the two products. It does cost more then CA's solution but
I've come to believe that CA products, in general, only "Sort of" work.
That's not good enough in my book for server replication.
Note that both of these products can suck up a significant amount of network
bandwidth and you will need an extra set of "licenses" for the second server
in some cases. ( Read: Any MS product - ie if you are replicating an
Exchange server you will need a second copy of Exchange since it is
"Installed" on both servers - even though only one is active at any given
moment. ) I'm not sure about Progress/Vantage ???
Also, you cannot replicate a PDC or BDC. If you have Vantage, Exchange, etc
installed on stand alone servers that are NOT domain controllers then you
can replicate them.
Todd Anderson
-----Original Message-----
From: meco_inc_paris [mailto:admin@...]
Sent: Monday, June 03, 2002 2:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Anyone use a product called Double Take
I am looking at ways to provide disaster recovery in the event our
server is taken out
Aka Manufacturing firm and the IT Room is unlocked - Go Figure
Anyway I am looking at putting in a second server for redundency and
found this software called Double Take by Sunbelt Software
Here is the info and the URL
Double-Take provides real-time (and open file) data protection,
reducing downtime for Windows NT and 2000 networks. It is an industry
leading "two-in-one" type of product as it provides both High
Availability and Disaster Recovery.
http://www.sunbelt-software.com/product.cfm?id=111
<http://www.sunbelt-software.com/product.cfm?id=111>
Anybody have any experience using this?
Thanks
James Piper - Systems Administrator
MECO, Inc
2121 S. Main St
Paris, IL 61944
(217) 465-7575 ext 201
Fax (217) 465-5230
Email: admin@...
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
________________________________________________________________________
________________________________________________________________________
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/