07:DML
todd aron, senior developer, software development
taron at competitrack.com
Thu Jan 14 14:23:00 EST 2010
what Andy said... but... to get from here to there, we've done "quick
fix" on data files and the data in these slots have reappeared.
every year, before "downsizing," we run our ODFs to 15 segments. w/
network burps and other issues corrupting our data, we've done a fair
amount of datafile fixing. its embarrassing to say, but we've used
"quick fix" to save us waaaaaay too many times.
that said, i've spent time in the BTS dealing w/ others' ODFs, and with
it on several projects, and the thing which provides the most solid ODF
is the export and reimport into a clean ODF. (when i was in BTS, of
course, we NEVER recommended "quick fix.")
by-the-by, our ODF is now off of the appleshare server and onto our EMC
Cellera storage. we take snapshots every half hour, and have an
automated process check twice a day, sending an email confirmation to
developers. (we like email notifications. ALOT. and i have filters to
make sure the deserving make their way to the appropriate circular
folder.) we have had an instance where our ODF was so badly damaged, the
snapshot came in handy.
in my first project on my own (pre-notation, o7v1 days), we had several
sites. i sneakernetted the updates (categories) to the satellite sites
and (data) back. part of that was an export, which relied on a
create/most recently changed date, something in every file format. to do
this, i wrote a generic routine that exported all data for a time slice.
something like this can be automated to run to always have a backup.
depending on how much of your data gets changed and how often, this may
work for you. even if you don't have common naming schemes for your
columns, you can use a list w/ fields for file format name, key, and
date fields to accomplish this.
On 1/14/2010 12:41 PM, Andy Hilton wrote:
> Export and import in any event would be the safest here in my own experience - no matter whether you *can* resolve the multiple file names issue or not !
>
> Andy
>
> On Jan 14, 2010, at 12:28 PM, wizardcompserv at aol.com wrote:
>
>> hi all
>>
>> I am hoping someone can help me.
>>
>> I have a customer with a 6 segment database - they have been having some
>> problems so I have today got a copy of the database.
>>
>> By going through the software I can see the data and get at the information
>> but ..... if I do a Check data or Examine data file some of the file
>> names are repeated many times and a lot of the names are missing - is there a
>> way out of this - or am I in for a complete export and import?
>>
>> Many thanks for your help
>>
>> Regards
>> Wendy Osbaldestin
>> Wizard Computer Services
>> Tel: 01260271647
>> Mobile: 07740541021
>> Web Site: _www.wizardcompserv.co.uk_ (http://www.wizardcompserv.co.uk/)
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
--
be well,
todd
x106
todd ARON p 718.482.4206
Competitrack f 718.482.4286
36-36 33rd st, suite 501 <taron at competitrack.com>
long island city, NY 11106 <http://www.competitrack.com/>
-= Jonna Lea =-
<http://www.facebook.com/photo.php?pid=30811748&l=039c01f396&id=1427923354>
<http://www.facebook.com/album.php?aid=2043422&id=1427923354&l=e408eeee57>
<http://www.facebook.com/photo.php?pid=30833205&l=e795f020fc&id=1427923354>
-= recommended tools =-
diff tool: WinMerge
images: irfanview, faststone, and paintDotNet
text editor: Notepad++, EditPad Pro
moi:
<http://www.facebook.com/album.php?aid=2015465&id=1427923354&l=b7c6a>
fun:
<http://www.inventgeek.com/Projects/paintball-turret/overview.aspx>
<http://www.engadget.com/2008/01/16/meet-the-disintegrator-24-barrels-of-rubber-band-minigun-madnes/>
<http://www.engadget.com/2008/12/22/nerf-dart-gun-hacked-into-pulverizing-chaingun/>
<http://www.kevincyr.net/index.php?/project/camper-bike/>
More information about the omnisdev-en
mailing list