IT guide: Clean Intune device exports in Excel without data corruption

·2 views

IT administrators often encounter data quality issues when analyzing device exports from Microsoft Intune. Common problems include serial numbers converting to scientific notation, duplicate device entries, and inconsistent user principal name formatting. The article recommends importing CSV files via Excel's Data tab rather than double-clicking to prevent automatic data type conversions. It advises standardizing UPNs through trimming, cleaning, and lowercasing before matching records. Administrators should deduplicate using stable identifiers like serial numbers or device IDs while preserving original export files.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Developer reportedly decompiles Adobe software, re-creates it in Rust as open source

A developer has reportedly decompiled the Adobe software suite and rebuilt its functionality using the Rust programming language. The resulting project has been released as open-source software. The claim was shared on the social platform Bluesky and subsequently discussed on Hacker News. The original report indicates this is a recent, independent project by an individual developer. The motivation appears to be an experimental recreation of the proprietary Adobe tools in a different, modern programming language.

0 comments Read more at Hacker News

ProgrammingDEV Community ·

Node.js service design ensures live poll notifications reach offline users

A Node.js service architecture is described for reliably delivering live poll results to all participants, including those who disconnect during a session. The design queues notification events in a durable per-recipient inbox before publishing them to currently connected users. This ensures users who reconnect after a session can still retrieve their notifications, addressing a scenario where 4,000 B2B SaaS participants might answer a poll within 12 minutes. The system's core invariants include stable event IDs, deduplication, and idempotent retries to guarantee delivery without user-visible duplication.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Free tool simplifies access to Japan's official property price database

Japan's Ministry of Land, Infrastructure, Transport and Tourism publishes detailed real estate transaction data for all 47 prefectures. A developer has created an open tool that makes this government data easily accessible via API. The tool provides programmatic access to transaction records dating back to 2005, including prices, locations, and property details. This enables AI agents and investors to analyze Japanese real estate markets without manually processing government documents. The service operates on a pay-per-result model with a free tier available.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Hotel price API benchmark shows 16% rate variance due to tax display differences

A developer benchmarked seven hotel price APIs for the same Rome hotel stay in November 2026. The APIs returned price variations of up to 16% for identical rooms, primarily due to differing tax inclusion practices across markets. Some APIs displayed prices before taxes for US users while showing tax-inclusive prices for German users. The tests also revealed significant performance differences, with response times ranging from 0.7 seconds to 75 seconds. The findings highlight the importance of normalizing tax-inclusive totals when comparing hotel rates from multiple sources.

0 comments Read more at DEV Community