Home > Archive > Clipper > June 2006 > Flexfile Memos
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Thomas Venus 2006-06-26, 7:55 am |
| Hi All,
one of my clients opened a DBF files that contained a flexfile
memofield with Excel and saved it with Excel.
The result is, that Excel changend the fieldtype from memo to char and
replaced the stored values with blanks.
Is there any chance to get back the connection between dbf-record und
dbv-file entry. The dbv-files itself is untouched.
Thanks for any help
Thomas
--
| |
| kevin smith 2006-06-26, 7:55 am |
| Does any chance do the individual "memos" contain an identifier that
would indicate the record that the memo is for (e.g. notes for an
account has that account number imbedded in it)? If so, you can low
level read the .DBV file and extract the text, and programmatically
rebuild the pointers by writing the text back to the MEMO field.
Since the pointers will be corrupt, make sure as you rebuild the
DBF/DBV link you start with a new .DBV, as you don't want to overwrite
the old text, since FlexFile will re-use empty space.
This can be a very messy process, so if you have it available to you, I
would recommend doing a tape restore of the .DBF/.DBV before the
pointers were lost (since all clients follow good backup procedures ;-)
| |
| Thomas Venus 2006-06-26, 7:55 am |
| Kevin,
thx for your answer.
It is what I was afraid of ;)
The Memos do not contain data that coulb be used to identify the
records. Just ordnary customer informations like : "is married, 2
children, prefers excpensive clothing...." and things like that.
He (my customer) does not have a backup. He must be one of those rare
cases that do not follow any backup strategy ;)
Thanks again
Thomas
| |
| AUGE_OHR 2006-06-26, 7:55 am |
| hi,
> He (my customer) does not have a backup. He must be one of those rare
> cases that do not follow any backup strategy ;)
.... so it will be a lot of work for you customer to enter all data again.
i woud NOT help him in any case ... this is the only way that your
customer will take care NOT to use a external Application on your
DBF database and corrupt it.
greetings by OHR
Jimmy
|
|
|
|
|