TOPIC: SOBI2 Import

Daniel,

I am trying to import a list of sobi2 entries into Hotspots. I imported a .csv file into SOBI2 using a com_ called CSVI SOBI... The title will import but no other information is being copied over such as the address, city, state, postal code, country. I have been playing with this for a couple days, and cant figure out what I am missing. Can you help me out if you have some time. Or direct me to the proper forum to ask this question... Thanks.

Andrew

Hi Andrew,
did you do the matching of the fields?

D,

I did match up all the fields in the field manager, but it still only imports just the entry_title and not the rest of the entries. It's kinda wierd... I'm going to try a fresh install and see if that helps with anything.

Andrew

If you can't manage to get it working you can give me the csv list. I'll import it on my localhost and will let you know if the import in hotspots was successful.
Daniel

D,

Ok, well i got it working after reinstalling SOBI2, only now the catagory ID is blank, so will I have to go through each entry and select a category?

Andrew

Hey Andrew,
Well I guess that this is the only possible option right now. Or execute a sql query in the database and assign them a category But I guess that this is more complicated then just investing 10mins and assigning the right category

Daniel,

Sorry to keep bugging you with this... but I added the catagories to the entries manually in the back end, but it took a bit longer then 10 min It was about 250 entries...! But when I go to the front end and click on the catagory, it just shows... "Loading Data..." and never loads the map. I don't think the markers are being located in the map...

Give me an url. Either your markers have invalid html or something else is wrong...

Daniel,

I just sent you a PM.

Andrew

Ok, I think that I know what the problem is and I really hope that with the next version this will be something of the past and I won#t get any more messages like - markers not loading

I looked at the markers and some of them have title's like this DON'S DIVING SERVICE - now this is normally fine, but not in this case.

You have 2 options. Unpublish the hotspots that have ' in their name and the map is going to work (after that edit the names of those hotspots and replace ' with something else)

Second option try to edit utils.php:
line 128change it toand it think that this should solve the problem.

D,

I did both solutions that you mentioned above, and there is still no resolution. What is the next step? Thank you so much again for all your support.

Andrew

Unpublish all markers and then publish just one and I'll have a look if it is not loading.

All markers are unpublished except for one in the "Dive Shop" catagory. Still not loading... Please let me know what you find out.

Andrew

Hi Andrew,
I'm not sure why the hotspots are not assigned to a category - this should work automatically.

The first time you open the component in the frontend hotspots finds that there are some locations that doesn't have coordinates. And it tries to find them. If it finds the coordinates, then it saves them...

This function returns "not found" for a lot of your markers because they don#t have any zip, street or country code.

Next - I think that the biggest problem came after you've assigned manually the category. You see, because those markers doesn't have coordinates in the backend in the fields for coordinates you will see - added automatically. But if you don't move the marker on the map, the "added automatically" text doesn't change to coordinates...

Here is what I can offer you. If you wish, send me a copy of your sobi2 database. I will try to figure out why the categories are not assigned. After that I'll write some kind of script that will match the coordinates for each marker and save them. And I'll add this fix to hotspots 1.1 . (which should appear in the next several weeks).

D,

Thank you so much for all your time and support... I will just wait till the next update is available, and let you spend more time getting that ready! I look forward to seeing the new updateed Hotspots... It is sure to be a success just as much as the current version...! Keep up the good work!

Hey Andrew,
Please send me a copy of your csv tables at This email address is being protected from spambots. You need JavaScript enabled to view it. - this will help me a lot to fix your problem.
Daniel

Here are the 2 .csv files that i used... just change the extention to .csv. I had to change it so i could upload it to you. Thanks...

Andrew

D,

Just wondering if you had a chance to follow up with this issue? Thanks, and I know we all can't wait to see the new version!

Hey Andrew, I don't see any csv or zip files in the thread. Are you sure that you've attached them?
Perhaps just send them to This email address is being protected from spambots. You need JavaScript enabled to view it. .