Verbesserung des CMS MySQLiteCMS Version 3.6.0, Import CSV

Mit Hilfe eines Special Tag kann jetzt eine CSV-Datei importiert werden, die innerhalb der Seite als HTML-Tabelle dargestellt wird. Die neuen bzw. angepassten Dateien sind:

  • \static\files\example-01.csv
  • \static\js\csv.js
  • \cms\data\content.sqlite
  • \cms\includes\functions.inc.php
  • \cms\templates\admin\subtemplates\admin_menu.inc.tpl

Der Syntax des Special Tag ist:

csv2table:dateiname|delimiter|id|filter|firstRowHeader|sortable|responsiv|tableclass

Beispiel csv-Import

Zunächst wird die Datei example.csv über Einstellungen>>Dateiverwaltung(Dateimanager) hochgeladen. Dort muss anstelle der Standardeinstellung media files gewählt werden.

id menu sequence name title link section accesskey
36 main_menu 1 Home Home home 0
37 main_menu 3 Documentation Documentation documentation documentation
39 main_menu 2 About About phpSQLiteCMS about about
43 demo-sub2 1 BPGS.DE BPGS.DE https://bpgs.de
44 demo-sub2 2 Bolivien Guide Book https://bolivien.bpgs.de
45 demo-sub2 3 Freehost-Profi Free Webspace https://freehost-profi.de
46 demo-sub1 1 New Default Template Demonstration of the new Default Template /documentation/template-default-3menus-news /documentation
47 demo-sub1 2 Include News Include a News Page /documentation/include-news
48 demo-sub1 3 Include Simple News Include a Simple News Page /documentation/include-simple-news

In der Regel reichen die Standardeinstellungen aus. Als delimiter wird im Standard ein Komma verwendet. Die id ist im Standard csv. Bei der Verwedung mehrerer CSV-Imports in einer Tabelle müssen auch unterschiedliche IDs verwendet werden. Die Anzeige lässt sich auch bereits filtern, die erste Zeile der CSV-datei ist der Kopf der Tabelle, die auch bereits sortierbar ist (mit Click auf den jeweiligen Spaltenkopf). Die Anzeige erfolgt auch responsiv, d.h. bei kleineren Bildschirmen kann/muss man in der Tabelle nach rechts scrollen.

Inhalt der Datei README.md

# MySQLiteCMS
A SQLite leightweight CMS

## Basis

The basis of this CMS is [https://github.com/ilosuna/phpsqlitecms](https://github.com/ilosuna/phpsqlitecms).

Another source is [https://github.com/emanuel4you/phpsqlitecms](https://github.com/emanuel4you/phpsqlitecms). This is a fork of the first mentioned repository.

## Improvements / Changes / Adaptations

My goal is to combine the best of both versions and eliminate existing issues.

That concerns for example:

* Submenus; These are already included in emanuel4you, but do not work properly.
* Backups of the Database; This are already included in emanuel4you, but do not work properly.
* Inserting news pages - done
* Adapting the Editor in Non-WYSIWYG Mode -done

## Changes 19.06.2019

* New: \cms\templates\default-3menus-news.tpl
* Changed:\cms\templates\default.tpl
* Changed:\cms\data\content.sqlite
* Changed:\cms\templates\admin\subtemplates\edit.inc.tpl

The main improvement is that you now can include News-Pages and Simple-News-Pages into other pages.

## Changes 20.06.2019

* New: \static\js\admin.js; from 2.0.4 but with some changes
* Changed: \static\css\style_admin.css; CSS Code for the Editor-Buttons
* Changed: \cms\templates\admin\main.tpl; include admin.js
* Changed: \cms\templates\admin\subtemplates\edit.inc.tpl; reaction for the Buttons

The main improvement is the improvement of the Non-WYSIWYG-Editor

## Changes 20.06.2019

* \cms\lang\german.admin.lang.php; corrections of misspelled items

## Changes 21.06.2019

New items for backup and submenu:

* \cms\lang\bulgarian.admin.lang.php
* \cms\lang\chinese_zh-CN.admin.lang.php
* \cms\lang\english.admin.lang.php
* \cms\lang\german.admin.lang.php; correction of misspelled items
* \cms\lang\polish.admin.lang.php
* \cms\lang\russian.admin.lang.php
* \cms\lang\spanish.admin.lang.php
* \cms\lang\ukrainian.admin.lang.php

Different changes:

* \config\definitions.conf.php; newer version for jquery, jqueryui, bootstrap and tinymce
* \cms\index.php; backup item added
* \cms\config\sql\mysql.initial.sql; submenu items
* \cms\config\sql\postgresql.initial.sql; submenu items
* \cms\data\content.sqlite; submenu column in table phpsqlitecms_menus added
* \cms\includes\backup.inc.php; new backup function
* \cms\includes\functions.admin.inc.php; improved security with password token
* \cms\includes\functions.inc.php; access to submenu items
* \cms\includes\menus.inc.php; access to submenu items
* \cms\includes\users.inc.php; improved security with password token
* \cms\templates\admin\subtemplates\admin_index.inc.tpl; backup item added
* \cms\templates\admin\subtemplates\admin_menu.inc.tpl; backup item added
* \cms\templates\admin\subtemplates\backup.inc.tpl; new for database backup
* \cms\templates\admin\subtemplates\menus_edit.inc.tpl; submenu handlung added
* \cms\templates\admin\subtemplates\menus_edit_item.inc.tpl; submenu handlung added
* \cms\templates\admin\subtemplates\users.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_delete.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_edit.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_new.inc.tpl; improved security with password token
 
The main improvements are the database backup and the submenus.

## Changes 23.06.2019

New:

* \cms\templates\subtemplates\bootstrap-carousel.inc.tpl

Changed:

* \cms\includes\classes\Gallery.class.php
* \cms\templates\default-3menus-news.tpl - missing jQuery added
* \cms\includes\functions.inc.php - Handling of the Bootstrap Carousel included
* \cms\data\content.sqlite - Demo Page of the Bootstrap Carousel included

The main improvement is the Bootstrap Carousel

## Changes 28.06.2019

New:

* .htaccess in some subdirectories - for security reasons
* \cms\templates\default-category.tpl - demonstration of news categories
* \cms\templates\default-headline-3menus-news.tpl - demonstration of headline
* \static\img\pdf.png - missing icon added
* \static\img\rss.png - missing icon added

Changed:

* \cms\data\content.sqlite - more demonstration and testpages
* \cms\includes\edit.inc.php - headline
* \cms\includes\functions.inc.php - collection of  news categories
* \cms\templates\default.tpl - no submenu hover (JavaScript)
* \cms\templates\default-3menus-news.tpl - no submenu hover (JavaScript)
* \cms\templates\admin\subtemplates\edit.inc.tpl - category and headline added
* \cms\templates\subtemplates\news.inc.tpl - category added
* \cms\templates\subtemplates\overview.inc.tpl - some comments added

The main improvement is categories in news pages.

## Changes 01.07.2019

* \cms\data\content.sqlite - some examples to demonstrate the new `https://bpgs.de/`
* \cms\includes\functions.inc.php - some useless comments removed, `https://bpgs.de/` included
* \cms\templates\admin\subtemplates\edit.inc.tpl - improved editor for sidebar content and teaser content
* \cms\templates\subtemplates\gallery.inc.tpl - better gallery with view title and subtitle

The main improvements are the special tag `https://bpgs.de/` and the improved editor for sidebar content and teaser content

## Changes 02.07.2019

New:

* favicon.ico
* all files in the \static\img\favicon directory

Changed:

* \static\img\favicon.png
* \cms\templates\default.tpl
* \cms\templates\default-3menus-news.tpl
* \cms\templates\default-category.tpl
* \cms\templates\default-headline-3menus-news.tpl

All changes serve the favicon representation.

## Changes 04.07.2019

New:

* \static\files\example-01.csv - example file for csv-import
* \static\js\csv.js - JavaScript for filtering and sorting of csv-imported tables

Changed:

* \github\cms\data\content.sqlite - example for csv import added
* \github\cms\includes\functions.inc.php - spezial tag for csv-import added
* \github\cms\templates\admin\subtemplates\admin_menu.inc.tpl - minor correction of HTML-Code output

The main improvement is the csv import via special tag:

    csv2table:dateiname|delimiter|id|filter|firstRowHeader|sortable|responsiv|tableclass