J!Mint - Joomla Magento Integration - Discussion

For Joomla! 1.5 Coding related discussions, please use: http://groups.google.com/group/joomla-dev-general
User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Mon Aug 17, 2009 10:18 pm

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Fri Aug 21, 2009 1:57 am

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

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Fri Aug 21, 2009 2:10 am

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Sat Aug 22, 2009 8:05 pm

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

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Sat Aug 22, 2009 8:14 pm

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Sat Aug 22, 2009 8:32 pm

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

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - LOCALIZATION??

Post by dorjano » Sat Aug 22, 2009 8:36 pm

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

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Sat Aug 22, 2009 8:55 pm

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Wed Aug 26, 2009 7:31 pm

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

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Wed Aug 26, 2009 10:51 pm

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Thu Aug 27, 2009 4:02 pm

Anh

I'll be there!

:pop :geek: :eek:
Moderator of Slovenian Forum

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Sat Aug 29, 2009 5:59 pm

Anh, what happened? No presentation?! :'( :(

oooo I'm so disappointed..

Regards,
D.
Moderator of Slovenian Forum

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Sat Aug 29, 2009 6:35 pm

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 .,

User avatar
dorjano
Joomla! Explorer
Joomla! Explorer
Posts: 432
Joined: Tue Aug 30, 2005 11:26 am
Location: Slovenia
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by dorjano » Sat Aug 29, 2009 7:28 pm

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

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Sat Aug 29, 2009 10:50 pm

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 .,

yonghan79
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Fri Nov 21, 2008 7:42 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by yonghan79 » Sun Sep 06, 2009 7:59 am

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. ^_^

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Sun Sep 06, 2009 8:59 am

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 .,

btschmidt
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Tue Jan 08, 2008 2:30 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by btschmidt » Wed Sep 09, 2009 8:29 pm

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?

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Fri Sep 11, 2009 2:23 am

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 .,

btschmidt
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Tue Jan 08, 2008 2:30 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by btschmidt » Fri Sep 11, 2009 2:36 am

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?

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Fri Sep 11, 2009 2:56 am

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 .,

rafaxgx
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Sep 20, 2009 1:26 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by rafaxgx » Sun Sep 20, 2009 2:40 am

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.

michuyewup
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Sep 29, 2009 8:47 pm

Re: J!Mint - Joomla Magento Integration - Discussion

Post by michuyewup » Tue Sep 29, 2009 8:51 pm

I checked out the demo, but did not see the Magento "Shop by" menu. Can it be integrated with J!Mint?

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Wed Sep 30, 2009 2:20 pm

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 .,

User avatar
tot2ivn
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Mar 20, 2009 6:00 am
Location: Singapore
Contact:

Re: J!Mint - Joomla Magento Integration - Discussion

Post by tot2ivn » Wed Sep 30, 2009 2:21 pm

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 .,

nightkami
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Sun Oct 07, 2007 3:02 pm

Re: J!Mint - Joomla Magento Integration - Discussion

Post by nightkami » Thu Oct 01, 2009 2:42 am

This is a great work. I'll try on my site and report any errors...
Count on me for translation in Spanish.

robertgo
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Oct 04, 2009 1:34 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by robertgo » Sun Oct 04, 2009 1:39 am

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.

robertgo
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Oct 04, 2009 1:34 am

Re: J!Mint - Joomla Magento Integration - Discussion

Post by robertgo » Sun Oct 04, 2009 1:48 am

This is the FULL MSQL error

Code: Select all

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?

coronaJet
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Oct 04, 2009 8:54 am
Location: Berlin Germany

Re: J!Mint - Joomla Magento Integration - Discussion

Post by coronaJet » Sun Oct 04, 2009 9:05 am

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)

coronaJet
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Oct 04, 2009 8:54 am
Location: Berlin Germany

Re: J!Mint - Joomla Magento Integration - Discussion

Post by coronaJet » Sun Oct 04, 2009 9:12 am

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


Locked

Return to “Joomla! 1.5 Coding”