Migrating to JDownloads 3.2

[Adam DeAloe]

Hi,

I'm following the instruction for migrating JDownloads from a Joomla 1.5 site to the current version. 
The first step says to update to JDownloads 1.8.4, but when I try, it says I need to upgrade step by step to that version.  I'm currently running JDownloads 1.4 RC 600, and I can't find JDownloads 1.5, 1.6, or 1.7 in order to get me up to 1.8.4.

Does anyone know where I can find these three (1.5, 1.6, and 1.7) versions of JDownloads?

If they're just not available, are there any instructions for manually converting the database from JD 1.4 to 3.2?  I'm not afraid to get my hands dirty with mysql and some munging.  Though I would prefer the upgrade route describe here: http://www.jdownloads.net/documentations/item/updated-from-jdownloads-1-8-x-on-joomla-1-5-to-jd-1-9-series-on-joomla-2-5-or-3-x

Any help is greatly appreciated.

[ColinM]

Hi
Wow that is a way back!  I doubt if jDownloads was as sophisticated and as option rich as it is now.  So I would first ask how many categories and how many downloads in total.  In that version did you have preview images or the like?  How extensive are the Descriptions?  What facilities are you using?

Basically I am leading up to saving all your download files in their directory structure; then just instal jDownloads on your test site and then copy over a few categories and their downloads at a time.  This is not the glamorous way but it will work.  First of course you should save all of the existing jDownloads database tables.from your MySql.  By looking at the old structure it will be possible to determine the Download (file) IDs, the name and the Description.  The new version on Joomla! 3.x will almost certainly have a different set of IDs as they will no doubt have been created in a different order.  Given that information it is feasible to create an sql query that will reload the descriptions into the new version.

Will try to help. Version 1.4 RC 600 is before I had ever heard of jDownloads.

Colin

[Adam DeAloe]

(oops, sorry, I think I accidentally clicked "report to moderator", lol.  It's been a long night)

Hi Colin,

Thanks for your response.
Yes, this was a ways back!  This website was long overdue for an upgrade.  I was afraid there wouldn?t be an easy/automated way of migrating my JDownloads data, so I started writing a program to convert the data the morning after I made my last post in this thread.  It was a heck of a journey!  I learned a lot about Joomla during this, namely how the assets are organized (and I?m so grateful for their API method for assets, I would NOT want to have to write code to manage that!).  Anyway, each of the 4000 articles we have, give or take a few hundred, are linked to a URL JDownloads method for downloading the file, based on the file_id.  i.e. ?sitteroot?/index.php?com_jdownloads?cid=7102? (or similar)?so the ID?s had to remain the same for this migration.  I migrated the categories manually, through the JDownloads interface, since there weren?t too many of them.  There are over 4000 downloads though, so I definitely needed to automate that migration.  Really long story short, my program worked great, all my Joomla 1.5 JDownloads data is now working beautifully on JDownloads for Joomla 3.  To run my program, I used a plugin that lets me run php directly from an article.  Can?t remember the name off hand, let me know if you want to know.  Basically I just did <?php require(?myprogram.php?);?>. 

Last but not least, the original links, as I mention above , look something like this: ?sitteroot?/index.php?com_jdownloads?cid=7102?, so I used ReReplacer to replace \{iACL type=cbfield 1\}\s*?\<div (class|id)=\"download_link.*?cid=([0-9]{1,6}).*?\{/iACL\}  to  {jd_file file==$2}?. Worked like a charm!

I?ll include my code, incase anyone would find it useful.
Please note, since this was a one-off, I didn?t write this to be user-friendly.  It?s necessary to propagate the association tables manually in order to make this work with individual systems/situations.



[gelöscht durch Administrator]

[ColinM]

Hi
Well done!  One of the import problems is keeping the IDs the same.  I will make sure Arno see this and maybe your code could form the basis of a new  importer.  If you have any free time help in bug solving is always welcome.  Mostly I do the documentation, English translation and some minor code bits but most of the hard bits are done by Arno.

Thanks for donating the code - sure it will help some others.

Colin