--- title: Blog url: 'https://kb.hills-family.uk/blog' markdown: 'https://kb.hills-family.uk/blog.md' date: '2026-08-31' description: 'Our blog, or knowledge base, starts here!' --- # Blog Our blog, or *knowledge base*, starts here! [ Home ](https://kb.hills-family.uk/) Blog 20 *Nov* #### [Restoring user access following a restore of a Microsoft SQL Server backup](https://kb.hills-family.uk/blog/restoring-user-access-following-a-restore-of-a-microsoft-sql-server-backup) [SQL Server](https://kb.hills-family.uk/blog/tag:SQL%20Server) When a Microsoft SQL Server backup is restored, it often includes the users that were associated with the database at the time of the backup. If the backup is used to restore on a new server, then there’s a good chance that the database users will be “disconnected” from the SQL Server users (if they exist at all). Fortunately, restoring access is simple. [Continue reading...](https://kb.hills-family.uk/blog/restoring-user-access-following-a-restore-of-a-microsoft-sql-server-backup) 11 *Jul* #### [Ethernet name change for FLEXlm in Ubuntu 20.04](https://kb.hills-family.uk/blog/ethernet-name-change-for-flexlm-in-ubuntu-20-04) [Licensing](https://kb.hills-family.uk/blog/tag:Licensing) [Network](https://kb.hills-family.uk/blog/tag:Network) [Ubuntu](https://kb.hills-family.uk/blog/tag:Ubuntu) [Linux](https://kb.hills-family.uk/blog/tag:Linux) I recently had to install an old piece of software on our (headless) Ubuntu 20.04 Linux system. Our first hurdle was binaries not executing properly — on attempting to run executables, the error `No such file or directory` would appear. This was corrected by installing `lsb-core`: ```bash $ sudo apt install lsb-core ``` The software we wanted to use had copy protection, specifically [Macrovision’s FLEXlm license manager](https://en.wikipedia.org/wiki/FlexNet_Publisher) (now with Flexera Software). Our FLEXlm-protected software was provided with a node-locked license and this was tied to a specific MAC address on our machine. It’s possible to ask FLEXlm what’s the HostID (MAC address(es)) that it sees by running: ```bash $ lmutil lmhostid lmutil - Copyright (c) 1989-2006 Macrovision Europe Ltd. and/or Macrovision Corporation. All Rights Reserved. The FLEXlm host ID of this machine is "" ``` Unfortunately, the software was unable to “see” our Ethernet adapter due to older versions of the software looking for Ethernet adapters starting with `eth`. The reason? `systemd` uses an [alternative naming convention](https://www.freedesktop.org/software/systemd/man/systemd.net-naming-scheme.html), formally part of the [*predictable network interface names*](https://www.freedesktop.org/wiki/Software/systemd/PredictableNetworkInterfaceNames/), that essentially means Ethernet devices will start with `en` instead of the “traditional” `eth` prefix. We therefore needed a way of getting FLEXlm to see the Ethernet adapter. [Continue reading...](https://kb.hills-family.uk/blog/ethernet-name-change-for-flexlm-in-ubuntu-20-04) 21 *Jun* #### [Fixed width file export row delimiter issue](https://kb.hills-family.uk/blog/fixed-width-file-export-row-delimiter-issue) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) [Logic Apps](https://kb.hills-family.uk/blog/tag:Logic%20Apps) [JavaScript](https://kb.hills-family.uk/blog/tag:JavaScript) ![](https://kb.hills-family.uk/images/e/c/8/2/4/ec824f83b7d05acbc16c9fb2bfd0261b25adceb7-crlf.png) As I have mentioned on my [previous post](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations), I have discovered an interesting bug while exporting a [fixed width file](https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format) using DMF within Dynamics 365 Finance and Operations. The bug occurs when you specify the row delimiter as `{CR}{LF}` or even `{CR}` on your fixed width file settings. In either instance, the file gets exported without a carriage return (`{CR}`) thus ignoring the row delimiter setting for the fixed width file. The exported file therefore wouldn’t be formatted as you would want, potentially causing readability issues for some text editors or applications that depend on the `{CR}{LF}` combination. In this post, I’ll take a deeper look into this and how I solved it by integrating a fix within the Logic Apps process required for exporting the data. [Continue reading...](https://kb.hills-family.uk/blog/fixed-width-file-export-row-delimiter-issue) 16 *Jun* #### [D365 F&O Fixed width file format](https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) ![](https://kb.hills-family.uk/images/f/6/8/0/8/f6808b04f940c2338e76c753b2eb678492de3bcd-configuredatasource.png) Fixed width a.k.a. fixed-character file is a file that is not delimited. That is, a file which contains rows and columns where the columns are not delimited by any special characters like commas (comma separated files `.csv`) or tabs (tab delimited files) but the columns are broken down based on the character length of each field/column. [Continue reading...](https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format) 16 *Jun* #### [Overcoming D365 F&O fixed width/character file limitations](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Logic Apps](https://kb.hills-family.uk/blog/tag:Logic%20Apps) [JavaScript](https://kb.hills-family.uk/blog/tag:JavaScript) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) ![](https://kb.hills-family.uk/images/c/a/e/7/8/cae78d6fcc1ef5cf51f47ecaca66691c95450e36-dmfmapping.png) I have been working on a requirement recently that involves importing a fixed width character file in D365 F&O via DMF by way of Logic Apps. There had been a couple on challenges on this one and I have Googled / Binged about it and found forums where people have had to find alternative solutions, thinking that it’s impossible (for example, [this question from the Microsoft Dynamics Community Forum](https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/312794/dixf---fixed-width-import-issue-query---breakout-of-values/907424)). I’ve also read many similar blog posts where some people say that they have asked the customer to change the file format. Like this one from before. > *We did complained to Microsoft about one year ago because we had the same issue, and as I see it stills hasn’t been fixed, so I wouldn’t believe it will be at least solved in a short time. Sorry to not bring to you a solution, in our case we had to change the file format.* But I’ve been wondering **why** the customer has to change the file format? Can the developer not create a solution? [Continue reading...](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations) - « - 1 - [2](https://kb.hills-family.uk/blog/page:2) - [3](https://kb.hills-family.uk/blog/page:3) - [»](https://kb.hills-family.uk/blog/page:2) #### Knowledge Base Tips, tricks and how-to guides on various topics. #### Popular Tags [Linux](https://kb.hills-family.uk/blog/tag:Linux) [Dynamics AX](https://kb.hills-family.uk/blog/tag:Dynamics%20AX) [D365 Finance and Operations](https://kb.hills-family.uk/blog/tag:D365%20Finance%20and%20Operations) [Network](https://kb.hills-family.uk/blog/tag:Network) [Data Management Framework](https://kb.hills-family.uk/blog/tag:Data%20Management%20Framework) [Logic Apps](https://kb.hills-family.uk/blog/tag:Logic%20Apps) [JavaScript](https://kb.hills-family.uk/blog/tag:JavaScript) [netcat](https://kb.hills-family.uk/blog/tag:netcat) [SSH](https://kb.hills-family.uk/blog/tag:SSH) [PowerShell](https://kb.hills-family.uk/blog/tag:PowerShell) [Virtual Machines](https://kb.hills-family.uk/blog/tag:Virtual%20Machines) [VMware](https://kb.hills-family.uk/blog/tag:VMware) [SQL Server](https://kb.hills-family.uk/blog/tag:SQL%20Server) [Wireshark](https://kb.hills-family.uk/blog/tag:Wireshark) [Python](https://kb.hills-family.uk/blog/tag:Python) [Licensing](https://kb.hills-family.uk/blog/tag:Licensing) [Ubuntu](https://kb.hills-family.uk/blog/tag:Ubuntu) --- ## Navigation - Previous: [Home](https://kb.hills-family.uk/index.md) - Children: - [D365 F&O Fixed width file format](https://kb.hills-family.uk/blog/d365-f-and-o-fixed-width-file-format.md) - [Duplicate label names in Microsoft Dynamics AX](https://kb.hills-family.uk/blog/duplicate-label-names-in-microsoft-dynamics-ax.md) - [Ethernet name change for FLEXlm in Ubuntu 20.04](https://kb.hills-family.uk/blog/ethernet-name-change-for-flexlm-in-ubuntu-20-04.md) - [Fixed width file export row delimiter issue](https://kb.hills-family.uk/blog/fixed-width-file-export-row-delimiter-issue.md) - [Generating multiple lists from a list of tuples](https://kb.hills-family.uk/blog/generating-multiple-lists-from-a-list-of-tuples.md) - [Hopping with SSH](https://kb.hills-family.uk/blog/hopping-with-ssh.md) - [Overcoming D365 F&O fixed width/character file limitations](https://kb.hills-family.uk/blog/overcoming-d365-f-and-o-fixed-width-character-file-limitations.md) - [Restoring user access following a restore of a Microsoft SQL Server backup](https://kb.hills-family.uk/blog/restoring-user-access-following-a-restore-of-a-microsoft-sql-server-backup.md) - [Shrinking a Linux Virtual Machine Disk with VMware](https://kb.hills-family.uk/blog/shrinking-a-linux-virtual-machine-disk-with-vmware.md) - [Use SSH as SOCKS 5 proxy](https://kb.hills-family.uk/blog/use-ssh-as-socks-5-proxy.md) - [When you don't have curl...](https://kb.hills-family.uk/blog/when-you-dont-have-curl.md) - [Wireshark for CLI](https://kb.hills-family.uk/blog/wireshark-for-cli.md)