One drive for Business Office 2016 Windows 10 - Syncing sticks. Syncing to sharepoint sticks. Cannot sync to onedrive or sharepoint. Use the Easy Fix Tool

Backup all your data to another folder, you're going to lose everything in the current sharepoint and onedrive folders.

Run this tool.
https://support.microsoft.com/en-us/kb/3038627

When entering the username and password to login to sharepoint, click on the password field and press enter.
Sometimes the "Sign In" button sticks, and doesn't let you click it.

Try this one as well
https://support.microsoft.com/en-us/kb/2933738

Dynamics SL - Tables

• https://mbs.microsoft.com/partnersource/global/deployment/documentation/how-to-articles/MSDYN_ReportAssistantsSL2011
• 
  
• Accounts
• Account
• SubAcct
• vs_acctsub (view)
• AcctHist - Account transaction history
• select distinct acct, sub, fiscyr from accthist
  where fiscyr >= 2012
• Vendors
• Vendor
• Class - VendClass
• Vendor Balances
• vr_03680VendorDetail (view)
• Purchasing
• PurchOrd - PO Hdr
• PurOrdDet - PO Lines
• PORct - Receipts
• POTran - Receipt Lines
• Customers
• Customer
• Class - CustClass
• Items
• Inventory
• Units of Measure - INUnit
• Sites - Site
• Item Class - ProductClass
• Item Qty - Location
• Bins - vp_DfltSiteBins
• Item Prices - Inventory

SQL Server 2014 - White circle instead of green arrow in server instance and SQL Server Agent

The Green arrow shows the state of the service as "Running"
If it shows a white circle, this is because you don't have enough priveleges to see the status of the service.
Right click and Run Management Studio as Administrator.
This should resolve this issue.

eOne Smartconnect - Invalid object name ‘SC9400’

This error occurs if you haven't created the GP resource cache.

• Install the SmartConnect GP Addin 2015 (It's a separate file in the installer)
• This will add the cnk file to the GP folder
• Launch GP, include code
• GP>Tools>Smartconnect>GP Resource Cache
• After it completes, Launch Smartconnect
• Setup the GP connector
• Run maintenance

Dynamics NAV - CAL Comments

Use "//" to insert a single line comment. When the "//" symbol is encountered in your code, the rest of the line is interpreted as a comment.

Use "{" and "}" to mark the beginning and end, respectively, of a block of comments.

Excel - CSV files do not open correctly delimited

https://kb.paessler.com/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this

This happens because the regional settings of the machine is set to use the ; as the default delimiter instead of ,

Solution: Change the Regional and Language settings  

• go to Start | Control Panel | Regional and Language Options
• Click Additional Settings
• For Decimal Symbol, enter a dot: .
• For List Separator, enter a comma: ,

OR

Add an extra line to your CSV file to tell Excel what the separator is.
Add the following line to the top of your CSV file:

sep=,

Connect to Jantek - Visual Foxpro ODBC and import data to Excel, Access or SQL

• I ended up using the following steps to move data from FoxPro to SQL
• Excel 2013 32-bit using Microsoft query Advanced ODBC connection using the FoxPro 32-bit ODBC driver
• Set the connections to automatically refresh
• Installed Microsoft Data Access Components 64-bit using /passive to get both drivers on the machine
• Read data into sql using
• SELECT * FROM OPENROWSET ( 'Microsoft.ACE.OLEDB.12.0',
  'Excel 12.0; Database=C:\JantekLink\janteklink32.xlsx;HDR=Yes', 'Select * from [EMP$]' )
• Setup System Scheduler to launch the excel sheet and close it
• Setup system scheduler to run a script to read the updated data from the sheet into sql

Notes on Connecting to Foxpro

• Cannot connect as linked server if using 64-Bit SQL (FoxPro is 32-bit)
• This method only works if connecting to 32-bit BQL.
• Use Visual FoxPro OLE DB Driver to connect (ODBC has been replaced, however, the ODBC still works to connect to the table sources)
• https://msdn.microsoft.com/en-us/vfoxpro/bb190232

http://serverfault.com/questions/361226/how-to-successfully-connect-to-foxpro-database-files-using-mssql-linked-server-f


Use Sybase Anywhere 64-bit ODBC driver
https://www.progress.com/download?interface=odbc&ds=sybase&os=win-64

Install 32-Bit office AND 64-bit Data Access Components in /passive mode and use an Access Database or Excel sheet as an intermediary between FoxPro and SQL.

Jantek Folder Structure - Visual FoxPro Tables - Free Tables

Jantek Database Folder - Free Tables
\DBF.JTA\EMPCLOCK.DBF - employees site assignments
\DBF.JTA\AUTOLOG.DBF - system data transfer log
\DBF.JTA\TIME.DBF -  clockin/out transactions
\DBF.JTA\Payroll.DBF -  approved payroll

Jantek Databases - FoxPro databases
\DBF\Company.dbf - Companies
\DBF\Branch.dbf - Branches
\DBF\Emp.dbf -Employees