Conversion tool problems

Yahoo Archive
1
I haven't seen the screenshot yet but yes/no fields should be either 0
(zero) for no or -1 (negative 1) for yes. Might check your original
data. Still doesn't make sense why it would crash your source database.

Butch

________________________________

From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 09, 2004 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] conversion tool problems


Thanks for the reply.

I tried to import just the partopr table. It was going and then I got
an "insufficient disk space or write protection" error. I uploaded the
screenshot5.zip file to the group web site. It seems it is trying to
import into a yes/no field a 1.00000000000 or a 0.000000000000.

This is frustrating ...

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 09, 2004 11:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] conversion tool problems

I have imported all my tables without using any logic. I go straight
from the query to the mapping to the convert. Since you're crashing the
source database I would check into the connection and the query. Do you
get any results on the query tab? Are you getting any errors during the
conversion?

I would convert one table at a time and then check the errorlog.txt file
in the convtool directory. It is cryptic but may give you an idea where
to look.

Butch

________________________________

From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 09, 2004 5:52 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] conversion tool problems


6.00.521

Ok. I have the tool. I'm trying to import the 7 tables for part
definition (part, partwhse, partplant, plantwhse, partrev, partmtl,
partopr). I can see the data in the query. I don't have any logic
written. I have the tables mapped to an access database.

When I try to import the data, it crashes and destroys the test
database. That's ok. I just restore the database from last night's
backup.

But what am I doing wrong? Is the data incompatible and needs logic to
clean it up?

Please help!!

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[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 Sponsor


ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1298fd27c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1094830173/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=162288635>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[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 Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12939dol2/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1094835141/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=711982346>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]
2
6.00.521

Ok. I have the tool. I'm trying to import the 7 tables for part definition (part, partwhse, partplant, plantwhse, partrev, partmtl, partopr). I can see the data in the query. I don't have any logic written. I have the tables mapped to an access database.

When I try to import the data, it crashes and destroys the test database. That's ok. I just restore the database from last night's backup.

But what am I doing wrong? Is the data incompatible and needs logic to clean it up?

Please help!!

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]
3
I have imported all my tables without using any logic. I go straight
from the query to the mapping to the convert. Since you're crashing the
source database I would check into the connection and the query. Do you
get any results on the query tab? Are you getting any errors during the
conversion?

I would convert one table at a time and then check the errorlog.txt file
in the convtool directory. It is cryptic but may give you an idea where
to look.

Butch

________________________________

From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 09, 2004 5:52 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] conversion tool problems


6.00.521

Ok. I have the tool. I'm trying to import the 7 tables for part
definition (part, partwhse, partplant, plantwhse, partrev, partmtl,
partopr). I can see the data in the query. I don't have any logic
written. I have the tables mapped to an access database.

When I try to import the data, it crashes and destroys the test
database. That's ok. I just restore the database from last night's
backup.

But what am I doing wrong? Is the data incompatible and needs logic to
clean it up?

Please help!!

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[Non-text portions of this message have been removed]
4
Thanks for the reply.

I tried to import just the partopr table. It was going and then I got an "insufficient disk space or write protection" error. I uploaded the screenshot5.zip file to the group web site. It seems it is trying to import into a yes/no field a 1.00000000000 or a 0.000000000000.

This is frustrating ...

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Thursday, September 09, 2004 11:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] conversion tool problems

I have imported all my tables without using any logic. I go straight
from the query to the mapping to the convert. Since you're crashing the
source database I would check into the connection and the query. Do you
get any results on the query tab? Are you getting any errors during the
conversion?

I would convert one table at a time and then check the errorlog.txt file
in the convtool directory. It is cryptic but may give you an idea where
to look.

Butch

________________________________

From: Tyira Eric [mailto:eric.tyira@...]
Sent: Thursday, September 09, 2004 5:52 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] conversion tool problems


6.00.521

Ok. I have the tool. I'm trying to import the 7 tables for part
definition (part, partwhse, partplant, plantwhse, partrev, partmtl,
partopr). I can see the data in the query. I don't have any logic
written. I have the tables mapped to an access database.

When I try to import the data, it crashes and destroys the test
database. That's ok. I just restore the database from last night's
backup.

But what am I doing wrong? Is the data incompatible and needs logic to
clean it up?

Please help!!

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...



[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 Sponsor


ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1298fd27c/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1094830173/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=162288635>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.


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