I want to create a series of fullwidth ion-cards populated through an array of objects

I want to iterate through an array of objects to create a series of FULLWIDTH (or halfwidth with the last one centered if count is an odd number) cards.

I have create a component which contains the card layout and am iterating through an the array using *ngFor but the col size does not seem to be affected regardless of what attributes i feed it or where I place it (within or outside the loop). The cards just size dynamically according to the text

<ion-row>   <app-artist-view *ngFor="let deal of loadedEvent.deals" [deal]='deal'></app-artist-view> </ion-row> 
<ion-col size = "12">    <ion-card>      <ion-item>       <ion-label  class="ion-text-center">{{deal.title}}</ion-label>     </ion-item>       <ion-card-content class="ion-text-center">        <ion-card-subtitle>Name: {{deal.talent.name}}</ion-card-subtitle>       <ion-card-subtitle>{{deal.performanceType}}</ion-card-subtitle>       <ion-card-subtitle>Length: {{deal.performanceLength}}</ion-card-subtitle>       <ion-card-subtitle>Status: {{deal.status}}</ion-card-subtitle>       <ion-card-subtitle>Value: {{deal.value}}</ion-card-subtitle>     </ion-card-content>   </ion-card> </ion-col>   

The cards size dynamically according to the text instead of remaining fullwidth for each component

How to add JSLink to a field through pnp?

I am trying to add a JSLink to my field through pnp the problem i am having is that pnp throws an unknown error when i am running this command (Reference):

Set-PnPField -Identity KIT_sc_ProjectType -Values @{JSLink=”~sitecollection/siteassets/jslink/groupcreation_grouptemplates.js”;Group=”KIT Fields”} -UpdateExistingLists

this the error i am getting back:

Set-PnPField : unknown error At line:1 char:1 + Set-PnPField -Identity KIT_sc_ProjectType -Values @{JSLink=”~sitecoll … + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (:) [Set-PnPField], ServerException + FullyQualifiedErrorId : EXCEPTION,SharePointPnP.PowerShell.Commands.Fields.SetField

Is it possible to add JSLink some another way to a field?

Unable to loop through the worksheets in an Excel workbook

I am trying to learn Python and trying to generate a .sql file from a mapping given to me in an excel file. But I am able to go through the rows and columns of the first sheet but unable to move forward to the next sheets. I am using Python 3.7. Each sheet would contain two columns

This is what the excel sheet columns look like

TABLE1                      TABLE2 ----------------------------------- VERSION                      NULL VALID_FROM                   USG_DT USERNAME                     MIG UD_GEPART_ID                 NULL UD_SEPART_ID                 NULL 

There can be multiple worksheets in one workbook.

Below is what I have tried so far. Please can someone point me out where I am going wrong in the code as I am not able to move to the next sheet:

import openpyxl as xl wb = xl.load_workbook("C:\New folder\MAPPING.xlsx") ws = wb.sheetnames sheet_obj = wb.active  #sheets = [wb.sheetnames] statement_a = "INSERT /*+ APPEND */ INTO " statement_b = "SELECT /*+ PARALLEL(64) */ "   for i, ws in enumerate(sheets):     stat_c = statement_b      stat_d = statement_b + ws[1+i] + " ( "  for sh in wb.sheetnames:     for col_cells in sheet_obj.iter_cols(min_row= 2, min_col= 2, max_col=2):         for cell in col_cells:             stat_c = stat_c + str(cell.value) + ", "     stat_c = stat_c.rstrip(", ")  +" FROM " + ws[1+i] + ";"     #print(stat_c)     #print("-------------------------------------------------")     for col_cellr in sheet_obj.iter_cols(max_row = 1,min_col= 2, max_col =2):         for cell in col_cellr:             stat_a = statement_a + cell.value + " ( "     for col_celli in sheet_obj.iter_cols(min_row= 2, min_col= 1, max_col=1):         for cell in col_celli:             stat_a = stat_a + str(cell.value) + ", "     stat_a = stat_a.rstrip(", ") + " )"     #print("\n")     #print(stat_a) 

CronJob in Ubuntu hanged halfway through and it removed the pid and wont reiniitiate the PID

PID hanged, got removed and it wont restart again. I am running Ubuntu on Azure and i have a couple of cronjobs that it is running perfectly. however I cannot explain the random cron job failures which the logs have not been able to show .

is there a way i can find out whether my cronjob have been failing.

Problem with offline repository downloaded through apt-mirror

I created an offline repository through apt-mirror using the package sources from Linux Mint 19.1 Cinnamon (64-bit). The download completed with no errors, yet when I run “sudo apt update” on an offline computer (same OS), I receive the following errors:

Download is performed unsandboxed as root as file ‘/media/leon/REPO/packages.linuxmint.com/dists/tessa/InRelease’ couldn’t be accessed by user ‘_apt’. – pkgAcquire::Run (13: Permission denied)Failed to obtain store:/var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic_main_dep11_Components-amd64.yml Cannot open file /var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic_main_dep11_Components-amd64.yml – open (13: Permission denied)Failed to obtain store:/var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic-updates_main_dep11_Components-amd64.yml Cannot open file /var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic-updates_main_dep11_Components-amd64.yml – open (13: Permission denied)Failed to obtain store:/var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic-backports_universe_dep11_Components-amd64.yml Cannot open file /var/lib/apt/lists/partial/_media_leon_REPO_archive.ubuntu.com_ubuntu_dists_bionic-backports_universe_dep11_Components-amd64.yml – open (13: Permission denied)Failed to obtain store:/var/lib/apt/lists/partial/_media_leon_REPO_security.ubuntu.com_ubuntu_dists_bionic-security_main_dep11_Components-amd64.yml Cannot open file /var/lib/apt/lists/partial/_media_leon_REPO_security.ubuntu.com_ubuntu_dists_bionic-security_main_dep11_Components-amd64.yml – open (13: Permission denied)Some index files could not be downloaded, have been omitted, or old ones used instead.

I scouted the Internet for answers and everybody suggests that the issue is because apt has no permissions for the folder and its contents, but it is owned by the _apt user and the root group, yet APT complains that it cannot access those files. I don’t understand what’s going on. Please help. Thanks in advance.

Storing files in database through encryption and Viewing them only on providing key for the file

I have this use case:

  1. User1 uploads his file into the database which should be encrypted.
  2. Any other users who request that file, user1 will be notified for approval, on approving other users should be able to view the file but can’t download the file.
  3. The file should be encrypted in the database so that it cannot be viewed if the database is hacked.

Does AWS Fargate only scale through adding AWS auto scaling to it?

I’m planning on shifting from EC2 to Fargate because it said it automatically “removes the need to choose server types, decide when to scale your clusters, or optimize cluster packing”. I think I understand how a cluster scales through auto-scaling rules, but that isn’t exactly automatic. So am I missing something regarding how scaling in AWS Fargate works?

As far as I understand so far, I make a basic task. I assign the task some memory and CPU, and the only way it scales is through auto scaling which will basically recreate these tasks when the need arises (either through alarms or specific rules). TIA!

Looping through rst.Fields

Pardon any errors my VBA skills are not great.

So, I’m attempting to upload excel data to a SharePoint list and I followed some tutorials to understand how I can accomplish this within a macro and I’m using ADO and SQL to achieve this. I got the connection working because in a separate Macro I was able to pull my data and send singular rows of data but I want to send several rows worth of data in the excel and I tried a common loop but it didn’t work. Ideally i’d like it if I could use the Macro to upload Row 2 to Row X (LastRow) I tried looping but either I don’t understand the syntax of this or I can’t loop it like how I figured I could.

Option Explicit Sub AddNew_SP() Dim cnt As ADODB.Connection Dim rst As ADODB.Recordset Dim mySQL As String Dim i As Integer Dim LastRow As Integer  Set cnt = New ADODB.Connection Set rst = New ADODB.Recordset LastRow = Cells(Rows.Count, "A").End(xlUp).Row mySQL = "SELECT * FROM [1];"  'open connection  With cnt     .ConnectionString = _     "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=MySite;LIST=MyGUID;"     .Open End With  rst.Open mySQL, cnt, adOpenDynamic, adLockOptimistic 'For i = 2 To LastRow rst.AddNew     'rst.Fields("Department")=[A2]     'rst.Fields("Section#") = ["B" + "i"]     'rst.Fields("Operation#") = ["C" + "i"]     'rst.Fields("Job") = ["D" + "i"]     'rst.Fields("Program") = ["L" + "i"] rst.Update 'Next i If CBool(rst.State And adStateOpen) = True Then rst.Close Set rst = Nothing If CBool(cnt.State And adStateOpen) = True Then cnt.Close Set cnt = Nothing  End Sub 

Transiting through Johannesburg to Maseru

I am a Ghanaian traveling to South Africa. I have a single entry visa to South Africa but I would like to visit Maseru first before entering South Africa.

I would like to have a direct flight to Maseru.

  1. Can I transit at the airport without having my passport stamped as having enter South Africa and then later enter South Africa by road?

  2. Do I need to pass through immigration before boarding the connecting flight to Maseru?

  3. The ticket I am holding is Accra – Joberg – Accra. Will a separate booking for Joberg – Maseru be considered a valid proof that I am not entering South Africa this not needing to go through Immigration at the OR Tambo airport?