[Alioth-staff-replacement] Migrating tracker items

[Olaf Meeuwissen]

Hi yet again,

I just submitted a tracker item[1] requesting someone applies the
attached patch to /usr/share/gforge/www/export/tracker.php in the
hope that that allows me to get a useful dump of the tracker item
info.

 [1]: https://alioth.debian.org/tracker/index.php?func=detail&aid=315941&group_id=1&atid=200001

Long story quoted (with some fixes) for reference.

Olaf Meeuwissen writes:

> Hi again,
>
> Olaf Meeuwissen writes:
>
>> Hi Alexander,
>>
>> Alexander Wirt writes:
>>
>>> On Fri, 02 Feb 2018, Olaf Meeuwissen wrote:
>>>
>>>> What is still on my list of things to migrate is the SANE project's
>>>> collection of Tracker items.  There are well over 1600 with more than
>>>> 400 still open.  I've tried the CSV export but that includes neither
>>>> attachments nor comments.  The export only appears to have the initial
>>>> submission and the current state.
>>>>
>>>> I could script scraping the web pages but it would be a lot easier for
>>>> me (and on the server) if I could work from a dump of the project's data
>>>> (similar to the mbox file you provide for mailing list migration).  Can
>>>> that be arranged?
>>>>
>>>> Either all of the project's DB data or "just" all of the tracker items
>>>> would be fine for me.
>>>
>>> I have no idea how to extract them. Feel free to read the fusionforge docs to
>>> tell me how to do so. But please don't expect that I will have time to find
>>> out on my own.
>>
>> I was afraid you would say that :-|  Guess that, in good Free Software
>> tradition, I get to help myself ...
>>
>> For fusionforge 6.1 I found
>>
>>   https://fusionforge.org/plugins/mediawiki/wiki/fusionforge/index.php/Forge_command_line/6.1#Tracker
>>
>> but no such thing for 5.3.2.  Will dig a bit more.
>
> Sorry, Alioth is running 5.2.3.  I've been digging a bit in the upstream
> sources for that version and came across tools/export-tracker.tcl.  This
> is nowhere to be seen on Alioth.  This script runs under pgtclsh which
> seems to have died as of PostgreSQL 8.0 (and Alioth is on 9.1.24).
>
> I've also been grepping for tracker related files provided by the gforge
> and fusionforge packages that are installed on Alioth with
>
>   $ dpkg-query -W | awk '/[ng]forge/{ print $1 }' \
>   > | xargs dpkg -L | sort -u | grep tracker
>
> and came across /usr/share/gforge/www/export/tracker.php.  That file
> (and the accompanying tracker.xsd) looked *very* promising.  I've tried
> to get it to produce something useful but only got as far as
>
>   $ curl https://alioth.debian.org/export/tracker.php?group_id=30186\&atid=410369\&offset=0
>   <tracker version="1.0" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://alioth.debian.org/export/tracker.xsd">
>
> no matter what offset value I used.  The group_id and atid correspond to
> the SANE project and its Feature Requests tracker.  Trying via a browser
> while logged into Alioth didn't make any difference.
>
> Poking around in the fusionforge history for this tracker.php file, I
> came across a [commit][1] that claimed to make it work again.  I've
> attached a minimal diff against the file that is on Alioth and would
> very much appreciate it if this could be applied.
>
>  [1]: https://fusionforge.org/scm/browser.php?group_id=6&scm_plugin=scmgit

Urk!  That's not a very useful link.  Try this instead

  https://scm.fusionforge.org/anonscm/gitweb?p=fusionforge/fusionforge.git;a=commit;h=5668cb3e9958dd021dee2cb37684f5cb240f5399

> The original commit also zapped the <resolution> info but as Alioth
> seems to be using that I'd prefer to get that if possible.
>
> Once applied, I'll see if I can get it to produce anything useful and
> report back here.

I've also tried doing this myself by copying the script to a project
website's cgi-bin that without any success :-(

Hope this helps,
--
Olaf Meeuwissen, LPIC-2            FSF Associate Member since 2004-01-27
 GnuPG key: F84A2DD9/B3C0 2F47 EA19 64F4 9F13  F43E B8A4 A88A F84A 2DD9
 Support Free Software                        https://my.fsf.org/donate
 Join the Free Software Foundation              https://my.fsf.org/join
-------------- next part --------------
A non-text attachment was scrubbed...
Name: export-tracker.diff
Type: text/x-diff
Size: 548 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/alioth-staff-replacement/attachments/20180314/35d6d00e/attachment.diff>