Accidentally deleted a few fax #'s.. anyway to get back?

yuppicide · 2010-12-30

Navision 3.10

I accidentally made a boo boo!

As you know I'm always looking to correct errors. I'm still going through and moving and removing wrong things on Customer Cards. For example, someone was putting excess spaces in random places, someone was writing email addresses in the website field, etc.

Well, today I was in Customer Quick Entry. I noticed a bunch of Fax No had extra spaces. As a test I pulled up every customer that started with M. I did a replace on "- " (has a space after the dash) to replace it with "-" (no space after dash). This replaced ALL the fax numbers with just a dash!

Luckily, that's all i did. I have Navision backed up on a tape drive nightly Mon - Fri. If there's a way I can get the file off the tape, is there a simple way I can get those back?

DenSter · 2010-12-30

A simple dataport should do the trick.

ara3n · 2010-12-30

You'll have to get them back from backup. Restore it in new db and export and import the data. The only transactional table that carries over the field is in Service Header.

Savatage · 2010-12-30

If you used the old Find->Replace - you have to make sure you're options are correctly set
See Pic - Replace Whole Field should be unchecked. This scares me too thats why for things like that I'll either test my find & replace on just one customer/vendor before unleashing it on the rest

But creating a space cleanup report using DELCHR I find it much easier to control.
NewString := DELCHR(String [, Where] [, Which])

OnAfterGetRecord()
"Vendor Fax No." := DELCHR("Vendor Fax No.",'=',' ');
MODIFY;

Accidentally deleted a few fax #'s.. anyway to get back?

Comments

Categories