merzak-x / simplexml

SimpleXML is a simple, easy to use Simple non complex XML, XLSX, XLS & CSV Documents manipulation program.

SimpleXML

SimpleXML is a simple, easy to use Simple non complex XML, XLSX, XLS & CSV Documents manipulation program.

SimpleXML-GUI

A simple XML, XLSX, XLS & CSV Documents & database tables reader that displays the result to a table DataGridView, allowing the user to easily manipulate the simple Document and export it to either one of those file formats or to an existing database table.

Screenshots

Currently supported DBMS : Microsoft SQL Server

Future support : Oracle Database

simplexml's Issues

Save new XML Doc

Change !readOnly.Checked || !newXmlDoc to !readOnly.Checked && !newXmlDoc in XML-GUI.cs@80

Copy/Paste Keys

Add copy/paste support for rows & cells based on user preferences under edit.

Duplicate Exit Dialog

Duplicate Exit Dialog caused by Application.Exit() call.

UI Resize-ability

@Yassine-Ag, please redesign the UI ASAP, I'll try to fix what I can ...

Validate column/entity name

Validate column & entity name, if they're valid names (not containing special chars).

NewTable Dialog

NewTable Dialog should have a fixed size, and unable to be resized.

Close Form

Closing Form without closing its child

Current open XML Document

Display current open file name in the form.title

Open Document MessageBox

When opening an invalid XML Document, the MessageBox displays the XmlGUI_DragDrop_wrongXmlExt_msg &! XmlGUI_Open_wrongXmlExt_msg.

@Yassine-Ag TODO List

@Yassine-Ag your TODO list here:

• Add function to test the SQL Connection
• Test and finish the XML2DB->export2DB() / XML2DB->importDB() / XML-GUI->Conn-DB
  (Which is just a basic display of the DB table contents to the DataGridView)
• Redesign the UI @MERZAK-X did
• Handel Exceptions
• A Database connection Form (that returns DataSet through a public member function) that opens a new XML-GUI Form using a new Constructor XmlGUI(DataSet ds)

Please be aware that although I tried using Windows10 with a bootable USB Drive, I wasn't able to install MS-SQL server and its components, this is why I opened #2

Entity name transmission

New table generates ExceptionBuilder.CanNotSerializeDataTableWithEmptyName when saving, caused by entityName@NewTable::class@:58, value not passed properly.

Import from database

Importing from database imports wrong table sometimes.

Success export message

Add Success message after exporting a file successfully

Close child forms

Child forms OwnedForms shall be closed and not disposed if parent form closes.

Use Threads for new forms

Using Threads for new Forms fixes #19

Export PK Violation

Exporting a table that has existing database primary keys, throws a PK violation SQLException.

Escaping Strings

Use SecurityElement.Escape(str) instead of Regex.Escape(str).

Export to XLS

Implement full Excel sheets support.

Dialog Forms

Open Dialog forms as form.ShowDialog(parent), and not as independent Threads.

Disable control

Disable control buttons when no XML Document is loaded

Edit cell

Add an Insert mode under edit to allow the user to edit a cell when selected.

Export CSV Sheet

Ability to Export data to CSV sheet

Redesign the UI

@Yassine-Ag, please update the UI design, and replace the Tool Strip Menu by a Ribbon Control.

Export: CSV Sheet Content

The CSV cell content is not escaped, which corrupts the CSV Sheet.

Save file

Saving files after #47, could cause file corruption for CSV and XLSX sometimes.

Add Ctrl+S hotkey

Add hotkey to save current XML Document #4

Export empty table

Disallow exporting an empty table under File->Export->toDB@Main, by checking its columns/rows.

Import from Database

Importing from Database is now under test phase.

Save XML file

Add possibility to either save (to the current open file) or export the XML document

Corrupted Xml Documents

Display a MessageBox when a file can't be loaded or is currupted.

Distinct column names

Don't allow duplicate column names in NewTable form.

Export to Database

Import & Export to database have an independent Form now.

Move lib to /

Move /XML2DB/lib to /lib

DatabaseConnection Dialog

Fix DatabaseConnection Dialog missing unincluded DatabaseConnection.resx in .csproj.

Add new file

Add the ability of creating a new file from scratch

Add Drag & Drop file to open

Add the option to slide file to the app to open it.

Read from CSV

Add the ability to read from a .csv file.

Add icons

Add icons to /lib for the title bar and exe

Current XML Document

Update the current XML Document path currentOpenXmlPath after exporting a document

MS SQL Server support

Add ability to import/export Data from/to Database.

Implement full XLSX/CSV Support

Excel Read/Export options were implemented in #46 & #17.
Now implementing save option for currently opened files.

Read from XLS

Add the ability to read from .xls Excel Sheets.

Release open corrupted file lock

Release the corrupted file lock (when deleting/updating same file from somewhere else while app is running).

Message Boxes

Add icons to MessageBox using , MessageBoxIcon.TYPE

Missing XML-GUI-NewTable.Designer.cs

Missing file in commit is causing a build failure .

Entity name in generated XML

The generated xml document contains data as following, the <XmlDocument> tag should be replaced with the name of the objects inside the document.

<?xml version="1.0" standalone="yes"?>
<DocumentElement>
-  <XmlDocument>
    <id>1</id>
    <name>TEST</name>
-  </XmlDocument>

<?xml version="1.0" standalone="yes"?>
<DocumentElement>
+ <user>
    <id>1</id>
    <name>TEST</name>
+ </user>
</DocumentElement>

ReadOnly Option

Sync readOnly with readOnlyToolStripMenuItem

Thread fileDialog.ShowDialog()

fileDialog.ShowDialog() in exportXml()@XML-GUI.cs causes :
System.Threading.ThreadStateException <- System.Windows.Forms.FileDialog.RunDialog

Add menu bar

Add File[New, Open, Save, Export[XML, CSV, DB], Exit], Edit[[x]Read Only] & Help[Info]

Search bar

Add search bar to search for a value in the data table.