Category: Import-Export

We have an issue with Tabular when a value of a field = "0"
And then how it is seen using : tiki-pluginlist_experiment.php

To reproduce.
I have a CSV with the following:
ID,NUMBER
111,1
112,1
113,0
114,0
115,0
116,5
117,4

Tabular import will create/update trackerItems as follow.

|| ID | NUMBER
111 | 1
112 | 1
113 |
114 |
115 |
116 | 5
117 | 4 ||

Which is wrong, empty is empty and 0 is 0. ;-)

Then when using the tiki-pluginlist_experiment.php here what I got.
Where they were a value for the field NUMBER I see:
tracker_field_trackerNUMBER => "1"
tracker_field_trackerNUMBER => "Vendu"

Where they were a 0 => that became an empty value the field is not displayed at all...

{syntax type="tiki" editor="plain"}
A CSV file may use different delimiters (commas, semicolons, tabs) and they are used to separate values.
Depending the application you use it your field will be delimited by one of them.

In the Tracker Import-Export feature (was tabular) if you try to import a CSV file were the delimiter is not a comma "," it will produce an error the "firstfieldlabel" is not found. (or something similar).

It should accept any of the 3 delimiters that are legit OR the error should said, Tiki accept only comma "," for delimiter of a CSV file.

Hi,

When trying to use the Tiki Importer for Mediawiki, I ended up with a blank page.

Reproducible everytime:
*Menu Admin / Tiki Importer
*In the dropdown box "Select the software to import from", select Mediawiki
*Click OK
=> blank page

I added this to view errors:
ini_set('display_errors',1);
error_reporting(E_ALL);

Fatal error: require_once(): Failed opening required 'Text/Wiki/Mediawiki.php' (include_path='/path/to/my/tiki/vendor/bombayworks/zendframework1/library:/path/to/my/tiki/vendor/bombayworks/zendframework1/extras/library:/path/to/my/tiki/vendor/phpseclib/phpseclib/phpseclib:.:/usr/lib64/php/:/usr/share/pear/:/usr/share/php/:/path/to/my/tiki/') in /path/to/my/tiki/lib/importer/tikiimporter_wiki_mediawiki.php on line 9


Indeed there is no Mediawiki.php in those folders

Workaround:
I found this file in the folder /vendor_extra/pear/Text/Wiki/
I copied the folder Text into /vendor/bombayworks/zendframework1/library
The file was properly called.

I guess it would be better to correct or add the path but I don't know how.

Thnak you!

Hello,

Tiki is fantastic piece of software providing (almost) everything one can think of CMS and I would not have difficult time to switch to it all of my web sites...except, there is one, imho, quite important thing which I do miss a lot - it's TIki's __import-export__ capabilities.

For instance, at the moment I?m responsible for one non-profit organization's web site and Tiki would be perfect match for it, but currently there are ~250 posts available and there is no option to import it into Tiki. (:cry:)

These days static-site-generators (e.g. [https://gohugo.io/|Hugo]) and/or flat-file CMS.-es (e.g.[https://getgrav.org/|Grav]) are becoming popular by eliminating need for database usage, but, provide some kind of support to migrate from popular blog engines like WordPress. Moreover, since the content is no longer stored within database, but it is written down in some standard markup (markdown, asciidoc, rst,...) and stored in regular filesystem, it is very easy to change one's platform.

Otoh, there is, afaik, nothing like that available for Tiki so in order to move to it, one practically has to start from the scratch and there is also no way out. (:eek:)

Recently, someone added support for Tiki markup to the [https://pandoc.org/|Pandoc] due to the need to migrate one's content from the Tiki, so we can say there is kind of 'way out' for those wanting to change from Tiki to something else, at least, for blog posts, articles etc.

However, there is none support to convert to Tiki, although there is an open [https://github.com/jgm/pandoc/issues/4825|issue] in regard.

So, my proposal it to take this issue more seriously (there is similar [https://dev.tiki.org/item6697-Markdown-support|issue] to make Tiki more friendly citizen for those wanting to move to/away from it.

Lastly, I'm also thinking that by having good support for Pandoc, I'd certainly take advantage to write some longer articles/posts using my preferred editor which provides helpers for the markup (e.g. rst), syntax highlighting etc., all while being offline and then just convert to Tiki Wiki markup.

It's a pity that Tiki does provide so many things, inherently missing in static-site-generators which have to be plugged via some 3rd party apps/services out, out of the box, but it lacks in import-export features.

There was also [https://github.com/wikiLingo/wikiLingo|wikiLingo] initiative, but it seems that it is stalled and/or [https://tiki.org/item6607-6607?highlight=robert%20plummer|Robert] is no longer around?

Various tools are able to built a structured documentation form internet exploration.
A good example is ZOTERO.
The product can get urls, html pages content, manage a hierarchical structure, set marks etc...
The product is able to export XML files with various basic patterns :
1. Zotero RDF
2. MODS
3. RIS
4. Refer/BibIX
5. Unqualified Dublin Core RDF
6. WikiPedia Citation templates
7. BibTeX

These structured informations can be imported to a wiki structure.
he interest of Zotero RDF (but I had not the time to the Unqualified Dublin Core RDF have the advantage of containing the structure definition the link to external url and if the html page has been captured the component html page with the elementary component has images.
This model his the closest of wiki structures.

Too the Wikipedia Citation templates is close but from the url refs;

I have not found where are the text and synthesis objectives for "import" and data shared (XML files as RDF Zotero structures), and multiwiki, in 4.x and 5.x

I am interested in participating to these developments.

Best regards to everybody

Implement something like the special page [http://en.wikipedia.org/wiki/Special:Book|Wikipedia Book] to generate some revenue from community assets

It seems as if the button to import csv items has been broken: no action is taken when the user clicks at "import". In fact, nothing seems to happen.
See it reproduced in the show2.t.o instance of another bug report (sorry I felt lazy to create another 20.x one just for this):

http://xavi-9794-7124.show2.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=import_items&trackerId=6
u: admin
p: 12345

Download the csv of items from this tracker:
http://xavi-9794-7124.show2.tikiwiki.org/tiki-download_file.php?fileId=1

I first exported them, clear the list of items in the tracker, and attempt to import them again.
Many other scenarios do reproduce this issue, afaik; what I did was some of the easiest way to let you reproduce the bug.

Tracker items Export after filtering fails (either all items or none exported, depending on how you create your plugin TrackerFilter call). That was known to work in the past (see ), and I recall using this type of feature long ago (years ago, maybe with tiki6???).

It seems as if minor fix was needed to have it export items filtered on the criteria indicated through either PluginTrackerFilter or based on the filtering in the tracker feature interface itself.

http://xavi-9794-5876.show.tikiwiki.org/
u: admin
p: 12345

!!! Fixed
!!!! Case 1: TrackerFilter using param "export=y"
This produces a button at the bottom to go to export, in theory, with the pre-selection of item filtered.

* Come here at the homepage:
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?page=HomePage
* Filter for the word "topic". It will list just 3 items from the longer list of items in the tracker.
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?trackerId=1#trackerFilter1-result
* click at the "Export" button at the bottom, which will load this page (should it be another url?), and apparently nothing happens: the same page is reloaded:
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?controller=tracker&action=export&trackerId=1&displayedFields=4&f_4=topic


!!!! Case 2: TrackerFilter using param " export_action='Export it' "
* Come here at the Tracker_as_Calendar_12 page:
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_12
* Type the word "topic" in the ext box and click at "Export it" button. The csv produced has no content.

!!!! Case 3
You want to do the same from the tracker feature itself: after listing items, you filter bsaed on some criteria, and you click at ecport, you expect to get that filtering applied to the csv to be exported.
The url might look like:
http://xavi-9794-5876.show.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=export&trackerId=1&status=o&sort_mode=f__asc&filterfield=4&filtervalue%5B1%5D=&filtervalue%5B2%5D=&filtervalue_other=&filtervalue%5B3%5D=5+%28high%29&filtervalue%5B4%5D=topic&filter=Filter

Couldn't we use these values in the arguments of the url to have a pre-selection of items to be exported?
---

!!! Pending Fixing
Update: Filter based on cases of "Multiple selection" fields do not work: nothing is exported or all is (filtering doesn't seem to be working). {sign user="xavi" datetime="2016-06-07T08:14:59+00:00"}
!!!! Case 11: TrackerFilter using param "export=y"
This produces a button at the bottom to go to export, in theory, with the pre-selection of item filtered.

* Come here at the homepage:
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?page=HomePage
* Field 7 (multiselect): "Resources needed" produces:
+ {CODE()}__tracker field type not processed yet M__{CODE}

!!!! Case 12: TrackerFilter using param " export_action='Export it' "
* Come here at the Tracker_as_Calendar_12 page:
+ http://xavi-9794-5876.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_12
*You can't see the form field to filter based on the multiselect field. You type Laser at the text field to filter, and a 0 byte file is produced.

!!!! Case 13
You want to do the same from the tracker feature itself:
http://xavi-9794-5876.show.tikiwiki.org/tiki-view_tracker.php?trackerId=1
* Filter for the "Resources needed" Laser Pointer. 3 items will be shown (out of the 6 max).
* click at the "Export" button at the bottom. None is exported, just the header line with the variable names, but no record below.

! AD-Field / User-Picker

When importing tracker data (tested via the "old" way as via the tracker tabular) into a user-picker-field, the imported user-name is NOT checked against the Tiki list of users. In the end the user-picker-field behaves just like a normal text-field while importing, accepting just every string and not only valid user-names.

This could also be a security problem cause someone could inject non-valid user-names in a internal list of valid users.

What should happen is that when importing values into that field, that every value get's checked against the Tiki user list.
If this heavily slows down the import speed, there should be a checkbox that gives the user the ability to enable/disable the check against the Tiki user list, given the user the deccission to check the user names externally before importing those names.

! Date field
When importing dates into a date-field every date is accepted. This is also valid if the date is outside the allowed scope which is defined in the settings "Start Year" and "First year in the dropdown". As result everything seems fine as long as nobody edits that item. As soon as someone edits the item (any other field) and saves it, the content of the date fields gets silently deleted, resulting in damaged/lost data.

Hi:

I've hit this type of error 500 (using Tiki 18svn & php 7.2.9) several times in a wiki page with Plugin TrackerFilter, when the field shows a dropdown field, and I select one option in the dropdown before clicking at the export button:
{CODE()}
[Wed Sep 05 16:58:24.138049 2018] [php7:notice] [pid 18063] [client ] PHP Fatal error: Uncaught Error: [] operator not supported for strings in /var/www/tiki18farm/tiki-export_tracker.php:84\nStack trace:\n#0 {main}\n thrown in /var/www/tiki18farm/tiki-export_tracker.php on line 84, referer: https://example.com/foobar
{CODE}

Wiki code in the wiki page (in case it matters):
{CODE()}
{trackerfilter trackerId="5" sort="n" showtitle="n" showlinks="y" showdesc="n" shownbitems="y" showstatus="y" showlastmodif="y" showlastmodifby="y" showcomments="y" status="opc" sort_mode="lastModif_desc" sortchoice="created_desc|Newest first:lastModif_desc|Last modified first" max="-1" showpagination="y" allowtableexpansion="y" more="y" silent="n" sortable="n" server="n" export_action="Confirm CSV Download" filters="45/t:53/t:50/d:55/m" export_itemid="y" export_status="y" export_modif="y" export_created="n" export_charset="UTF-8"}
{CODE}

Field 50 is a "dropdown with other" field, with options:
{CODE()}
1-Pendent,1-Pendent,2-Encarregat,3-Treballant,4-Fet,5-Entregat,other=Altres
{CODE}

However, choosing some user from the dropdown of users (field55), also produces the same type of error (we are using Real Name display instead of username in trackers, etc)

I tried to import a mediawiki 1.31 and 1.35
I get the error message, the xml schema is not supported by tiki 22.0

The current spec for the XML format is here: https://www.mediawiki.org/xml/export-0.11.xsd

I tried to put the xsd in lib path from the importer, changed the filename to match the other and add an entry in the file tikiimporter_wiki_mediawiki.php "case '0.11':"
but i'm not an programmer and it doesn't work.
I followed this https://sourceforge.net/p/tikiwiki/code/65119

The existing Tiki importer which supports MediaWiki needs updating to support the latest MediaWiki spec. The Tiki importer seems to be several years out of date. Supporting the latest MedaWiki spec would help increase Tiki adoption from other platforms, where many users have large amounts of existing data that they want - and are currently unable - to migrate over.

The current spec for the XML format is here: https://www.mediawiki.org/xml/export-0.10.xsd

I don’t remember for sure but I think the last supported format in the Tiki importer is 0.6 (maybe 0.4?). If that’s the case it does not look like the changes since then are massive. Certainly it would take time to implement support in the import parser to handle the additional tags, but if they don’t map to anything in Tiki they can just be ignored, and since they were never supported previously, it seems like that would not be much of a loss. In other words I believe that supporting the updates to the format should not be tremendously labor intensive.

Linking to my original forum post and feature request here for details and explanation of why I think this is important and valuable for the Tiki project:
https://tiki.org/forumthread65578#threadId65617

In the Properties tab of the Wiki edit screen (either standard wiki editor or wysiwyg) there is an option to Import the content of wiki page that has previously been exported (needs some Wiki options set to see these)

The export process works fine producing a text file with a special header area then the content which is in wiki syntax for the normal editor or html when using the (full) wysiwyg editor (not tested the wiki syntax wysiwyg option)

To import the page you simply browse to the file and then save the page - which used to import the content at that point.

However now (22 Aug 2013) in 11.x and trunk nothing happens and the page remains empty. It used to work Ok at some point probably version 6 or perhaps earlier?

While importing for WordPress 5.7, process reported all extracted data from XML file as expected. After reporting 49 posts as successfully imported, stops with message:

Out of range value for column 'activity' at row 1
The query was:
update `tiki_blogs` set `activity`=? where `blogId`=?
Values:
1. 100
2. 1
The built query was likely:
update `tiki_blogs` set `activity`='100' where `blogId`='1'

To verify that this was not caused by a specific post, I deleted the first 50 posts from de XML file and reran the import. Exact same scenario repeated (with blogId value incremented by 1).

Looking at the table tiki_blogs I thought that the field 'activity' may not allow for a value of 100 so modified to increase length by 1 digit and reran. It now works. Successfully imported all 393 posts.

I do not know if the error is caused by the data definition (field to short?) or the importer (value should not reach 100?) as I am not clear on what the "activity" column represents.

Creating a XML Zip worked in 12.x, in tiki 15+ it ends in a white screen with no zip download.

Creating a XML Zip worked in 12.x, in tiki 15+ it ends with 2 php error messages:

Strict Standards: Redefining already defined constructor for class XML_Parser in /var/www/drsassafras-11658-6198/vendor_extra/pear/XML_Parser/Parser.php on line 222

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/drsassafras-11658-6198/vendor_extra/pear/XML_Parser/Parser.php on line 611

admin password for show instance: 12345

{syntax type="tiki" editor="plain"}
If the XMP Zip export of a Structure is used, the first time use works fine - but if you then try to export a different Structure it just exports the 1st again. Repeated swapping to try and export another/different Structure does occasionally export the right one (haven't worked out the logic of when its OK) but generally it gets it wrong.

{sign user="pascalstjean" datetime="2013-08-26T01:31:06+00:00"}
Can't reproduce at the moment. Tried exporting all of the samples created on SHOW and worked flawlessly.

thanks

{sign user="eromneg" datetime="2013-08-26T09:47:00+00:00"} --I've downgraded the priority on this as it may be some strange manifestation of my private test site - if anyone has some time and wants to looks at my test site it would be appreciated since the issue is definitely happening there !--

{sign user="eromneg" datetime="2013-08-27T07:41:49+00:00"}
OK the bug is now reproduced in the 'show' url - see the site for more details

Really odd !!!

Importing of a XML zip fails.

Attached is an XML zip created on 12.x

This is a php7 issue. It works fine with php 5.x

PHP Error: PHP Parse error: syntax error, unexpected 'new' (T_NEW) in /Sites/tiki/vendor_extra/pear/XML_Parser/Parser.php on line 611

Tiki show instance not useful as its hosted on php 5.x

I have a xml.zip attached for trial reasons, but it does not matter what is being imported, it all fails.