How to add Nodes in Smartconnect after Installation.

Smartconnect
-After installation of Smartconnect Application
-Register Smartconnect
-Install GP Smartconnect
-Process Cache in GP Smartconnect
-Then go back into Smartconnect application
-Create GP Connector
-Run System Maintenance

-BOOM! Nodes added!

Integration using stored procedure and smartconnect

So you run your integration file which is using a stored procedure instead of a table.

Then you get error messages in the form of a number. You check Event Viewer and find nothing.

For example '7' or '50997'.

To figure out what this means you have to run the below select statement:

SELECT * FROM DYNAMICS..taErrorCode

Smartconnect Map runs in one company but does not run in another company

So you created a map, run it to test on your test company and it works.

Then you run it on the live company and boom, nothing happens. Smartconnect just counts your records and does not import any.

In your mapping you have a GP Rolling column created. You need to delete it and re-create it with your mapping on the live company (this is defined in the companies window in the front). This will make the rolling column look at the correct company.
Re-run integration and it will work now.

Scheduled Smartconnect map not running automatically only manually

So you have a schedule setup. File in folder ready for running but the file does not import. You look at smartconnect and see the map showing it ran but it didnt.

If you run it manually it works.

So what to do?
Restart eone service and then it will work.

Smartconnect - Collection could not be initialized

So you get the above error and a long string of the fields used in the integration when you try to save the map you created.

To Resolve, export all setups from smartconnect.
Uninistall Smartconnect
Reinstall and 'run as admin'.

All will be fine now.
Trust me ;)