Clock time report

Hi Guy’s i have set up a clock in and out system … working perfect
i can only report on 1 employee at a time.

when i followed the steps given and did the up date system set up a report to show only the current employees

[#Punch Editor:1,1, 1,48,48, 1, 1]

Date|Day|Hours|START|END|ID|Status
@@EmployeeHoursDailyPEOriginal:Employee,Boby

can someone please help me code the report so that as employees are added that the report will pick them up by its self… to include all employees as they are added

That is the Punch Editor Report. It is designed to only show 1 Employee at a time so that you can edit their clock in/out times. You should not be using that Report for Employee hours.

Which Tutorial did you implement?

lol i cannot seem to find find it now …
it was the one that you downloaded an up date … ill try to find it , but now i seem to have a bigger problem all of a sudden after backing up i am getting a restart error. I have tried re- installing as still the same thing


i have no idea what went wrong

The error is not overly informing. For error on start it’s usually install issue, connection string issue or application start automation issue.
Connection string typically throws specific message suggesting one of the other two.
Reinstalling doesn’t solve many issues unless issue with program files themselves as most settings are in the db.
You could try removing the settings file in program settings and resetting connection string and seeing where the issue comes back.

Post the content of the log file:

[Documents]\SambaPOS5\log.txt

Inner Exception 2
Type: System.Data.SqlClient.SqlException
Message: Cannot open database “HATTECH POS Evolution” requested by the login. The login failed.
Login failed for user ‘User\Chaseten Westphal’.
Source: .Net SqlClient Data Provider
Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.b__36(DbConnection t, DbConnectionInterceptionContext c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action2 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.EntityConnection.b__2()
at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Action operation)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()


[Assembly Info]

mscorlib, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
PresentationFramework, Version=4.0.0.0
Samba.Services, Version=1.0.0.0
System.Configuration, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
Samba.Presentation.Common, Version=1.0.0.0
Samba.Domain, Version=1.0.0.0
System, Version=4.0.0.0
PresentationCore, Version=4.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
System.Core, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.13.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Localization, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
FastButton, Version=1.0.0.0


[System Info]

Operating System
-Microsoft Windows 8.1 Pro
–CodeSet = 1252
–CSDVersion =
–CurrentTimeZone = 120
–FreePhysicalMemory = 926880
–OSArchitecture = 32-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 0
–ServicePackMinorVersion = 0
–Version = 6.3.9600

Machine
-USER
–Manufacturer = Sony Corporation
–Model = VGN-S58GP_B
–TotalPhysicalMemory = 2145570816
–UserName = User\Chaseten Westphal


######################### E N D #########################

[General Info]

Application: SambaPOS
Version: 5.1.62
Region: en
DB: SQ
Machine: USER
User: Chaseten Westphal
Date: 29-Sep-17
Time: 3:22 AM

User Explanation:

Chaseten Westphal said “”

[Exception Info 1]

Top-level Exception
Type: System.Data.DataException
Message: An exception occurred while initializing the database. See the InnerException for details.
Source: EntityFramework
Stack Trace: at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
at System.Data.Entity.Internal.LazyInternalContext.b__4(InternalContext c)
at System.Data.Entity.Internal.RetryAction1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action1 action)
at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
at Samba.Infrastructure.Data.SqlData.EFWorkspace…ctor(CommonDbContext context)
at Samba.Persistance.Data.WorkspaceFactory.Create()
at Samba.Presentation.Services.Common.DataGeneration.DataCreationService.get_Workspace()
at Samba.Presentation.Services.Common.DataGeneration.DataCreationService.ShouldCreateData()
at Samba.Presentation.Services.Common.DataGeneration.DataCreationService.CreateData()
at Samba.Presentation.Bootstrapper.InitializeShell()

Inner Exception 1
Type: System.Data.Entity.Core.EntityException
Message: The underlying provider failed on Open.
Source: EntityFramework
Stack Trace: at System.Data.Entity.Core.EntityClient.EntityConnection.Open()
at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions)
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass651.b__63()
at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryReliably[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, Object[] parameters) at Samba.Persistance.Data.Initializer.InitializeDatabase(DataContext context) at System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf1.b__e()
at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)

Inner Exception 2
Type: System.Data.SqlClient.SqlException
Message: Cannot open database “HATTECH POS Evolution” requested by the login. The login failed.
Login failed for user ‘User\Chaseten Westphal’.
Source: .Net SqlClient Data Provider
Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.b__36(DbConnection t, DbConnectionInterceptionContext c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action2 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed)
at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.EntityConnection.b__2()
at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Action operation)
at System.Data.Entity.Core.EntityClient.EntityConnection.Open()


[Assembly Info]

mscorlib, Version=4.0.0.0
WindowsBase, Version=4.0.0.0
PresentationFramework, Version=4.0.0.0
Samba.Services, Version=1.0.0.0
System.Configuration, Version=4.0.0.0
System.Xaml, Version=4.0.0.0
Microsoft.Practices.Prism.MefExtensions, Version=4.0.0.0
Samba.Presentation.Services, Version=1.0.0.0
Samba.Presentation.Common, Version=1.0.0.0
Samba.Domain, Version=1.0.0.0
System, Version=4.0.0.0
PresentationCore, Version=4.0.0.0
Microsoft.Practices.Prism, Version=4.0.0.0
System.ComponentModel.Composition, Version=4.0.0.0
System.Core, Version=4.0.0.0
Samba.Infrastructure, Version=1.0.0.0
DevExpress.Xpf.Core.v14.1, Version=14.1.13.0
Microsoft.Practices.ServiceLocation, Version=1.0.0.0
Samba.Localization, Version=1.0.0.0
Samba.Persistance, Version=1.0.0.0
FastButton, Version=1.0.0.0


[System Info]

Operating System
-Microsoft Windows 8.1 Pro
–CodeSet = 1252
–CSDVersion =
–CurrentTimeZone = 120
–FreePhysicalMemory = 763760
–OSArchitecture = 32-bit
–OSLanguage = 1033
–ServicePackMajorVersion = 0
–ServicePackMinorVersion = 0
–Version = 6.3.9600

Machine
-USER
–Manufacturer = Sony Corporation
–Model = VGN-S58GP_B
–TotalPhysicalMemory = 2145570816
–UserName = User\Chaseten Westphal


######################### E N D #########################

Inner Exception 2
Type: System.Data.SqlClient.SqlException
Message: Cannot open database “HATTECH POS Evolution” requested by the login. The login failed.
Login failed for user ‘User\Chaseten Westphal’.

There is your answer. You are using Windows Authentication on the DB and the user does not have access to Login. You should be using SQL Auth instead (ie. the “sa” account)

You should contact HATTECH for further support since they stole SambaPOS and are selling it as if it is their own creation. Either get support from them (it’s the least they can do), or get your money back. @Tayfun

3 Likes

He is from Hattech. See wallpaper from his screenshot.

@Brett_Westphal, maybe you should clarify that how you get your company name on Samba POS software? If you get special version direct from Samba POS?

I am sorry then I refuse to give someone like that help. He should pay me for every ounce of help I give on here. He should also pay you guys. Furthermore I want my name listed on his website as a contributor and their names taken off as creators of Hattech.

4 Likes

A lot of ppl oversold their ability (get paid setting up system) and always come here asking for free support even ask step by step with screenshot and URGENT please help me my client opening tomorrow.

Kendash, QMcKay, JTR and lot more ppl here still help out and don’t get a penny. I agree putting your company name in the software is too extreme.

People overselling there services as a reseller especially if they have been listed as official reseller given the gumpf on samba site about becoming reseller is bad enough.
To rebrand samba and still expect support here for ‘your own software’ according to your website is propper taking the piss…
I think all licences on hatacks account should be recinded personally for clear violation of terms and taken of reseller page if not already.

1 Like

Just visit SambaPOS.com no Hattech as reseller on SambaPOS.com. I heard Tayfun said he know Hattech. I was thinking maybe they compile a special version for them.

Now I think SambaPOS should take more aggressive action and get new reseller in that city/country and all license has to go thru new reseller.

Maybe Hattech already bypass the license check :confounded:

That was my first thought, if the program has been recompiled I doubt the licence system is hugely syfisticated…
Know them or not, if the rebrand is official - those of us who support the comunity and can actually use the software unlike this person should be offered something, at least we are supporting them via the software on top of extra licence sales etc.
Without this forum samba would not be what it is I would sayZ

I Am not from HATTECH i bought the software from them … Hattech dose not exist anymore that is why i am looking for support here

Omg really. …
https://www.linkedin.com/today/author/brett-westphal-940992143?trk=prof-sm

1 Like

Sales Manager at Hatteck lol busted…

1 Like

Amazing!!! Sniff Sniff hmmmmmmm whats that smell???

Oh yea Bull S**t!!

Might all be coincidence but what are the real chances of you having the same forum name as the sales manager of this company… Pretty slim if your honest.
It’s a tad annoying you couldn’t come up with a better explanation… Hattechs website which is still live says they offer franchise so a bit of thought and you could have said you were franchise person or hell you could have even said you used to work for them as sales manager and a friend who was a customer asked for your help but you went with cold faced lie.
Hay each to their own but then again the company you represent recompiled and rebranded Samba calling it their own so I guess it’s no big issue baring false witness…
You might not be the one who made the call on what was done but the majority of the people on this forum are loyal samba users, some of us resellers through legitimate channels so were you really expecting different reactions…
Think it’s time to come clean personally but not holding my breath.

1 Like

Wow what a massive count

-o