The Joomla! Forum ™



Forum rules


Please use the mailing list here: http://groups.google.com/group/joomla-dev-general rather than this forum.



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 98 posts ]  Go to page 1, 2, 3, 4  Next
Author Message
PostPosted: Mon Aug 17, 2009 10:18 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi guys,

I'm Anh Nguyen, a student participant in GSoC 2009 under Joomla category. My project is J!Mint : Joomla Magento Integration. It's almost coming to the end of GSoC 2009. I open this thread for those who are interested in using / further developing J!Mint could gather up and discuss about problems / suggestions / questions.

This extension is FREE and licensed under GNU-GPL 2.0.
Supported version : Joomla 1.5.14 , and Magento : 1.3.2.3

You can find the demo of front-end integration here: http://jmint.info
We'll schedule an online presentation on J!Mint for those interested some time between August 20 - 29, 2009. The code and documentation, will be released on the same day. Details will be announced here later.

Here are the series of blog entries I've written on Joomla community blog:

1. User-management Feature
2. Back-end Integration
3. Front-end Integration

Thank you very much, and I look forward to hearing from you.

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Fri Aug 21, 2009 1:57 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Anh you are my hero!!

I didn't try it jet since i discover your bridge minutes ago. Anyway, I really hope that it works since this two systems are very different in nature and even Magento DEV guys are saying that it is almost impossible to "combine" the two.

Cheers,
Dorjano

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Fri Aug 21, 2009 2:10 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi Dorjano,

Thanks for ur interest. Feel free to ask if you think any front-end feature is not working or necessary to implement. :)

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Sat Aug 22, 2009 8:05 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Hi Anh

Could you tell me which of them is actually handling user registration? It seems to be Magento, right?
Since there is no user name to enter as is a usual procedure in J! Would be a nice idea to broaden up a registration process with all the data needed for making an e-shopping - Address is a must. As it is right now the shopper have to register and re-input his/her data again later. (Let's forget a non registering shoppers here).
Anyway Anh I would really, really like to put my hand on your code. Any download link jet?
I can't discuss more that this since I don't see all of the work.

Keep going!

Cheers,
Dorjano

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 22, 2009 8:14 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi dorjano,

Thanks for your comment. In this J!Mint, when an user is registered, he's registered on both Joomla and Magento ! And the username is the email address, exactly the way Magento handles registration.

Perhaps you're not a frequent Magento user as you don't know that you can fill out the address form after registration. :) This process I did is just like that of Magento.
Also, after registration, you can login to Magento anytime you want with the email address and password !

I will release the code on the presentation day :) So sit tight for now. :D


Best,

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Sat Aug 22, 2009 8:32 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
tot2ivn wrote:
Hi dorjano,
..
Perhaps you're not a frequent Magento user as you don't know that you can fill out the address form after registration. :) This process I did is just like that of Magento.
...

No, no!! I know Magento quite well. I know what it's possibilities are. The idea is to be able to write all the necessary data at first registration. I know that there is a possibility to edit user data later. But with your solution the user is FORCED do go to edit their data just after registration. Hope you understand what I mean.
tot2ivn wrote:


I will release the code on the presentation day :) So sit tight for now. :D

Huuu, can't wait! :)

D.

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 22, 2009 8:36 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Anh

What about localization? Do you write J!Mint in a way it could be localized? I would be more than happy to do some translation...

Go, Anh, goooo!

D.

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 22, 2009 8:55 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Thanks for your idea man.. coz I just didn't want to change the way Magento handles the registration process.. they kinda have a reason for it ;)

About localization, I will add this feature in to make sure the languages displayed on the Magento section & the Joomla section are consistent. Currently, J!Mint just brings what languages you set on Magento, and Joomla together.. kinda doesn't need for a common localization.

Thanks,

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Wed Aug 26, 2009 7:31 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Anh
Any info about when your online presentation? I'm very anxious to see it and of course try your J!Mint.
You should post some notice in the magento-joomla integration group on magento site to!
It's funny that there are more than 400 members of this group and here you have ...hmm only me listening :-)

Cheers,
Dorjano

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Wed Aug 26, 2009 10:51 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi Dorjano,

Thanks for your suggestion. I'll post a notice there too.

I'll be giving the online presentation on my GSoC 09 project, J!Mint,
at 10.00 am, MDT (Chihuahua Time) Saturday, Aug 29, 2009.

Time: http://timeanddate.com/worldclock/fixed ... c=0&p1=395

Place: https://joomla.webex.com/mw0306l/mywebe ... url=joomla
Password: j!M1nt


See you there,

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Thu Aug 27, 2009 4:02 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Anh

I'll be there!

:pop :geek: :eek:

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 29, 2009 5:59 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Anh, what happened? No presentation?! :'( :(

oooo I'm so disappointed..

Regards,
D.

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 29, 2009 6:35 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi Dorjano,

Did you come to the site posted above ? I did make the online presentation on time. No changes.

Probably, you got the time wrong or something ? :)

Anyway, the presentation recording will be posted online very soon.


Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Sat Aug 29, 2009 7:28 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Aug 30, 2005 11:26 am
Posts: 432
Location: Slovenia
Blody hell. I do miss it. But a mighty Google helped me again. So I found Mark Deksters's post here:
http://community.joomla.org/blogs/commu ... ation.html
There is a link for those guy which miss it like me. Go for it.

IN THE PRESENTATION, A THE END IS A LINK TO DOWNLOAD!!! Go get it guys!

Anh
Thanks for your presentation and a good work. I hope you'll develop J!Mint further.

Take care!

Dorjano

_________________
Moderator of Slovenian Forum


Top
 Profile  
 
PostPosted: Sat Aug 29, 2009 10:50 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Thanks Dorjano :) ,

I hope I will have time to further develop J!Mint in the next coming period of time. Coz I just decided to get a job outside already.

Here is the link to download the source code : http://code.google.com/p/jmint/downloads/list

Link to the webinar : http://community.joomla.org/blogs/commu ... ation.html

Any problems, feel free to discuss it here.


Angh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Sun Sep 06, 2009 7:59 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Nov 21, 2008 7:42 am
Posts: 15
Hi tot2ivn,i'm trying to watch the webinar.It doesn't work for me..It ask me download
atgpcdec..Could you send me the video if it's a video.Cause i never used it before.Sorry.. Thanks a lot by the way. ^_^


Top
 Profile  
 
PostPosted: Sun Sep 06, 2009 8:59 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi Yonghan,

You can download the WebEx Player here http://www.webex.com/downloadplayerpopu ... .php?os=pc .

I'm sorry, since the video was recorded using WebEx, we have to use this player to watch it :D.. it's not in a regular video format.

Thanks for your interest.

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Wed Sep 09, 2009 8:29 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jan 08, 2008 2:30 am
Posts: 2
Angh,

If i wanted to install your demo on a hosted website, what steps would i need to take other than creating a mysql database for each side. Also i assume your demo is multi-store?


Top
 Profile  
 
PostPosted: Fri Sep 11, 2009 2:23 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi btschmidt,

The demo zip file contains the demo sites + databases. If you just want to install J!Mint on a running website, you need to follow the steps in the User Guide.

The guide on how to setup J!Mint is quite detailed, if you need help on that later. Probably, we could setup a Skype chat some time, I can help you out on that.

Multi-store: it depends on what you want to integrate ? The language integration hasn't been implemented in this J!Mint v1.0.

Best,

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Fri Sep 11, 2009 2:36 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jan 08, 2008 2:30 am
Posts: 2
Anh,

Thanks for your quick reply.

I am reasonably familiar with Joomla. I was hoping to use your demo info to get a better understanding of magento in a sandbox environment.

My guess is this will be a four step process.

Install the demo Joomla, install the demo magento, import the sql to the appropriate databases then install J!Mint.

Correct so far?


Top
 Profile  
 
PostPosted: Fri Sep 11, 2009 2:56 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
Hi btschmidt,

Yes, you're right. Actually, you should follow the guide in User Guide. (in jmint_v0.1.zip)


Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Sun Sep 20, 2009 2:40 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Sep 20, 2009 1:26 am
Posts: 1
Hi Anh (and others),

First of all, thanks a lot for your hard -and good- work. It's excellent. But I have a problem (I'm NOT working in local):

After uploading Magento and Joomla, and after creating the database for both of them, I tried to import the magento database, but I got this error:

    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE

I browsed in the forums, and found some solutions, one of them is deleting the words USING BTREE... and it seems to work until I get another error:

    #1452 - Cannot add or update a child row: a foreign key constraint fails (`mydatabase_magento/#sql-12b6_1da4813`, CONSTRAINT `FK_eav_attribute` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE)

Do you know the solution, please? (I cannot find a "real" solution out there). Or,

1.- Could you just export the database from your host (not local)

2.- Can I just import the magento_sample_data_for_1.2.0.sql database?

Thanks in advance.
Rafael.


Top
 Profile  
 
PostPosted: Tue Sep 29, 2009 8:51 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Sep 29, 2009 8:47 pm
Posts: 1
I checked out the demo, but did not see the Magento "Shop by" menu. Can it be integrated with J!Mint?


Top
 Profile  
 
PostPosted: Wed Sep 30, 2009 2:20 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
rafaxgx wrote:
Hi Anh (and others),

First of all, thanks a lot for your hard -and good- work. It's excellent. But I have a problem (I'm NOT working in local):

After uploading Magento and Joomla, and after creating the database for both of them, I tried to import the magento database, but I got this error:

    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE

I browsed in the forums, and found some solutions, one of them is deleting the words USING BTREE... and it seems to work until I get another error:

    #1452 - Cannot add or update a child row: a foreign key constraint fails (`mydatabase_magento/#sql-12b6_1da4813`, CONSTRAINT `FK_eav_attribute` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE)

Do you know the solution, please? (I cannot find a "real" solution out there). Or,

1.- Could you just export the database from your host (not local)

2.- Can I just import the magento_sample_data_for_1.2.0.sql database?

Thanks in advance.
Rafael.


Hi Rafael, I'm not sure if exporting the database from my host would solve the problem as it's just the same thing. I think, you should follow the Manual setup in the User Guide. :)

Best,

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Wed Sep 30, 2009 2:21 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 20, 2009 6:00 am
Posts: 31
Location: Singapore
michuyewup wrote:
I checked out the demo, but did not see the Magento "Shop by" menu. Can it be integrated with J!Mint?


Yes, you can use the J!Mint Content module to grab that menu from Magento site :)
Any problem feel free to post it here..

Thanks,

Anh

_________________
Proud to be a Front-end Web Developer .,


Top
 Profile  
 
PostPosted: Thu Oct 01, 2009 2:42 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Oct 07, 2007 3:02 pm
Posts: 4
This is a great work. I'll try on my site and report any errors...
Count on me for translation in Spanish.


Top
 Profile  
 
PostPosted: Sun Oct 04, 2009 1:39 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Oct 04, 2009 1:34 am
Posts: 2
rafaxgx wrote:
Hi Anh (and others),

First of all, thanks a lot for your hard -and good- work. It's excellent. But I have a problem (I'm NOT working in local):

After uploading Magento and Joomla, and after creating the database for both of them, I tried to import the magento database, but I got this error:

    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE

I browsed in the forums, and found some solutions, one of them is deleting the words USING BTREE... and it seems to work until I get another error:

    #1452 - Cannot add or update a child row: a foreign key constraint fails (`mydatabase_magento/#sql-12b6_1da4813`, CONSTRAINT `FK_eav_attribute` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE)

Do you know the solution, please? (I cannot find a "real" solution out there). Or,

1.- Could you just export the database from your host (not local)

2.- Can I just import the magento_sample_data_for_1.2.0.sql database?

Thanks in advance.
Rafael.



I am having the same problem.

I am using virtualbox with turnkey LAMP and not sure what needs to be changed in MSQL to fix this error.


Top
 Profile  
 
PostPosted: Sun Oct 04, 2009 1:48 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Oct 04, 2009 1:34 am
Posts: 2
This is the FULL MSQL error

Code:
Error
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `catalog_category_entity_varchar`
--
CREATE TABLE IF NOT EXISTS `catalog_category_entity_varchar` (

`value_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`entity_type_id` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`attribute_id` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`store_id` smallint( 5 ) unsigned NOT NULL DEFAULT '0',
`entity_id` int( 10 ) unsigned NOT NULL DEFAULT '0',
`value` varchar( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `value_id` ) ,
UNIQUE KEY `IDX_BASE` ( `entity_type_id` , `entity_id` , `attribute_id` , `store_id` ) USING BTREE,
KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` ( `entity_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` ( `attribute_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` ( `store_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =205;



MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
  KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
  KEY `FK_CATALO' at line 9


Anyone got any ideas?


Top
 Profile  
 
PostPosted: Sun Oct 04, 2009 9:05 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Oct 04, 2009 8:54 am
Posts: 19
Location: Berlin Germany
Hi,

this is how it looks on another database export from a productive Magento site,
I am maintaining.

Change the concerning command to the new MySQL5.0 format and it should work :

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `catalog_category_entity_varchar`
--

DROP TABLE IF EXISTS `catalog_category_entity_varchar`;
CREATE TABLE IF NOT EXISTS `catalog_category_entity_varchar` (
`value_id` int(11) NOT NULL auto_increment,
`entity_type_id` smallint(5) unsigned NOT NULL default '0',
`attribute_id` smallint(5) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned NOT NULL default '0',
`entity_id` int(10) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`value_id`),
UNIQUE KEY `IDX_BASE` USING BTREE (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE` (`attribute_id`),
KEY `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE` (`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=494 ;



Best regards Hans 8)


Top
 Profile  
 
PostPosted: Sun Oct 04, 2009 9:12 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Oct 04, 2009 8:54 am
Posts: 19
Location: Berlin Germany
Hi Anh,

I have a question please.

I installed successfully your demo site on my localhost, burt I dont have the passwords to get in the admin areas of Joomla and Magento .
I want to see, how you configured the various modules for content import from Magento.

What are the right passwords ???

Best regards Hans


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 98 posts ]  Go to page 1, 2, 3, 4  Next



Who is online

Users browsing this forum: No registered users and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group