merzak-x/simplexml

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

simplexml's Issues

Message Boxes

Add icons to MessageBox using , MessageBoxIcon.TYPE

Distinct column names

Don't allow duplicate column names in NewTable form.

Entity name transmission

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

UI Resize-ability

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

Success export message

Add Success message after exporting a file successfully

Validate column/entity name

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

Export empty table

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

Read from CSV

Add the ability to read from a .csv file.

Add menu bar

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

ReadOnly Option

Sync readOnly with readOnlyToolStripMenuItem

@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

Export: CSV Sheet Content

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

Add Drag & Drop file to open

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

Export to XLS

Implement full Excel sheets support.

Escaping Strings

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

Import from database

Importing from database imports wrong table sometimes.

Export CSV Sheet

Ability to Export data to CSV sheet

Export to Database

Import & Export to database have an independent Form now.

Dialog Forms

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

Duplicate Exit Dialog

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

Use Threads for new forms

Using Threads for new Forms fixes #19

Save XML file

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

Save file

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

Corrupted Xml Documents

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

Read from XLS

Add the ability to read from .xls Excel Sheets.

Current open XML Document

Display current open file name in the form.title

Edit cell

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

Current XML Document

Update the current XML Document path currentOpenXmlPath after exporting a document

Import from Database

Importing from Database is now under test phase.

Close Form

Closing Form without closing its child

Implement full XLSX/CSV Support

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

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>

Disable control

Disable control buttons when no XML Document is loaded

Search bar

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

NewTable Dialog

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

MS SQL Server support

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

Missing XML-GUI-NewTable.Designer.cs

Missing file in commit is causing a build failure .

Add Ctrl+S hotkey

Add hotkey to save current XML Document #4

Add icons

Add icons to /lib for the title bar and exe

Close child forms

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

Add new file

Add the ability of creating a new file from scratch

Open Document MessageBox

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

Move lib to /

Move /XML2DB/lib to /lib

Thread fileDialog.ShowDialog()

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

Copy/Paste Keys

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

Release open corrupted file lock

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

DatabaseConnection Dialog

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

Export PK Violation

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

Redesign the UI

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

Save new XML Doc

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