Forums
 |
Marketplace 2 (en)Forum for Marketplace 2 - Classified Ads for Joomla! 1.5. Posts in english language. |
| Public write access is disabled. Please login or register |
 | Last post |
| Forums | » Marketplace 2 (en) | » Marketplace 2 installation with import from Marketplace 1.4.6 |
    504 posts --- Location: Fulda Germany Moderator  |
10.07.2010 17:22Marketplace 2 installation with import from Marketplace 1.4.6Hi, some of you asked me if it would be possible to save and restore categories and ads from Marketplace 1.4.6. Yes it is. Ads will be transfered without images, though. Here is the procedure. Test it on a development system before you do that on your live server. Step 1: BACKUP YOUR DATABASE!!! I'm not joking. Make a backup of your database. Step 2: Use your favourite SQL client e.g. phpMyAdmin, mysql or whatever you like and execute these 3 sql statements. Please note that you have to use your table prefix! These 3 statements use the default jos_ prefix. Again: Replace jos with your table prefix. There are 6 occurences: CREATE TABLE jos_marketplace_146_ads SELECT * FROM jos_marketplace_ads; CREATE TABLE jos_marketplace_146_categories SELECT * FROM jos_marketplace_categories; CREATE TABLE jos_marketplace_146_types SELECT * FROM jos_marketplace_types; Step 3: Make sure these 3 new tables exist (with your table prefix) jos_marketplace_146_ads jos_marketplace_146_categories jos_marketplace_146_types Step 4: Uninstall Marketplace 1.4.6 Step 5 Install Marketplace 2 (Reminder: Don't forget to install and activate the plugin) Done What? Done??? If everything worked fine your types, categories and ads from Marketplace 1.4.6 are automatically imported during installation. Go to the Marketplace 2 backend and have a look. Probably now you want to set some nice aliases for you imported categories. Regards Achim -- Achim Fischer Codingfish Limited www.codingfish.com |
 47 posts --- Location: Denmark |
11.07.2010 14:16 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Wonderful! Will be testing soon!www.akvarieplanter.dk |
|
47 posts --- Location: Denmark |
12.07.2010 11:26 Re: Marketplace 2 installation with import from Marketplace 1.4.6 okso.. did this.. and it didn't work. Nothing was imported.. :-/ www.akvarieplanter.dk |
|
47 posts --- Location: Denmark |
12.07.2010 11:51 Re: Marketplace 2 installation with import from Marketplace 1.4.6 From what I can see, the tables are clearly different.ads = entries types = labels and nowhere does the install script look for the marketplace_146_* tables. is this something you've implemented in a new release, which isn't uploaded yet? hopefully we'll get a reply soon, since my site is now without any marketplace  www.akvarieplanter.dk |
|
47 posts --- Location: Denmark |
12.07.2010 14:41 Re: Marketplace 2 installation with import from Marketplace 1.4.6 hiwell, I forced my self to try and fix this.. Now I have NO idea about sql programming or such, but I managed to make something that works. When you have the backup tables jos_markedplace_146 (the 3 from the guide) you then run : INSERT INTO jos_marketplace_entries( category_id, user_id, firstname, city, phone, email, label_id, headline, text, price, date_created, date_lastmodified) SELECT category, userid, name, city, phone1, email, ad_type, ad_headline, ad_text, ad_price, date_created, date_lastmodified FROM jos_backup_marketplace_146_ads This transfers "most" of the entries.. I could not get 'ad_condition' to work.. I have no idea why.. Also, I only chose the columns I needed .. so if you have more stuff in your tables.. add it your self. After this, you need to update the jos_markedplace_entries table to reflect the new categories vs. the old ones.. this means : 1: you already created the categories in the new marketplace (the same as you had in the old) 2: you note the 'id' of the old ones, and the 'id' of the new ones. then I did this... 1. I updated the category ID's to be something I was sure wasn't being used. because if you update id 3,4,5 & 6 to be 5,6,7 & 8 then 3 will be 5, 4 will be 6, 5 (which has already been changed) will then be changed to 7 and 6 again to 8... so this needs a little workaround.. I did: UPDATE jos_marketplace_entries SET category_id = '13, 14, 15, 16, 17' WHERE category_id = '6, 7, 8, 9, 10'; then after that: UPDATE jos_marketplace_entries SET category_id = '3, 4, 5, 6, 7' WHERE category_id = '13, 14, 15, 16, 17'; it takes a little fiddling about.. as I said this is by no means a solution.. but it got my entries migrated... and caused me some headaches... I give NO promises, nor do I believe I can help you if it doesn't work.. but I will try.... perhaps Achim can see some use in this? www.akvarieplanter.dk |
|
504 posts --- Location: Fulda Germany Moderator |
12.07.2010 16:04 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Hi,is this something you've implemented in a new release, which isn't uploaded yet? Yes, this is in the final 2.0 version which I currently prepare to upload. It's not in the RC. Regards Achim -- Achim Fischer Codingfish Limited www.codingfish.com |
|
47 posts --- Location: Denmark |
12.07.2010 18:49 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Hi Achim.Ok, maybe... just maaaaaaaaybe you should've mentioned this in the post... so no one actually started trying the guide.. since it won't work in RC2... www.akvarieplanter.dk |
|
504 posts --- Location: Fulda Germany Moderator |
12.07.2010 20:30 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Hi,
Well, I have always said that this feature will be included in 2.0 final. RC2 is out for weeks now and the script went online yesterday  However, did you try it now with the today uploaded 2.0 version? Regards Achim -- Achim Fischer Codingfish Limited www.codingfish.com |
|
7 posts --- Location: Portugal |
12.07.2010 22:17 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Well, will this import work for Marketplace 1.3? |
|
504 posts --- Location: Fulda Germany Moderator |
12.07.2010 23:46 Re: Marketplace 2 installation with import from Marketplace 1.4.6 Hi,Well, will this import work for Marketplace 1.3? No, there are a lot of changes e.g. new database fields in 1.4.6 compared to 1.3.x Regards Achim -- Achim Fischer Codingfish Limited www.codingfish.com |
| Forums | » Marketplace 2 (en) | » Marketplace 2 installation with import from Marketplace 1.4.6 |