Tag: 2016

SHAREPOINT SERVER 2016 and UBUNTU

I have a computer running Windows Server, and I can access that Windows server from another computer running the Windows operating system using the Firefox browser.
When I try to access it from another computer with the UBUNTU operating system and Firefox browser, I can not do that.
Does anyone know where the problem lies?
Many Thanks

Microsoft Word 2016 – VBA file "Paste" without contents of the content controls from the source document

I have a VBA form for Word 2016. In this & # 39; main document & # 39; can I select other Word documents to insert at the cursor position in my document. The documents contain associated content controls. When inserted in this way, the content controls are empty. When I copy and paste the contents of the files, they are transmitted correctly (and the associated content in the main document is then updated with the transmitted information).

Is there a solution to this problem or another way?

Below is the code to paste the files.

If Me.lstSelectedFiles.ListCount> 0 then
& # 39; browse selected files
For i = 0 To Me.lstSelectedFiles.ListCount - 1
Selection.InsertFile filename: = Me.lblFilePath.Caption & "" & Me.lstSelectedFiles.List (i), Range: = "", _
ConfirmConversions: = False, Link: = False, Attachment: = False
Next
Selection.TypeBackspace removes the last page break
Otherwise
MsgBox "You must add at least one file to the selected file list", vbCritical
When
Unload me

End Sub

Reading DynamicValue Keys Within a Loop in SharePoint 2016 Visual Studio Workflow

I am trying to create custom workflow activities in Visual Studio for SharePoint 2016. Custom activities should send emails based on templates. I pass the values ​​you want to replace in the template by using DynamicValue in key-value format. For example, the loaded template will display # FIRSTNAME #, and I will pass the key value DynamicValue FirstName: John. I can easily drag the dynamic value and use the GetDynamicValue property to get John. My problem is how to know the key FirstName at all.
I tried to use a dictionary instead of a dynamic value, but in SharePoint Designer, I only associate custom properties with parameters of type DynamicValue.

E-Mail – E-Mail from Windows Server 2016 blocked, but not since 2008

Good Morning:

I'm executing exactly the same script from two different virtual machines:

  • The first in Windows Server 2008 R2
  • The second in Windows Server 2016

properties

  • The SMTP is an external service of hosting (BlueHost)
  • The script does not generate an error
  • The mail comes in both cases to internal addresses (from BlueHost)
  • The mail does not reach external addresses (like Gmail) in the second case (Win 2016)
  • Both VMs run on the same desktop
  • Both VMs have antivirus and firewall disabled

I am looking for help to understand where the problem lies. I think there are some weird configurations in Windows 2016 that cause BlueHost to block them or Gmail not get them.

I've tried many things, but I've reached a very strange point where I do not understand what's going on.

This is the script I use for testing only for testing purposes. Because the same error is generated by sending the e-mail from SQL Server Databasemail.

$ EmailTo = "blabla@gmail.com"
$ EmailFrom = "blabla@mydomain.com.ar"
$ Subject = "Test a"
$ Body = "Test Body"
$ SMTPServer = "mail.mydomain.com.ar"
$ SMTPMessage = New-Object System.Net.Mail.MailMessage ($ EmailFrom, $ EmailTo, $ Subject, $ Body)
$ SMTPClient = New-Object Net.Mail.SmtpClient ($ SmtpServer, 26)
$ SMTPClient.EnableSsl = $ false
$ SMTPClient.Credentials = New-Object System.Net.NetworkCredential ("blabla@mydomain.com.ar", "pass");
$ SMTPClient.Send ($ SMTPMessage)

Any help? Thanks for now!

MS SQL Server Migration 2008 -> 2016

Gurus –

I was recently asked to do an analysis of what is required to complete the migration / upgrade from On-Prem MS SQL Server 2008 to 2016.

I googled around but did not find much. Can someone please share a few links on where to start or to point items that can help me in the right direction.

Any help, even the smallest, is appreciated.

Thanks again
T K

Can I use SPFx 1.7 with Sharepoint 2016 Feature Pack 2, which has been updated to the latest patch for January 2019?

We have an on-prem Sharepoint 2016 server that keeps up to date with the latest security and feature updates and patches.

We would like to create a client application SPFX Web Partsespecially interested in React,
When I use the current skeleton generator (1.7), it asks if I want to aim Sharepoint 2016 and further, along with 2019 continue and just On-line,

If we choose the Sharepoint 2016 option, we get Reaction 15.4 along with "@ microsoft / sp" libraries locked to 1.1.x.

If we choose option 2019 forward, we get Reaction 16.3 together with "@ microsoft / sp" libraries locked to 1.7.x.

I want the latest React features like that Context API etc. When you create these Web Parts, you can deploy the solution you created with them 2019 Next option on Sharepoint 2016 ?

If not, can I update my React version in package.json to 16+ while selecting the Sharepoint 2016 framework option? I understand that I have seen libraries "@ microsoft / sp" and "@ microsoft / sp-office-ui-fabric-core" that help you use the React available in your application when you create Web Parts. Do not really know if they would break.

Has anyone tried this?

SharePoint 2016 – Error with the add-in for Word 2016

I would set the logging level of the trace log to detail and reproduce the error when running ULS Viewer.

Somewhere you'll find that SharePoint tells Word that this mysterious feature is not supported. And with this message from the ULS protocol, the community can certainly help you better 🙂

I documented the search for the ULS protocol in my blog some time ago: https://engineerer.ch/2019/01/04/how-to-find-errors-in-the-sharepoint-uls-log/

Problems using Office365 Sharepoint Lists as backend for MS Access 2016

I'm new to Sharepoint.
I had a rather complex Access 2016 database that had a "backend" access database with 15 tables, an Access Admin frontend with many queries for reporting, and another Access frontend that had a single form for input containing the data by the employees. This form finds two values ​​in the tables and writes the corresponding report data to a third table.

I've migrated all back-end tables to SharePoint lists to make it easier to remove our on-premise file servers and switch to the cloud using OneDrive. Some of these new SharePoint lists are quite large with 20,000 to 40,000 rows. I linked the two front-end access databases to these sharepoint lists, and indexed the key ID columns used to join the various tables.

Now I seem to have two big problems:

1) It seems that only one employee can use the front-end access database at the same time, as if all tables were locked and not just the few lines used.

2) Some users can access only some of their records, but not all, while other users can access the records that the first user can not access.
For example, if I enter the appropriate details in the form, the correct information is displayed as expected.
However, if my colleague gives the same information in the same form, he will receive a blank (not found / not found). However, my colleague can open most of the other form details as usual, so neither his skills nor their permissions in SharePoint are the problem.

This is very problematic and I am completely at a loss

Do you have any thoughts?

Is that too much of Sharepoint to ask, and should I consider a proper SQL server?

Ta

phil

SQL Server – Providing data from the SQL 2016 backup in an Azure database

I have backup data from a SQL 2016 server that I want to move / restore to an Azure database. I do not see an internal option to do this everywhere. So, the best option would seem to be local recovery, creating schema / data scripts for the data, and running the script in the Azure database.

The only problem is that the script I get back is about 4 GB in size. It will not load into SQL Management Studio or Azure's own Query Editor page. When I implement it through SQLCMD, it crashes halfway, with no easy way to figure out where it crashed and how it can be resumed from there.

Is there a good way to do that? I plan to do this several times, so I want to get my methods down. Many Thanks!