Data entries import plugin not working with Multifield/Location Filter

Hi, I'm trying to import "City" locations into "District" field via data entries import plugin.

But it not working...

On the "Data Entries Import" plugin -

Try creating "New" on data entries import, the import seems to be complete but its not showing in data entries.

And also on "Exists" data entries import, can't able to select already added second level parent manually created.

These are the repeats in error log:

32 repeats | Mysql Error: Table 'database.vb_multi_formats_lang_ta' doesn't exist on line# 190 (file: /plugins/multiField/rlGeoFilter.class.php)
7 repeats | Mysql Error: 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 '' at line 1 on line# 137 (file: /includes/classes/rlHook.class.php)

Because of this plugin bug, i can't able to build my site. I have over thousands of data entries to be imported, which can't be done manually bcoz its large.

I created a ticket and the support people saying, "There is no solution yet , we plan to modify the multi-feed plugin for importing nested fields"

I'm waiting for this plugin update for last 6 months, but still no luck...Anyone can help me out here?

Is this really a bug; or, the feature just has not been added to the plugin?

Are these new entries; or, do you have a backup file with the entries already?

I am sure Flynax will get to it as soon as possible; however, there are other people, who have been waiting for some time, who have requested updates, bug fixes, and new features. I am sure they have a plan to proceed with things in a certain order. I have requested improvements and hope they get to them in the near future; so, please, no taking cuts in front of me. Joking of course.

I personally, by hand, entered data for 10 countries with sub-region I, sub-region II, and sub-region III over a couple of weekends. Regardless of the method of entry, you still need to go back and review each piece of data one by one for accuracy. So there are no shortcuts for this step in the setup process.

With another website, I hired a developer to install thousands of locations along with GPS coordinates for a little sum of money. Have you consulted with Flynax about whether they can assist you if you pay for the developer's time? I am not sure if this is possible; but, it is worth a try. I simply gave the WordPress developer an Excel file and they processed the information and uploaded it to my database.

Hello Joe,

Is this really a bug; or, the feature just has not been added to the plugin?
//Yes, its bug. Its worked fine with the previous versions of Multifield/Location Filter. It just not working with the next updates of this plugin.

I am sure Flynax will get to it as soon as possible; however, there are other people, who have been waiting for some time, who have requested updates, bug fixes, and new features. I am sure they have a plan to proceed with things in a certain order. I have requested improvements and hope they get to them in the near future;
//Yes, but this is very important thing to get it fixed at top priority.

Are these new entries; or, do you have a backup file with the entries already?
//These are new entries, if i have backup i could simply import that sql table via phpmyadmin.


I personally, by hand, entered data for 10 countries with sub-region I, sub-region II, and sub-region III over a couple of weekends. Regardless of the method of entry, you still need to go back and review each piece of data one by one for accuracy. So there are no shortcuts for this step in the setup process.
//Really by hand, ohhhhh! Very hard...

With another website, I hired a developer to install thousands of locations along with GPS coordinates for a little sum of money. Have you consulted with Flynax about whether they can assist you if you pay for the developer's time? I am not sure if this is possible; but, it is worth a try. I simply gave the WordPress developer an Excel file and they processed the information and uploaded it to my database.
//I will wait for another one or two months, if there's no update to the plugin i will do the data entry one by one manually. There's no way...

Regarding GPS Coordinates, how did you do that? Its for the purpose of Auto Detecting the location right?
In the data entry, there's no such thing like GPS coordinate, are you talk about something else?

Guys,

I'll try to get to this plugin as soon as I can and come up with some solution until the update releases (for adjusting to multiFied 2.2+)

I'll let you know in this thread

Thanks

Thank you, Rudi :)

So rolling back to the prior plug won't work?

It will work with multiField <= 2.1.2

Please consider making it multi field with a multi select option in the future.

Quote:

---

Originally Posted by Pragash Jayaraman

Hello Joe,

Regarding GPS Coordinates, how did you do that? Its for the purpose of Auto Detecting the location right?
In the data entry, there's no such thing like GPS coordinate, are you talk about something else?

---

Yes, different software; but, just offering a different potential solution.

Quote:

---

Originally Posted by Rudi

Guys,

I'll try to get to this plugin as soon as I can and come up with some solution until the update releases (for adjusting to multiFied 2.2+)

I'll let you know in this thread

Thanks

---

Any updates on this Rudi? I still don't know how to import my 2nd and 3rd level locations. :(

Sorry guys for the delay,

I finally got to the plugin and fixed it

now the solution is available below,

unzip the archive and upload the files into your plugin directory

Attachment 4170

Quote:

---

Originally Posted by Rudi

Sorry guys for the delay,

I finally got to the plugin and fixed it

now the solution is available below,

unzip the archive and upload the files into your plugin directory

Attachment 4161

---

Hi Rudi,
Thank you for the solution however I' getting "MYSQL ERROR" each time I try to upload data.

Maybe you missed something replacing the files,

send me your domain name to my PM where you encounter this error and I'll look into it

Quote:

---

Originally Posted by Rudi

Maybe you missed something replacing the files,

send me your domain name to my PM where you encounter this error and I'll look into it

---

message sent

Quote:

---

Originally Posted by Rudi

Sorry guys for the delay,

I finally got to the plugin and fixed it

now the solution is available below,

unzip the archive and upload the files into your plugin directory

Attachment 4170

---

Rudi, Can you add this patch to the plugin ?

Hello Pragash,

You can do it yourself, you need to download the archive with solution and follow the instructions below

Yes i know that, but I meant in the major plugin update with this patch

The fact is that it's a temporary solution

and the official plugin update will be later

Was this plugin updated already?

Not yet, you'd better use this fix n the near future

Thanks.

No rush.

Just checking.

Quote:

---

Originally Posted by Rudi

Sorry guys for the delay,

I finally got to the plugin and fixed it

now the solution is available below,

unzip the archive and upload the files into your plugin directory

Attachment 4170

---

Rudi, It doesn't seems to be working.

I just tested with latest installed 4.8.2 version. I haven't tested it before.

I uploaded the above files to data entries import plugin directory and tired to import the data entries from admin panel, it gives http 500 error.

Can you please check it and let me know the issue?

Maybe you did something wrong applying my solution

you'd better create a ticket and I look into it,

also attach your file with entries you try to import

I uploaded all the files to the data entries import plugin.There are 3 files overwritten with the existing files.

I don't know why it's not working. Anyway I started uploading one by one manually from admin panel.

Hi all, is there any update on this plugin, I have an import of over 1000 records and I really would prefer not to manually add them. I am receiving a 500 error. Thanks in advance!

Hello,

Unfortunately, not yet (

Have you applied my solution?

If you can't do it then you need to create a ticket and I'll help you out

Thanks for the update. Yes, I updated the three files in the plugin folder but still no joy. I also have entered a ticket on Flynax support. Thanks!

Hello Rudi,

Is it possible to transfer locations from one version to another?

Hello,

If you have the version below 2.2.0 you can update it to the latest and all the locations will be moved to a separate table automatically, i.e. from table data_formats to table multi_formats

anyway, you don't need to transfer your locations manually updating the plugin to the newer version

OK, thanks. I understood.

In the latest update, issue with Multifield/Location Filter fixed without using your patch?

My patch was just a temporary solution :)

So this issue not yet fixed with this update, right?

In fact, the update involves removing any dependencies on the multi-field plugin to make it more stable and lighter while the multi-field plugin should be remade to work properly with the data-entries plugin

But this is a second step and you need to wait some time for the new update of the multi-field

meanwhile, you'd better use the previous version of data-entries and apply my patch


Sorry for the inconvenience

Hi Rudi,

Is this plugin working now for locations import?

Thanks.

Hello,

Unfortunately, the only way is to use my solution :(

Hi,

I'll try it. Thank you.

Quote:

---

Originally Posted by Rudi

Sorry guys for the delay,

I finally got to the plugin and fixed it

now the solution is available below,

unzip the archive and upload the files into your plugin directory

Attachment 4170

---

Hi Rudi,

I uploaded and replaced the files. Now I can go to Countries but not reach the specific country I would like to upload my entries in. Any hint? Maybe I'm missing something?

https://forum.flynax.com/attachment....tid=4796&stc=1

Hello,

You need to replace files from the previous version of the plugin (1.2.1)

Quote:

---

Originally Posted by Rudi

Hello,

You need to replace files from the previous version of the plugin (1.2.1)

---

Where can I find the previous version (1.2.1)?