Month: July 2024
date format getting changed from yyyy-mm-dd hh:mm:ss:fff to dd-mm-yyyy hh:mm
Hi All,
I am trying to export data from sql server database to csv. data is getting export perfectly in csv file but date format is getting from “yyyy-mm-dd hh:mm:ss:fff” to “dd-mm-yyyy hh:mm”.
please help to correct it
Appreciate quick response.
# Define database connection details
$server = “YourServerName”
$database = “YourDatabaseName”
$username = “YourUsername”
# Retrieve and decrypt the password
$encryptedPassword = Get-Content “C:pathtoencryptedPassword.txt” | ConvertTo-SecureString
$credentials = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $username, $encryptedPassword
# SQL query
$query = “
SELECT *
FROM YourTable
“
$data = Invoke-Sqlcmd -ServerInstance $server -Database $database -Credential $credentials -Query $query
$data | Export-Csv -Path “C:pathtoyouroutput.csv” -NoTypeInformation -Encoding UTF8
Write-Host “Data exported successfully to C:pathtoyouroutput.csv”
Hi All, I am trying to export data from sql server database to csv. data is getting export perfectly in csv file but date format is getting from “yyyy-mm-dd hh:mm:ss:fff” to “dd-mm-yyyy hh:mm”.please help to correct it Appreciate quick response. # Define database connection details$server = “YourServerName”$database = “YourDatabaseName”$username = “YourUsername”# Retrieve and decrypt the password$encryptedPassword = Get-Content “C:pathtoencryptedPassword.txt” | ConvertTo-SecureString$credentials = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $username, $encryptedPassword# SQL query$query = “SELECT *FROM YourTable”$data = Invoke-Sqlcmd -ServerInstance $server -Database $database -Credential $credentials -Query $query$data | Export-Csv -Path “C:pathtoyouroutput.csv” -NoTypeInformation -Encoding UTF8Write-Host “Data exported successfully to C:pathtoyouroutput.csv” Read More
Index and Match Function
Hello all,
I’m taking a intro to underwriting course and I’m stuck on the Index and Match function
This is the same exact formula that shown in the course but for some reason my excel does not accept it
=INDEX(F3:M8,MATCH(A7,E3:E8,0)MATCH(B7,F2:M2,0))
Excel Suggests a new formula with the * before the second MATCH as shown bellow
=INDEX(F3:M8,MATCH(A7,E3:E8,0)*MATCH(B7,F2:M2,0))
Does anyone have any feedback or can point me in the right direction? Thank you!!!
Hello all, I’m taking a intro to underwriting course and I’m stuck on the Index and Match function This is the same exact formula that shown in the course but for some reason my excel does not accept it=INDEX(F3:M8,MATCH(A7,E3:E8,0)MATCH(B7,F2:M2,0)) Excel Suggests a new formula with the * before the second MATCH as shown bellow=INDEX(F3:M8,MATCH(A7,E3:E8,0)*MATCH(B7,F2:M2,0)) Does anyone have any feedback or can point me in the right direction? Thank you!!! Read More
Custom in-app notifications for updates to Loop tables
Hello, Microsoft 365 Insiders,
Earlier this year, we enabled process automation for Loop tables. Many of you have embraced this new capability and encouraged us to innovate further in this area.
Our latest update introduces custom in-app notifications for updates to Loop tables and table templates! In our quest to extend these capabilities to all our users, we’re excited to share that you can now activate in-app notifications to keep your team updated, even without a Power Automate license.
Check out our latest blog by Tanvi Sharma, Product Manager on the Loop team, for a detailed walkthrough of setting up and using these enhancements.
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hello, Microsoft 365 Insiders,
Earlier this year, we enabled process automation for Loop tables. Many of you have embraced this new capability and encouraged us to innovate further in this area.
Our latest update introduces custom in-app notifications for updates to Loop tables and table templates! In our quest to extend these capabilities to all our users, we’re excited to share that you can now activate in-app notifications to keep your team updated, even without a Power Automate license.
Check out our latest blog by Tanvi Sharma, Product Manager on the Loop team, for a detailed walkthrough of setting up and using these enhancements.
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
xbox app won’t run and won’t uninstall
I am an Xbox game pass user and I had a lot of games on my hard disk drive but it needed maintenance so I unplugged it and plugged it back in but now the Xbox app doesn’t work for some reason, I wanted to uninstall it but I couldn’t find it in the “installed apps” section of the settings and I tried to click “uninstall” in the start menu but it just stays there, I tried to force uninstall it using Revo uninstaller but it did nothing I used the gaming repair tool but it wasn’t running either, and when I try to run a game it says I “don’t have gaming services”. it’s really messing with me, I don’t even want to use this app anymore due to how bugged it is.
I am an Xbox game pass user and I had a lot of games on my hard disk drive but it needed maintenance so I unplugged it and plugged it back in but now the Xbox app doesn’t work for some reason, I wanted to uninstall it but I couldn’t find it in the “installed apps” section of the settings and I tried to click “uninstall” in the start menu but it just stays there, I tried to force uninstall it using Revo uninstaller but it did nothing I used the gaming repair tool but it wasn’t running either, and when I try to run a game it says I “don’t have gaming services”. it’s really messing with me, I don’t even want to use this app anymore due to how bugged it is. Read More
Quick–B00ks Error C 224
Could someone please help me understand what Quick..B00k Error C 224 means and how to resolve it?
Could someone please help me understand what Quick..B00k Error C 224 means and how to resolve it? Read More
Q-B Error 179: How to Get Support and Troubleshooting Tips
Q.B Error 179 occurs when users encounter banking issues. It blocks access, causing login failures and data discrepancies. Troubleshooting involves verifying credentials and resolving connectivity problems.
Q.B Error 179 occurs when users encounter banking issues. It blocks access, causing login failures and data discrepancies. Troubleshooting involves verifying credentials and resolving connectivity problems. Read More
Quick.B00ks Crash When Opening Company File
Hi everyone,
I’m experiencing a frustrating issue with Quick..B00ks where it crashes every time I try to open my company file. As soon as I select the file and attempt to open it, Quick.B00ks shuts down unexpectedly without any error message.
Hi everyone,I’m experiencing a frustrating issue with Quick..B00ks where it crashes every time I try to open my company file. As soon as I select the file and attempt to open it, Quick.B00ks shuts down unexpectedly without any error message. Read More
Quick_Books Error 6069: How to Get Support and Fix the Issue
Quick-Books Error 6069 occurs due to file or data corruption. Get support via Q-B customer service, community forums, or professional assistance for effective solutions.
Quick-Books Error 6069 occurs due to file or data corruption. Get support via Q-B customer service, community forums, or professional assistance for effective solutions. Read More
Figma Variables and new components available (v3.0.0) in the SharePoint Web UI Kit
Our SharePoint Web UI Kit in Figma has been updated with some great new additions! This update includes the exciting addition of Figma Variables and more components so you have more options when designing your SharePoint sites and pages.
What’s new in v3.0.0
Introduced Figma Variables for color, size, spacing, corner radius, and stroke width
Added new components: Site activity web part, Content pane
What’s updated in v3.0.0
Themes and background colors can now be switched using modes
Removed dark background variants from all components
Re-factored components and bug fixes
Updated documentation on using Figma Variables effectively
To get started with our updated UI kit, simply download the latest version from the Figma Microsoft Community website: SharePoint Web UI Kit – Figma.
Also, in case you missed it, watch our “Introduction to the SharePoint Web UI Kit” video on YouTube to watch a demo walking through how to use the SharePoint Web UI Kit yourself.
Why use the Figma SharePoint Web UI kit?
Figma is a subscription-based application that is the industry standard tool for web design. It provides an alternative to designing sites and pages outside of SharePoint. Figma does not build the pages in SharePoint, so once you finalize a design in Figma, you will need to build it in SharePoint. You should evaluate if Figma is the right solution for mocking up sites and pages for SharePoint.
Design without organizational limitations
This UI kit provides SharePoint users with another tool in their toolbox. While building a page in SharePoint is easy, we wanted to provide the ability to mockup sites and pages. It allows you to explore different design options for your site without the limitation of admin privileges and tenant restrictions, and doesn’t expose organization data.
Figma mockups provide a quick snapshot of SharePoint updates which business stakeholders can use to plan and make decisions. They can provide appropriate requirements and use this UI kit in collaboration with their design team to iterate in the life cycle of your organization’s intranet.
Share designs with ease
This UI kit provides you with page layouts and a selection of web parts to allow you to mockup and share new ideas across organizations and companies. Figma gives you the flexibility of reviewing and sharing your designs without having to spend time and resources creating it in SharePoint. Figma also allows you to download your designs into easy-to-use formats that can be used in documentation and presentations.
Learn more at https://www.figma.com/
Community feedback
Please tell us what’s missing, what doesn’t work for you, and where your biggest challenges are by leaving a comment on the Figma SharePoint Web UI kit page or by visiting the SharePoint Community.
We hope you enjoy our latest update and look forward to seeing what you create with it!
Microsoft Tech Community – Latest Blogs –Read More
Copilot for Microsoft 365 now supports Traditional Chinese
In our Tech Community blog dated April 29th, 2024 we announced 16 new supported languages for Copilot for Microsoft 365. We also announced the availability of Traditional Chinese but stopped short of offering full support while we worked out some known issues. Today, we’re pleased to announce that traditional Chinese now meets our quality standards and we are formally adding it to the list of supported languages.
Administrators and users are not required to take any actions to use Traditional Chinese with Copilot for Microsoft 365. We are continuously refining responses in every language we support and are looking forward to adding support for even more languages in the coming months.
Did you know? The Microsoft 365 Roadmap is where you can get the latest updates on productivity apps and intelligent cloud services. Check back regularly to see what features are in development or coming soon
Microsoft Tech Community – Latest Blogs –Read More
Are Flooded Evaporators modeled already?
Is there a block ready to be used to model a shell and tube flooded evaporator using Ammonia as a refrigerant?Is there a block ready to be used to model a shell and tube flooded evaporator using Ammonia as a refrigerant? Is there a block ready to be used to model a shell and tube flooded evaporator using Ammonia as a refrigerant? heat-transfer, evaporators, simulink, fluids MATLAB Answers — New Questions
Prohibited names in discussions
I tried to answer on related to Excel and <Q…B> question, but answer is blocked with
Any other companies/products we can’t mention here?
I tried to answer on related to Excel and <Q…B> question, but answer is blocked with
Any other companies/products we can’t mention here?
Read More
Auto populate trendline variables into specified spreadsheet cells
I’ve created a couple of graphs and created trendlines to determine R^2, slope and intersect values. Is there a way of automatically transcribing those values into defined spreadsheet cells rather than manually doing it?
I’ve created a couple of graphs and created trendlines to determine R^2, slope and intersect values. Is there a way of automatically transcribing those values into defined spreadsheet cells rather than manually doing it? Read More
LookUp column shows up as [object Object] for single column in board view
Hi,
I have seen similar questions from this topic, but I couldn’t really apply to my problem.
I have a SharePoint list which one of the lookup columns retrieves data from another list.
This new column [Evaluated Property] allows multiple selection from the LookUp column it originates from.
When viewed in list mode, the multiple selection LookUp columns results are visible (1st picture).
However, when I create a board view, I get [object Object],[object Object].
I figure from other threads here in the discussion group that this can be solved using a JSON custom formatting. However, this did not seem to work. I am unsure how should I do this formatting since I am not familiar with JSON coding.
Did anyone face this same issue and could suggest me how to handle this?
Regards,
Lucca
Hi, I have seen similar questions from this topic, but I couldn’t really apply to my problem. I have a SharePoint list which one of the lookup columns retrieves data from another list. This new column [Evaluated Property] allows multiple selection from the LookUp column it originates from. When viewed in list mode, the multiple selection LookUp columns results are visible (1st picture). However, when I create a board view, I get [object Object],[object Object]. I figure from other threads here in the discussion group that this can be solved using a JSON custom formatting. However, this did not seem to work. I am unsure how should I do this formatting since I am not familiar with JSON coding. Did anyone face this same issue and could suggest me how to handle this? Regards, Lucca Read More
Exchange Hybrid Configuration Wizard error – root element is missing when connecting to 365
Hi Exchange Brain trust,
I have an Exchange 2016 environment where I recently joined a Exchange 2019 server to move everything and eventually decommission 2016 server. Everything is configured manually to match what we currently have in 2016 server – configuration wise, they both are identical now. We don’t have any mailbox on-prem. Its just being used for administration and SMTP relay.
The question is, do we still have to run Hybrid Config Wizard ? The reason I’m asking is, I’m stuck on the following stage with an error I pulled my hair off for hours trying to figure the root cause. Connectivity is all working well.
Any idea would be really appreciated !
Hi Exchange Brain trust, I have an Exchange 2016 environment where I recently joined a Exchange 2019 server to move everything and eventually decommission 2016 server. Everything is configured manually to match what we currently have in 2016 server – configuration wise, they both are identical now. We don’t have any mailbox on-prem. Its just being used for administration and SMTP relay. The question is, do we still have to run Hybrid Config Wizard ? The reason I’m asking is, I’m stuck on the following stage with an error I pulled my hair off for hours trying to figure the root cause. Connectivity is all working well. Any idea would be really appreciated ! Read More
What do sign-in logs to Azure AD Identity Governance – Entitlement Management tell me
BLUF: I’m seeing a few user accounts (members and guests) that are showing up in sign in activity to Azure AD Identity Governance – Entitlement Management…but most other user accounts (members and guests) do not show up with sign-ins against that app, why would I be seeing sign-in logs for that, and what exactly am I seeing?
We have about 50 internal users (members) and 500 external users (guests)…out of those typical sign-ins I mostly see then within the apps that they are utilizing, however there are a few user accounts (members and guests) where I’m seeing sign-in logs specifically to the application name = Azure AD Identity Governance – Entitlement Management. We do have 100+ apps in which we have setup access packages for external users, but I haven’t seen any other sign in activity to apps that they haven’t been given permission to access, this seemed to have started around first of June 2024. I’m just curious as to what I’m actually seeing when I see a user sign-in log showing up for Application = Azure AD Identity Governance – Entitlement Management.
BLUF: I’m seeing a few user accounts (members and guests) that are showing up in sign in activity to Azure AD Identity Governance – Entitlement Management…but most other user accounts (members and guests) do not show up with sign-ins against that app, why would I be seeing sign-in logs for that, and what exactly am I seeing? We have about 50 internal users (members) and 500 external users (guests)…out of those typical sign-ins I mostly see then within the apps that they are utilizing, however there are a few user accounts (members and guests) where I’m seeing sign-in logs specifically to the application name = Azure AD Identity Governance – Entitlement Management. We do have 100+ apps in which we have setup access packages for external users, but I haven’t seen any other sign in activity to apps that they haven’t been given permission to access, this seemed to have started around first of June 2024. I’m just curious as to what I’m actually seeing when I see a user sign-in log showing up for Application = Azure AD Identity Governance – Entitlement Management. Read More
Quick,B00ks Error R6025 – How to Resolve?
I’ve encountered Quick-Books Error R6025 recently and I’m not sure how to fix it. It happens randomly when I’m working in Q-B Desktop. What does this error mean, and what steps can I take to resolve it? Any insights or suggestions would be greatly appreciated!
I’ve encountered Quick-Books Error R6025 recently and I’m not sure how to fix it. It happens randomly when I’m working in Q-B Desktop. What does this error mean, and what steps can I take to resolve it? Any insights or suggestions would be greatly appreciated! Read More
Quick-B00ks Error 163 – Need Assistance to Resolve
I’ve encountered Quick-Books Error 163 while trying to [describe the specific action or task you were performing]. Can someone please explain what this error means and provide guidance on how to resolve it? Any help would be greatly appreciated!
I’ve encountered Quick-Books Error 163 while trying to [describe the specific action or task you were performing]. Can someone please explain what this error means and provide guidance on how to resolve it? Any help would be greatly appreciated! Read More