What is synchonized
From Uni to Smartdok: Orders, Projects, Machines, Employees, Departments.
From Smartdok to Uni: Hours.
The synchronization settings
WageCode for machine hours
Machine hours should be imported with a particular wagecode, which needs to be created before synchonizing any hour.
Then, all machine hours will be added in addition to the normal hours (these ones will be imported with the correct timeart).
A machine should have “Maskintimer” varetype, so that the hours will be correctly imported.
Ignore machine hours
Machine hours can be ignored; it is not a standard setting, but you may want to get only normal hours.
Add from/to in machine hours
The hours will have the same fron/to datetime as the hours it is registered on. but the amount of hours will still be only the machine hours amount. So if you modify from or to afterwards in timereg, the amount will be reinitialized.
Inv. hours = amount – machine hours
If this option is checked, the invoiceable hours will be recalculated as total hours – machine hours. If it is not checked, it will be total hours (and the machine hours won’t be substracted).
Dimensions for department and work description
When importing the hours from Smartdok, we are getting department and work description. If nothing is selected here, these values won’t be imported. If you want to get them (for exmaple to get the departments as Dim2), it should be selected before the sync.
By default, the orders won’t be synchonized. Each order should be checked if you want it to be synchonized.
If you want all orders to be synchonized, you can run this request in sql-browser. “9” should be replaced by the client name (uni_9, unit_9)
insert into unit_9..SmartdokOrderActive (OrderRef, SyncActive, syncdate, LastEdit)
(select o1.Ordrenr, 0, DateAdd(month,-1,getdate()), getdate() from uni_9..ORDRE o1 where not exists( select * from unit_9..SmartdokOrderActive smo1 where smo1.OrderRef=o1.Ordrenr))
Hours will be created in Smartdok. If you want them to be synchonized, you should first get them attested. If they are only added by an employee without being attested by an administrator, they won’t be synchronized.
The errors which are modified in Smartdok after they have been sent, won’t be modified in Uni. Once the hours are synchonized, they are “marked as exported” and should be set in both places if necessary.
A file is missing (message containing”Could not load file or assembly”)
In this case, the first thing to do is to download again the last version of the sync framework and to install it or repair it (depending on the option). If it doesn’t run, make sure everything is closed (timereg and the sync)
Invalid length of a Base-64 char array or string
This not-very-clear message actually means that the username/password is wrong in the synchonization settings.
It could be that your user has been unactivated in Smartdok, or doesn’t have administrator rights anymore. This can be checked with Smartdok directly.
0 rows have been imported
If not all rows have been imported, you can check why in the importer.
If not all records appear in the importer.
select * from unit_9..Import_TransMain where status<>0 and status <>1
This is the request for checking the record which have not been imported, and are not showing in the list. If the status is -3, it means that they have been ignored.