teleren/devto huggingface dataset:
Automate distribution of Unreal Engine 5 to Apple TestFlight
Tags: ios, ue5, gamedev, devops
Published: 2024-03-22 06:19:29

To automate distributing a Unreal Engine 5.3.2 build to test flight, you can do the following. There may be other ways but this is the only way I got it working now.

1. Build the xarchive with something like:
`RunUAT.command BuildCookRun -platform=IOS -project=ProjectName.uproject -clientConfiguration=Shipping -build -cook -stage -pak -package -distribution -archive`

2. At this point, you have a `ProjectName.xcarchive` archive. Now is your chance to go into the archive and poke the plist file with your custom versions etc. I did it with a script something like this. Call the script with: `./UpdateProjectVersion.command "0.0.1"`

```bash
#!/bin/bash
if [ -z "$1" ]; then
    echo "Usage: $0 <version_number>"
    exit 1
fi

VERSION="$1"

pushd /ProjectName/Root/Folder

#Note, we assume we only have one xcarchive in this folder. Make sure to clean up
for file in *.xcarchive; do
    mv "$file" "ProjectName.xcarchive"
    break # Only rename the first one found
done

PLIST="ProjectName.xcarchive/Products/Applications/ProjectName.app/Info.plist"
if [ -f "$PLIST" ]; then
    # Using awk to insert lines after the first occurrence of <dict>
    awk -v ver="$VERSION" '/<dict>/{print;print "<key>CFBundleVersion</key>\n<string>"ver"</string>";next}1' "$PLIST" > temp.plist && mv temp.plist "$PLIST"
else
    echo "Info.plist not found."
    exit 1
fi

popd
```
4. Now you need to get a good `ExportOptions.plist` file. I suggest you make an ad-hoc distribution with xcode and grab the file that is output in the same directory as the ipa.

5. Create an ipa.
`xcodebuild -exportArchive -archivePath ProjectName.xcarchive -exportOptionsPlist ExportOptions.plist -exportPath .`
This will create the ipa in the current directory.

6. Validate the ipa
`xcrun altool --validate-app -f ProjectName.ipa -t ios --apiKey APPSTORE_API_KEY_ID --apiIssuer APPSTORE_ISSUER_ID`

7. Upload the ipa
`xcrun altool --upload-app -f ProjectName.ipa -t ios --apiKey APPSTORE_API_KEY_ID --apiIssuer APPSTORE_ISSUER_ID`

Note: Last two steps assume you have your app store key file in `~/.private_keys` or one of the other valid search paths.
Famous Places in Burr Ridge Illinois US - Mohit Tandon
Published: 2024-03-22 06:07:41

Burr Ridge is a village in Cook and DuPage counties in the U.S. state of Illinois. Mohit Tandon from Burr Ridge suggested Famous places in Burr Ridge illinois US.

1. Burr Ridge Village Center: This is a mixed-use development featuring shopping, dining, and entertainment options. It's a popular spot for locals and visitors alike to shop, dine, and spend leisure time.

2. Kraml Park in Burr Ridge: Kraml Park offers recreational facilities such as tennis courts, baseball fields, and playgrounds. It's a great place for outdoor activities and family outings. -** Mohit Tandon Burr Ridge**

3. Burr Ridge Community Park: Another popular park in Burr Ridge, it features walking trails, picnic areas, and sports fields. It's a lovely spot for enjoying nature and outdoor activities. - Mohit Tandon Burr Ridge

4. Burr Ridge Historic District: This district showcases some of the village's historic architecture and landmarks. It's a charming area to stroll around and admire the well-preserved buildings.

5. The Village Green: This is a central gathering place in Burr Ridge, often hosting community events and festivals. It's a vibrant hub of activity within the village.- [Mohit Tandon](http://mohittandonchicago.me/)

While Burr Ridge may not have as many famous landmarks as larger cities, these places contribute to its charm and appeal as a suburban community.
How to First Letter Capital & Rest All Small for Any Name in Excel Using Python Automation
Tags: webdev, programming, python, productivity
Published: 2024-03-22 06:00:05

In Excel, names are often written in various formats, but sometimes it’s necessary to standardize them. One common standard is to capitalize only the first letter of each name and make the rest lowercase. This ensures consistency and readability in datasets.

Python provides tools like the openpyxl library to automate Excel tasks. With Python, you can write a script that reads a list of names from an Excel file, converts them to the desired format, and saves the modified names back to the Excel file. This automation process can save time and reduce errors when working with large datasets.

In this tutorial, we’ll use Python to automate the task of capitalizing the first letter of each name and making the rest lowercase in an Excel file. We’ll use the openpyxl library to read the names from the Excel file, modify them, and save the modified names back to the Excel file.

By the end of this tutorial, you’ll have a Python script that can easily handle this task, making it easier to maintain consistency in your Excel datasets.

Original Excel(names.xlsx)

[Read More](https://codemagnet.in/2024/03/22/how-to-first-letter-capital-rest-all-small-for-any-name-in-excel-using-python-automation/)
Photo puzzle x effect capcut template
Tags: javascript, webdev, beginners, tutorial
Published: 2024-03-22 05:53:55

The CapCut template library harbors a covert key to crafting viral sensations across social media platforms. Each day, creators unveil captivating effects and ingenious templates that fuel the creative fire. Among these luminaries, Heril RCS stands out, having recently unveiled a masterpiece titled "[Foto puzzle x Efek CapCut template](https://capcutapkdownload.info/foto-puzzle-x-efek-capcut-template/)". Also known colloquially as the Puzzle CapCut template, it has swiftly garnered acclaim for its mesmerizing cutout transitions.

This template has been warmly embraced by users, owing to its seamless blend of creativity and innovation. Much like its counterparts in the CapCut realm, it has surged in popularity on TikTok, finding its way into countless videos. As the video unfolds, the subject's image, meticulously isolated from its background, takes center stage, undergoing a captivating metamorphosis against a backdrop of diverse environments.

Its allure extends far and wide, evidenced by the staggering figure of 20 million users who have integrated it into their videos, each adding their unique twist to the template's enchanting tapestry.
History API in One Byte Explanation
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-22 05:53:05

---
title: History API in One Byte Explanation
published: true
tags: frontendchallenge, devchallenge, javascript, webdev
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zfrqisrc44trxfsr6pfr.jpg
---

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer

Browser session history is managed by states and this API helps us to modify and query it. Along pushing, replacing states and tracking it with popstate event, we can navigate visitors to go back, forward or jump to specific point of the history.


## Additional Context

[MDN reference](https://developer.mozilla.org/en-US/docs/Web/API/History_API) | [cover credit to Joanna Kosinska](https://unsplash.com/photos/brown-paper-and-black-pen-B6yDtYs2IgY)

I'm a simple old-school guy who just tried to munch a lot information in a bite, yes pun intend >:) Hopefully it won't choke any reader ;)
LOVELYPEARS PTE LTD
Published: 2024-03-22 05:51:48

"**[Lovelypears Pte Ltd]( https://lovelypears.com/)** is a T-Shirts Printing consultancy that has catered for the printing needs of Educational Institutes, Non-Profit Organizations, Corporate Entities and Individuals in Singapore since 2009.

Riding through the tides for the past 14 years, we have anchored ourself in the industry with excellent results. Moreover, we have faith in bringing long term business relationships between ourselves and our customers, presenting them with value added services. Not to mention, Our business survived through Covid-19 pandemic.

Regardless of usage for corporate branding exercises, events awareness or just bringing the message across through T-Shirt Printing, we believe in providing our customers the best in our products with competitive prices regardless of quantity desired. Choose the type of Apparels that are suitable for your events and purposes. There’s no limits to what you can choose to make.

So what are you waiting for?  Let’s PYOTee – Print Your Own Tee!"
How to style form without changing the HTML markup.
Tags: frontendchallenge, devchallenge, css, javascript
Published: 2024-03-22 05:51:10

This is a submission for DEV Challenge v24.03.20, Glam Up My Markup: Camp Activities_

The main point of this challenge is not to change the HTML markup. So, I was started form the first point of my every day developers mindset. First of all I see the markup - there is nothing special. I decided to use codepen - it's very simple to use and give me many options to improve the initial markup.
After logged in, I set up the pen's settings. Choose the preprocessor and normalize scss.
![pen settings](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w4oulotvtf60cpghh2ad.png) 

After that I set up font and base styles in body (useful for case you don't want to reset styles on every element).
![set up font and base styles](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vqf4tqe34k305g5e27op.png)

Because I was not allowed to change the HTML, I decided to write styles by selectors. For form's container I choose the flex positioning. Very easy and useful. And for the form I choose the grid positioning. In purpose not to duplicate styles for form's fields and button I write initial styles in one place and use the inheritance.
![write initial styles](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rcx4zunsgdmarz3ba1kn.png)

After that add some styles for hover and small animation.
Also I made a small js part for improve interactivity. There is no need to complex approaches. I coose the way to find parent element on document, and then search all his children (if needed) on parent, not on document.

![small js part for improve interactivity](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/g71az7jreswxypdysf9m.png)

![final step](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fmg38e7mczqithpl5wja.png)

## Demo
[CodePen demo](https://codepen.io/juliettkhar/pen/oNOZymY?editors=0011)

## Journey
This way helps me to create nice and adaptive form with minimum lines of code. And keeps it readable.

<!-- Team Submissions: Please pick one member to publish the submission and credit teammates by listing their DEV usernames directly in the body of the post. -->

<!-- We encourage you to consider adding a license for your code. -->

<!-- Don't forget to add a cover image to your post (if you want). -->


<!-- Thanks for participating! -->
My experience in phase one
Published: 2024-03-22 05:49:13

Ever since I was in high school I have always wanted to become a software engineer and now it's finally happening! I spent so much time working odd jobs trying to save enough money to be able to attend Flatiron School and kept constantly getting set back. I was beginning to lose hope in being able to attend Flatiron School, but thankfully my grandparents offered to help me finance the tuition through a loan and I'd only have to pay half so I was able to attend!!

When I was applying to Flatiron School I had already known that it was going to be very fast-paced and difficult and it has definitely lived up to my expectation in that regard, but I'm also amazed by how much I've learned in such a short time. Coming from a background of manual labor and just blue-collar work this has been a drastic change for me but I am so glad I made it, I love that feeling I get when all the tests finally pass or I finally figure out what the bug in my code was that had me stuck for hours, feeling myself getting more efficient and comfortable with things I once struggled with is such an accomplishing feeling.

A good example of something I once struggled with and am now so much more comfortable with would be understanding the DOM, the DOM (Document Object Model) is a programming interface for web documents and the backbone of web development. The DOM represents the hierarchical structure of an HTML document as a sort of tree of objects where each element in the document can be manipulated with Javascript

```
// Select the heading element using its id
const heading = document.getElementById('main-heading');

// Update the text content of the heading
heading.textContent = 'Welcome to my Website!';
```
this little snippet of code is a great example of how we can edit the DOM using Javascript  to change something, in this example we changed the text of the heading element to now say "Welcome to my website!"

The DOM can also be used for other things such as responding to user actions by using `.addEventListener()`. A good example of this would be the following code in which we add an event listener that changes the color of the heading when the user clicks.

```
// Add an event listener to the heading element
heading.addEventListener('click', () => {
    // Change the color of the heading
    heading.style.color = 'blue';
});
```
This is something that I used to struggle a lot with, but now find it to be extremely easy and wonder how I ever did struggle with it, it's so much fun learning this and looking back at how much I now understand. Before attending this school honestly I didn't even know how to really read code, I'd occasionally open the dev tools in Google Chrome and just click stuff and maybe rewrite the name of something if I was really bored but it all looked indecipherable to me and being able to now more than just read the code actually be able to write my own and create my own webpages feels like such an accomplishment to me
BlogTimes is a user-friendly &dynamic Guest Posting Website
Tags: business
Published: 2024-03-22 05:48:42

BlogTimes is a pioneering online platform dedicated to curating a diverse array of articles spanning a wide range of topics. Established in the early 2000s, BlogTimes quickly rose to prominence as a go-to destination for individuals and businesses seeking to share insights, expertise, and perspectives on subjects ranging from Artificial Intelligence and Business to Cryptocurrency and Finance.

With a commitment to fostering inclusivity and encouraging contributors from all walks of life, BlogTimes has cultivated a vibrant community of writers, thought leaders, and enthusiasts. The platform serves as a virtual melting pot where voices from diverse backgrounds converge to engage in meaningful discourse and exchange ideas.

Driven by a passion for knowledge sharing and a dedication to staying at the forefront of digital trends, BlogTimes continues to evolve, adapting to technological advancements and emerging topics while maintaining its core values of authenticity, accessibility, and diversity.

Whether you're a seasoned expert looking to share your insights or a curious reader eager to explore new perspectives, BlogTimes offers a dynamic platform where everyone has a voice and every topic finds its place. Join us on our journey as we continue to inspire, educate, and connect through the power of words.

[BlogTimes](https://blogtimes.in/)
Using clearTimeout in JavaScript
Tags: javascript, webdev, tutorial
Published: 2022-12-02 19:21:02

### Overview & Setup

This article will show how to use the clearTimeout function in JavaScript. This function allows you to use cancel a setTimeout before it resolves.In this example I will use an angular project in StackBlitz, but as this is a JavaScript feature, it can be used in any JavaScript environment.  

To see a working use of this, you can checkout my example project <a href="https://stackblitz.com/edit/cleartimeout?file=src/app/app.component.ts" target="None"> here </a>.

### Getting Into It

There are many possible use cases in which using clearTimeout may be advantageous. For example, if you want to have an input field fire off a search when the user types in it, but you want to wait until the user stops typing to run the search function. You would need to use setTimeout in this situation to delay the search function. But without a way to cancel that timeout, the function would still run on every key stroke. 

So to get the desired behavior and cancel the timeout, you would need to implement something like this:

```js 
  setTO = () => {
    if (this.timeoutId) {
      clearTimeout(this.timeoutId);
    }
    this.timeoutId = setTimeout(() => {
      this.running = false;
      this.completed = true;
    }, 3000);
  };
```

In this function, we look to see if there is already a timeout. If there is, we clear it and set a new one. So in this example the user would need to not input anything for 3 seconds before the timeout resolves. 

### Conclusion

That is the basic implementation and situation of when you might need or want to use clearTimeout. It is a function that has helped me in my coding and hopefully this can help you too! Again, to see my Stackblitz example with a working implementation, <a href='https://stackblitz.com/edit/cleartimeout?file=src/app/app.component.ts' target='None'> click here. </a>
React to the Future: Building SEO-Friendly Apps with Next.js
Published: 2024-03-22 05:33:58

In the fast-paced world of web development, staying ahead of the curve is essential. As businesses strive to improve their online visibility and drive organic traffic to their websites, search engine optimization (SEO) has become increasingly crucial. In this article, we'll explore how Next.js, a powerful framework built upon React, can be leveraged to create SEO-friendly web applications that rank higher in search engine results.

**Understanding Next.js and React:**
Before diving into the specifics of building SEO-friendly apps with Next.js, let's first understand the basics of Next.js and React. React is a popular JavaScript library used for building user interfaces, known for its simplicity and flexibility. Next.js, on the other hand, builds upon React's foundation by adding features like server-side rendering (SSR), static site generation (SSG), and routing capabilities.

**Next.js vs. React: A Brief Comparison:**
[Next.js vs React](https://www.clickittech.com/developer/next-js-vs-react/?utm_source=backlinks&utm_medium=referral
) have their unique strengths and advantages. While React offers flexibility and a robust ecosystem for building interactive user interfaces, Next.js takes it a step further with features like SSR and SSG, making it a preferred choice for SEO-conscious developers.
**
The Power of Next.js for SEO:**
Next.js offers several features that make it ideal for building SEO-friendly web applications.

**Server-Side Rendering (SSR) for Improved Indexing:**
One of the key features of Next.js is its ability to perform server-side rendering (SSR). With SSR, the initial HTML content is generated on the server and sent to the client, making it easier for search engine crawlers to index the content. This results in better visibility and higher rankings in search engine results pages (SERPs).

**Static Site Generation (SSG) for Faster Loading Times:**
Next.js also supports static site generation (SSG), which allows developers to pre-render pages at build time. This approach ensures that the content is readily available to users and search engines, leading to faster loading times and improved user experience. Additionally, pre-rendered pages are easier to index, further enhancing SEO performance.

**Dynamic Routing for SEO-Friendly URLs:**
Next.js offers dynamic routing capabilities, enabling developers to create SEO-friendly URLs that are easy to understand and navigate. By structuring URLs effectively, developers can improve the overall user experience and increase the likelihood of higher search engine rankings.

In conclusion, Next.js provides developers with a powerful toolkit for building SEO-friendly web applications. With features like server-side rendering, static site generation, and dynamic routing, Next.js empowers developers to create high-performance apps that rank well in search engine results. By leveraging Next.js' capabilities, developers can stay ahead of the competition and ensure their apps are optimized for maximum visibility and success in the ever-evolving digital landscape.
How to Set up Google Analytics: A Step-by-Step Guide for 2024
Tags: google, analytics, webdev
Published: 2024-03-22 05:32:30

https://codecraftsangita.blogspot.com/2024/03/how-to-add-google-analytics-to-your.html

Are you overwhelmed by the thought of adding Google Analytics to your website? Goals that are as significant as knowing your audience, monitoring traffic, and enhancing your online presence can be confused by the practical concerns for many website owners.

Fortunately, it's easier than you may think to set up Google Analytics, and it's a valuable tool for anybody looking to increase their online presence.

I'll walk you through the process of adding Google Analytics to your website in this in-depth tutorial, breaking it down into easy-to-follow stages.

Read the full article here: https://codecraftsangita.blogspot.com/2024/03/how-to-add-google-analytics-to-your.html
How to Handle Different Data Types during Row-to-Column Transposition
Published: 2024-03-22 05:27:30

We have a database table FIRSTTBL. Below is part of its data:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q32rukcfcrdpyokwtke4.png)
And we are trying to combine every six rows into one record. Below is part of the desired result:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q7abt6sm9yw82e1xjqxa.png)
It is a row-to-column transposition – converting PROPERTY field values of every six rows into the new column attributes, and get non-null values under the original STRING, INTEGER, DATETIME, BOLLEAN and XML columns to assign them to the corresponding new columns (while maintaining the original data types).
SQL：

```
SELECT
            ID,
            FIRSTNAME,
            ...,
            FLAG = CAST (FLAG AS INT),
            ...
FROM
            (
            SELECT
                        *
            FROM
                        (
                        SELECT
                                    f.ID,
                                    f.PROPERTY,
                                    f.STRING + f."INTEGER" + f.DATETIME + f.BOLLEAN + f.XML AS COLS
                        FROM
                                    FIRSTTBL f)
            PIVOT(
                        min(COLS) FOR PROPERTY IN
                                    (
                                    'firstname' AS firstname,
                                    'lastname' AS lastname,
                                    'birthdate' AS birthdate,
                                    'address' AS address,
                                    'flag' AS flag,
                                    'number' AS "NUMBER"
                                    )
                        )
            )
```
According to the original table, there is one and only one non-null value among STRING, INTEGER, DATETIME, BOLLEAN and XML columns for any row, so we just need to get the first non-null value and assign it to the corresponding new column. It is not difficult to perform the transposition using PIVOT function, except that we need to handle different data types according to the SQL rule, which requires that each column have a consistent type. For this task, first we need to convert the combined column values into a string, perform row-to-column transposition, and then convert string back to the proper types. When there are a lot of columns, the SQL statement can be tricky, and dynamic requirements are even hard to achieve.

Yet it is easy to write the code using the open-source esProc SPL:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mgwx83wwojwa64ybjiuf.png)
SPL does not require that data in the same column have consistent type. It is easy for it to maintain the original data types while performing the transposition.