Yahoo Map Plugin from IndexUTemplates.com

[FSGDAG]

I have a question regarding the Yahoo Map plugin thats on IndexUTemplates.com. Here is what is inside the plugin php file

 //add column to idx_link_temp
    $dbConn->execute("alter table `idx_link_temp` add `address` varchar (255) default NULL");
    $dbConn->execute("alter table `idx_link_temp` add `city` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link_temp` add `zip_postal` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link_temp` add `state` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link_temp` add `country` varchar (255)  default NULL");
    //add column to idx_link
    $dbConn->execute("alter table `idx_link` add `address` varchar (255) default NULL");
    $dbConn->execute("alter table `idx_link` add `city` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link` add `zip_postal` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link` add `state` varchar (255)  default NULL");
    $dbConn->execute("alter table `idx_link` add `country` varchar (255)  default NULL");
    //insert data to idx_custom_field
    $dbConn->execute("insert into `idx_custom_field`(field_name,field_text,field_type,required,searchable) values ('address','Address','TEXT',1,1)");
    $dbConn->execute("insert into `idx_custom_field`(field_name,field_text,field_type,required,searchable) values ('city','City','TEXT',1,1)");
    $dbConn->execute("insert into `idx_custom_field`(field_name,field_text,field_type,required,searchable) values ('zip_postal','Zip Postal','TEXT',1,1)");
    $dbConn->execute("insert into `idx_custom_field`(field_name,field_text,field_type,required,searchable) values ('state','State','TEXT',1,1)");
    $dbConn->execute("insert into `idx_custom_field`(field_name,field_text,field_type,required,searchable) values ('country','Country','TEXT',1,1)"); 

I already have my custom fields created and each of them have data in it already. They are the following:

address1
address2
city
state
zip

I currently do not have 'country' as one of them.

Do I need to make any changes to the plugin to work with what I already have??

I also what this plugin to display in a very specific place in my detail_links page. What do I need to do to make that happen?

[Bruceper]

I haven't used this plugin yet, but here's what I do know.

1) If you add this plugin it will use the custom field(s) that you already have, but if you remove this plugin it will delete those fields!!! The plugins assume that the fields it creates are not used by anything else other than the plugin

This is not a flaw in the plugin, it's how they were designed to operate so that when you remove them they clean up after themselves.

2) You could always manually change YOUR custom fields to something else so that you can save them. You need to edit idx_link, idx_link_temp and idx_custom_field

3) Since we use hooks (for plugins) the plugin would go where the hook is. If you want it in a specific place then you may just need to move the hook.

[CEC]

Sorry, but I don't see how removal of a simple map plugin that leads to the deletion of all custom address fields that were there prior to its installation isn't considered a flaw.

[Bruceper]

Most users don't use custom fields anyways, but if you're that concerned then simply rename them as I stated above.

[FSGDAG]

Bruce...

Is the Google Map Plugin the same way???

[Bruceper]

I would assume so, I haven't used it yet. Remember I haven't been here for almost a month.

[FSGDAG]

Ok... I was able to download the Google Map plugin today and its the same as the Yahoo plugin. I'm just not sure what to do here...

Like I said in my previous post, I've already created my own custom fields and stored information in it. Not all of my custom fields match up with the custom fields of the plugin. So what should I do at this point?

[Bruceper]

I'll talk to the programmers about changing the field names in the plugins by default. For now I think your best bet would be to

a) export your current data, so it can be imported if you decide to remove the plugin
b) change the field names in the plugin (search and replace in all files) using a number perhaps in front of the field such as 1address

[CEC]

FSGDAG, what came of this? Were you ever able to get this plugin working for you?

[FSGDAG]

Yep... Sure did...

If you already have custom fields with the data in it prior to installing the plugin, make sure you backup the data first!!! The only real way I got it working was to backup my data, delete the custom fields that were associated with it, then install the plugin. The plugin will install its own custom fields, then just import the data back into the new custom fields the plugin created using phpMyAdmin.

Are you having issues with it? Let me know if you need help