Publisher is EE6 compatible, but it does not support the Fluid field. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Entry created but no grid data added

Status Resolved
Add-on / Version DataGrab 4.0.4
Severity
EE Version 6.3.4

Marcus Lee-Steere

Jun 24, 2022

Hi, I am running DataGrab to import data to a Grid field from a CSV file. The entries themselves are being created but none of the Grid data is being added. It is only sample data at this stage so I have copied the error log below:

01:20:34 06/25/2022 Import #6 Started
01:20:34 06/25/2022 Import #6 Initialized
01:20:34 06/25/2022 Begin Importing [3 Armstrong Street]
01:20:34 06/25/2022 [3 Armstrong Street] is a new entry
01:20:34 06/25/2022 Added 1 entries
01:20:34 06/25/2022 Clearing all cache
01:20:34 06/25/2022 Begin Importing [3 Armstrong Street]
01:20:34 06/25/2022 [3 Armstrong Street] already exists. Updating.
01:20:34 06/25/2022 Updated 1 entries
01:20:35 06/25/2022 Begin Importing [3 Armstrong Street]
01:20:35 06/25/2022 [3 Armstrong Street] already exists. Updating.
01:20:35 06/25/2022 Updated 1 entries
01:20:35 06/25/2022 Begin Importing [3 Armstrong Street]
01:20:35 06/25/2022 [3 Armstrong Street] already exists. Updating.
01:20:35 06/25/2022 Updated 1 entries
01:20:35 06/25/2022 Begin Importing [3 Armstrong Street]
01:20:35 06/25/2022 [3 Armstrong Street] already exists. Updating.
01:20:35 06/25/2022 Updated 1 entries
01:20:35 06/25/2022 Begin Importing [4 Armstrong Street]
01:20:35 06/25/2022 [4 Armstrong Street] is a new entry
01:20:36 06/25/2022 Added 1 entries
01:20:36 06/25/2022 Clearing all cache
01:20:36 06/25/2022 Begin Importing [4 Armstrong Street]
01:20:36 06/25/2022 [4 Armstrong Street] already exists. Updating.
01:20:36 06/25/2022 Updated 1 entries
01:20:36 06/25/2022 Begin Importing [5 Armstrong Street]
01:20:36 06/25/2022 [5 Armstrong Street] is a new entry
01:20:36 06/25/2022 Added 1 entries
01:20:36 06/25/2022 Clearing all cache
01:20:36 06/25/2022 Begin Importing [5 Armstrong Street]
01:20:36 06/25/2022 [5 Armstrong Street] already exists. Updating.
01:20:36 06/25/2022 Updated 1 entries
01:20:37 06/25/2022 Begin Importing [5 Armstrong Street]
01:20:37 06/25/2022 [5 Armstrong Street] already exists. Updating.
01:20:37 06/25/2022 Updated 1 entries
01:20:37 06/25/2022 Begin Importing [5 Armstrong Street]
01:20:37 06/25/2022 [5 Armstrong Street] already exists. Updating.
01:20:37 06/25/2022 Updated 1 entries
01:20:37 06/25/2022 Import #6 End

 

The site is in a local environment at this stage so I cannot provide a login.

As the CSV is only small I have attached a screen of it, happy to provide the file if that helps.

Any help or suggestions appreciated.

Cheers

Marcus

#1

BoldMinded (Brian)

Jun 26, 2022

Hi, Marcus. Can you put the file on Dropbox or something and put the link in a private comment?

#2

BoldMinded (Brian)

Jun 26, 2022

Also include screenshots of your DataGrab config screens so I can try to replicate what you have setup.

#3

Marcus Lee-Steere

Jun 26, 2022

Comment has been marked private.

#4

BoldMinded (Brian)

Jun 27, 2022

Try the build in the next comment. You’ll need to make sure your Grid field is configured to update rows if they match a specific value:

#5

BoldMinded (Brian)

Jun 27, 2022

Comment has been marked private.

#6

Full Circle Developers

Jun 28, 2022

Is there any progress on this issue? I seem to be encountering a similar problem; DataGrab v4.0.4 and EE 6.3.4.

#7

BoldMinded (Brian)

Jun 28, 2022

Nick, create a new ticket and I’ll send you a newer build that should fix it.

#8

Marcus Lee-Steere

Jun 28, 2022

Hi Brian

No change with the new build unfortunately, still having the entry created but no grid data carried over. Using the same csv file. Deleted the EE Cache, for whatever that good that will do. Also did an uninstall and reinstall of Datagrab and recreated the fields and channel just to be sure. Same result in all cases.

Apologies for the slow responses BTW but I am in Australia so significant time difference between when I am working and you are working I expect.

Cheers

Marcus

#9

BoldMinded (Brian)

Jun 29, 2022

Can you provide more screenshots of your import settings? I’m using the same file you provided and am able to import the rows successfully.

#10

Marcus Lee-Steere

Jun 29, 2022

Comment has been marked private.

#11

BoldMinded (Brian)

Jun 30, 2022

Tell me more about this “Owners Date” column? Have you tried to match it on the “Owners Name” instead? What type of column is the date column in the field config? Is it a text field, number, date?

#12

BoldMinded (Brian)

Jun 30, 2022

Marcus, I’ve tested this again with the same csv file you sent, deleted the existing entries it imports, and re-imported them, then run the import 2 more times and it keeps the entry data intact.



#13

Marcus Lee-Steere

Jun 30, 2022

Brian, the Owners date (and Owners name) fields are both text fields due to the range of data that might be there. I had not tried matching to Owners name but tested this to no avail.

Seems then that there is something else going on. Perhaps I will wait until I have a dev version online and can let you have a look at that.

#14

BoldMinded (Brian)

2 days ago

I’m going to close this ticket out. Feel free to re-open it if you need to once you have more information and an environment I can take a look at.

Login to reply