<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><font size="-1"><font face="Calibri">Joop,<br>
<br>
Thank you very much for your reply. In case it's of any help,
here are logs when I set database to rt3 and assign Plugin(
"RTx::AssetTracker" );<br>
<br>
Let me know if there is any other info you might need to give
me some direction on getting AT3.0 up and running. I'm also
going to try to get some usable tables dumped from postgresql
just to try another approach....<br>
<br>
Oct 15 10:59:15 rt4 RT: [21451] Use of inherited AUTOLOAD for
non-method RT::System::AddRights() is deprecated at
/opt/rt4/local/plugins/RTx-AssetTracker/lib/RTx/AssetTracker/Type.pm
line 114, <DATA> line 751.<br>
<br>
Oct 15 10:59:15 rt4 RT: [21451] Can't locate object method
"_Accessible" via package "DeleteAsset" (perhaps you forgot to
load "DeleteAsset"?) at
/usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 422,
<DATA> line 751.<br>
Compilation failed in require at
/opt/rt4/local/plugins/RTx-AssetTracker/lib/RTx/AssetTracker/Types.pm
line 70, <DATA> line 751.<br>
BEGIN failed--compilation aborted at
/opt/rt4/local/plugins/RTx-AssetTracker/lib/RTx/AssetTracker/Types.pm
line 70, <DATA> line 751.<br>
Compilation failed in require at
/opt/rt4/local/plugins/RTx-AssetTracker/lib/RTx/AssetTracker.pm
line 56, <DATA> line 751.<br>
BEGIN failed--compilation aborted at
/opt/rt4/local/plugins/RTx-AssetTracker/lib/RTx/AssetTracker.pm
line 56, <DATA> line 751.<br>
Compilation failed in require at /opt/rt4/sbin/../lib/RT.pm
line 729, <DATA> line 751.<br>
<br>
</font></font>
<pre class="moz-signature" cols="72">William Clarke
ITS System Administrator
Bard College at Simon's Rock
84 Alford Road
Great Barrington, MA 01230
(413) 528-7428 (voice)
(413) 528-7405 (fax)
<a class="moz-txt-link-abbreviated" href="mailto:wclarke@simons-rock.edu">wclarke@simons-rock.edu</a></pre>
On 10/16/2014 7:33 AM, Joop wrote:<br>
</div>
<blockquote
cite="mid:24553_1413459275_543FAD4B_24553_345_1_543FAD21.1010003@xs4all.nl"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On 15-10-2014 20:08, William Clarke
wrote:<br>
</div>
<blockquote cite="mid:543EB819.5020202@simons-rock.edu"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div class="moz-cite-prefix"><font size="-1"><font
face="Calibri">RT,<br>
<br>
Little more info...<br>
<br>
I have migrated\updated rt3 database to a fresh install of
rt4.2.8. So I can bounce back and forth between rt3
database and rt4 database with $DatabaseName in
RT_SiteConfig.pm.<br>
<br>
rt4 database has "RT::Extension::Assets" plugin working
however the tables (rtxassets, rtxassets_id_seq,
rtxcatalogs, rtxcatalogs_id_seq) aren't populated due to
this being a fresh database.<br>
<br>
old rt3 build\database on the other hand had
"RTx::AssetTracker" installed so it has the following
tables\sequences that rt4 does not (at_assets,
at_assets_id_seq, at_ips, at_ips_id_seq, at_ports,
at_ports_id_seq, at_types, at_types_id_seq)<br>
<br>
</font></font></div>
</blockquote>
<font size="-1"><font face="Calibri">My plan of attack:<br>
- generate for all assettypes a seperate rt_config.pm which
maps the CustomFields to the right Catalogs<br>
- generate a search to export each assettype to a csv file<br>
- import using the RT::Assets import tool to import them
maintaining the ids<br>
- write a small perl script to walk all
tickets,articles,old_assets looking for links to old_assets
and relink them to the new_assets.<br>
- drop the old tables.<br>
<br>
In concept this should work I think but I'm open to better
ways todo this since its error prone and a lot of work.<br>
</font></font>
<blockquote cite="mid:543EB819.5020202@simons-rock.edu"
type="cite">
<div class="moz-cite-prefix"><font size="-1"><font
face="Calibri"> Installing AT3.0 has given me some issues
with both rt3 and rt4 database. It appears it's no longer
supportd after rt4.0.0. We were hoping you guys could shed
some light on this for us. How can we migrate our old
Asset Tracker data into rt4 database or maybe get rt3
database fully functional on 4.2.8. <br>
</font></font><br>
</div>
</blockquote>
Had the same problem and 'fixed' that in testing by looking at the
error and where it was generated. From memory it was about a
CustomField type of thing.<br>
<br>
Joop<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>