Xjyuk

Book in which the "mountain" in the distance was a hole in the flat world

Aren't all schwa sounds literally /ø/?

A Real World Example for Divide and Conquer Method

What would be the effects of (relatively) widespread precognition on the stock market?

What does "play in traffic" mean?

What is a Romeo Word™?

why neutral does not shock. how can a neutral be neutral in ac current?

Does unblocking power bar outlets through short extension cords increase fire risk?

Brute-force the switchboard

Could a US citizen born through "birth tourism" become President?

Why didn't NASA launch communications relay satellites for the Apollo missions?

Why is the forgetful functor representable?

Do I have to mention my main characters age?

What is the difference between uniform velocity and constant velocity?

What is the minimum wait before I may I re-enter the USA after a 90 day visit on the Visa B-2 Program?

How to hook up Korg EX-8000 to a compouter w/o a keyboard?

Nilpotent elements of Lie algebra and unipotent groups

"move up the school" meaning

Why should fork() have been designed to return a file descriptor?

Difference between string += s1 and string = string + s1

What's a German word for »Sandbagger«?

Could Europeans in Europe demand protection under UN Declaration on the Rights of Indigenous Peoples?

Linearize or approximate a square root constraint

Manager is asking me to eat breakfast from now on

Date input format problem

date ranges in view filter criteriaParsing bad dates automatically with feeds and date api?Unable to import date from csv with Feeds moduleFeeds Import Date RepeatCustom date range format on a node by node basisAlter a date format in a view based on another date“Posting date” format cannot be localizedCannot format date for date field in a Views_Database_Connector viewHow to filter a date range?Create a custom date format

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

3

I need to import a large dataset (over 300,000 records) into a Drupal 8 site. I have figured out how to do this with feeds on a small test dataset.

The dates in the records are in the format June 8, 2018. I do not see a way to use a Drupal 8 Date field to input dates in this format.

I need to be able to create a view that displays records based on a date range.

What is the best way to get the data into Drupal in a format that a view can use? Would it be to maybe use computed field to transform the data while it is being imported? Or would it be better to maybe execute a SQL query after the data is imported?

datetime

share|improve this question

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

add a comment | 

3

I need to import a large dataset (over 300,000 records) into a Drupal 8 site. I have figured out how to do this with feeds on a small test dataset.

The dates in the records are in the format June 8, 2018. I do not see a way to use a Drupal 8 Date field to input dates in this format.

I need to be able to create a view that displays records based on a date range.

What is the best way to get the data into Drupal in a format that a view can use? Would it be to maybe use computed field to transform the data while it is being imported? Or would it be better to maybe execute a SQL query after the data is imported?

datetime

share|improve this question

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

add a comment | 

I need to import a large dataset (over 300,000 records) into a Drupal 8 site. I have figured out how to do this with feeds on a small test dataset.

The dates in the records are in the format June 8, 2018. I do not see a way to use a Drupal 8 Date field to input dates in this format.

I need to be able to create a view that displays records based on a date range.

What is the best way to get the data into Drupal in a format that a view can use? Would it be to maybe use computed field to transform the data while it is being imported? Or would it be better to maybe execute a SQL query after the data is imported?

datetime

share|improve this question

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

share|improve this question

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

share|improve this question

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

edited 6 hours ago

kiamlaluno♦

81.6k1010 gold badges135135 silver badges252252 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

asked 8 hours ago

FinnFinn

7177 bronze badges

1 Answer
1

active

oldest

votes

3

Rather than using Feeds, I suggest using the core Migrate module. There is also a core plugin for converting dates during migration, FormatDate. This will allow you do specific the input format and the output format. I believe, this process configuration would work in your case:

process:
 field_date:
 plugin: format_date
 from_format: 'F j, Y'
 to_format: 'Y-m-d'
 source: event_date

If Feeds is your preferred method, then you can try the Feeds Tamper module. Based on the plugin list for Drupal 8, I think you would need to do a "String to Unix timestamp" tamper on the field, followed by a "Unix timestamp to Date" tamper, using 'Y-m-d' as the format string. However, I haven't used Feeds and Feeds Tamper in a long time, and would typically write custom tampers for something like this.

share|improve this answer

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mpdonadio. I haven't used the Migrate module yet, but now may be the time to try it.
  
  – Finn
  6 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "220"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdrupal.stackexchange.com%2fquestions%2f283684%2fdate-input-format-problem%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

Rather than using Feeds, I suggest using the core Migrate module. There is also a core plugin for converting dates during migration, FormatDate. This will allow you do specific the input format and the output format. I believe, this process configuration would work in your case:

process:
 field_date:
 plugin: format_date
 from_format: 'F j, Y'
 to_format: 'Y-m-d'
 source: event_date

If Feeds is your preferred method, then you can try the Feeds Tamper module. Based on the plugin list for Drupal 8, I think you would need to do a "String to Unix timestamp" tamper on the field, followed by a "Unix timestamp to Date" tamper, using 'Y-m-d' as the format string. However, I haven't used Feeds and Feeds Tamper in a long time, and would typically write custom tampers for something like this.

share|improve this answer

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mpdonadio. I haven't used the Migrate module yet, but now may be the time to try it.
  
  – Finn
  6 hours ago
  

  
  
  
  

add a comment | 

3

Rather than using Feeds, I suggest using the core Migrate module. There is also a core plugin for converting dates during migration, FormatDate. This will allow you do specific the input format and the output format. I believe, this process configuration would work in your case:

process:
 field_date:
 plugin: format_date
 from_format: 'F j, Y'
 to_format: 'Y-m-d'
 source: event_date

If Feeds is your preferred method, then you can try the Feeds Tamper module. Based on the plugin list for Drupal 8, I think you would need to do a "String to Unix timestamp" tamper on the field, followed by a "Unix timestamp to Date" tamper, using 'Y-m-d' as the format string. However, I haven't used Feeds and Feeds Tamper in a long time, and would typically write custom tampers for something like this.

share|improve this answer

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks mpdonadio. I haven't used the Migrate module yet, but now may be the time to try it.
  
  – Finn
  6 hours ago
  

  
  
  
  

add a comment | 

Rather than using Feeds, I suggest using the core Migrate module. There is also a core plugin for converting dates during migration, FormatDate. This will allow you do specific the input format and the output format. I believe, this process configuration would work in your case:

process:
 field_date:
 plugin: format_date
 from_format: 'F j, Y'
 to_format: 'Y-m-d'
 source: event_date

If Feeds is your preferred method, then you can try the Feeds Tamper module. Based on the plugin list for Drupal 8, I think you would need to do a "String to Unix timestamp" tamper on the field, followed by a "Unix timestamp to Date" tamper, using 'Y-m-d' as the format string. However, I haven't used Feeds and Feeds Tamper in a long time, and would typically write custom tampers for something like this.

share|improve this answer

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

process:
 field_date:
 plugin: format_date
 from_format: 'F j, Y'
 to_format: 'Y-m-d'
 source: event_date

share|improve this answer

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

answered 7 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges