Mfcttrf

Aren't all schwa sounds literally /ø/?

Fast algorithm for finding all solutions of simple equation involving only addition of terms from list

Is art a form of communication?

BIP-23 criticism: Is bitcoin PoW actually sha256+merkleGeneration? Or have I misunderstood coinbase/append?

Host telling me to cancel my booking in exchange for a discount?

Making an example from 'Clean Code' more functional

setcounter is not affecting numbering

What does a Nintendo Game Boy do when turned on without a game cartridge inserted?

Animating the result of numerical integration

Discretisation of region intersection in 3D

Inside Out and Back to Front

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

Time war story - soldier name lengthens as he travels further from the battle front

Infinite points on circle

Linearize or approximate a square root constraint

How is it possible for the induced emf to take negative values in Faraday's Law of induction?

Remove side menu(right side) from finder

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

Will a ThunderBolt 3 (USB-C?) to ThunderBolt 2 cable allow me to use a MacBook Pro as second monitor?

Polynomials with natural coefficients arising from exponentiation and sums

How much did all the space agencies spent on rockets launching and space exploration? What are the benefits for me and you?

Alignment problem with a mathematical equation in a presentation in beamer

Linux ext4 restore file and directory access rights after bad backup/restore

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

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 6 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 6 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 6 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 6 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 6 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

answered 6 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges

answered 6 hours ago

mpdonadio♦mpdonadio

34.4k66 gold badges7575 silver badges136136 bronze badges