How to generate csv file from table data and save in specific path?

 A simple way to generate a CSV file from a database table is the "file_put_contents" function. here we are giving an example of this.

Code:

// Given exmaple is relate from drupal query..

function array2csv($data, $delimiter = ',', $enclosure = '"', $escape_char = "\\")

{

    $f = fopen('php://memory', 'r+');

    foreach ($data as $item) {

        fputcsv($f, $item, $delimiter, $enclosure, $escape_char);

    }

    rewind($f);

    return stream_get_contents($f);

}

$data = array();  

$watchdog_results = db_query("SELECT wid,uid,type,message,severity,link,location,referer,hostname,timestamp FROM watchdog")->fetchAll();

if(!empty($watchdog_results)){

// for adding first Header row

$data[] = array(

  'wid',

  'uid',

  'type',

  'message',

  'severity',

  'link',

  'location',

  'referer',

  'hostname',

  'timestamp',   

);

// for adding content rows

foreach($watchdog_results as $line){

   $data[] = $line;  

}

}

$array = json_decode(json_encode($data), true);

$csdata = array2csv($array);

file_put_contents('/code/watchdog-report.csv', $csdata);

// here "/code/watchdogcustom-report.csv" is our located file path and filename, you can write filename as you want and also locate in any path.

In Drupal, you can use this code anywhere you want like, in any controller or hook_cron function, etc.

Note: If have any suggestions or issue regarding 'How to generate csv file from table data and save in specific path?' then you can ask by comments. 

How can we update Drupal version?

Easy way to update Drupal website, we just have to follow some steps.

Step 1: Please take website full backup(files + database). We can use Backup and Migrate module ( https://www.drupal.org/project/backup_migrate )

Step 2: Site should be in maintanance mode because it can be broken updation time.

Step 3: Please take care of your patch code that already applied in core.

Step 4: Take a backup of Important files like 'robots.txt', '.htaccess', 'settings.php', 'web.config'. We will not update these files otherwise you will not get your old website.

Step 5: Now upload or override New version of drupal files except of given Step 4 files and 'modules','profiles','themes' folder because in new version these 3 folders will be empty.

Step 6: After full upload of files override Step 4 files.

Step 7: Clear the cache of website.

Step 8: Run update.php file via https://yourserver.com/update.php But by default this file is blocked, you have to enable this feature by setting.php file, go to setting.php file and change the option $settings['update_free_access'] = FALSE; to $settings['update_free_access'] = TRUE;

Step 9: After that save setting.php file and clear cache and hit https://yourserver.com/update.php after completion of process you can check you finally updation of site via https://yourserver.com/admin/reports/updates.

Note: If have any suggestions or issue regarding 'How can we update Drupal version?' then you can ask by comments. 

What is the difference between upgrade and update in Drupal?

It's easy to understand, what is upgrade and update, please have a look.

Update: If Drupal gives minor change version like Drupal 8.0.1 to 8.2.0, so that is update.

Upgrade: If Drupal gives major changes version like Drupal 6 to Drupal 8 or from Drupal 7 to Drupal 8,  that is upgrade.

Note: If have any suggestions or issue regarding 'What is the difference between upgrade and update in Drupal?' then you can ask by comments. 

How to load CSS or JS in footer?

If, we have to load CSS and JS in header or footer in Drupal 8, so we will call our CSS or JS in '*.libraries.yml' file, there we will use scope attribute for this purpose.

we just have to pass the option value either header or footer.

like: scope:footer  or  scope:header 

Example:

If our yml file is mytheme.libraries.yml and we are attached assets there..

slick_slider:

  css:

    theme:

      slick.min.css: { type: external, scope:footer }

  js:

    slick.min.js: { type: external, minified: true, scope: header }

  dependencies:

    - core/jquery

Note: If have any suggestions or issue regarding 'How to load CSS or JS in footer?' then you can ask by comments. 

How to remove or cleanup old aggregated css and js files?

It's very problematic question that how we remove old aggregated css and js files otherwise folder will be too large.

In drupal we have 2 functions drupal_clear_css_cache() and drupal_clear_js_cache() that are creating our aggregation files and store in css and js folder in files/css or files/js folder.

In drupal we have on special variable `drupal_stale_file_threshold` and the default value of this 30 days, it means after 30 days old aggregated file will automatically removed and we can change this 30 days value or less then 30 days like..

Code:

variable_get('drupal_stale_file_threshold', 2592000) //for 30 day. 

variable_set('drupal_stale_file_threshold', 172800) //for 2 days.  

Note: In drupal, we have advance aggregation module, there we have delete old aggregated files option.

Note: If have any suggestions or issue regarding 'How to remove or cleanup old aggregated css and js files?' then you can ask by comments. 

How to permanent delete unused files in Drupal 8?

Drupal 8, we can programmatically delete our unused files(assets) easily. we just have to write the code in custom module file in `hook_cron` function. After put the code and clear the cache whenever you hit the cron manually or automatically will run this code will execute.

Code:

/**

 * override hook_cron()

 */

function mymodule_cron()  // mymodule will replace with module name

{

  // get all files ids

  $fids = Drupal::entityQuery('file')->execute();

  $file_usage = Drupal::service('file.usage');

  // loop all fids and load files by fid

  foreach ($fids as $fid) {

    $file = Drupal\file\Entity\File::load($fid);

    $usage = $file_usage->listUsage($file);

    // check if file not used

    if (count($usage) == 0) {

      $file->delete();

    }

  }

}

Note: If have any suggestions or issue regarding 'How to permanent delete unused files in Drupal 8?' then you can ask by comments. 

How to create node programmatically in drupal 8?

Simple way to create node in Drupal 8 is use of Node::create() function. We are going to explain with an example.

Code structure:

$entity_type = 'node';

$values = [

  'nid' => NULL,

  'type' => 'article', // put the content type machine name here..

  'title' => 'Testing title', // title of the node..

  'uid' => 1, //user id for node publisher or use \Drupal::currentUser()->id() for default logged-in user id..

  'status' => TRUE, // published..

  'field_metatags' => serialize([

        'title' => 'Some title',

        'description' => 'Some description.',

      ]),

];

$node = \Drupal::entityTypeManager()->getStorage($entity_type)->create($values);

$node->save();

OR 

We have another code for node creation…

    $nodeArray = array();

$nodeArray = array(

'type' => 'resources',

'langcode' => 'en',

'uid' => '1', //\Drupal::currentUser()->id(),

'status' => '1',

'title' => $row->title,

'created' => strtotime($row->created),

'path' => [

  'alias' => $row->page_url,

  'pathauto' => PathautoState::SKIP,

]

);

$node = \Drupal\node\Entity\Node::create($nodeArray);        

$node->set('body', ['value' => $row->body, 'summary' => '', 'format' => 'full_html']);

$node->set('field_resources_content_type', $row->field_resources_content_type);

$node->set('field_resources_lob', $row->field_resources_lob);

$node->set('field_resources_vidyard_id', $row->field_resources_vidyard_id);

$node->set('field_instrument_description', $row->field_instrument_description);

$node->set('field_source', $row->source);

$node->set('field_expiration_date', $row->field_expiration_date);

$node->set('field_meta_tags', serialize([

  'title' => $row->field_meta_title,

  'description' => $row->field_meta_description,

  'keywords' => $row->field_meta_keywords,

]));

$document_url = $row->field_resources_asset_tagging;

$extfile_info = basename($document_url);

$filename = explode(".", $extfile_info);

list($ext_name, $extension) = explode(".", $extfile_info);

//$name = $filename[0] . '.' . $extension;

        $name = $extfile_info;

        $savepath = str_replace($base_url.'/sites/default/files/','',$document_url); 

$uploaded_file = file_save_data(file_get_contents($document_url), "public://".$savepath, FILE_EXISTS_RENAME);

$file_url = $uploaded_file->getFileUri();

$fid = $uploaded_file->get('fid')->value;

if (!empty($uploaded_file)) {

    $node->set('field_resources_asset_tagging', ['target_id' => $fid]);

} else {

drupal_set_message('file not uploaded for '.$row->title,'warning');

}

$thumbnail_url = $row->field_resources_thumbnail;

if($thumbnail_url!=''){

$extfile_info1 = basename($thumbnail_url);

$filename = explode(".", $extfile_info1);

list($ext_name, $extension) = explode(".", $extfile_info1);

//$name = $filename[0] . '.' . $extension;

$name = $extfile_info1;

$uploaded_thumbnail = file_save_data(file_get_contents($thumbnail_url), "public://importcsv/$name", FILE_EXISTS_RENAME);

$file_url = $uploaded_thumbnail->getFileUri();

$fid = $uploaded_thumbnail->get('fid')->value;

if (!empty($uploaded_thumbnail)) {

$node->set('field_resources_thumbnail', ['target_id' => $fid]);

}

}

        $res_save = $node->save();

Here we are giving an example for node create programmatically in Drupal 8, default fields, entity reference field, text field, list field, image upload, PDF upload in Node::create() code.

Note: If have any suggestions or issue regarding 'How to create node programmatically in drupal 8?' then you can ask by comments.