Getting a fatal error when running imports \

The more I look into this, the more I'm unimpressed. Just changed the website to 8.4 to see what happens and got this when I ran the import.

A fatal error has occurred.

0%

str_getcsv(): the $escape parameter must be provided as its default value will change. 

Even on the "working" PHP 8.0, the unique key logic fails and creates duplicates. This indicates to me that the plugin is having major issues, not just incompatible. Happy to be proved wrong, but unless you can come back with a proper fix in the next couple of days, I think I'll be pushing for a refund and be moving to a different product. I have spent a whole day trying to get this working. 

Hi David,

Sorry to hear you are having issues with the plugin.

If you would like a refund, you should be able to do this on codecanyon and i can then accept the refund request.

To help me out with the php 8.3 error, does your server have error logs, if so can you attach them so i can see what the error is?

When you mention th unique key logic fails, can you confirm what you have selected, if you are looking to update existing records you should use the unique identifier option "Select a template field to be used as the unique identifier", and then select the template field you wish to use, otherwise if you have selected "Select data from your import file" then you are only only referencing rows in the file that have been previously imported.

James

Hi James

Thanks for refund info. I'm happy to let you have a look through first, before I go down that route. 

I've checked the logs on the server and php wasn't activated, so I've turned that on. I've tried to re run the import several times, and it's not generating anything in the error_log_[domain] file. The last time that log was written to was 3 days ago. Happy to still post it if you need. Let me know if there is any other log etc you need. 

For the unique identifiter, I'm selecting that in the identifier field and that is a unique number for each row, eg. b000001, b000002 etc from the csv file. 

Cheers
David

Thanks, no if the log is not written to it will show no info.

Can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

Can you also export and attach your jet engine skin, along with your csv file? or similarily structured one to test.

James

Can you confirm what the permissions "unique identifier" was set to, as the importer config is empty? Or let me know what column of the csv you wish to use as the unique identifier to stop the duplicates.

I have attached an modified version of the importwp-jet-engine plugin, this fixes an error thrown in php 8.3 when no image is present.

James

Hi James

I'm not sure what you mean. My "unique identifier" is just a meta field under the Business post type that has a unique alpha/numeric setup for each business to confirm which business is which.

I'm just about to head out, I'll try the updated plugin when I get back. 

Cheers
David

Ok, so I've installed the updated plugin. 

Pros: 
No longer giving me that error and the import actually finishes it's cycle

Cons:

It's still creating a separate business with the same unique number that is already there, but if I add a business via the importer, make a change to it on the csv, upload the new csv it updates it. Anything already there, it just assumes it's not there. 

So I'll try a few more things, then if that looks ok, I might just delete all the businesses, then recreate all the businesses from the CSV and go from there. 

Will update after I've done that. 

If you set the unique importer to "Select a template field to be used as the unique identifier for each record." and then set the template field to "bussiness_id" by typing it in the input. (as shown in the screenshot) it will search for existing records with that custom field set.

However since you have imported duplicate records already it will fail to import some rows and say that there were multiple records found matching the unique identifier (removing the duplicates should resolve this).

I've setup another import. This time I have discounts cpt, which link back to a parent business cpt. I've exported the list of system IDs of each business. I've added them to the discounts, so that the discount links to the company that is offering it. 
If I import it, in the preview it picks up the correct ID, 1242, but each time I run the import, it sets the ID of the parent to 1254. I've deleted the item and re imported and the same thing happens. See attached. 

Can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

ANd also attach the csv being used.

Here's the json file of the single line import for my discounts, plus the csv file I used for the import

Hi David,

Just to confirm, that when you import the first row in the csv file, it imports as 1242 or 1254?

When you mention that the discount links back to the buisness system id, i take it you are not using the post_parent field for this, as the post parent field links to parent items in the same post type?

I can see no issue with your importer config as it is setup like i would expect, running the importer locally updates the post_parent field with the correct id.

The post parent field passes the value set in the importer directly as the post parent (only modifies the value by confirming it is numeric).

James

Hi James

I've just spent a couple more hours stuffing around with. I've even tried getting help from ChatGPT. It suggested adding some PHP, which still doesn't seem to work. 

I think I've wasted enough of your time, I don't think this is going to work for me. I'll put in for a refund. Appreciate your help in trying to get it to work, but I think to keep trying to fix it, we are both spending too much time on this issue. 

Cheers
David