Category: Import-Export

{syntax type="tiki" editor="plain"}
Uploading a Mediawiki-XML-Dump created by Mediwikis dumpBackup.php leads to an empty page and an apache segfault on debian etch 64bit.

From /var/log/messages

{CODE()}apache2[3658]: segfault at 7fff3f74cef8 ip 7f3837b9d2f7 sp 7fff3f74ce00 error 6 in libpcre.so.3.12.0[7f3837b8e000+25000]{CODE}

File is beeing uploaded correctly in /tmp, upload to File Galleries works correctly.
changed the following values in

{CODE()}
/etc/php5/apache2/php.ini

post_max_size=128M
upload_max_filesize = 128M
max_execution_time = 600
max_input_time = 600
memory_limit = 32M (also tried 64M,128M,256M)
{CODE}

{CODE()}
/etc/apache2/apache2.conf
Timeout 600
{CODE}

Running Debian Etch amd64 all packages actual version of the distri.

Ways to reproduce:
1.) create a XML-Dump from Mediawiki via {CODE()}php dumpBackup.php --full --contents > dump.xml{CODE}
2.) use tikiwiki-importer via ->admin->tikiwiki-importer
3.) Upload in 1. created xml-dump

Neither changing export settings of ~np~ dumpBackup.php --full or --current with or without --content ~/np~ nor changing import options in tikiwiki-importer changes outcome.


---
Addition:
-Upgraded to tikiwiki4, upgraded to debian stable (lenny) as suggested
Problem still exists:

{CODE()}apache2[2231]: segfault at 7fff2184eec0 ip 7f9019c1bf6b sp 7fff2184edc0 error 6 in libpcre.so.3.12.1[7f9019c0b000+28000]{CODE}

See the associated show.t.o instance.

I created a site using trunk (future 14.x), applied a profile which created a long tracker (160+ fields), with long field names, etc.
When I tried to export a single file from the tracker, I get in a Tiki 12.x installation:
^
Request-URI Too Large

The requested URL's length exceeds the capacity limit for this server.
^

And if I try to do the same with trunk(Tiki14), I get the screen converted into a semi-transparent blackish window, as if something was to be shown, but the user can't see anything happening. Just no message, no tracker definition exported, etc.

See it reproduced here:
# Log in here: http://xavi-9794-5536.show.tikiwiki.org
** u: admin
** p: 12345
# Go to tracker fields:
+ http://xavi-9794-5536.show.tikiwiki.org/tiki-admin_tracker_fields.php?trackerId=1
# Select one (for instance, id 5, which is short and has no commas in the name, etc).
# Go down to the dropdown field at the bottom, and select "Export selected", and click at "Go".
** No field definition is exported.

Update of database to 7.0 doesn't work properly so I was need to export wiki articles to tiki 7.0 version so I tried to use this feature (Tiki -> TikiPages -> XML Zip. I have extended version of PHP so it shouldn't be PHP Problem.

{syntax type="tiki" editor="plain"}
When our users attempt run the Calendar export (either via tiki-calendar.php or tiki-calendar_params_ical.php) a 500 internal server error occurs.

From apache access.log:
{CODE(caption="access.log")}10.100.44.149 - - [30/Apr/2010:07:33:27 -0400] "POST /eiadwiki/tiki-calendar_export_ical.php HTTP/1.1" 500 - "http://eiadwiki/eiadwiki/tiki-calendar_params_ical.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3"{CODE}

From PHP error log:
No error reported log.

HTTP Request:
{CODE(caption="HTTP Request")}POST /eiadwiki/tiki-calendar_export_ical.php HTTP/1.1
Host: eiadwiki
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 115
Referer: http://eiadwiki/eiadwiki/tiki-calendar.php
Cookie: javascript_enabled=y; menu=@menu42__50%3Ac@menu42__600%3Ac@menu42__1050%3Ao@menu42__200%3Ac@menu42__350%3Ac@filtercal%3Ao@exportcal%3Ao; tab=1; activeTabseiadwiki%2Ftiki-adminusers.php=tab1; local_tz=AM; PHPSESSID=mkiu7d2r4jlj74f7hlt2brvvj4
Content-Type: application/x-www-form-urlencoded
Content-Length: 41

export=y&calendarIds%5B%5D=1&valid=Export{CODE}

HTTP Response:
{CODE(caption="HTTP Response")}HTTP/1.0 500 Internal Server Error
Date: Fri, 30 Apr 2010 11:37:38 GMT
Server: Apache
X-Powered-By: PHP/5.3.2-dev
Expires: 0
Cache-Control: private
Pragma: dummy=bogus
Content-disposition: inline; filename=calendar.ics
Content-Length: 0
Content-Transfer-Encoding: quoted-printable
Connection: close
Content-Type: text/calendar; method=REQUEST; charset=iso-8859-15{CODE}

We are running in a multi tiki environment on Windows Server 2003, tikwiki 3.2 and php 5.3.

In an old media wiki with iso-8859-1 charset, somebody supposedly has copy&pasted some M$ Office/Word DOC text into the old wiki.
Now, when migrating from the old media wiki to a new tiki wiki 15.2., somebody else copy&pastes the same text from source to source, but after saving it into the new wiki, "index rebuilding" fails because of the char "→", and with that the whole tiki wiki is stalled, won't produce any usable page anymore.

Uhm, apparently there are multiple versions of "right arrow" in M$ Word, which all seem to be converted to the same UTF char ... now.
Not sure anymore which of those it was... I can't reproduce in old environment, because the pages have been deleted after migration.

Will investigate if I can recover those broken pages/ chars, back later.

Now... funny thing, I didn't notice immediately, but other users later on, and when I "rebuild index" via the search control panel, I get the following errorlist for simply putting this little example on a page:

"Bla → KK"

Error(s)

Indexing failed while processing "12" (type activity) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "1" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "2" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "3" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "4" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "6" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "7" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "8" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "10" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "12" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "13" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "14" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "15" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "16" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "17" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "18" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "19" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "20" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "21" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "22" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "23" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "24" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "25" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "26" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "27" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "28" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "29" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "30" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "32" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "33" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "34" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "35" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "36" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "37" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "38" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "39" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "40" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "41" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "42" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "43" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "44" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "45" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
Indexing failed while processing "46" (type category) with the error "Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1"
The search index could not be rebuilt.
Could not perform index modification: Incorrect string value: '\xE2\x86\x92 KK...' for column 'data' at row 1

{syntax type="tiki" editor="plain"}
Can not ((XML Import-Export)).

It looks as though there is a Calendar import feature using CSV (tiki-calendar_import.php) however there are no options to export as CSV in tikiwiki 3.2. The only Calendar export option that I see is exporting to iCal (via tiki-calendar_export_ical.php) but that is not working for our group ([http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3152]).

Can Calendar export to CSV be possible?

We are running in a multi tiki environment on Windows Server 2003, tikwiki 3.2 and php 5.3.

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

Reproduced when attempting to export sheet4 in doc.t.o, which is part of the sample charts generated from the tiki spreadsheet feature:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=4

When exported (as csv with comma, and utf8) the content is like:
{CODE(colors="htmlmixed")}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13),<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1,4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13),<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116,,6,Feb,2002
Pie,"=LINECHART(D2:D8, F2:F6)",<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A,7.2,Mar,2003
Line,"=PIECHART(D2:D8, E2:E8)",<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5,7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

And in my honest opinion, it should be something like:
{CODE()}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002
Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003
Pie,"=PIECHART(D2:D8, E2:E8)",=PIECHART(D2:D8, E2:E8),7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

{syntax type="tiki" editor="plain"}
When exporting tracker items, the generated csv file contains a blank line after every 100 items.

...
100 "180";"48";"13-06-2005";""
101 "133";"1";"30-04-2005";"5"
102
103 "179";"47";"31-01-2005";"0"
104 "178";"46";"31-01-2005";""

Reproduced here:
http://stirus-11828-6082.show.tikiwiki.org/tiki-sheets.php
u: admin
p: 12345

I tried the following:

1-created a spreadsheet with two columns; row one had headings, row two data
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=1
2-exported the spreadsheet in CSV format, UTF-8 character set
3-renamed the export file
4-edit the exported file with UltraEdit; changed one field; saved with UTF-8
5-created an empty spreadsheet
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=2
6-ran import CSV with UTF-8
7-no data imported, and the sheet just says "Array".

Tested in Tiki 25:
The Tiki uses Tracker to store users information and email as username.
I have a tracker (user information) with a username field.
I have a CSV with a list of users.
Using the Import-Export feature I created automatically a format with a "userlink" type of field.

If I import my CSV ===but the users don't exist yet===, even if the feedback is "success" and I can see the items, as result when going to the tracker view (tracker1) only the display will be completely broken and unusable displaying only the first items.

The import-export should reject the missing users items.
The verbose shouldn't be success but something like "item for bsfez could not been imported, the user doesn't exist".
Of course even if it happen to be (an item point to a user that doesn't exist) the tracker display should not be broken and allow the other item editing.

An imported Mediawiki page that has

{CODE(wrap="0",ishtml="0",ln="0",wiki="0",rtl="0",cpy="0")}* a bullet
** sub bullet{CODE}

gets translated to

{CODE(wrap="0",ishtml="0",ln="0",wiki="0",rtl="0",cpy="0")}* a bullet
{DL()}
sub bullet
{DL}{CODE}

which results in the sub bullet and text not displaying on the page at all, except being represented by a small icon.

Yet if the importer had just left it as

{CODE(wrap="0",ishtml="0",ln="0",wiki="0",rtl="0",cpy="0")}** sub bullet{CODE}

it would have worked.

__Update:__ Sometimes it does get the nested bullets. But there are other places where Mediawiki stuff ends up in the DL tags where it shouldn't - with the effect that it disappears from the visible page.

https://doc.tiki.org/WordPress-importer

Nothing happens when I load the file. I don't know if it just hangs or never starts at all. I do see the percentage countdown in my web browser, it does get to 100% but then nothing happens and no posts are loading into blogs, articles or wikis. Possibly the problem is the WordPress xml file. The only time WordPress has been trouble free (importing) was when it was from WordPress to another WordPress site. Including the OPML (links) file.

Would it be easier to import from Joomla? I tried them for a couple of months and did import most of my WordPress site there. (Images did not make it).

There must be a few others moving from other CMS type software to Tiki. Please help.

Tested in version 3.3 and 7:
Importing tracker items through CSV does not properly process the date field.

My exported CSV contains e.g. "24/12/2010 19:55"
The imported data only contains "24/12/2010" The time has been left out.

{CODE(caption="incorrect code 3.3" colors="php")}# Version 3.3
Line 1697
} elseif ($field['type'] == 'f' || $field['type'] == 'j') {
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
}{CODE}

Replaced by following code :
{CODE(caption="correct code 3.3" colors="php") } elseif ($field['type'] == 'f' || $field['type'] == 'j') {
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
}{CODE}

The same for the latest version 8.3

{CODE(caption="Incorrect code 8.3" wrap="0" colors="php")} case 'f':
case 'j':
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = preg_split('#-#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
}{CODE}


{CODE(caption="Correct code v8.3" wrap="0" colors="php")}# Line 1730
case 'f':
case 'j':
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm, $ss) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
break;
{CODE}

Importing tracker items through CSV only sets the created and lastModif value properly if the dates from the CSV file are in the numerical php date format.

When you import a csv file where the created and lastModif dates are written as proper dates, the imported tracker items have a created and lastModif date/timestamp of the date & time of the import action.

example csv :

"itemId","status","created","lastModif","VRID -- 265"
"849","o","07/12/2009 13:24","07/12/2009 13:24","4"

Whenever I export a csv file, it contains the dates as shown above, so you can't just export data and import data on the fly without modifying all the values...

c.f. [https://dev.tiki.org/item3500|bug 3500]

Hi,

i am pretty new to tikiwiki (please point my to any guides if i am missing something here) and currently testing the 8.3 release.
As i do have several mediawiki installations it is a must for me to be able to import data from mediawiki to tiki.

I did export an .xml file via dumpBackup.php from one of my mediawikis which resulted in a 85mb file - which opens without errors in a random selected webbrowser.

As a next step i tried to use the Tiki Importer.
- Choosed source type (mediawiki) & pressed ok & got forwarded to next page
- used the default selections (uncheck, uncheck, 1, option 3) & selected the xml local file -> pressed the 'import' button
- warning id displayed that a script will be started and may take some time & that i should have a backup -> i do select 'OK' here

-> 3 sec later i am back at the start page of the tiki importer.


Problem:
- no error is displayed
- no import is done


question:
- is that function supposed to work?
- could it be related to the size of the xml file? even then i would consider an error.
- can i offer any additional informations?


best regards in advance
fidel


EDIT:
#####
seems to be related with the size of the .xml file.

case 1: small file - around 1 MB -> worked (i do see a progress window)
case 2: big file - around 85 MB -> failed - see above for a detailed description)

Main problem i do see here is that in case 2 the user/admin gets no feedback at all.

Say I have a desktop spreadsheet file. I can copy-paste this to Tiki spreadsheet and it makes it fun & fast to move data to Tiki. (It's also easy to export to .csv to re-use in the desktop spreadsheet).

But what if I want my info in a tracker?

((doc:PluginTrackerList)) has displaysheet=y which displays in spreadsheet view. This is nice but we'd need to be able to edit existing records, and easily add records.

For future versions 11 ? 12 ?

Hi,

There are several main marked up languages that we know well.

I think that it will be useful to be able to exchange (import, export) documents with other selected marked up languages.

!!I particularly think to two categories :

!!!1- The task and documents managers used by development tools : Eclipse-Mylin Aptana environment and Bugzilla

Remark :
About this category, I redact documents using textile to describe the developments integrated into projects and bugzilla.
This because I have near fifty elementary project developed since 4.0, stabilized at 8.3 and that I am preparing for 10.x. (They remain for most of them available and someones must be adapted - galleries particularly)

!!!2- The wikies
The problem is to exchange data with users of main wiki.

The need is to use the large capabilities of tikiwiki to hold projects management and documentation. But as it is not specialized it cannot be directly used.

!!There are several ways, this is completely opened :
1- Be compatible i/O with textile which is very closed from basic tiki marked up language. This for basic articles.
2- Develop a plugin using tikiwiki as marked up language for Mylin
3- Look farther with a full XSL XSL-Fo (note that with eclipse all marked up supported languages can be exported as XSL-

!!On the way, proposal
1- First : list of major marked up languages for wiki and task managers
2- Links import export existing from one to another
3- Choose the optimum
!!
Aim :
- Prepare use of tikiwiki in project management
- Be compatible with environments as Eclipse to with other project management tools

!!Reason(s)
- Tiki provides a lot of coherent and very useful tools to manage the content of projects (documents and detailed task management, studies) and groupware life and management which is the core of project management (the classical tools for planning are only in my mind a little part). __But it cannot be connected with specialized existing tools and information systems in various businesses. The problem and aim is to prune efficiently tikiwiki into these organizations.
__
Trebly

Make File gallery tag image files in Tiki according to exif tags and such, and the other way round too.

For instance, we could tag files in shotwell, and upload them to tiki, to have all tags recognized and shown in tiki also.
"Shotwell 0.8 can write metadata to photo files on the fly - to enable this, select the option "Write tags, titles and other metadata to photo files" in the preferences dialog. Once this is selected, Shotwell will update metadata in photo files as soon as you tag them."

Ideally, tags added in Tiki to image files should be added to image exif metadata (and similar), so that when images are exported from tiki they should carry their own tags inside. At least, allow that optionally.

I tried to import XML from MediaWiki (1.27.0) following [https://doc.tiki.org/MediaWiki+Importer|this guide]. Error:
__"MediaWiki XML file version 0.10 is not supported."__

Here´s what i tried so far:
1) Create [https://www.mediawiki.org/wiki/Help:Export|XML-Backup from MediaWiki]
2) Tools->Importer, upload the original file
3) Error: Wrong MIME-Type
4) Edit XML file: add ‹?xml version="1.0" encoding="utf-8"?› to the top of the file (brackets changed for posting).
5) Tools->Importer, upload the modified file
6) Message: MediaWiki XML file version 0.10 is not supported.

Thanks for any suggestion, fix or workaround for this issue!

/lib/pear/Text/Wiki/Render/Tiki/Redirect.php has an error in line 38

{CODE(wrap="0",ishtml="0",ln="0",wiki="0",rtl="0",cpy="0")}return '{REDIRECT(pageName="';{CODE}

should be

{CODE(wrap="0",ishtml="0",ln="0",wiki="0",rtl="0",cpy="0")}return '{REDIRECT(page="';{CODE}

since Tiki's redirect takes "page", not "pageName".

{syntax type="tiki" editor="plain"}
I tried to import a MediaWiki XML file and got the following error mesage:

Loading and validating the XML file

Fatal error: Class 'DOMDocument' not found in /wiki/tikiwiki-4.1/lib/importer/tikiimporter_wiki_mediawiki.php on line 69

I am not a PHP programmer but this looks like not all the modules are linked together.


Any help would be appreciated.

Thanks
John

{syntax type="tiki" editor="plain"}
The Mediawiki Importer fails with:

[Sun Nov 28 22:17:33 2010] [error] ... PHP Notice: Undefined offset: 1 in /var/www/tiki/lib/pear/Text/Wiki/Parse/Mediawiki/Wikilink.php on line 263, referer: .../tiki/tiki-importer.php
[Sun Nov 28 22:17:38 2010] [notice] child pid 13376 exit signal Segmentation fault (11)

This is on Ubuntu Lucid with a 2.6.32-25-server kernel. It happens while the Importer is in the initial "Loading and validating the XML file" phase, and the Apache child instance running it of course just dies.

Update: It happens ever after I comment out the lines in Wikilink.php that threw the error - that is, there's still a segfault. This is with Apache 2.2.14 and PHP 5.3.2.

This may be the same bug as http://dev.tiki.org/tiki-view_tracker_item.php?itemId=2853&trackerId=5&show=view&reloff=1&cant=2&status=o&trackerId=5&sort_mode=f_41_desc&filterfield=26&filtervalue[26]=Importer - but that shows as fixed, so ....

This may also be related to this preg_replace_callback() bug: https://bugs.launchpad.net/ubuntu/+source/php5/+bug/369737 - although that's unresolved. That function is used in Table.php and Url.php in lib/pear/Text/Wiki/Parse/Mediawiki.

Update 2: Installed a fresh Fedora 14, put Tiki on it, and it gets the same segfault, in the same place in each of the 2 different XML files I'm attempting this with. Now, in both cases these are 64-bit, in case that has anything to do with it (but who runs a 64-bit server today?). In each case these are relatively large XML files - but our requirement is to convert a fair-sized Mediawiki if we're to use Tiki at all.

{syntax type="tiki" editor="plain"}
Should be a simple enough fix, "export only" fields (obviously) should bnot be needed as columns in the csv being imported.

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...