Powered by Jitbit .Net Forum free trial version. dismiss

recent posts recent posts - RSS

29 days ago
Topic:
Unable to login after installation

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Unable to login after installation
Hi, the default user is admin


You should see the first-time password setup screen once you open SQLwallet for the first time.
29 days ago
Topic:
Unable to login after installation

sada
sada
Posts: 1
Hello,

thanks for a making a good product.
I'm not able to login in to the application after installation as I don't which user to login with.
I'm not able to see in any documentation the initial user credentials.
Thanks.
9/17/2018
Topic:
Run / Export to CSV

Ullrich B
Ullrich B
Posts: 5
Works as designed :)
Thank you.
9/14/2018
Topic:
Run / Export to CSV

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Run / Export to CSV
Added in 1.6.0 under Configuration/Customization
8/28/2018
Topic:
Linux Version?

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Linux Version?
Hi, as Oracle recently finally released their Beta provider for .NET core, now we can look into it. Cannot provide an estimate at the moment though, but will keep this thread updated on the progress.
8/28/2018
Topic:
Linux Version?

glenruben
glenruben
Posts: 1
glenruben
glenruben
Posts: 1
Topic: Linux Version?
Hi!
Has there been any updates or progress on this feature?
Running sqlwallet as a docker container would make things a lot easier for us :)
8/26/2018
Topic:
How To Setup Report Parameters

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: How To Setup Report Parameters
Sorry, I am confused. Are you asking about how to create a drop-down parameter, filled with data from field NUMBER from table MATTER?
8/25/2018
Topic:
How To Setup Report Parameters

smccarthy945
smccarthy945
Posts: 2
Hey Gleb, sorry but I am not a smart as you so bear with me on this. I appreciate your time in helping me as I really love this product and want to understand it and get it working. I just need some clarification.

I guess what I am asking so I understand this is the following:

1. What do I put in the two parameter fields for values? numbers?
2. What should the actual SQL statement be? Should it be:
select NUMBERS as Text, NUMBERS as Value from MATTERS order by NUMBERS


If you can tell me what should be in the parameter fields and give me the actual SQL statement, I will understand how this works.

This is my SQL Query if it helps at all:


SELECT
m.Number AS matter,
mot.Timekeeper AS tkprnumber,
t.DisplayName AS tkprname,
mot.Percentage,
m.MattStatus,
m.DisplayName,
m.Client,
Client.DisplayName AS DisplayName1
FROM
Matter m
JOIN MattDate md ON md.MatterLkUp = m.MattIndex
JOIN MattOrgTkpr mot ON mot.MattDate = md.MattDateID
JOIN Timekeeper t ON mot.Timekeeper = t.TkprIndex
INNER JOIN Client ON m.Client = Client.ClientIndex
WHERE
md.NxEndDate >= GetDate()
ORDER BY
matter
8/25/2018
Topic:
How To Setup Report Parameters

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: How To Setup Report Parameters
Hi, for the dynamic dropdowns, the query should return Text and Value columns, i.e.

select NUMBERS as Text, NUMBERS as Value from MATTERS order by NUMBERS.

Hope it helps.
edited by Gleb on 8/25/2018
8/25/2018
Topic:
How To Setup Report Parameters

smccarthy945
smccarthy945
Posts: 2
I cannot figure out how to setup report parameters. I even had one of my employees look at it who is a SQL expert and he was lost as well. We read the FAQ on it. I am trying to setup a drop down that reads from the table called "MATTERS" from the field called "NUMBERS". I want the drop down to display all the NUMBERS from the table MATTERS.

I love this product and am definitely going to purchase it but I need to get the parameters working before I do so. Can you help show me how to setup the parameters to make the drop down work? I greatly appreciate it.

Awesome product by the way! I love it!
8/17/2018
Topic:
"Run set of custom commands" for scheduled reports

Gleb
Gleb
Administrator
Posts: 49
Hi, thank you for your suggestion, we will add this.

In the meantime, here is the quick instruction how to save the report file in c:\backup folder:

1) When creating a schedule, under Action tab select "Run custom commands"
2) In the "Command line" field type powershell
3) In the "Command arguments" field, type c:\scripts\copy.ps1 c:\backup
4) Create file c:\scripts\copy.ps1 with the following content:

Copy-Item $args[1] -Destination $args[0] -Force -Recurse

5) Make sure that powershell script execution is enabled for x86. See this post for details: https://stackoverflow.com/questions/4037939/powershell-says-execution-of-scripts-is-disabled-on-this-system

When the scheduler executes a custom command, it invokes the command line and passes the arguments. The last argument always will be the generated file name. Therefore within your script $args[1] will be the generated file name, and $args[0] will be "c:\backup".

You can add extra actions such as renaming the file within the script as you wish.

In order to test the scheduler without waiting for the scheduled time, go to http://yoursqlwallethost/hangfire/recurring, select the scheduled job and press "Trigger now" button. If you have the latest release 1.5.0, you will find the link to the jobs console in the Admin menu.
edited by Gleb on 8/17/2018
8/17/2018
Topic:
Run / Export to CSV

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Run / Export to CSV
Not at the moment. I will add this to the next release.
8/17/2018
Topic:
Error to edit user`s password

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Error to edit user`s password
Hi, the link you provided is not working. Did you check the error log?
8/17/2018
Topic:
"Run set of custom commands" for scheduled reports

Ullrich B
Ullrich B
Posts: 5
Hi,
could you please provide a FAQ-Entry about the feature "Ability to run set of custom commands and scripts, passing path to the generated report file as an argument"? What i want to do is saving results of scheduled reports for further processing, may be in a monitored local folder.

Best regards
8/7/2018
Topic:
Run / Export to CSV

Ullrich B
Ullrich B
Posts: 5
Hi,
do i have a chance to change the CSV field delimiter from "," to ";"?
6/8/2018
Topic:
Error to edit user`s password

meerim
meerim
Posts: 1
As admin created a new user and then tried to edit users' password. There is the internal server error. If the admin of SQL Wallet can`t edit users` password is there should be a message about permission? Or it is a bug?
Please, look a picture below
SQL Wallet ver: 1.4.6

https://drive.google.com/open?id=1fX6GM9J-e5qf3KORnk0_ib_nb8xYoHV8
4/16/2018
Topic:
Error starting browser after installation

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: Error starting browser after installation
Thank you for reporting this. The fix will be applied in the next release.
4/3/2018
Topic:
Error starting browser after installation

Ullrich B
Ullrich B
Posts: 5
Hi,
screenshot is there. Error message is the same on Systems with Chrome or IE. Application works fine when i'm ignoring the problem, esp. with the new version :)
3/24/2018
Topic:
HTTP error 500

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: HTTP error 500
Please try http://www.sqlwallet.com/media/1057/sqlwallet_setup-1.4.6.exe. I added the missing framework DLLs here. You might need to uninstall the previous version.

Let me know if it worked.
edited by Gleb on 3/24/2018
3/24/2018
Topic:
HTTP error 500

Gleb
Gleb
Administrator
Posts: 49
Gleb
Gleb
Administrator
Posts: 49
Topic: HTTP error 500
Hi Anne

If the error is still the same as in your initial post, please manually copy the file Microsoft.CSharp.dll (and any other DLLs you may get error messages in the log about) from C:\Windows\Microsoft.NET\Framework\v4.0.30319 into SQLwallet /refs folder.

Please let me know if it worked.

I will try to reproduce the issue on a clean machine.
edited by Gleb on 3/24/2018




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software