next »

[solgajazz]

Nice program, got it working without a hitch.  Now what do I do with the output files?   /me a db nub

[Xyphos]

Depends on "output file" you refer to.

"*.XRDB4" are raw extracts of the database, compressed with a gzip alogrithrim and each record has a modified header.
it is from these files, that the plugins will parse the data from.

data parsed depends on which plugin you use, or you can design your own plugin in VB.NET 2008+

[solgajazz]

XRDB4_Plugins-XMLOutput_18-02-02-00_FULL.xml is the name of the output file and is 197mb in size.  How do i shrink it down to the normal 2.8mb sql file?

[Xyphos]

XRDB4_Plugins-XMLOutput_18-02-02-00_FULL.xml is the name of the output file and is 197mb in size.  How do i shrink it down to the normal 2.8mb sql file?

2 versions exist, FULL and mini
FULL versions are created when you don't compare data files eg, old vs new
mini versions are created when you do compare data files.

mini versions like they suggest are much smaller xml's cuz they only contain what has changed.

[petteyg359]

Downloaded 4.6.1, and ran it. It extracted with no errors. When I click the "parse" button it immediately crashes. Have XML plugin selected.

An unhandled exception of type 'System.BadImageFormatException' occurred in mscorlib.dll

Additional information: Could not load file or assembly 'System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

00000158  lea         rcx,[rbx+68h]
0000015c  mov         rdx,qword ptr [rsp+00000090h]
00000164  call        FFFFFFFFFFF90810
00000169  mov         rax,qword ptr [rdi+10h]
0000016d  mov         rdx,qword ptr [rdi+18h]
00000171  mov         rcx,qword ptr [rax+8]
00000175  call        qword ptr [rax+18h]
00000178  nop             
00000179  add         rsp,0A8h
00000180  pop         rdi 
00000181  pop         rbx 
00000182  rep ret         

[Vhab]

Guessing here, you have a 64bit OS?

[petteyg359]

Guessing here, you have a 64bit OS?

The crash was in Vista 64-bit. Usually using Linux and wine, but am having trouble getting .NET to install in order to attempt using XRDB from wine. Trying to set up a VM with XP, now.

EDIT: Tried it in mono. It says "Invalid AO directory" whether I select the Windows install of AO or the wine install. Also, it won't exit (I have to kill -9 the mono process) :p

[Vhab]

Xyphos: Change "target platform" in your project settings to "x86" (or 32-bit, forgot what it's labelled) to ensure the application always runs in 32-bit mode, even on 64bit.

To get .net on wine, use winetricks

[petteyg359]

I'm using Crossover Games, don't want to mess it up with winetricks. Haven't tried in a plain wine, yet. It worked fine in VMware using XP, I've got my XML file now

[Xyphos]

Xyphos: Change "target platform" in your project settings to "x86" (or 32-bit, forgot what it's labelled) to ensure the application always runs in 32-bit mode, even on 64bit.

To get .net on wine, use winetricks

Done. an oddity of sorts it somehow got switched over to AnyCPU by mistake.
v4.7.0 is released and forced to run under Active(x86) mode.

[Prodigy007]

It would be nice to export to sql the very same information output to xml if you could help me figure that out in its entirety.

[Prodigy007]

Im guessing this isnt a feature your willing to help me figure out. Im not good with vb. I had wished maybe this tiny section could be added to the plugins file.

[Xyphos]

you don't have to code the plugin with VB; you can use C# also

just add a reference to XRDB4-Extras.dll, create a new class inheriting XRDB4_Extras.Plugin
and implicitly implement the plugin interface

in the ExtractRecords method, have it return an array of XRDB4_Extras.ExtractRecordDictionary.ExtractRecord;
indicating what records you want extracted. the other routines are for parsing data.