Problems Importing XML Files Into Access
I'm trying to import several XML files into Microsoft access. When I use the XML import wizard however, access imports the XML file creating multiple tables, rather than a single table where each record in the table is from one of the XML files. Is there a way to import an XML file into a single table, rather than it creating multiple tables?
Please help! Excel 2016 truncates URL of REST API call to import XML data
Dear all, I have created a number of Excelsheets that are using calls to a REST API for importing tables into the Workbook. (Through Developer Tools -> XML -> Import and then entering the URL.) I created these workbooks in Excel 2010 and they continue to update fine when I click "Refresh data" or "Refresh all" in Excel 2010 - but in Excel 2016 the URL gets truncated which leads to an error message and the data not getting updated. I would be extremely grateful for any pointers as to how this can be resolved. Thank you very much in advance for any help you may be able to provide. All the best, Stefan
🚀 New & Improved Data Mapper UX in Azure Logic Apps – Now in Public Preview!
We’re excited to announce that a UX update for Data Mapper in Azure Logic Apps is now in Public Preview! We have continuously improved Data Mapper, which is already generally available (GA), based on customer feedback. Last year, we conducted a private preview to assess the improvements in the new user experience and confirm that we are on the right track in simplifying complex data transformations, including EDI schemas. With the insights gained, we made significant UI enhancements and added features to streamline the mapping process. Feedback We value your feedback to make the Data Mapper even better. Please share your thoughts, suggestions, and overall experience with us through our feedback form. How feedback shaped the Public Preview Throughout the evolution of Data Mapper, we gathered valuable feedback from customers and partners. Key themes that emerged include: Reliability: Ensuring the Data Mapper can handle large schemas and complex transformation logic, including functions. Error handling: Providing real-time validation by allowing users to test payloads and catch errors while authoring maps. Looping: Clearly indicating when repeating nodes are mapped and ensuring complex objects are properly represented Drag & drop enhancements: Improving how connections between nodes are created for better usability. Deserialization & namespace honoring: Ensuring XML deserialization correctly loads mappings without data loss, preserving namespace integrity for seamless schema validation. We’ve incorporated these suggestions into the public preview, ensuring a more refined and user-friendly experience. What’s new in the Data Mapper UX? 1. Easier navigation Docked schema panels keep you oriented within the data map. Easily search for specific nodes to streamline mapping. 2. Side-by-side function panel Search and use 100+ built-in functions, including mainly: Collection functions (for repeating elements) String manipulations Mathematical operations Conditional logic 3. Automatic looping for repeating nodes When mapping repeating nodes, a new loop connection is automatically added on the immediate parent nodes at source and destination. Repeating parent nodes are denoted by "A1, A2" notation on hover. Note: If the child node in the source has a deeper nesting level than in the destination, you must manually map the connection from the repeating source node to the destination to ensure proper data transformation. 4. Real-time error detection On saving the map, instantly view warnings and errors for missing mappings or incorrect configurations 5. Test Your Map Instantly Preview the output before running your workflow. How to set up and test out the new Data Mapper experience Enable the Preview: Go to your Azure Logic App (Standard) extension -> Settings -> Data Mapper. Select “Version ~2” to try out the new user experience. Light theme: Enable "Light Theme" in VS Code before creating a new data map. Dark Theme is not supported, but is on the roadmap and will be prioritized soon. Create a New Data Map: Navigate to the Azure tab on the left-hand panel of your VS Code. Select “Create New Data Map” and name it. Once loaded, select the schemas for source and destination. Upload schemas: Upload your source and destination schemas before creating the map (eg .xsd or .json files). Limitations While the new Data Mapper UX brings significant improvements, a few limitations remain: Filter function: The filter function correctly processes numeric conditions when enclosed in quotes (e.g., ">= 10"), but does not behave consistently for string comparisons (e.g., checking if item name = "Pen"). We are actively working on refining this behavior. Custom Functions: Support for custom functions is coming in the next refresh to enhance flexibility in data mapping. Usability enhancements: Improved tooltips, function labels, error messages and other UX refinements are on the way to provide clearer guidance and a smoother mapping experience, especially for complex transformations. Future investments The product is going to continue getting better and we should be adding more features very soon! Some immediate investments include: Enhanced test map experience: Making it easier to validate mappings during development. Panel resizing: Allowing users to have flexibility in viewing larger schemas and functions when multiple panels are expanded.
VBox: Remote Management / Add Roles & Features: The WS-Management service cannot process the request
Hello, I have installed Windows Server 2019 in a VirtualBox 6.1 machine. In the Server Manager I want to activate remote management and install roles like AD DS, but these error messages appear: Local Server \ Remote Management: "The WS-Management service cannot process the request because the XML is invalid." Add Roles and Features: "The WS-Management service cannot process the request. The service in configured to not accept any remote shell requests." I have created the VirtualBox virtual machine as "Windows 2016" and tried several options like EFI, I/O APIC, PAE/NX, nested VT-x, nested paging, NAT, bridged adapter. In the Local Group Policy Editor (Windows Server virtual machine), I have manually enabled "Allow Remote Shell Access" in Local Computer Policy > Computer Configuration > Administrative Templates > Windows Components > Remote Shell and run gpupdate /force. I have also installed Windows Server in VirtualBox on two other computers, but the same problem appears. I hope anyone can help me solve this problem. What has to be configured to make the WS-Management service work correctly?How to export customized Windows 10 taskbar in to an XML
Howdy Folks ! Not sure if this is the right hub for this question but I thought it'd be more relevant here. As Intune natively doesn't offer a way to deploy a customized Windows 10 start menu while still allowing end users to modify it, I've managed to workaround it using the combination below. 1. Export the desired start menu from a template device in to a XML file 2. Create a new registry key and values to target the above XML from the default location Start menu worked perfectly well but I'm trying to figure out how we can do the same for 'Taskbar'. Appreciate if any of your can shed some lights here on how we can export the taskbar and potentially embedding it to the same XML file so that both StartMenu and Taskbar can be deployed at once ? This is my customized start menu (a very basic modification with tile size and location changes) This is the exported XML of the same. My question is, how we can export the taskbar as well, and potentially embedding it to the same XML file so that both StartMenu and Taskbar can be deployed at once? <LayoutModificationTemplate xmlns:defaultlayout="http://schemas.microsoft.com/Start/2014/FullDefaultLayout" xmlns:start="http://schemas.microsoft.com/Start/2014/StartLayout" Version="1" xmlns="http://schemas.microsoft.com/Start/2014/LayoutModification"> <LayoutOptions StartTileGroupCellWidth="6" /> <DefaultLayoutOverride> <StartLayoutCollection> <defaultlayout:StartLayout GroupCellWidth="6"> <start:Group Name="Productivity"> <start:Tile Size="2x2" Column="0" Row="0" AppUserModelID="Microsoft.MicrosoftOfficeHub_8wekyb3d8bbwe!Microsoft.MicrosoftOfficeHub" /> <start:DesktopApplicationTile Size="2x2" Column="2" Row="0" DesktopApplicationLinkPath="%ALLUSERSPROFILE%\Microsoft\Windows\Start Menu\Programs\Microsoft Edge.lnk" /> <start:Tile Size="2x2" Column="4" Row="0" AppUserModelID="Microsoft.WindowsStore_8wekyb3d8bbwe!App" /> </start:Group> <start:Group Name=""> <start:Tile Size="1x1" Column="1" Row="0" AppUserModelID="Microsoft.WindowsCalculator_8wekyb3d8bbwe!App" /> <start:Tile Size="1x1" Column="2" Row="0" AppUserModelID="Microsoft.WindowsAlarms_8wekyb3d8bbwe!App" /> <start:Tile Size="2x2" Column="4" Row="1" AppUserModelID="Microsoft.MixedReality.Portal_8wekyb3d8bbwe!App" /> <start:DesktopApplicationTile Size="1x1" Column="4" Row="0" DesktopApplicationLinkPath="%APPDATA%\Microsoft\Windows\Start Menu\Programs\System Tools\Control Panel.lnk" /> <start:DesktopApplicationTile Size="1x1" Column="3" Row="0" DesktopApplicationLinkPath="%ALLUSERSPROFILE%\Microsoft\Windows\Start Menu\Programs\Accessories\Snipping Tool.lnk" /> <start:DesktopApplicationTile Size="2x2" Column="2" Row="1" DesktopApplicationLinkPath="%APPDATA%\Microsoft\Windows\Start Menu\Programs\OneDrive.lnk" /> <start:Tile Size="2x2" Column="0" Row="1" AppUserModelID="Microsoft.Office.OneNote_8wekyb3d8bbwe!microsoft.onenoteim" /> <start:Tile Size="1x1" Column="5" Row="0" AppUserModelID="Microsoft.SkypeApp_kzf8qxf38zg5c!App" /> <start:Tile Size="1x1" Column="0" Row="0" AppUserModelID="microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.calendar" /> </start:Group> </defaultlayout:StartLayout> </StartLayoutCollection> </DefaultLayoutOverride> </LayoutModificationTemplate> Thanks for your support ! Cheers !
