Little utility - Beta testers wanted

[Legacy_Tarot Redhand]

               'Ware the grinning cat is back () or

Greetings and felicitations,

I have created a very small utility written in vb 2008. It requires the .net framework 3.5 in order to run.
It is called 2da-csv. It allows the following conversions -

• 2da to csv - converts a 2da file to a file containing comma seperated values
• csv to 2da - converts a csv file to a 2da file
• 2da to html - converts a 2da file to an html table viewable in any browser
• 2da to Tidy 2da - anyone who has looked in skyboxes.2da should find this useful
• 2da to xml

By using 1 & 2 above you can use any spreadsheet program to in effect, edit a 2da file using the power of the spreadsheet's editor to speed things up.

3 and 5 may be of use, but I'm not sure. I'm especially not sure if the xml output of 5 is well formed.

4 on the other hand can be very useful. What it does is to realign the columns of a 2da file such that there is a minimum columnar gap of 2 spaces between the items.

Anyway, if anyone is interested in looking at this little util, I have put it here in my public folder on dropbox. There is no install program, just the util itself contained in a 7zip archive.

Have fun

TR
               
               

               
            

[Legacy_Tarot Redhand]

               Oooops! Forgot to request that if you download it please let me know, even if you don't want to tell me what you think of it. It would be nice to know that I didn't waste my time writing it.

TR
               
               

               
            

[Legacy_Borden Haelven]

               I'll have a play with it for you. Probably breakit mind, bit clumsy that way lol.
               
               

               
            

[Legacy_OldTimeRadio]

               I downloaded it (sounds useful!) but I haven't had the time/cause to play with it yet.  Still, it's always a treat to see a new utility come out.
               
               

               
            

[Legacy_Tarot Redhand]

               Thanks guys, it's appreciated. Sorry about the lack of documentation at this stage, but as I said in the title it is only a beta. Also it's a lot better for someone to break it at this stage, than when it goes fully live with said documentation etc. Just a reminder, it absolutely needs the .net framework in order to operate.

Thanks again.

TR
               
               

               
            

[Legacy_Just a ghost]

               I also downloaded it, and I have some 2da stuff to do soon.
               
               

               
            

[Legacy_Lightfoot8]

               Does your VB have the option to compile to native code?

Compiling Your Project to Native Code
               
               

               
            

[Legacy_Tarot Redhand]

               The last time you could do a full compile to native code was with vb6. Since then all versions of vb have been evolving versions of vb.net i.e. a part of visual studio and not a separate entity. In vs 2008 (which is what I own a copy of) the only language (AFAIK) that has the ability to compile to native code is vc++.

TR
               
               

               

                     Modifié par Tarot Redhand, 23 août 2012 - 08:59 .
                     
                  

            

[Legacy_Invisig0th]

               I've downloaded it, and will test it out using multiple formats. I'll forward any feedback to you via PM.
               
               

               
            

[Legacy_Tarot Redhand]

               Thank you.
               
               

               
            

[Legacy_Just a ghost]

               I am getting this error when I press 'begin'. Doesn't really matter what option I choose. I try to deal with placebleas.2da, and it may have to do with me not bothering about the numbering of the lines. visualeffects, which is tidiier seems to work fine.

-------------------------------------------------------------------------------------------------------------

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: Queue empty.
  at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
  at System.Collections.Generic.Queue`1.Dequeue()
  at WindowsApplication1.cls2DA_File.Parse2daLine(String strCurrentLine)
  at WindowsApplication1.cls2DA_File.Read2daFile(String strFileName)
  at WindowsApplication1.frm2DAtoCSV.Convert2DAtoTidy2DA()
  at WindowsApplication1.frm2DAtoCSV.btnBegin_Click(Object sender, EventArgs e)
  at System.Windows.Forms.Control.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  at System.Windows.Forms.Button.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
2DA-CSV
   Assembly Version: 1.0.0.0
   Win32 Version: 1.0.0.0
   CodeBase: file:///C:/Users/Disco/Desktop/2DA-CSV.exe
----------------------------------------
Microsoft.VisualBasic
   Assembly Version: 8.0.0.0
   Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5456 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5460 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5462 (Win7SP1GDR.050727-5400)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Accessibility
   Assembly Version: 2.0.0.0
   Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
   CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
   <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

------------------------------------------------------------------------------------------------------

I have .NET 4 and 1.1.

A hint for the UI, though. I'd let people choose their file first, and then select the options. I was kinda worried that it would target some folder and start working all by itself.
               
               

               

                     Modifié par Just a ghost, 30 août 2012 - 09:20 .
                     
                  

            

[Legacy_Tarot Redhand]

               @Just a ghost - could you let me have a copy of the placeables.2da that is causing this problem. You have exposed a weakness in my error checking and I'd like to fix it by stepping through the code with the data that is causing the problem. Thanks.

TR
               
               

               
            

[Legacy_Just a ghost]

               http://www.amiaworld.../placeables.zip

There you go!
               
               

               
            

[Legacy_Tarot Redhand]

               OK, found the problem and hopefully fixed it. I have uploaded the 'fixed' version to my dropbox public folder here. What had happened was that I had assumed that all 2da files that it was given to work with would be whole. Unfortuneately that particular 2da is missing 2 columns of data from line 202 - 224 and appears to be broken from 202 - 233, as all these lines are missing line numbers. As I have designed it to ignore any data line that doesn't start with a number, this obviously presents problems.

2DA-CSV is not designed to be able to guess what you actually intended the 2da file to be eventually. It is designed so that if you want to edit a 2da file you 1st need to use it to convert the 2da to a csv file and edit that in a spreadsheet. Then save your edited file as a csv file and use 2da-csv to convert your edited file to a 2da file. Done this way, there will be no need to use 2DA-CSV to tidy the 2da file as it will have been automatically done anyway.

Thank you for the error report, as 2DA-CSV is now more robust. I hope my little explanation has been helpfull. If you find any more problems, do not hesitate to let me know.

Thank you for the UI suggestions, but I prefer it the way it is.

TR