You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I import a table from Google sheets that has 4 columns: ID (not a craft-id, just an increasing integer), Startdate (Format: dd/mm/yy), Text, Enddate (same format). After running without any problems for about a year now, it suddenly does not work anymore.
I get the error-message:
Starting processing of node #29.
Match existing element with data {"slug":"394"}
Data ready to import {"title":"394","slug":"394","postDate":"2023-01-28T23:00:00.000000Z","expiryDate":"2023-01-29T23:00:00.000000Z","enabled":true,"datum":"2023-01-28T23:00:00.000000Z","text":"Some short text"}.
Object of class DateTime could not be converted to string - 3641473fa3f8fb2ada8f0c73452aa78b.php: 38
It seems like all the data has been detected correctly. However, something must go wrong while creating the entry.
Interestingly, an update of an already existing entry does work:
Starting processing of node #28.
Match existing element with data {"slug":"393"}.
Existing element [#328064] found.
Data to update for title: "393".
Data to update for slug: "393".
Data to update for postDate: "2023-01-27 23:00:00".
Data to update for expiryDate: "2023-01-28 23:00:00"
Data to update for enabled: true
Data ready to import {"title":"393","slug":"393","postDate":"2023-01-27T23:00:00.000000Z","expiryDate":"2023-01-28T23:00:00.000000Z","enabled":true,"datum":"2023-01-27T23:00:00.000000Z","text":"Some short text"}.
Entry [#328064] updated successfully.
Finished processing of node #28.
Maybe this is also more craft-related than feedme-related. I am not sure.
I have already tried to strip down the import data to only one row, use various date-formats etc.
The site still runs on Craft 3 and it will need some more time to upgrade to Craft4, although that's planned for this year. However, we therefore really need this plugin right now.
Additional info
Craft version: 3.7.64.1
PHP version: 8.1.15
Database driver & version: MySQL 5.7.22
Plugins & versions: FeedMe 4.5.4
The text was updated successfully, but these errors were encountered:
Hi, thanks for reaching out. I’m having a hard time replicating this issue. One more thing you could try from your end is to clear compiled template caches via php craft clear-caches/compiled-templates and see if that makes any difference at all. If not, would you be able to share a screenshot of your feed mapping screen and a snippet of data you’re trying to import that triggers this issue?
Thanks for the info. This looks to be happening when trying to update the title field: #6 /craft3/vendor/craftcms/cms/src/elements/Entry.php(1625): craft\elements\Entry->updateTitle()
craft\elements\Entry->updateTitle() is only triggered when the entry type has a dynamic title format.
I can replicate this issue if I use {postDate} as a title format. It works as expected if I change that to {postDate|date('d/m/y')}. The same would happen if I used expiryDate in the title format.
I’m going to go ahead and close this, but if you have any more issues, please feel free to let me know.
Description
I import a table from Google sheets that has 4 columns: ID (not a craft-id, just an increasing integer), Startdate (Format: dd/mm/yy), Text, Enddate (same format). After running without any problems for about a year now, it suddenly does not work anymore.
I get the error-message:
It seems like all the data has been detected correctly. However, something must go wrong while creating the entry.
Interestingly, an update of an already existing entry does work:
Maybe this is also more craft-related than feedme-related. I am not sure.
When running the debug mode, I get the following:
I have already tried to strip down the import data to only one row, use various date-formats etc.
The site still runs on Craft 3 and it will need some more time to upgrade to Craft4, although that's planned for this year. However, we therefore really need this plugin right now.
Additional info
The text was updated successfully, but these errors were encountered: