Solved

Load XML data into Joomla Estate Agency

Posted on 2011-03-22
7
1,592 Views
Last Modified: 2012-06-21
Dear expert:

I'm going to create a Joomla site for allowing agents to rent flats and houses.
I'm thinking about Joomla Estate Agency component or simliar.

I will have some XML files adquired from other sites. Does it exists a component to load XML data into Joomla Estate Agency database ?
In case it doesn't exists, I understand I have to create my own php process for doing so but, where can I get the database documentation for knowing all tables and fields involved ?

Thank you.
0
Comment
Question by:gplana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 13

Accepted Solution

by:
StormITSolutions earned 500 total points
ID: 35193383
Hi

It's a great component, we were using it for a client.

I remember a long thread about importing xml files in to joomla database and also nothign could do it back then without coding it yourself.

http://joomlashopbuilder.com/index.php?option=com_content&view=article&id=232&Itemid=156

This extension does it to stock a store with products
SO you could edit this to stock your database with property info

It would be alot less work than doing it yourself.

Hope this guides you in the right direction

Storm
0
 
LVL 13

Assisted Solution

by:StormITSolutions
StormITSolutions earned 500 total points
ID: 35193398
Just thought alternatively

YOu could use csvimproved to import CSV files which can be created from Excel.

We do that with our clients stores as you can create simple excel formulae to create the comma delimiter format.

Storm
0
 
LVL 15

Author Comment

by:gplana
ID: 35193712
Excellent.

Just two questions:

1. Do you know if joomlashopbuilder can be used also for importing data to JEA component ?

2. Do you know if Realtyna RPL it's better than JEA for using as Real Estate add-in ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 13

Assisted Solution

by:StormITSolutions
StormITSolutions earned 500 total points
ID: 35193808
Hi

1. I dont think it can by default, you might need to edit the destination fields on the sql  commands

2. JEA was good as the client had no budget for an off the shelf subscription system for property sales didnt try RPL

Storm
0
 
LVL 15

Author Comment

by:gplana
ID: 35193956
Thnk you.

Do you know how can I get information about which tables and fields are JEA using ?
0
 
LVL 13

Assisted Solution

by:StormITSolutions
StormITSolutions earned 500 total points
ID: 35194180
Yeah

Use phpmyadmin or alternative navigator with your hsoting package to look at the database
you will see many tables i.e jos_components etc

look for the one named estate agent i think it is.

There will be a few for the different sections in that component.

Then its a case of going through the other component and making sure the tables match up.

But it sounds easier than it will be.

Your other alternative to save time would be to use the store uploader to your advantage.

say the table is Price make that your property type table.


so what I mean is although it will upload to populate the store you can in phpmyadmin copy the data in a table to another table, so what i think you should do is on a spreadsheet work out all the fields you need for JEA and see how many there is

then look at the fields the uploader will use and mentally assign each.

Then go into database and copy the rows from the store one to your JEA one.

Its a fix that will work but requires work until you make your own uploader.

Storm
0
 
LVL 15

Author Closing Comment

by:gplana
ID: 35194277
Thank you very much. You have helped me a lot.

Regards.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Change Joomla Logo Graphic This tutorial goes over the steps to change the Joomla Logo in the template you are using. For this example we will be assuming you are using the rhuk_milkyway Joomla Template which is installed by default. You will …
Have you ever wanted to use that sweet jQuery gallery plugin on your Joomla site but couldn't get it working due to jQuery conflicts or your lack of knowledge about what's under the Joomla hood? This article will step you through the process of impl…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question