thank
live date editing
Started by ypf1258, Dec 13 2004 01:05 AM
4 replies to this topic
#1
ypf1258
-
- Moderators
-
- 101 posts
Advanced Member
- Gender:Male
- Location:ny
Posted 13 December 2004 - 01:05 AM
Hi I have been trying to fix something in mom I opened the cust dbf & started playing around and In error I deleted the cust dbf so I restored it from a back up but was not up to date how can I put back the data I tried using dbuwin but when I load back the cust dbf mom tells me invalid index how can I create a new index outside mom so mom should accept it
thank
thank
#2
zelik
-
- Members
-
- 13 posts
Member
Posted 13 December 2004 - 12:27 PM
Backup and delete CUST.CDX in the MOM directory and reload MOM. It should fix that problem.
#3
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 13 December 2004 - 01:49 PM
Yikes,
The solution was easy until you tried your backup idea...
If you delete a record in a foxpro table the record is still there, it is only marked for deletion. If you go into dbuwin and select the option of viewing all records you will see the record you deleted. Only after you pack and ZAP the table are the records gone.
At this point you need to delete the cust.cdx file. Now by opening MOM you will trigger a new index to be created. I doubt your customer's order and invoice history have been deleted so you will have to manually enter the info into your CUST.DBF table and hope you can make a match.
If you need help recovering data email me and I will try and help.
Cheers,
David
The solution was easy until you tried your backup idea...
If you delete a record in a foxpro table the record is still there, it is only marked for deletion. If you go into dbuwin and select the option of viewing all records you will see the record you deleted. Only after you pack and ZAP the table are the records gone.
At this point you need to delete the cust.cdx file. Now by opening MOM you will trigger a new index to be created. I doubt your customer's order and invoice history have been deleted so you will have to manually enter the info into your CUST.DBF table and hope you can make a match.
If you need help recovering data email me and I will try and help.
Cheers,
David
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
#4
ypf1258
-
- Moderators
-
- 101 posts
Advanced Member
- Gender:Male
- Location:ny
Posted 14 December 2004 - 11:27 PM
Thanks for your response
But I found an solution before the replies came
By creating a new dbf file & putting in all the inf. I needed
Then I opened dbuwin & the cust dbf & did "append from file" and it works like a jiffy
P.S. David I need some rr templates from you
But I found an solution before the replies came
By creating a new dbf file & putting in all the inf. I needed
Then I opened dbuwin & the cust dbf & did "append from file" and it works like a jiffy
P.S. David I need some rr templates from you
#5
Guest_Guest_*
Guest_Guest_*
-
- Guests
Posted 17 December 2004 - 10:03 AM
deleting the CDX would have worked fine.
2 user(s) are reading this topic
0 members, 2 guests, 0 anonymous users
