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, 2022Hi, 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
BoldMinded (Brian)
Jun 26, 2022
Hi, Marcus. Can you put the file on Dropbox or something and put the link in a private comment?
BoldMinded (Brian)
Jun 26, 2022
Also include screenshots of your DataGrab config screens so I can try to replicate what you have setup.
Marcus Lee-Steere
Jun 26, 2022
Comment has been marked private.
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:
BoldMinded (Brian)
Jun 27, 2022
Comment has been marked private.
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.
BoldMinded (Brian)
Jun 28, 2022
Nick, create a new ticket and I’ll send you a newer build that should fix it.
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
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.
Marcus Lee-Steere
Jun 29, 2022
Comment has been marked private.
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?
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.
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.
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.