Linux workflow for browse images + raw edit?

I’m currently on a Mac using Capture One and have a very simple photos workflow. It is:

  • import images, usually raw
  • add folder to Capture One
  • browse new and existing photos
  • edit selected images
  • get out, and browse, repeat …
  • back up folder structure to NAS

I don’t spent a huge amount of time editing. It’s probably 50/50 browse/edit.

The nice thing about this single-app workflow is that the edits I make are visible in the browser. I don’t need to do anything in particular, and so the workflow is very fast.

But, I want to move to Linux. And it seems there are a bunch of different programs. They all do their jobs well, but they don’t interop with one another. An edit in one program doesn’t show up in another.

What’s the closest I can get to my desired workflow?

FREE Car Images (for personal and commercial use) – autocontent.uk

We have recently launched a new platform offering free automotive stock images, as we understand how hard it is to source car images for projects.
(​IMG)
We offer free stock images for websites, write ups, editorials, blog posts, advertisements, large format artwork, videos, design work and social media….

FREE Car Images (for personal and commercial use) – autocontent.uk

Is it possible to insert and filter icons / images together with cells in MS Excel?

I’m using Icons (which are basically graphics/images) in my Excel Sheet (Office 365). I figured that resizing the icon to the cell will “lock” it to the cell (allowing to copy/cut the icon with the cell). But when I filter the corresponding cells, the icon will move to another cell.

How can I insert the icon in such a way that I can filter the icon with the cell? (make it disappear when the cell disappears)

Here an example: The icons are locked in their corresponding cells and will move with the cells:

the icons are locked to the cells

However when I filter the cells, the icons stay visible and will move to different cells. I’d like to filter the icons as well…

when filtering the icons move out of the cells

automation – Bulk Insert images into Google Sheets as Drawing

I have generally bunch of pics/slides which I like to add into sheets using Insert > Drawing which allows me to annotate/edit freely.

The is that I need to do that 1 by 1 which is very annoying so I am looking for a way to automate this somehow.

All advices/questions are welcome.

Edit:

As I said, I do this operation manually through sheets menu for each image I want to add:

  • Insert > Drawing
  • Insert Image
  • Close

I am looking for a way to bulk upload images as such. One drawing per image so I can annotate each separately later when needed.

8 – Styled images are created with nobody user

I don’t know why my Drupal 8 site is creating styled images owned by “nobody” user instead of web server account user. This cause a problem that those images can`t be read (not found error in drupal log). I have to change the owner of this files, and then I can read the images.
I have my site in a shared hosting and then I have an user to login, ftp, etc. All files are owned by this user, but when I upload an image, styled images are created owned by “nobody”. I don’t know if this is an apache issue or a Drupal issue, but I have some other D8 sites in the same server without this problem.

seo – Google image search crops my images

Google image search shows thumbnails of images that fit in their search results layout. If the aspect ratio doesn’t allow it to fit into the layout, Google crops the image. Google crops the thumbnails show in the search results that are either too tall or to wide.

It looks like the tallest images you can use without cropping have an aspect ratio of about 7:9. To prevent Google from cropping your images in the search results, increase the image width.

For some searches, almost all the images are a taller aspect ratio than what fits in the search results layout. If you search for “standing woman”, almost all the results show women with parts of their heads or feet cropped off. There are a couple that are not cropped though. Note that the image from 3D Warehouse on the right of the screenshot below is not cropped. That image has plenty of white space on the right and left making the aspect ratio of the image wider than tall.

Standing Women Google Image Search

mongodb – Which NoSQL for storing images as 2D arrays (BLOBs)

I have large number of images that I need to access on per-pixel-basis in my app. The images are downloaded from web and are quite large (4k). Update is done several times a day (tousands of images), reading is non-stop.

Currently I use PostGis and store images tiled in raster column type. However, performance is not the best, mainly updates are quite slow (transaction, index update etc).

So I would like to use NoSQL database, since I really dont need SQL.

My workflow is:

Insertion – download image -> split it to tiles of size 64×64 (compress them if necessary with arithetic or huffman coder) -> store tiles in database

Selection – read pixel (x, y) -> locate tile -> retrieve tile -> “unpack” tile in memory -> locate pixel (x, y) -> return value to user

What database should I use for this purpose? I have looked to MongoDB and Cassandra. The later one seems more appropriate for this task.

magento2.3 – Importing images with special characters in path

I am trying to import a lot of images. Images for each product are placed in subfolders by product IDs and locale.

The problem is that each locale specific folder name starts with a caret (^).

Example image paths:

9454032/^all/my_image.jpg
9454032/^en/my_english_image.jpg

What I’m getting

1. Wrong URL/path used for attribute image in row(s): 1, 2 
2. Wrong URL/path used for attribute small_image in row(s): 1, 2 
3. Wrong URL/path used for attribute thumbnail in row(s): 1, 2
4. Wrong URL/path used for attribute additional_images in row(s): 1, 2

What I’ve tried

  • Encoding ^ to %5E, like in URLs
  • Simply removing the caret from

What I’m sure of

  • CSV file encoding; I’m using Sublime text, besides Mac’s Numbers, to verify the data
  • Image path is correct, because it works without the caret in the path
  • Multiple images (in additional_images) are separated correctly, with |, and specified in the importer
  • There are no other special characters in the image names
  • No extra slash in the beginning of the image path

Possible solutions

  • A shell script to rename all folders containing ^, although I’d like to avoid altering original data for consistency reasons

References

Versions

  • Magento 2.3.5-p1
  • PHP 7.3.24

page template – Get text and images from other site

I have a site which is not WordPress, it usually gets input from user like Event name, event speakers, images etc. I want to create an event page in WordPress which contains all the details of events. Is it possible to fetch details from another site to a WordPress site?

document library – Best way to store Images in SharePoint Online

You have several topics to address.
Let’s start with the data volume.
You will need to use tools to upload such a data volume in a reliable way. Using File Explorer or OneDrive for Business (ODFB) client will not work.
For example, 3 TB of images each consuming 5 MB storage corresponds with 600000 files. This is beyond the limit of ODFB client.

In addition, not many tools support extracting of EXIF metadata during uploading.
OOTB SharePoint does not expose EXIF metadata directly and the values cannot be used for searching, viewing and filtering. Using Power Apps / Power Automate it is possible to expose/extract EXIF properties after uploading but firing off 600k Power Automate flows does not sound attractive to me.

There are migrations tools that extract EXIF metadata (and other metadata schemes like XMP, IPTC, ICS) during uploading and capture them into SharePoint columns. See e.g. here (all the EXIF metadata listed in the bottom section can be extracted and stored in SharePoint columns). The SharePoint columns can then be used for searching, viewing, filtering etc..
The tools can also be used to extract the location from images with GPS details. Some tools also support GeoTagging to set location details for files without GPS details during uploading.

The choice for a library type (picture, asset, …) depends on what you want to do with the images after they have been uploaded.
See What is the difference between Document Library, Picture Library & Asset Libray? for a similar discussion.

Hope this helps,

Paul | SLIM Applications