text:
Q: Optocoupler delay off MOSFET solenoid This is to trigger a 12v solenoid (acting as a laser shutter) with 5v (JP2) thru an optocoupler.
The problem is 5v line have bit fast interruptions on a laser show, so I'd like to add a bit of delay OFF (say 0,5sec) in order the shutter remains active (energised) when this fast OFF interruptions happens (you know, to avoid click-click shutter open-close noise)
So I think I need to put a capacitor and maybe resistor+capacitor, but sorry, I don't know where on this circuit...could you help me please?
Many thanks

maybe this one?

A: The biggest problem with your circuit is that it works backwards from what you want. With 5 volts applied to the optoisolator, the OI will turn on, and the MOSFET gate will be pulled low, and the MOSFET will turn off. So the shutter coil will not be energized when 5 volts is present. Is this a problem? I'll assume not.
Then, for a 0.5 second delay, your proposed circuit won't work - both the resistor and the capacitor are too small. A 10k resistor and a 100 to 200 uF will probably do what you want. Just be aware that the delay will vary from MOSFET to MOSFET, over about a 2:1 range.


text:
Q: How to count all rows in a list with more than one criteria I want to count all the rows for specific values in a list
for example, if i want to count rows from this sheet for columns c, f and j

and seperate them by their values here:

what would be the best way to do this?
I tried using:
=COUNTIFS('REBOUND DEFECT LOG AND HOPPER'!C:C,'Area '!B4,'REBOUND DEFECT LOG AND HOPPER'!F:F,'Area '!C2,'REBOUND DEFECT LOG AND HOPPER'!J:J,'Area '!C3)

but it isn't giving the correct count.

A: If you are using Excel365, the new dynamic array function FILTER is just what you are looking for.
for instance, in your table you can use:
=Count(FILTER(C4:C12,sheet1!D4:D12="Recived",sheet!E4:E12="In Process"))

To count the rows where the values in sheet 1 that feet two criteria.
Sorry, I don't quite understand the logic you require in you question so this is a general answer/

redpajama_set_name: RedPajamaStackExchange


text:
Q: The result of a standard form line equation If we substituted a point in the standard form equation, what the resulting number indicates?
For example:
We have the line:
$$3x + 6y + 12 = 0$$
And we have the point $I(1,2)$
Substituting I in the line equation:
$$3(1) + 6(2) + 12 = 0$$
$$=> 27 = 0$$
Does this only means that the point does not belong to the line?
And what the $27$ indicates in this example?
(I know that if the resulted number is positive that means that the point is above the line and if it is negative the point is below the line). But my question is that if the number $27$ indicates something, apart from the sign

A: A point $P(a,b)$ is in the line $3x+6y+12=0$ if, and only if,
$$3a+6b+12=0.$$
In this case since the LHS is just $3(1)+6(2)+12=27$ and the RHS is just $0$, so $LHS\not=RHS$ and it follows that the point $I(1,2)$ is not the line $3x+6y+12=0$.

A: General reference : https://en.wikipedia.org/wiki/Distance_from_a_point_to_a_line
Here is an answer that (I think so) adresses the question.
Let us write the equation of line L under the form
$$f(x,y)=0 \ \text{where} \ f(x,y)=ax+by+c$$
Plugging the coordinates $x=x_0, y=y_0$ of point I in it,
Result: The value of $f(x_0,y_0)$ is proportional to the oriented (shortest) distance of I to the straight line L, with a constant proportionality factor.
Otherwise said : there exist a constant $K$ such that:
$$f(x_0,y_0) = K  \times \ \text{dist}((x_0,y_0), L) \tag{1}$$
What is meant by "signed distance" ? Its absolute value is the ordinary distance ; its sign indicates the side of the straight line where point $I(x_0,y_0)$ is situated.
Example : In the graphical representation, $f(x,y)=x+y-1$ (in red), the values of $f(x_0,y_0)$ for different points are given. You can check that they are all proportional to the distance, with a proportionality factor equal to $\sqrt{2}=\sqrt{a^2+b^2}=sqrt{1^2+1^2}$.
This graphical representation features different "level lines" for function $f(x,y)=c$ :

Example : point $I(1,1)$ is such that
$$f(1,1)=1 \tag{2}$$
The constant $K$ being $\sqrt{2}$, formula (1) gives:
$$dist(I,L)=1/\sqrt{2}=\sqrt{2}/2$$
which is indeed half the length of the diagonal of a square with side 1.
Remark: there is a re-interpretation using a generalization of (2) by considering equation $z=f(x,y)$, which is the equation of a slant plane P intersecting horizontal plane along line L. The level lines mentionned above are plainly the projection onto horizontal $x-y$ plane of level lines of this plane P. I don't go further on because I know by experience that invoking 3D geometry for understanding 2D concepts is often very fruitful, but can also be confusing for learners.

A: Take the general form of the line $A x + B y + C = 0$ and calculate the perpendicular distance to an arbitrary point $(x,y)$
$$ {\rm dist} = \frac{| Ax +By+ C |}{\sqrt{A^2+B^2}}$$
You are asking about the numerator. If you normalize the coefficients of the equation such that $A^2+B^2 = 1$, then $f = |A x + B y + C| $ is just the distance to that point.
If $A x + B y + C =0 $ is zero then the point belongs on the line.

*

*The signed distance to a point is $$ {\rm dist} = \frac{ Ax +By+ C }{\sqrt{A^2+B^2}}$$ the sign is negative if the point is closer to the origin from the line, and positive of the point is beyond the line.

*The normal vector of the line is $$\boldsymbol{n} = \frac{1}{\sqrt{A^2+B^2}}  \pmatrix{-B \\ A}$$ The normal vector is defined here as pointing towards the origin
You can parameterize the equation of the line using its direction angle $\psi$ and distance from origin $d$ as
$$ (\sin \psi) x + (-\cos \psi) y + (-d) = 0 $$
where $A=-\sin \psi$, $B=\cos \psi$, and $C=-d$


text:
Q: Request in PhantomJS and NodeJS not working in specific webpage I'm trying to get information from a site using Phantom on NodeJS. My code is as follows:
const phantom = require('phantom');

const instance = await phantom.create(['--local-url-access=false', '--ssl-protocol=any']);
const page = await instance.createPage();

await page.on('onResourceRequested', function(requestData) {
    console.info('Requesting', requestData.url);
});

page.open('https://www.google.com/').then(async (status) => {
    await instance.exit();

    resolve(null);
}).catch((err) => {
    reject(err);
});

It works without problems, but when I put the url https://reclameaqui.com.br does not load the content

A: When I am using this code in an API it is working fine.
var express = require("express");
var router = express.Router();
const phantom = require("phantom");

/* GET home page. */
router.get("/", async function(req, res, next) {
  res.render("index", { title: "Express" });

  const instance = await phantom.create([
    "--local-url-access=false",
    "--ssl-protocol=any"
  ]);
  const page = await instance.createPage();

  await page.on("onResourceRequested", function(requestData) {
    // console.info("Requesting", requestData.url);
    console.log(requestData);
  });

  page
    .open("https://reclameaqui.com.br/")
    .then(async status => {
      await instance.exit();

      resolve(null);
    })
    .catch(err => {
      reject(err);
    });
});

module.exports = router;


text:
Q: Tabulator data from Postgres Database I have tried to load the data from the file json.php with this code and it's work fine
$data = [
    [id=>1, name=>"Billy Bob", progress=>"12", gender=>"male", height=>1, col=>"red", dob=>"", driver=>1],
    [id=>2, name=>"Mary May", progress=>"1", gender=>"female", height=>2, col=>"blue", dob=>"14/05/1982", driver=>true],
    [id=>3, name=>"Christine Lobowski", progress=>"42", height=>0, col=>"green", dob=>"22/05/1982", driver=>"true"],
    [id=>4, name=>"Brendon Philips", progress=>"125", gender=>"male", height=>1, col=>"orange", dob=>"01/08/1980"],
    [id=>5, name=>"Margret Marmajuke", progress=>"16", gender=>"female", height=>5, col=>"yellow", dob=>"31/01/1999"],
];

//return JSON formatted data
echo(json_encode(["last_page"=>30, "data"=>$data]));

But my data is stored into a table of database in postgres.
in the same file I replaced the code with this one, but not work
$sql = "SELECT * from cross_reference";
$result = pg_exec($sql);
$data = array();
while($row = pg_fetch_assoc($result)) {
     $data[] = $row;
}
echo (json_encode(["last_page"=>30, "data"=>$data]));

Can you help me please!?
Thank you

A: That would depend on two things, the setup of your table and the data you are getting from your database.
If you have set up Tabulator for pagination then your response is correct, if you are not using pagination then you just need to return the json encoded data variable.
if you post a copy of your table definition object in your question i can give a more specific answer


text:
Q: GoogleMaps on Android showing grey squares I have a Eclipse Android project of my colleague in which development i need to continue. When I install .apk file from bin directory of his project, everything is going fine, Google Maps are working. But when I import project into Eclipse and then use my .apk file generated by imported project, google maps are not working. On screen are little grey squares instead of Google Maps. May the problem be in API key? I´m using key which has been generated by colleague on his computer.
Thanks for your help...

A: You seem to either be using your colleagues debug key or perhaps a deploy key he has created. You either have two options.

*

*Sign up for API access using your own debug key

*Get his debug key and override your own debug key

A: On every computer,that you work on your Google map application you have to generate your own SHA1 key
for this specific machine and register it via the Google API Console together with you package name of the application.
You can check this blog post I wrote on doing just that:
Get your Google Map API V2 key


text:
Q: What does it mean to extend curves to the projective line The question is (from Arnol'd 's book : Ordinary Differential Equations):
"Which of the differential equations $ \dot x = x^ n$ determine on an affine line a phase velocity field that can be extended without singular points to the projective line?"
The answers that are given are n = 0,1,2.
In the book from where I got this question, phase velocity field is when you plot the function $ v (x) = \dot x = x^n $ against $x$. $x$ is on the vertical axis and $v(x)$ on the horizontal one.
For $\dot x = x$ and $\dot x = 1 $, the phase velocity fields are a diagonal line and a vertical line, respectively. So it makes sense that these are solutions. On the other hand, $\dot x = x^2$ has the phase velocity field that looks like $ y = \sqrt x $, which is what the phase velocity fields look like for higher values of n (although they get flatter faster).
So what I don't understand is why is $ n = 2 $ a solution, but not $ n > 2 $
So where am I going wrong? Any help is appreciated. Thanks in advance.

A: What Arnol'd is asking is about the behaviour of the solution on $\mathbb R \cup \{\infty\}$, which is obtained by "gluing together" the ends of the real line at a "point at infinity". You can also visualize this as an attempt to map $\mathbb R$ to a circle $S^1$ stereographically. Take a look at the image below. We draw a line from the North pole $N$ of the circle, through any point $P$ on the circle, and then we identify the point $P'$ on the real line with the point $P$ on the circle. You can try obtaining an explicit formula however it's pretty much clear that it's one-to-one and onto - except for the case when $P=N$ - that is, when $NP$ and the real line become parallel. If $P$ approaches $N$ in an anticlockwise direction, the corresponding $P'$ approaches $+\infty$. For the other direction, it approaches $-\infty$. The projective real line is simply defined as having that one extra point, making the stereographic projection a bijection.

Now we're coming to what Arnol'd is asking. If we stay on the real line, a solution to a differential equation can diverge in finite time. However on the projective real line, nothing "diverges", it just reaches the point at infinity in finite time. Or: it reaches the North pole in finite time. Now if we move $P$ to $N$ and then continue going, we will end up on the negative real line.
Arnol'd asks: what solutions are nonsingular on the projective line? Well, yes we want to avoid "singular points", but we can think of this as passing from the positive real axis to the negative real axis continuously, with just an added minus sign that indicates we are now on the negative real line.
The solution to the equation $\dot x = x^n,n>1$ is $$x(t)= c_n\left(t_{\infty}-t\right){}^{\frac{1}{1-n}},$$
where $c_n:= (n-1)^{\frac{1}{1-n}}$, and $t_{\infty}:=\frac{x(0)^{1-n}}{n-1}$, so that $x$ blows up at $t=t_{\infty}$.
This is already in a form of "series expansion" around $t_{\infty}$. For instance, we can see that for $n=2$, we have $$x(t)=c_2 \frac{1}{t_{\infty}-t},$$
so that $$\lim_{\epsilon\rightarrow 0} x(t_{\infty}-\epsilon)=+\infty$$ and $$\lim_{\epsilon\rightarrow 0} x(t_{\infty}+\epsilon)=-\infty.$$
This is good, this is what we were talking about. If you plot the solution, you can see that it blows up, reaching its vertical asymptote, and then reappearing to the right of the asymptote from below, from $x=-\infty$. However, for $n>2$,
$$\lim_{\epsilon\rightarrow 0} x(t_{\infty}-\epsilon)=\lim_{\epsilon\rightarrow 0} c_n \frac{1}{\epsilon^{\frac {1}{n-1}}},$$
yet
$$\lim_{\epsilon\rightarrow 0} x(t_{\infty}+\epsilon)=\lim_{\epsilon\rightarrow 0} c_n \frac{1}{(- \epsilon)^{\frac {1}{n-1}}}.$$
If we extract the minus, we get a factor of $(-1)^\frac {1}{1-n}=e^{\frac{i \pi}{1-n}}$, which is not a real number! Clearly we have gotten out of the projective real line by trying to extend time beyond $t_{\infty}$, and ended up on some new branch of the appropriate complex function. I hope this helped! And I will leave the asker to re-examine the cases $n=0,1$ from this point of view!


text:
Q: Finding velocity of rock when it hits the ground. So, suppose a rock is thrown upward with a speed of $30ft/s$ from the edge of a building $200ft$ above the ground. How would you find the speed of the stone when it hits the ground also assuming acceleration due to gravity is $-32ft/s^2$?
I know that 30ft/s is the initial speed of the stone, 200 is the position at time t=0, and the rock is accelerating at a rate of -32ft/s. I know the kinematic formulas such as $\int a=v(t)$, $\int v(t)=s(t)$
So $s(0)=200$ and so on but I just can not see how all of this fits together for the problem. Any help to set up the initial equations would be appreciated.

A: Notice, the maximum height $(h_{max})$ obtained by the rock above the building where the final vertical velocity becomes zero.
Hence, using third equation of motion (moving upwards) $$v_y^2=u_y^2-2gh_{max}$$ setting the corresponding values, we get $$0=(30)^2-2(32)h_{max}\implies h_{max}=\frac{225}{16}$$
Now, the rock starts falling down from the highest point at a height $h=h_{max}+200=\frac{225}{16}+200=\frac{3425}{16}$ from the ground & there the initial vertical velocity is zero i.e. $u_y=0$
Hence, using third equation of motion (falling downwards) $$v_y^2=u_y^2+2gh$$ setting the corresponding values, we get $$v_y^2=0+2(32)\left(\frac{3425}{16}\right)$$$$v_y=\sqrt{13700}$$
$$\color{red}{v_y=10\sqrt{137}\approx 117.047\ ft/s}$$


text:
Q: Bootstrap media vs pulls I have the following header I am trying to code responsively using Twitter Bootstrap:

Now for the purple menu bar I am going to use a navbar. However, for the content above, I am really trying to determine the best approach. I am stuck between using media or pull-left and pull-right. I am really unsure what the best approach for this would be.
Any recommendations as to the proper way of coding this using Bootstraps built in classes would be appreciated. Please note that only the logo would be an image, everything else would use fonts and font icons.

A: Use Bootstrap grid system for the content above.
The only thing here where the Media object suits is the "phone number and email" part.
For "follow us" use nested rows/cols.

It would have been a lot easier to help you if you had provided us code too.

A: In bootstrap you should build a row with different columns. See my example:

Lef content

middle content

Right content


text:
Q: How to solve the issue of NetSuite Restlet timeout limit issue? Now I am working on NetSuite Restlet for the first time.
I have the following data retrieved from savedSearch.
{
  "recordType": "receipt",
  "id": "sample-id",
  "values": {
    "customer.customerid": "sample-id",
    "customer.customercompany": "sample-customercompany",
    "customer.addressone": "sample-addressone",
    "customer.addresstwo": "sample-addresstwo",
    "customer.addresscity": "sample-addresscity",
    "customer.addressstate": "sample-addressstate",
    "country": "Australia",
    "transacitionrecordid": "sample-id",
    "unit": "Dollar",
    "total": "120"
  }
}

And I have to loop the resultsets and push each record to the array and return the array at the end.
There are no fields that I can drop. All the fields have to be included.
The problem is that the number of records is roughly 31,000.
When I run my script, the execution goes over 5 mins which is the Restlet execution time limit.
Here is my script.
define(['N/search'], function(search) {
  function get(event) {
    var saved = search.load({ id: "search-id" });
    var searchResultSet = saved.run();

    var results = [];
    var start = 0;

    do {
      searchRecords = searchResultSet.getRange({ start: start, end: start + 1000 });
      start = start + 1000;
      results.concat(searchRecords);
    } while(results.length);

    return JSON.stringify(results); // return as string for now to see the output on browser
  }

  return {
    get: get
  };
})

This is what my script looks like.
Ideally, I call this script once and return the whole 31,000 records of data.
However, due to the execution limit, I am thinking of passing a parameter(works as a pointer?index?cursor) and passing this variable to getRange function as a starting index.
I have tested and I can call for 10,000 records. So call this script 3 times by passing the parameter like 0, 10000, 20000.
But is there any better way to solve this issue? What I am really looking for is to call this script only once and return 31,000 records without having the issue of timeout.
Can I have any suggestions, please?
Thank you very much in advance.

A: It sounds like you need a map reduce script type. I am not sure what the overall result you are trying to achieve is but in general MapReduce scripts are made for processing large amounts of data.
The script can be scheduled OR you can trigger it using N/Task (seems like this is what you need if you want to trigger it from the RESTLET)
MapReduce scripts have 4 native functions. Each function has its own usage limit each time it is triggered which makes it ideal for processing large amounts of data like this.
The first is used for generating the dataset (you can return a search: return search.create({}) )
Second is for grouping data - it will run once per search result.
Third is for executing code on the data - it will run once per unique key that was passed from the previous funciton.
Fourth is for summarizing the script. You can catch errors here etc.
It is possible that 31k results will be to large for the first function to query in which case you can split it into sections. For example get up to 5k results and then in the summarize check if there are still more results to process and if there are trigger the script again (to do this you will need multiple deployments and a marker on the transaction to tell you that it was updated OR a global field which holds the the last chunk of data that was processed)


text:
Q: Unsupported major.minor version 52.0 with web app built with eclipse, server is tomcat 7 I have recently upgraded my development machine to Ubuntu 18.04 and have been revisiting and checking some old projects, one of which is built under Eclipse oxygen and deployed using Tomcat 7.
To the best of my memory this project worked when deploying the .war file to the private instance of tomcat (running on port 10080) and the main, autostarting instance on 8080.
It still works on 10080 but when I deploy to 8080 and open through a browser, I see

javax.servlet.ServletException: java.lang.UnsupportedClassVersionError: org/eclipse/jdt/internal/compiler/env/INameEnvironment : Unsupported major.minor version 52.0

I have $JAVA_HOME as JAVA_HOME="/usr/lib/jvm/java-8-oracle"
The main tomcat manager page shows :

Apache Tomcat/7.0.68 (Ubuntu)     JVM version 1.7.0_80-b15

I have set the the eclipse compiler compliance level to 1.7.
I am completely baffled as to why one instance is OK and the other not. I don't want to change the JAVA_HOME, so I think it must be something to do with the tomcat configuration or the internal compiler but can't seem to sort it out.
All sensible suggestions will be gratefully received.
Edit:
This is not a duplicate of a question, as I have built one war file and exported it to ~/junk. After that I have copied and pasted it to the separate webapps folders for the two Tomcat instances. I think it's a tomact configuration issue but I can't see what. Please don't mark it as duplicate
Edit 2:
Looking at how the tomcat was started as a service with systemctl I see:
nick@nick-X555LAB:~$ systemctl status tomcat7.service
tomcat7.service - LSB: Start Tomcat.
   Loaded: loaded (/etc/init.d/tomcat7; generated)
   Active: active (running) since Mon 2018-08-20 12:04:29 BST; 55s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 10050 ExecStart=/etc/init.d/tomcat7 start (code=exited, status=0/SUCC
    Tasks: 20 (limit: 4915)
   CGroup: /system.slice/tomcat7.service
           └─10109 /usr/lib/jvm/java-7-oracle/bin/java -Djava.util.logging.confi

Aug 20 12:04:24 nick-X555LAB systemd[1]: Starting LSB: Start Tomcat....
Aug 20 12:04:24 nick-X555LAB tomcat7[10050]:  * Starting Tomcat servlet engine t
Aug 20 12:04:29 nick-X555LAB tomcat7[10050]:    ...done.
Aug 20 12:04:29 nick-X555LAB systemd[1]: Started LSB: Start Tomcat..

Note the reference to java7 - I'd like to switch this to java 8

Solved
Solved it. Found a reference to java 7 in /etc/default/tomcat7, changed it to java 8 and all is well.

A: Use update-alternatives to change the default JDK to java8
as
sudo update-alternatives --config java

see https://linux.die.net/man/8/update-alternatives


text:
Q: How to set CreatedAt date for product review when creating it programmatically? I'm trying to Import the product reviews, into my new magento site. For that When I create product review programmatically, I can't set my own date for createdAt field of product review.
When I'm looking into the core file, following function in app/code/core/Mage/Review/Model/Resource/Review.php set the created at date by itself
protected function _beforeSave(Mage_Core_Model_Abstract $object)
    {
        if (!$object->getId()) {
            $object->setCreatedAt(Mage::getSingleton('core/date')->gmtDate());
        }
        if ($object->hasData('stores') && is_array($object->getStores())) {
            $stores = $object->getStores();
            $stores[] = 0;
            $object->setStores($stores);
        } elseif ($object->hasData('stores')) {
            $object->setStores(array($object->getStores(), 0));
        }
        return $this;
    }

I'm running following code to create review programmatically
<?php
ini_set('memory_limit', '128M');
require_once 'app/Mage.php';
Mage::app();
Mage::app()->setCurrentStore(1);
$date = gmdate("M d Y H:i:s", mktime(0, 0, 0, 1, 1, 2014));
$review = Mage::getModel('review/review');
$review->setReviewId($review->getId());
$review->setEntityPkValue(1);//product id
$review->setStatusId(1);
$review->setTitle("mytitle");
$review->setDetail("mydetail");
$review->setEntityId(1);
$review->setStoreId(Mage::app()->getStore()->getId());      //storeview
$review->setStatusId(1); //approved
$review->setCustomerId(1);//null is for administrator
$review->setNickname("Menickname");
$review->setCreatedAt($date);
$review->setStores(array(1,3));
$review->save();
$review->aggregate();

How Can I set a date by myself? Is there any way?

A: I see 2 options here.
Option 1. Rewrite the method you mentioned and make it allow you own created at. Just make sure it does not interfere with the regular process of posting a comment. Try with something like this: (untested code)
protected function _beforeSave(Mage_Core_Model_Abstract $object)
{
    if (!$object->getId() && !$object->getSkipCreatedAtSet()) { //add an other constraint here
        $object->setCreatedAt(Mage::getSingleton('core/date')->gmtDate());
    }
    if ($object->hasData('stores') && is_array($object->getStores())) {
        $stores = $object->getStores();
        $stores[] = 0;
        $object->setStores($stores);
    } elseif ($object->hasData('stores')) {
        $object->setStores(array($object->getStores(), 0));
    }
    return $this;
}

Then when creating your review programatically, add this in the code just before calling save.
$review->setSkipCreatedAtSet(true);

This should prevent the entering in the first if statement from beforeSave and it will use the value you set for created at.
Option 2. Since the created_at is set only when the $object does not have an id, you can try to save the object again. something like what you do, but after calling save do this. (untested code again)
$review->setCreatedAt(....);
$review->save();

But this may slow your process down because you call save twice.
I would go with the first approach. Seams cleaner and more flexible.

A: SIBHI S, if you set custom date when you create review pragmatically. You should  be change table structure of review. There are set default value is CURRENT_TIMESTAMP of createAt field. You set it as As Define. That's it.


text:
Q: Arrays / CustomObjects TL;DR: I'm trying to build an array with headers based off a condition, ideally looking like this.
Name        Value        Status
Element 1   Value 1      --
Element 2   Value 2      Action Required
Element 3   Value 3      --
I've been trying it different ways but here are my two latest attempts:
This outputs the last line of every row (as the $array += $list is within the if..else statement). However when it is outside the if..else it comes up with a null value. Appending the $list to the $array does not seem to be working for me (I'm doing something wrong).
$array = @()
$list = "" | Select Name,Value,Status
foreach ($row in $worksheet) {
  $row.Psobject.Properties | ? {
    if ($RuleArray -contains $_.Name) {
      $list.Name = $_.Name;
      $list.Value = $_.Value;
      $list.Status = "Action Required"
      $array += $list
    } else {
      $list.Name = $_.Name;
      $list.Value = $_.Value;
      $list.Status = "--"
      $array += $list
    }
  }
}
Write-Host $array

The next attempt uses a string to store the values but I have not managed to place a header on the string, and the formatting as a result is non existent. The upside is that I at least see the values I am expecting, so I know the condition works.
$array = @()
$list = New-Object System.Collections.Generic.List[System.String]
foreach ($row in $worksheet) {
  $d = $row.Psobject.Properties | % {
    if ($RuleArray -contains $_.Name) {
      $_.Name; $_.Value; "Action Required`n"
    } else {
      $_.Name; $_.Value; "--`n"
    }
  }
  $list.Add($d)
}
$array = "" | Select Name,Value,Status #hail mary
$array += $list.ToArray()
Write-Host $array

Any idea on where I'm going wrong?

A: The usual approach is to create a list of custom objects with a defined set of properties, like this:
foreach ($row in $worksheet) {
  $row.Psobject.Properties | ForEach-Object {
    New-Object -Type PSObject -Property @{
      Name   = $_.Name
      Value  = $_.Value
      Status = if ($RuleArray -contains $_.Name) {'Action Required'} else {'--'}
    }
  }
}

or like this:
foreach ($row in $worksheet) {
  $row.Psobject.Properties |
    Select-Object Name, Value, @{n='Status';e={
      if ($RuleArray -contains $_.Name) {'Action Required'} else {'--'}
    }}
}


text:
Q: Relation between a polynomial and its reflection I have two polynomials:
$Q(z)=q_0 +q_1 z + \cdots q_mz^m$ and its reflection $ Q^'(z)=q_0 z^m +q_1z^{m-1}+ \cdots q_m$. I'd like to find a relation between them (i.e. $Q(z)= \phi(Q'(z))$, so far for I could only show that for $Q(z)=q_0+q_1 z$ and $Q'(z)=q_0z+q_1$ $Q^2(z)-Q'^2(z)=(1-z^2)(q_0^2-q_1^2)$.
There is probably some well-known solution to this problem. Please don't solve it for me, just point in the right direction.

A: To elaborate on my comment...don't read what follows if you want to work this out for yourself...
$Q(z^{-1})=a_mz^{-m}+\cdots+a_1z^{-1}+a_0$. So $z^mQ(z^{-1})=a_m+\cdots+a_1z^{m-1}+a_0z^m$. Thus the reflection of $Q(z)$ is just $z^mQ(z^{-1})$.


text:
Q: How to iterate and load property file values in UI using ZK? I have a property file named "ABC.properties" having values such as
A="APPLE"
B="BALL"
C="CAT"

Now i need to get these values and load in my UI. Have iterate and then need to load because like wise there may be more than 50 values in that property file.
Can anyone please help me with this?

A: In your zk.xml file, give the path of properties file you wanted to read.
<zk>
<system-config>
    <label-location>/path/to/ABC.properties</label-location>
</system-config>
</zk>

If you want to read them in zul file, for example you want to show label having value as A then
< label value="${labels.A}" />

If you want to read properties file's value in listener class then do
Labels.getLabel("A");

A: First of all, I don't know if there are more items in the property file then you need to fetch.
Note : Multiple properties files all readed in this way and are accessible in the same map.
If yes :
Convert the key's with subsections :
FRUIT.APPLE = apple
FRUIT.ORANGE = orange
TOYS.BALL = ball
TOYS.DOLL = doll

and so on.
The next thing is as @BhushanPatil already mentioned :

In your zk.xml file, give the path of properties file you wanted to read.

<zk>
    <system-config>
        <label-location>/path/to/ABC.properties</label-location>
   </system-config>
</zk>

Then you have the following method getSegmentedLabels under Labels.
This is the method we will use.
So if you want to declare it only in the zul, the next step is what you have to do :
<?xel-method
    prefix="prop" name="all" class="org.zkoss.util.resource.Labels"
    signature="java.util.Map getSegmentedLabels()"?>

<vlayout forEach="${prop:all().get('FRUIT')}">
    <label value="${each.key} : ${each.value}"/>
</vlayout>

The Xel-method is for declaring the static method (only way to acces a static method before ZK 8).
Now we want to get all our FRUIT labels, so we call the getSegmentedLabels with the Xel-method name all().
This return a Map<String,Object> where all the labels are in.
We are interested only in the subsection FRUIT so we get the value behind the key FRUIT.
This object is again a Map<String,Object> wich contains every key under the FRUIT.
In this example it contains <'APPLE','apple'>,<'ORANGE','orange'>.
The next thing we need to do is iterating over the Map and showing all the values of the Map.
This we do with the forEach attribute.
So the each object's value is now an Object of class Entry<String,Object>.
The only thing to show it now is showing the value, with is Entry.getValue().


text:
Q: Putting this command into bash script with help of google , script that measures multicast streams bandwidth.
Here it is
 tcpdump -tnn -i eth1 -f multicast | sort | uniq -c | awk '{print $3,"> "$5,$1*$NF/2*8/1024 " Kbps"}' | awk '$1 > 10' & sleep 2s && pkill -HUP -f tcpdump
It turns out fine, except I need to hit enter to get back to prompt.
 I know it is && problem, but dont know how to fix it.
How can I trascribe it to shell script. And maybe add $var for number of seconds.

A: Try using timeout to kill the tcpdump after a duration:
(timeout -s HUP 2 tcpdump -tnn -i eth1 -f multicast || true) | sort | uniq -c | awk '{print $3,"> "$5,$1*$NF/2*8/1024 " Kbps"}' | awk '$1 > 10'

To script it:
#!/bin/bash

if ! [[ "$1" =~ ^[0-9]+$ ]]; then
        echo "Usage: $0 <number of seconds>"
        exit 1
fi

(timeout -s HUP $1 tcpdump -tnn -i eth1 -f multicast || true) | sort | uniq -c | awk '{print $3,"> "$5,$1*$NF/2*8/1024 " Kbps"}' | awk '$1 > 10'

A: you don't need to press enter to exit. it's just a cosmetical issue here. that is because your output "overwrites" your terminal (you can still enter any command and press enter - it will be executed).
To "fix" this layout issue you can try to append "; sleep 1; echo" to your line so it will look like:
tcpdump -tnn -i eth1 -f multicast | sort | uniq -c | awk '{print $3,"> "$5,$1*$NF/2*8/1024 " Kbps"}' | awk '$1 > 10' & sleep 2s && pkill -HUP -f tcpdump; sleep 1; echo

Hope that helps.
And here is your bash script with variable:
#!/bin/bash

SLEEPTIME=5

tcpdump -tnn -i eth0 -f multicast | sort | uniq -c | awk -v a=$SLEEPTIME '{print $3,"> "$5,$1*$NF/a*8/1024 " Kbps"}' | awk '$1 > 10' & sleep $SLEEPTIME && pkill -HUP -f tcpdump; sleep 1; echo


text:
Q: Storing spark double values into Elasticsearch I have a double value (9999999999999.99) and trying to store the same into elastic search document (type double and tried scaled_float as well). But, on the Elasticsearch document the same value being shown as 9.99999999999999E12.
Could some one please educate me to resolve this issue

A: It seems that you don't actually have a problem, let me explain:
9999999999999.99 is a normal representation of a floating point value (float, double etc.)
9.99999999999999E12 is another representation of the same value. E meaning Exponent.
Exponent is the same as multiplying by 10 to the power of the exponent value, in this case 12 so 10**12 == 1000000000000.
9.99999999999999 * 1000000000000 == 9999999999999.99
Further explanation:
If you move the decimal point twelve digits to the right, you'll get the same number 9999999999999.99, and that's what the exponent is used for.
Also the exponent can be negative, in which case you'd move the decimal point to the left.


text:
Q: No such module 'Firebase' - Xcode and Swift Package Manager I'm trying to incorporate Firebase Analytics into my SwiftUI project in Xcode.  I've added the Firebase package using Swift Package Manager, and am able to call FirebaseApp.configure() to initialize my app in my UIApplicationDelegate class.  Now I'm trying to log analytics events and am running into an issue.
My UIApplicationDelegate class is in an iOS-specific folder.  I have a service class that is in a Shared folder (to be used across both iOS and macOS builds).  In my service class, I've added a line that says:
import Firebase

However, when I go to build my iOS target I get an error saying:
No such module 'Firebase'

I don't know why this import statement would cause a problem, since I have the very same statement in my UIApplicationDelegate class.  The only thing I could think of was that somehow my Shared classes don't know about Firebase?  Maybe?  When I view the iOS target in my project it shows that the FirebaseCrashlytics and FirebaseAnalytics frameworks have been added to it.
I'm at a loss as to what's happening.  All other things I've found online are for Cocoapods, which I'm not using for dependency management.  I'm leveraging the Swift Package Manager for this.  Any help would be greatly appreciated!!

A: I had the same issue but the post below from GitHub should fix it:
https://github.com/firebase/firebase-ios-sdk/issues/9014#issuecomment-979489434

A: I had the same error but with 'FirebaseCore'. I tried everything, but what worked for me was to add @_implementationOnly to import. So it should look like this:
@_implementationOnly import FirebaseCore

Here is the link that helped me and it says:

You could use @_implementationOnly import for the modules from the
third-party SDK if you aren't using anything from that SDK as part of
your module's public interface.

A: After installing the Firebase swift package, make sure you add the Firebase libraries to Frameworks:
TARGETS -> Your App -> General -> Frameworks, Libraries, and Embedded Content -> hit '+' to add the Firebase libraries you want:


text:
Q: Disable Laptop Touchpad I'm using a Lenovo x230 laptop which features a touchpad and a trackpoint.  I love the trackpoint and dislike the touchpad -- I continuously hit it with my thumb.
I would like to disable the touchpad, but leave everything else working. I've tried using xinput by putting the following in my .xinitrc:
$ xinput --disable 'SynPS/2 Synaptics TouchPad'

This works, however, after a few minutes, the touchpad becomes enabled again. I'm not sure why this is happening.  Is this the best way to persistently disable the touchpad?

A: The following methods will ensure your changes persist as long as you use gnome:

*

*Install and run dconf-editor (if you're on 12.10, dconf-editor might be pre-installed):
$ sudo apt-get install dconf-tools
$ dconf-editor

*Go to the following settings directory:
org.gnome.settings-daemon.peripherals

*Under touchpad, uncheck the touchpad-enabled checkbox.

If you prefer not to meddle with dconf-editor's GUI, run the following command instead:
gsettings set org.gnome.settings-daemon.peripherals.touchpad touchpad-enabled false


text:
Q: google suggest like feature in ios First things first, I am very new to ios development. I am very much experienced with web dev though.
I have gone through How to implement 'auto complete' feature (like google search), but unfortunately it is only applicable for local data.
I have to implement similar feature but the data will have to be brought from a remote server.
 I will be using NSURLConnection.
So, I am left with two problems

*

*Parse the response JSON and display it as list below the text box

*The list items must be interactable. If i click any of those a corresponding data will be retrived.

Any leads on this will be very appreciated. Thanks

A: For parsing the JSON you can use JSONKit. It generates a NSDictionary from your JSON Data
For accessing the list items look at the UITableViewDelegate Reference under – tableView:didSelectRowAtIndexPath:
Maybe this tutorial will help you implementing a UISearchdispayController which I really recommend for such functionality.

A: ios5 has built in support for JSON. It is very easy to use and is native so future compatibility isn't an issue.
NSDictionary* json = [NSJSONSerialization
                      JSONObjectWithData:responseData
                      options:kNilOptions
                      error:&error];


text:
Q: error message: non-static member found in multiple base-class subobjects of type person // Homework 3.cpp : Defines the entry point for the console application.
//

#include <iostream>
#include <string>
#include <iomanip>
#include <cassert>

using namespace std;

class Person{
public:
    Person(){ //Default Constructor
        name = "";
        ssn = 0;
        age = 0;
        gender = "";
        address = "";
        phone = "";
    }

    Person(const Person& p){ //copy constructor
        name = p.name;
        ssn = p.ssn;
        age = p.age;
        gender = p.gender;
        address = p.address;
        phone = p.phone;
    }

    Person(string _name, int _ssn, int _age, string _gender, string _address, string _phone)
    {
        name = _name;
        ssn = _ssn;
        age = _age;
        gender = _gender;
        address = _address;
        phone = _phone;
    }

    const string getName(){ return name; }
    const int getSSN(){ return ssn; }
    const int getAge(){ return age; }
    const string getGender(){ return gender; }
    const string getAddress(){ return address; }
    const string getPhone(){ return phone; }

    void setName(const string name);
    void setSSN(const int ssn);
    void setAge(const int age);
    void setGender(const string gender);
    void setAddress(const string address);
    void setPhone(const string phone);

protected:
    string name;
    int ssn;
    int age;
    string gender;
    string address;
    string phone;

};

class Student : public Person{
public:
    Student(){ //default
        gpa = 0;
        major = "";
        gradYear = 0;
    }

    Student(const Student& s) //copy
    {
        gpa = s.gpa;
        major = s.major;
        gradYear = s.gradYear;
    }

    Student(string _name, int _ssn, int _age, string _gender, string _address, string _phone, double _gpa, string _major, int _gradYear) : Person(_name, _ssn, _age, _gender, _address, _phone){
        gpa = _gpa;
        major = _major;
        gradYear = _gradYear;
    }

    const double getGPA(){ return gpa; }
    const string getMajor(){ return major; }
    const int getGradYear(){ return gradYear; }

    void setGPA(const double gpa);
    void setMajor(const string major);
    void setGradYear(const int gradYear);

protected:
    double gpa;
    string major;
    int gradYear;
};

class Employee : public Person{
public:
    Employee(){
        department = "";
        jobTitle = "";
        yearHire = 0;
    }

    Employee(const Employee& e){
        department = e.department;
        jobTitle = e.jobTitle;
        yearHire = e.yearHire;
    }

    Employee(string _name, int _ssn, int _age, string _gender, string _address, string _phone, string _department, string _jobTitle, int _yearHire) : Person(_name, _ssn, _age, _gender, _address, _phone){
        department = _department;
        jobTitle = _jobTitle;
        yearHire = _yearHire;
    }

    const string getDepartment(){ return department; }
    const string getJobTitle(){ return jobTitle; }
    const int getYearHire(){ return yearHire; }

    void setDepartment(const double department);
    void setJobTitle(const double jobTitle);
    void setYearHire(const double yearHire);

    virtual double getAnnualWages() = 0; // a pure virtual function.

protected:
    string department;
    string jobTitle;
    int yearHire;
};

class HourlyEmployee : public Employee{
public:
    HourlyEmployee(){
        hourlyRate = 0;
        hoursWorked = 0;
        unionDues = 0;

    }

    HourlyEmployee(const HourlyEmployee& he){
        hourlyRate = he.hourlyRate;
        hoursWorked = he.hoursWorked;
        unionDues = he.unionDues;
    }

    HourlyEmployee(string _name, int _ssn, int _age, string _gender, string _address, string _phone, string _department, string _jobTitle, int _yearHire, double _hourlyRate, double _hoursWorked, double _unionDues):Employee(_name, _ssn, _age, _gender, _address, _phone, _department, _jobTitle, _yearHire){
        hourlyRate = _hourlyRate;
        hoursWorked = _hoursWorked;
        unionDues = _unionDues;
    }

    const double getHourlyRate(){ return hourlyRate; }
    const double getHoursWorked(){ return hoursWorked; }
    const double getUnionDues(){ return unionDues; }

    void setHourlyRate(const double hourlyRate);
    void setHoursWorked(const double hoursWorked);
    void setUnionDues(const double unionDues);

    double getAnnualWages(){ return (hourlyRate*hoursWorked) + unionDues; }

protected:
    double hourlyRate;
    double hoursWorked;
    double unionDues;

};

class SalariedEmployee : public Employee{
public:
    SalariedEmployee(){ annualSalary = 0; }

    SalariedEmployee(const SalariedEmployee& se){
        annualSalary = se.annualSalary;
    }

    SalariedEmployee(string _name, int _ssn, int _age, string _gender, string _address, string _phone, string _department, string _jobTitle, int _yearHire, double _annualSalary):Employee(_name, _ssn, _age, _gender, _address, _phone, _department, _jobTitle, _yearHire)
    {
        annualSalary = _annualSalary;
    }

    double getAnnualSalary(){ return annualSalary; }

    void setAnnualSalary(const double annualSalary);

    double getAnnualWages(){ return annualSalary; }

protected:
    double annualSalary;

};

class StudentEmployee : public Student, public HourlyEmployee{ //multiple inheritance of student and HourlyEmployee
public:

    StudentEmployee(){}

    StudentEmployee(const StudentEmployee& ste){}

    StudentEmployee(string _name, int _ssn, int _age, string _gender, string _address, string _phone, string _department, string _jobTitle, int _yearHire, double _hourlyRate, double _hoursWorked, double _unionDues,double _gpa, string _major, int _gradYear): Student(_name, _ssn, _age, _gender, _address, _phone, _gpa, _major, _gradYear), HourlyEmployee(_name, _ssn, _age, _gender, _address, _phone, _department, _jobTitle, _yearHire, _hourlyRate, _hoursWorked, _unionDues){}

protected:
};

struct ListNode { //struct for list
    Person p;
    ListNode *link;
};

class SingleLinkedList{ //class to store all persons
public:
    SingleLinkedList() {
        front = rear = nullptr;
        size = 0;
    }

    ~SingleLinkedList() {
        Clear();
    }

    ListNode* headptr(){
        return front;
    }

    // Removes every node in the list.  Frees my memory with delete.
    void Clear() {
        ListNode *node = front;

        while (node != nullptr) {
            ListNode *next = node->link;
            delete node;
            node = next;
        }

        front = rear = nullptr;
        size = 0;
    }

    bool Contains(Person p) const {
        ListNode *node = front;

        while (node != nullptr) {
            if ( node->p.getName() == p.getName() && node->p.getSSN() == p.getSSN() && node->p.getAge() == p.getAge() && node->p.getGender() == p.getGender() && node->p.getAddress() == p.getAddress() && node->p.getPhone() == p.getPhone() ) { return true; } //checks to see if all of the information for the person is the same
            node = node->link;
        }

        return false;
    }

    void PopFront() {
        assert(size > 0);

        ListNode *obsolete = front;

        if (front == rear) { // Exactly one element in our list
            front = rear = nullptr;
        }
        else {
            front = obsolete->link;
        }

        delete obsolete;
        --size;
    }

    void PushBack(Person p) {
        ListNode *insert = new ListNode(); // We need to delete this node later
        insert->p = p;
        insert->link = nullptr;

        if (front == nullptr) {
            front = rear = insert;
        }

        rear->link = insert;
        rear = insert;
        ++size;
    }

    void PushFront(Person p) {
        ListNode *insert = new ListNode();
        insert->link = front; // This node will be the new front, connect the old front
        insert->p = p;

        if (front == nullptr) {  // No elements currently in the list
            front = rear = insert;
        }

        front = insert;
        ++size;
    }

    int Size() const {
        return size;
    }

    void displayNode(ListNode *ptr)const{
        cout << setw(3) << ptr->p.getName() << endl;
    }

    void displayList(ListNode *ptr)const{
        if (ptr==nullptr){
            cout << "Nothing to display!\n";
        }
        for (int i = 1; i <= size;i++){
            displayNode(ptr);
            ptr = ptr->link;
        }
    }

protected:
    int size;
    ListNode *front, *rear; // Front points to first node in list, rear to last
};

//main program
int main()
{
    Person a("John Doe", 123456789, 26, "male", "123 Park Pl", "555-123-4567");
    Person b("Jane Smith", 234567890, 21, "female", "66 Oak Ave", "123-456-7890");
    Student s("Katie Brown",749374394, 18,"female","100 Curtain Rd","472-473-2038", 4.0, "Statistics", 2016);
    SalariedEmployee se("Ross Gellar", 123056789, 55, "male", "123 5th Ave", "515-683-8924", "Science", "Professor", 1999, 50000);
    HourlyEmployee he("Monica Bing", 123056589, 55, "female", "64 South Park Dr", "538-238-0747", "Dining", "Chef", 1999, 20.00, 40, 100);
    StudentEmployee stuem("Cathrine Miller", 550789234, 25, "female", "218 Knickerbocker Way", "888-555-0000", "Fitness", "Trainer", 2015, 7.25, 10, 5, 3.2, "Computer Science", 2017);

    SingleLinkedList x;
    x.PushBack(a);
    x.PushBack(b);
    x.PushFront(s); //adds student f to the list of persons
    x.displayList(x.headptr());

    if (x.Contains(a) == true) //to show john doe is on list
        cout << "This " << a.getName() << " is in the list.\n";
    else
        cout << "This " << a.getName() << " is NOT in the list.\n";

    x.Clear(); //clears list

    x.displayList(x.headptr());

    if (x.Contains(a) == true) //shows john doe not on list because list was cleared
        cout << "This " << a.getName() << " is in the list.\n";
    else
        cout << "This " << a.getName() << " is NOT in the list.\n";

    cout<< "Annual Wages for "<<se.getName()<<" is "<<se.getAnnualWages()<<endl;
    cout<< "Annual Wages for "<<he.getName()<<" is "<<he.getAnnualWages()<<endl;
    cout<< "Annual Wages for "<<stuem.getName()<<" is "<<stuem.getAnnualWages()<<endl;

    return 0;
}

on the last cout statement, my program will give me the error message non-static member 'getName' found in multiple base-class subobjects of type person. i know i have to refer all the variables to just one of the base classes, but i dont know how to

A: You have to use virtual inheritance from Person in this case. I guess that's the point of this homework. You're encountering The Diamond problem, because at stuem.getName(), the compiler doesn't know which instance of the two underlying Person base class instances to use.
Making the inheritance virtual will insure, that there's only one Person object:
class Student : virtual public Person { ... };
class Employee : virtual public Person { ... };

Off topic, but by this time you should be using member initialization lists and assigning "" to std::string which is already initialized and empty is, well, uncomfortable to look at. And copy-constructors can be defaulted in C++11:
Person(const Person& p) = default;


text:
Q: Using ChoETL to print CSV file returns values to Console as "dynamic" Hi I am very new to C# and have to turn in a module for integration testing tomorrow. I was trying an easy and expidient way to read CSV files and stumbled on ChoETL:
https://www.codeproject.com/Articles/1145337/Cinchoo-ETL-CSV-Reader?msg=5847644#xx5847644xx
Following their first example, I tried to run the code:
using ChoETL;
using System;

foreach (dynamic rec in new ChoCSVReader("Emp.csv")
    .WithFirstLineHeader())
{
    Console.WriteLine($"Id: {rec.Id}");
    Console.WriteLine($"Name: {rec.Name}");
}

When I run it, I get the ouput:
Id: 1
Name: dynamic
Id: 2
Name: dynamic
Id: 3
Name: dynamic

Instead of:
Id: 1
Name: Tom
Id: 2
Name: Carl
Id: 3
Name: Mark

WHy is this? And what is rec being turned to at runtime? I don't know anythnig about dynamic types
I ran this on a Console project on NetCore 5.0 on VS2019

A: It is bug in the recent package (v1.2.1.30). Alternatively in order to run the sample successfully by doing as below
foreach (dynamic rec in ChoCSVReader.LoadText(csv).WithFirstLineHeader())
{
    Console.WriteLine($"Id: {rec.Id}");
    Console.WriteLine($"Name: " + rec["Name"]);
}

UPDATE:
This issue is fixed and pushed to nuget with v1.2.1.32 and give it try.
Sample fiddle: https://dotnetfiddle.net/REcRCc


text:
Q: How to cast date to string in psycopg2? I'm sure it has something to do with registering custom type cast as described here. However, I'm not sure how to do that.
What I want to do is something like this:
SELECT * FROM table
and where a column is of date type, I want psycopg2 to convert it to Python string instead of datetime.

A: I found how to do it:
def register_New_Date():
    # Cast PostgreSQL Date as Python string
    # Reference:
    # 1. http://initd.org/psycopg/docs/extensions.html#psycopg2.extensions.new_type
    # 2. http://initd.org/psycopg/docs/advanced.html#type-casting-from-sql-to-python
    # 1082 is OID for DATE type.
    NewDate = psycopg2.extensions.new_type((1082,), 'DATE', psycopg2.STRING)
    psycopg2.extensions.register_type(NewDate)

Then run:
register_New_Date()


text:
Q: Date in Spreadsheet shows as number when cell format is short date One spreadsheet in the workbook has a column of dates that appear as left justified numbers, even though the format on the column is Short Date.  Cannot set the column to number format, change alignment or force any other format.  When a cell is selected it shows as a date in the cell and in the formula bar, but when focus is changed, it reverts to number.  How to fix this?

A: The spread sheet was copied from another workbook, and was apparently protected in that workbook.  Thus not able to format or change anything.  Ended up selecting all cells in the worksheet and pasting into a new worksheet.  Able to apply changes then.


text:
Q: How can I reduce the RMS value for a bridge rectifier?
I need to reduce the rectified DC voltage.  Is it possible to reduce the RMS value after the bridge rectifier i.e before the capacitor? Practical value (at the capacitor) is 34 DC voltage. I need to reduce this voltage.
Input is 24 VAC, output should be at least 26 V DC.  Input voltage is fixed.

A: You could simply add a couple of diodes to drop the voltage:

simulate this circuit – Schematic created using CircuitLab
each diode will drop about 1 V, you can add more if needed.
The "proper" way to do this is of course to use a transformer with the right output voltage. This diode trick is a bit of a "hack" but that might be all you need.


text:
Q: Controller not loading Grid container Error: Class 'Mage_Reviewmycompany_Helper_Data I have created a custom module one part is working fine that is adminform now i have create a grid to show all the data saved in database. But all i get is blank page.
Here is my grid.php file:
<?php

   class OptFirst_ReviewMyCompany_Block_Adminhtml_Review_Grid extends
Mage_Adminhtml_Block_Widget_Grid
     {

      public function __construct()
       {
         parent::__construct();
         $this->setId('reviewGrid');
         $this->setDefaultSort('id_optfirst_reviewmycompany');
         $this->setDefaultDir('ASC');
         $this->setSaveParametersInSession(true);
       }

      protected function _prepareCollection()
       {
         $collection = Mage::getModel('optfirst_reviewmycompany/review')->getCollection();
         //print_r($collection);
         $this->setCollection($collection);
         return parent::_prepareCollection();
       }

      protected function _prepareColumns()
       {
         $this->addColumn('id', array(
        'header' => Mage::helper('optFirst_reviewMyCompany')->__('Facebook'),
        'align' => 'right',
        'width' => '10px',
        'index' => 'id',
        ));

        $this->addColumn('name', array(
        'header' => Mage::helper('optFirst_reviewMyCompany')->__('Google'),
        'align' => 'left',
        'index' => 'name',
        'width' => '50px',
        ));

    $this->addColumn('content', array(
        'header' => Mage::helper('optFirst_reviewMyCompany')->__('Twitter'),
        'width' => '150px',
        'index' => 'content',
        ));
      return parent::_prepareColumns();
     }
   }

And here is my controller:
  <?php

       class OptFirst_ReviewMyCompany_Adminhtml_ReviewController extends Mage_Adminhtml_Controller_action
        {

          public functio  indexAction() {
            $this->loadLayout();
            $this->renderLayout();

        }
       public function gridAction()
        {
         $this->loadLayout();
         $this->getResponse()->setBody(
         $this->getLayout()->createBlock('optfirst_reviewmycompany/adminhtml_review_grid')->toHtml()
         );
        }
       }

And here is my confix.xml
  <?xml version="1.0"?>
   <config>
<modules>
    <OptFirst_ReviewMyCompany>
        <version>1.0.0</version>
    </OptFirst_ReviewMyCompany>
</modules>

<global>
    <blocks>
        <optfirst_reviewmycompany>
            <class>OptFirst_ReviewMyCompany_Block</class>
        </optfirst_reviewmycompany>
    </blocks>

    <helpers>
        <optfirst_reviewmycompany>
            <class>OptFirst_ReviewMyCompany_Helper</class>
        </optfirst_reviewmycompany>
    </helpers>

    <models>
        <optfirst_reviewmycompany>
            <class>OptFirst_ReviewMyCompany_Model</class>
            <resourceModel>optfirst_reviewmycompany_resource</resourceModel>
        </optfirst_reviewmycompany>
        <optfirst_reviewmycompany_resource>
            <class>OptFirst_ReviewMyCompany_Model_Resource</class>
            <entities>
                <review>

optfirst_reviewmycompany

                </review>
            </entities>
        </optfirst_reviewmycompany_resource>
    </models>

    <resource>
        <optfirst_reviewmycompany_setup>
            <setup>
                <module>OptFirst_ReviewMyCompany</module>
            </setup>
            <connection>
                <use>core_setup</use>
            </connection>
        </optfirst_reviewmycompany_setup>
        <optfirst_reviewmycompany_write>
            <connection>
                <use>core_write</use>
            </connection>
        </optfirst_reviewmycompany_write>
        <optfirst_reviewmycompany_read>
            <connection>
                <use>core_read</use>
            </connection>
        </optfirst_reviewmycompany_read>
    </resource>
</global>

<admin>
    <routers>
        <adminhtml>
            <args>
                <modules>
                    <optfirst_reviewmycompany after="Mage_Adminhtml">OptFirst_ReviewMyCompany_Adminhtml</optfirst_reviewmycompany>
                </modules>
            </args>
        </adminhtml>
    </routers>
</admin>

<adminhtml>
    <layout>
        <updates>
            <optfirst_reviewmycompany>
                <file>optfirst_reviewmycompany.xml</file>
            </optfirst_reviewmycompany>
        </updates>
        <updates>
            <review>
                <file>review.xml</file>
            </review>
        </updates>
    </layout>
    <translate>
        <modules>
            <optfirst_reviewmycompany>
                <files>
                    <default>OptFirst_ReviewMyCompany.csv</default>
                </files>
            </optfirst_reviewmycompany>
        </modules>
    </translate>
</adminhtml>

<default>
    <optfirst_reviewmycompany>
        <general>
            <default_sort_by><![CDATA[position]]></default_sort_by>
        </general>
    </optfirst_reviewmycompany>
</default>

My Helper Class in OptFirst/ReviewMyCompany/Helper/Data.php
     <?php
      class OptFirst_ReviewMyCompany_Helper_Data extends Mage_Core_Helper_Abstract
         {

         }

Can you please check what is wrong and why its not showing the grid container?

A: Your helpers calls in your Grid.php are wrong.
You need to replace:
Mage::helper('optFirst_reviewMyCompany')

With :
Mage::helper('optfirst_reviewmycompany')

The value inside the Mage::helper method should match what you've declared in your config.xml in your case:
<helpers>
    <optfirst_reviewmycompany>
        <class>OptFirst_ReviewMyCompany_Helper</class>
    </optfirst_reviewmycompany>
</helpers>

A: I thin you are missing the grid container
class OptFirst_ReviewMyCompany_Block_Adminhtml_Review extends Mage_Adminhtml_Block_Widget_Grid_Container
{
    public function __construct()
    {
        $this->_controller = 'adminhtml_review';
        $this->_blockGroup = 'review';
        $this->_headerText = Mage::helper('test')->__('Review Manager');
        $this->_addButtonLabel = Mage::helper('advancecms')->__('Add Review');
        parent::__construct();
    }
}

that were called in
<adminhtml_review_grid>
    <reference name="content">
        <block type="reviewMyCompany/adminhtml_review" name="review" />
    </reference>
</adminhtml_review_grid>

A: After review you coding there were three mistake in that
config.xml
<?xml version="1.0"?>
<config>
    <menu>
        <optfirst translate="title" module="optfirst_reviewmycompany">
            <title>Review My Company</title>
            <sort_order>90</sort_order>
            <children>
                <form translate="title" module="optfirst_reviewmycompany">
                    <title>Form</title>
                    <sort_order>10</sort_order>
                    <action>adminhtml/adminform</action>
                </form>
                  <items module="optfirst_reviewmycompany">
                        <title>Manage Social Icons</title>
                        <sort_order>0</sort_order>
                    <action>adminhtml/review/index</action>
                    </items>
            </children>
        </optfirst>
    </menu>
    <acl>
        <resources>
            <all>
                <title>Allow Everything</title>
            </all>
            <admin>
                <children>
                    <optfirst>
                        <title>Optfirst</title>
                        <sort_order>90</sort_order>
                        <children>
                            <form>
                                <title>Form</title>
                                <sort_order>10</sort_order>
                            </form>
                        </children>
                    </optfirst>
                </children>
            </admin>
        </resources>
    </acl>
</config>

optfirst_reviewmycompany.xml
<?xml version="1.0"?>
<layout version="1.0.0">

    <adminhtml_adminform_index>
        <update handle="editor"/>
        <reference name="content">
            <block type="optfirst_reviewmycompany/adminhtml_form_edit" name="adminform"/>
        </reference>
       <reference name="left">
            <block type="optfirst_reviewmycompany/adminhtml_form_edit_tabs" name="adminform_tabs"/>
        </reference>
    </adminhtml_adminform_index>

    <adminhtml_review_index>
        <reference name="content">
            <block type="optfirst_reviewmycompany/adminhtml_review" name="review" />
        </reference>
    </adminhtml_review_index>

</layout>

ReviewController.php
<?php

class OptFirst_ReviewMyCompany_Adminhtml_ReviewController extends Mage_Adminhtml_Controller_action
{

    public function indexAction() {
        $this->loadLayout();
                $this->renderLayout();
    }

    public function gridAction()
    {  //this action is used for ajax request you are calling it directly

                $this->getResponse()->setBody(
                $this->getLayout()->createBlock('optfirst_reviewmycompany/adminhtml_review_grid')->toHtml()
                );

    }

 }

Review.php
<?php
class OptFirst_ReviewMyCompany_Block_Adminhtml_Review extends Mage_Adminhtml_Block_Widget_Grid_Container
{
    public function __construct()
    {
        $this->_controller = 'adminhtml_review';
        $this->_blockGroup = 'optfirst_reviewmycompany';
        $this->_headerText = Mage::helper('optfirst_reviewmycompany')->__('Review Manager');
        $this->_addButtonLabel = Mage::helper('optfirst_reviewmycompany')->__('Add Review');
        parent::__construct();
    }

}

A: <? xml version = "1.0" ?>
 <layout version="0.1.0">
    <adminhtml_reviewmycompany_review_grid>
        <reference name="content">
            <block type="reviewmycompany/adminhtml_review_grid" name="review" />
        </reference>
    </adminhtml_reviewmycompany_review_grid>
</layout>

layout XML node
adminRoute_moduleName_contromlerName_ActionName
refers to route
adminRoute/moduleName/contromlerName/ActionName
So
<adminhtml_reviewmycompany_review_grid>

will refer to
YOUR_ADMIN_ROUTE/reviewmycompany/review/grid
and resolve to the following method
OptFirst/ReviewMyCompany/Adminhtml/ReviewController -> gridAction

A: in your grid.php file helper is wrong in every where
please change your grid.php with below
<?php

   class OptFirst_ReviewMyCompany_Block_Adminhtml_Review_Grid extends
Mage_Adminhtml_Block_Widget_Grid
     {

      public function __construct()
       {
         parent::__construct();
         $this->setId('reviewGrid');
         $this->setDefaultSort('id_optfirst_reviewmycompany');
         $this->setDefaultDir('ASC');
         $this->setSaveParametersInSession(true);
       }

      protected function _prepareCollection()
       {
         $collection = Mage::getModel('optfirst_reviewmycompany/review')->getCollection();
         //print_r($collection);
         $this->setCollection($collection);
         return parent::_prepareCollection();
       }

      protected function _prepareColumns()
       {
         $this->addColumn('id', array(
        'header' => Mage::helper('optfirst_reviewmycompany')->__('Facebook'),
        'align' => 'right',
        'width' => '10px',
        'index' => 'id',
        ));

        $this->addColumn('name', array(
        'header' => Mage::helper('optfirst_reviewmycompany')->__('Google'),
        'align' => 'left',
        'index' => 'name',
        'width' => '50px',
        ));

    $this->addColumn('content', array(
        'header' => Mage::helper('optfirst_reviewmycompany')->__('Twitter'),
        'width' => '150px',
        'index' => 'content',
        ));
      return parent::_prepareColumns();
     }
   }


text:
Q: SSL Handshake error caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors I have a Spring-Boot web application that accesses a MySQL database. I am trying to encrypt this access using SSL. For this purpose, I have followed a tutorial at https://www.techrunnr.com/connect-mysql-server-from-spring-boot-application-with-ssl/.
However, when I try to access the database, I am getting com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure which is ultimately caused by java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors.
The complete stack trace from the IDE is:

2020-09-04 11:09:29.227  INFO 17540 --- [         task-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-09-04 11:09:29.377  INFO 17540 --- [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2020-09-04 11:09:30.165  INFO 17540 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (https) with context path ''
2020-09-04 11:09:30.167  INFO 17540 --- [  restartedMain] DeferredRepositoryInitializationListener : Triggering deferred initialization of Spring Data repositories…
2020-09-04 11:09:30.167  INFO 17540 --- [  restartedMain] DeferredRepositoryInitializationListener : Spring Data repositories initialized!
2020-09-04 11:09:30.175  INFO 17540 --- [  restartedMain] c.c.s.SpringbootHibernateApplication     : Started SpringbootHibernateApplication in 3.377 seconds (JVM running for 4.19)
2020-09-04 11:09:30.776 ERROR 17540 --- [         task-1] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.4.5.jar:na]
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1224) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1255) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) ~[na:na]
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) ~[na:na]
    at java.base/java.lang.Thread.run(Thread.java:832) ~[na:na]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
    at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) ~[na:na]
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481) ~[na:na]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:334) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:164) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1342) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 33 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:325) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:268) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:263) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1340) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.onConsumeCertificate(CertificateMessage.java:1215) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.consume(CertificateMessage.java:1158) ~[na:na]
    at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:396) ~[na:na]
    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:445) ~[na:na]
    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:423) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:182) ~[na:na]
    at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:171) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1475) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1381) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:441) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:412) ~[na:na]
    at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:336) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:325) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 38 common frames omitted
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:400) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1442) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1324) ~[na:na]
    ... 53 common frames omitted
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at java.base/sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:158) ~[na:na]
    at java.base/sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:84) ~[na:na]
    at java.base/java.security.cert.CertPathValidator.validate(CertPathValidator.java:309) ~[na:na]
    at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:393) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 55 common frames omitted

2020-09-04 11:09:30.777  WARN 17540 --- [         task-1] o.h.e.j.e.i.JdbcEnvironmentInitiator     : HHH000342: Could not obtain connection to query metadata : Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2020-09-04 11:09:30.786  INFO 17540 --- [         task-1] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
2020-09-04 11:09:31.271  INFO 17540 --- [         task-1] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-09-04 11:09:32.436 ERROR 17540 --- [         task-1] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.4.5.jar:na]
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.4.5.jar:na]
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:43) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcConnection(ImprovedExtractionContextImpl.java:60) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcDatabaseMetaData(ImprovedExtractionContextImpl.java:67) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImpl.java:333) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTablesInformation(DatabaseInformationImpl.java:120) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:65) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) ~[hibernate-core-5.4.20.Final.jar:5.4.20.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391) ~[spring-orm-5.2.8.RELEASE.jar:5.2.8.RELEASE]
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) ~[na:na]
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) ~[na:na]
    at java.base/java.lang.Thread.run(Thread.java:832) ~[na:na]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
    at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) ~[na:na]
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481) ~[na:na]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:334) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:164) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1342) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 32 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:325) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:268) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:263) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1340) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.onConsumeCertificate(CertificateMessage.java:1215) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.consume(CertificateMessage.java:1158) ~[na:na]
    at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:396) ~[na:na]
    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:445) ~[na:na]
    at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:423) ~[na:na]
    at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:182) ~[na:na]
    at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:171) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1475) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1381) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:441) ~[na:na]
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:412) ~[na:na]
    at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:336) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:325) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 37 common frames omitted
Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:400) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1442) ~[na:na]
    at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java:1324) ~[na:na]
    ... 52 common frames omitted
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
    at java.base/sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:158) ~[na:na]
    at java.base/sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:84) ~[na:na]
    at java.base/java.security.cert.CertPathValidator.validate(CertPathValidator.java:309) ~[na:na]
    at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:393) ~[mysql-connector-java-8.0.21.jar:8.0.21]
    ... 54 common frames omitted

2020-09-04 11:09:32.437  WARN 17540 --- [         task-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 08S01
2020-09-04 11:09:32.437 ERROR 17540 --- [         task-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

The status information from the MySQL server is:
Connection id:          582
Current database:
Current user:           root@localhost
SSL:                    Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter:        ;
Server version:         8.0.21 MySQL Community Server - GPL
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    cp850
Conn.  characterset:    cp850
TCP port:               3306
Binary data as:         Hexadecimal
Uptime:                 9 days 19 hours 42 min 45 sec

Threads: 2  Questions: 6985  Slow queries: 0  Opens: 669  Flush tables: 3  Open tables: 583  Queries per second avg: 0.008
--------------

The application.properties file:
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/abc?\
  verifyServerCertificate=true&\
  useSSL=true&\
  requireSSL=true&\
  clientCertificateKeyStoreUrl=file:D:\\BITS\\Practice-School-2\\Training\\Coding projects\\springboot-Hibernate\\src\\main\\resources\\clientkeystore.jks\
  &clientCertificateKeyStorePassword=nucleus&\
  trustCertificateKeyStoreUrl=file:D:\\BITS\\Practice-School-2\\Training\\Coding projects\\springboot-Hibernate\\src\\main\\resources\\truststore.jks\
  &trustCertificateKeyStorePassword=nucleus
spring.datasource.username=root
spring.datasource.password=nucleus
spring.datasource.tomcat.max-wait=20000
spring.datasource.tomcat.max-active=50
spring.datasource.tomcat.max-idle=20
spring.datasource.tomcat.min-idle=15

spring.jpa.show-sql = true
spring.jpa.hibernate.ddl-auto = update
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQLDialect
spring.jpa.properties.hibernate.id.new_generator_mappings = false
spring.jpa.properties.hibernate.format_sql = true

logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

server.ssl.key-store=classpath:medium.jks
server.ssl.key-store-type=pkcs12
server.ssl.key-store-password=nucleus
server.ssl.key-password=nucleus
server.ssl.key-alias=medium
server.port=8080

Please help me figure out how to remove the above-mentioned exceptions.
Note: when I remove the part
  verifyServerCertificate=true&\
  useSSL=true&\
  requireSSL=true&\
  clientCertificateKeyStoreUrl=file:D:\\BITS\\Practice-School-2\\Training\\Coding projects\\springboot-Hibernate\\src\\main\\resources\\clientkeystore.jks\
  &clientCertificateKeyStorePassword=nucleus&\
  trustCertificateKeyStoreUrl=file:D:\\BITS\\Practice-School-2\\Training\\Coding projects\\springboot-Hibernate\\src\\main\\resources\\truststore.jks\
  &trustCertificateKeyStorePassword=nucleus ```

from the application.properties file, the application runs perfectly.

A: useSSl=false will avoid this problem try it
or if you have to use ssl then try this document upto step 10 for enabling ssl in mysql
https://access.redhat.com/solutions/68098


text:
Q: Import by fileName is not supportted I have a django project and a dump.json file in which all the database dump is present.
I am trying to run this command to load data into my django project
django-admin loaddata dumpdata.json --settings=~/Workspace/odx-lm/lm/settings/local.py

On running the above command from the folder ~/Workspace/odx-lm/,
I am getting the following error:

Traceback (most recent call last):   File
  "/home/delhivery/Workspace/odx-lm/odx-lm-env/bin/django-admin.py",
  line 5, in
      management.execute_from_command_line()   File "/home/delhivery/Workspace/odx-lm/odx-lm-env/local/lib/python2.7/site-packages/django/core/management/init.py",
  line 367, in execute_from_command_line
      utility.execute()   File "/home/delhivery/Workspace/odx-lm/odx-lm-env/local/lib/python2.7/site-packages/django/core/management/init.py",
  line 316, in execute
      settings.INSTALLED_APPS   File "/home/delhivery/Workspace/odx-lm/odx-lm-env/local/lib/python2.7/site-packages/django/conf/init.py",
  line 53, in getattr
      self._setup(name)   File "/home/delhivery/Workspace/odx-lm/odx-lm-env/local/lib/python2.7/site-packages/django/conf/init.py",
  line 41, in _setup
      self._wrapped = Settings(settings_module)   File "/home/delhivery/Workspace/odx-lm/odx-lm-env/local/lib/python2.7/site-packages/django/conf/init.py",
  line 97, in init
      mod = importlib.import_module(self.SETTINGS_MODULE)   File "/usr/lib/python2.7/importlib/init.py", line 37, in import_module
      import(name) ImportError: Import by filename is not supported.

Any help would be highly appreciated.

A: The value for settings must be a Python module path, not a file path.
... --settings=lm.settings.local


text:
Q: C How to exit the command prompt I'm trying to write a program in C that executes another program and doesn't even appear visually, but the way I made the code it for some reason doesn't close at all, only when I press the red x button on the top right, if you know were that is. So here is the code I used, hopefully you can help.
#include<stdlib.h>
int main(){
    system("%appdata%/file.jar");
    exit(0);
    return(0);
}

As you can see i am not very skilled in this particular programming language.

A: Ok. This could simply be done with a simple start or just a batch script. Here is an example:
#include <stdlib.h>
main()
{
    system("start %appdata%/file.jar");
    return(0);
}

batch script being:
start %appdata%/file.jar

I don't quite understand why it is needed to be a full binary, but that should solve your problem (assuming this is Windows)
The author then changed the path, seemingly just to get the edit credits. Updated, with improvement.


text:
Q: Curved text in latex table column problem I have one problem with my table. Why fourth column of my table has curved text?
\begin{table}[!htbp]%
\caption{XMM-Newton expositions for Gaia18awg\label{tab5}}
\centering
\begin{tabular*}{500pt}{@{\extracolsep\fill}lccD{.}{.}{3}c@{\extracolsep\fill}}
\toprule
Exp.ID & Instrument & Mode & Filter & Duration \\
\midrule
S001& EMOS1 & Small Window & MEDIUM   & 16626s\\
S002& EMOS2 & Large Window  &MEDIUM & 16604s\\
S003& EPN & Small Window   & MEDIUM & 16139s \\
S006& OM & Image & V   &4000s\\
S007& OM & Image   &U & 3999s\\
S008& OM & Image   & UVW1 & 4001s\\
S009& OM & Image & UVW1  & 3400s\\
S004& RGS1 & Spectroscopy HER+SES &N/A& 16911s\\
S005& RGS2 & Spectroscopy HER+SES & N/A & 16909s\\
\bottomrule
\end{tabular*}
\end{table}

A: A D type column (from the dcolumn package) is intended to be used for columns containing numbers. Since your column only contains text, a r, lor c column (depending on the desired horizontal alignment) would be better suited.
Depending on the size of the page and the margins, the table might be wider than the textwidth. To prevent this, you might want to consider using \textwidth instead of 500pt.
Personally, I would not recommend stretching a table to be significantly wider than it yould naturally be since the additional white space does not improve the readability. I also recommend placing repeated information into the column header (seconds in the last column). In the following MWE, I have thus added a second example table, in which I also used an S type column from siunitx to improve the alignment of the numbers in the last column.

\documentclass{article}
\usepackage{geometry}
\usepackage{booktabs}
\usepackage{siunitx}
\begin{document}

\begin{table}[!htbp]%
\caption{XMM-Newton expositions for Gaia18awg\label{tab5}}
\centering
\begin{tabular*}{\textwidth}{@{\extracolsep\fill}lccrc@{}}
\toprule
Exp.ID & Instrument & Mode & Filter & Duration \\
\midrule
S001& EMOS1 & Small Window & MEDIUM   & 16626s\\
S002& EMOS2 & Large Window  &MEDIUM & 16604s\\
S003& EPN & Small Window   & MEDIUM & 16139s \\
S006& OM & Image & V   &4000s\\
S007& OM & Image   &U & 3999s\\
S008& OM & Image   & UVW1 & 4001s\\
S009& OM & Image & UVW1  & 3400s\\
S004& RGS1 & Spectroscopy HER+SES &N/A& 16911s\\
S005& RGS2 & Spectroscopy HER+SES & N/A & 16909s\\
\bottomrule
\end{tabular*}
\end{table}

\begin{table}[!htbp]%
\caption{XMM-Newton expositions for Gaia18awg\label{tab5}}
\centering
\begin{tabular}{llllS[table-format=5]}
\toprule
Exp.ID & Instrument & Mode & Filter & {Duration (\si{\second})} \\
\midrule
S001& EMOS1 & Small Window & MEDIUM   & 16626\\
S002& EMOS2 & Large Window  &MEDIUM & 16604\\
S003& EPN & Small Window   & MEDIUM & 16139 \\
S006& OM & Image & V   &4000\\
S007& OM & Image   &U & 3999\\
S008& OM & Image   & UVW1 & 4001\\
S009& OM & Image & UVW1  & 3400\\
S004& RGS1 & Spectroscopy HER+SES &N/A& 16911\\
S005& RGS2 & Spectroscopy HER+SES & N/A & 16909\\
\bottomrule
\end{tabular}
\end{table}

\end{document}


text:
Q: Does VSCode SSH to a remote PC download all files under a open folder from that PC to local PC? I am using VSCode with a SSH extension (Remote Explorer) to SSH into an EC2 instance. So while using a node app or react app on a open folder from EC2 instance, perhaps it is downloading all the node modules in the VSCode locally from ec2 as well.
I received an alert about its usage of 1.0 GB for free per month as part of AWS Free Usage Tier (Global-DataTransfer-Regional-Bytes), and suspecting VSCode downloading all things available in a react app causing double the data usage. If this is true then how can I exclude VSCode from downloading certain unnecessary folders such as node_modules?