GIMP: Why can I set a higher quality than original image in the “Export Image as JPEG” dialog?

After having read the GIMP Export Image as JPEG section, I still have one understanding issue:

Why am I able to select a higher quality value than the one from original image in the export dialog?

For example, given a .jpeg image, the quality slider is first set to the default 90. When marking “Use quality settings from original image”, the value is set to 75. I can now still select slider values > 75, which creates the impression to raise the quality above original image.

With that assumption in mind (which may be wrong, I am happy to be corrected here), this dialog does not make sense to me. JPEG is a lossy format and an image with lower quality cannot be magically transformed to a higher-detail image. Also, the value seems to indicate some kind of “absolute quality”, not a relative one – otherwise the original quality would be 100.

8 – Export current gutenberg content for page entered in the visual editor as JSON

I’m using Gutenberg and various custom content types like blog post, person, article, etc. I want it so when a user creates an article it automatically fills the page with a preset set of blocks with placeholder data, or data that came from custom fields for that content type.

I do see that there’s a page template section https://www.drupal.org/docs/8/modules/gutenberg/page-templates that you can set for each content type. But instead of manually writing the JSON for the template I want to be able to take the content I’ve already entered and export it to JSON so I can paste it into that field.

Is it possible to export content from the Gutenberg visual editor to JSON so I can use it as a template for content types?

sharepoint online – Column not appearing in Export to Excel

I was wondering if someone can help. There is a Hidden Column which I can’t view in List Settings.
It appears as a column I can add when creating a view.
But when exporting to excel, the column doesn’t pull through.
I should point out that it used to pull through in export to excel uptil last week. But today it didn’t. I can’t figure out why the column is not exporting. It is very important column which contans users update.
The data in this field is generated by a workflow which I cannot figure out.
Can anyone provide context / workaround or fix please?

high sierra – to change the date based on exif data since export from Mac Photos shows date of export using exiftool

I used the following to change the Date Created to the actual date the photo was taken because exporting from Photos showed the date of export.
“for file in *; do SetFile -d “$(exiftool -p ‘$CreateDate’ -d ‘%m/%d/%Y %H:%M:%S’ “$file”)” “$file”; done”

I got the following warning:
“Warning: (minor) Adjusted MakerNotes base by 46 – IMG_1369.JPG” — what does this mean?

I found the above suggestion at this thread:
Export from Mac Photos app while keeping date created data?

Also what is the cmd to change “Date Modifed” using exiftool?

Thanks.

Export all Posts as individual .txt files inside folder in root

Using PHP 7.4, I need a solution that creates the folder for me and then exports each post into a .txt file.

The idea is for the code to create a folder in the installation root called exported-posts and then to run the export and save each post as an individual .txt file inside that folder.

The error I get related to this:

file_put_contents($f, $content);

Warning: file_put_contents(./exported-posts/post-name.txt): failed to open stream: No such file or directory in /exported-posts.php on line 16

I have wp-debug turned on to make sure no errors.

This is what I got so far, but it gives me a error:

define( 'WP_USE_THEMES', false );
require( './wp-load.php' );

// the argument array, should be SQL but I don't know how
$args = array(
'post_type' => 'post',
'post_status' => 'publish',
'posts_per_page' => -1
);


$query = new WP_Query($args);

    while ( $query->have_posts() ) : $query->the_post();

    $f =  './exported-posts/'.get_the_title().'.txt';


    $content = 'Title: ' . get_the_title() . PHP_EOL;
    $content .= 'Published on: ' . get_the_date() . PHP_EOL;
    $content .= PHP_EOL . PHP_EOL;
    $content .= get_the_content();

    file_put_contents($f, $content);
 endwhile;

excellink – How export a list to Excel

I would like to know how I can add the following list with the title (RMSp) and counting numbers to an excel sheet (fig below). Please note that the length of the list might change. In fact, it should be shown as follows:

Data = {20.6142, 178.024, 345.767, 56.678, 7767, 765}

I am using the following script

rmsp = {“RMSp”};
AppendTo(rmsp, Data)
toExcel = Transpose({rmsp})
toExcel // TableForm

enter image description here

export – Get shareable URLs of all YouTube Music playlists automatically

Instructions:

  1. Go to your Playlists page.
  2. Scroll to the bottom of the Playlists page (making sure that all your playlists have loaded).
  3. Press F12 to open your console.
  4. Paste this JavaScript into your console.
    const playlists = ();
    
    document.querySelectorAll("ytmusic-two-row-item-renderer").forEach(playlist => {
      const title = playlist.querySelector(".details > .title-group").innerText; 
      const url = playlist.querySelector("a").href;
    
      if(title !== "New playlist" && title !== "Your Likes")
        playlists.push({title, url});
    });
    
  5. (optional) To sort it, enter this:
    playlists.sort((a,b) => (a.title > b.title) ? 1 : ((b.title > a.title) ? -1 : 0));
    
  6. Do what you’d like with the array of objects. I provide a few options below.

If you want the output in JSON form, just stringify it:

JSON.stringify(tracklistObj, null, 't');

If you want a plain text version:

let myString = "";
playlists.forEach(list => myString += `${list.title} - ${list.url}n`);
myString;

If you want to have the output be an HTML list:

let myHTML = "<ul>";
playlists.forEach(list => myHTML += `<li><a href="${list.url}" target="_blank">${list.title}</a></li>` );
myHTML += "</ul>";

How to export RGB Vertex Color in Blender for Unity

I am currently trying to understand how I can paint my vertices in blender to then use them in my shaders in Unity. Ideally I would like to export all color channels (RGB) so that I have 3 different masks ready in my shader in Unity.

In blender I have used the vertex painting mode and painted a simple sphere in blue on the x-axis and in red on the y-axis. When I exported the fbx and had a look in Unity there were two problems:

  1. The red and the blue channel seem to be mixed up
  2. One channel was painted ontop of the other channel and “erased” data from the other color channel

Why are my color channels mixed up (do I have to tick certain boxes while exporting?) and how can I paint the channels separately and still export them all together inside the fbx?

cheers

How to export Access database table exceeding 4 million records to Excel?

I have an Access database with 1 table with over 4 million records. I would like to read this in with Python, but the pyodbc module is giving me issues. Another approach I’m considering is to export the table to Excel, but Excel limits the number of rows to about 1.05 million. How do I partition the Access table into multiple sets of 1.05 million rows each so that all of the data can be exported into multiple .xlsx files?

scala – Export huge excel file

Sorry if it is a wrong subject. I came here from stackoverflow.

I develop a web application in Angular (frontend) and Scala (backend) for a big data team. Because they use large files for export/import, I build a module which is a copy of Microsoft Excel.

So, what is the flux for import files:

the client send the file to api1
api1 save the file on a temp folder and send response to client that the import has began.
this time, api1 call api2 (service) to process this file, map rows and columns in list of objects, create a table in database and insert bulk rows (2500 lines for each query) For import, that’s ok, is a process in background and the client don’t need to wait for it because will see results from first second (first bulk insert is realy fast). We talk here about excels with some hundred thousands of rows, maybe millions.
after processing, the file is deleted from temp folder
Now, the problem is at export: How I need to think about exporting a db table like this? Because, if I don’t save it anywhere, I need to get all data from table and compute a temp file (excel worksheet) which take some time (maybe 5, 10, 15 minutes) and I can not keep a connection client – server opened so much time. Anyway, if I can use sockets instead http-requests for this, the client will need to wait this time to compute the file. Is annoying for him.

One solution is to keep the temp file on server/cloud, but probably this will be (or can be) altered by users and need to be updated before downloading. My question is … how I can map db tables in excel files to give it to users instantly, when they want to download a table?

For my api2 I’ll use Apache Spark for reading the files and write into database. But anyway, this will remain an background process and will be decoupled from the user request.