samwoo

Hi, We've been getting this issue for the last few weeks. It sounds like there are multiples of the same actions occurring when we press a button once, but throwing an error because the action has already been completed. There doesn't seem to be a pattern to it though. Thanks, Samuel

Hi all, Just wanted to mention that I use Softerra LDAP Browser (free) to build these filters. Once i get the results i require, i copy the filter that I built from the software into the Conf file and away it goes. http://www.ldapadministrator.com/ When building filters they look like this (example from their website): When you've created the filters they end up looking like the ones we need for the LDAP_Import. I don't check for disabled accounts as they are moved into the "Archived" OU anyway, if any current user ends up in here they are set to "Archived" in Hornbill, if they are moved into another OU then they will automatically become "Active" if they are not already. It's really cool. Thanks, Samuel

Hello, This would be useful for us too. Thanks, Samuel

I really like how it looks now, and the Wiki Markup is a plus! Is there a way to do line breaks in the Markup? I've got an image in the progressive capture that is smallish, but the first word of the text in the paragraph following the image is showing on the same line as the image itself. What's the workaround to ensure this paragraph is on it's own line?

Hello, For the Self Service Portal, is it possible to... Change the wording of the Resolution Text (shown between blue brackets) Remove the rating bit Remove the "It's working!" button Rename the "It's still broken" button If we can fix this, it will prevent customer confusion and prevent issues with the way we currently do things. Thanks, Samuel

Hi Kelvin, Does it make any difference if you use h_status <> 'status.closed' Thanks, Samuel

Hi James, In my case, I am able to download the CSV file... when I see the data from the SQL query in Hornbill, everything is in the right columns, but when outputting to CSV the data doesnt sit in the right columns. For each record the data could be in different places in the CSV file. For example: As you can see for alehal and aliapp, where it should be a 0 in the third column, its moved to the second column because they dont have a company name What i guess is happening is that if the column is empty, the comma that's supposed to separate it is not added. This seem to be happening with all the SQL Direct reports where a field could have an empty column sucn as the h_sys_accounts table when exporting to CSV. Thanks, Samuel

Hello, Is it possible to add a clickable link if a "Read Only" text box with a default value has a link? Maybe by allowing the use of Wiki-markup or <a></a> tags? At the moment the way to get the customers to go to the link is by telling them to Copy and Paste it. Thanks, Samuel

Hello, When I need to provide certain information to the customer via the Self Service Portal, I often use the Multiline Text-box and set it to Read-Only and input the information I need to relay as the Default value. This is great except for two things... When having large amounts of information, the formatting of the Multiline textbox (as users have found) can be difficult to read. Could we have the possibility of adding formatting to this box? At least allowing line breaks via the PCM setup to show in the form as expected. When anyone jumps to a form with Read Only information, the field is automatically too large. We need this Multiline text box to fit to the text automatically. If i zoom in and out whilst on this screen, the Multiline text box shrinks to fit the text... which is not a workaround but to show that it seems to be capable of doing this. Thanks, Samuel

Sorry I forgot about using Service Manager Reports... i still prefer SQL though but will use Advanced Analytics this time round. Other created with SQL Direct (the more complicated ones) do come out with the issue i mentioned in the first post.

Hello, When I run the following code (for example): select h_sys_accounts.h_user_id as USERID, trim(h_attrib7) as COMPANY, h_account_status as STATUS from h_sys_accounts When I export it to CSV, if the h_attrib7 field is null it will then populate the empty h_attrib7 field with the h_account_status instead of leaving it blank. If it is populated, then the next field as expected will contain the h_account_status. This happens with every export I do, especially the h_sys_accounts... if i export this then where there is a blank field, it puts in the value from the next field leaving all the information out of sync and in the wrong fields.... and this is not consistent so I cannot filter information in excel. Can this be fixed? I have a small workaround for the above script (run it once for null h_attrib7 and one for populated h_attrib7) but need to see the overall picture from h_sys_accounts on it's own. Thanks, Samuel.

Ah no I didn't know that existed - will hunt for that button. It's handy writing it in Word as it keeps it in the same format when I paste it in so I never really used the buttons on CKEditor. Thanks Trevor

Hello, I have come across a slightly frustrating issue when creating email templates. If i create a new template and copy the text from the following sources: * Word Document * Another Template * Notepad * Wordpad I get the following error message at what appears to be randomly. If i do get this message, i'll have to duplicate the tab, create a new email template yet again and copy and paste the information from the problem template. This doesnt always work, there have been occassions where I have needed repeat this process more than 5 times before I am finally able to create the template. This is the template I am having issues with at the moment in time: I have created other emails successfully with an underscore _ at the front of the name. Can someone advise? Thanks, Samuel EDIT: Oh and the other thing that happens is that if I do manage to click "Create" without getting that error message, but don't get an acknowledgement that the Template has been created, I will never be able to use the Template name ever again. When this happens, the Create button is still active. So I refresh or create a new template, put the same name again and press Create... the create button is still active no matter how many times i do it. I go into the Email Templates area and there is no template with the name that i want to use. But when I add an extra character to the template name that I want to use, the template is created and works.

Hi Trevor, Thank you very much for investigating this. I will still use the LDAP imports to update the user information as I'm now confident (thank you) that it wont affect any current job roles assigned to a user. I will keep an eye out for any updates to this issue. Cheers, Samuel

Hi Trevor, Thank you. I have attached the file. Many thanks, Samuel Hornbill_-_LDAP_Testing.zip

Hi Trevor, Thanks. I have run the script for maredw who should have the extra Job roles from the import and it hasnt worked He only has the Self Service User and Basic User role applied. I'm at a loss... will keep checking anyway. Thanks, Samuel

Thanks Trevor. Is there a table where I can do a select query to truly see what Job Roles a user has? I am wondering whether or not it is actually assigning it to them but it's not showing in the Job Roles area. And also now i'm thinking about it, the last time I posted on here about it to give users the "Self Service Portal" role it actually added the Job Roles to via the LDAP Import, but not this time. Maybe something has changed? Thanks, Samuel

maredw has a user type of "user" (as does everyone else i'm assigning these job roles to). Doesnt having the Basic User Role assigned to a "user" have any effect on adding additional Job Roles? Thanks, Samuel

Hi Trevor, If we look at maredw - these are his job roles after running the above import (please note maredw had these job roles since he was set up on the system manually quite some time ago): The job roles i specified to assign are not showing up. I am unable to test as the user is currently unavailable but ideally would like to see it appear here. This happens with everyone who do not have at least one of the my the Job Roles against them. Thanks, Samuel

Hi Trevor, Sorry I got it now. These are the only errors that I get when running the smallest conf file:

That's all i get from the smallest conf result (it does the same thing with more users in other OU's too which is set in other conf files)

Hi Trevor, Cheers for that I will keep an eye out for this feature. I have yet another question... I have been updating our AD so we can pull "Basic" users and "Users" from certain areas. I have enabled the flag "UpdateUserType" , and have already has "UserRoleAction" set to "Create". For users that were Basic are now updating to User is fine, but for the extra job roles that I need assigned to some of them... it's not working: Does that allow updating of current job roles by adding any new non-existing ones? Thanks, Samuel

@TrevorKillick and @bob_dickinson Thank you both for responding. I have improved on this by download Softera LDAP Browser, i am now visually able to define Filters, then copy the Filter string into the conf files. I've also created a Batch file which will run LDAP_Import a few times, but for each run i've changed the conf file it looks at... and it works flawlessly (will take dryrun=true off once testing is completed) I have a request though... i was wondering if we could have a new feature where we can define what word to prefix at the front the log file as running this batch will produce multiple log files in the same format, with no visible way of know which conf file it was running for. So to use the example BAT file above, i would expect it could look something like the following (for example): Then the log file will look like the following (for example) Desktop_LDAP_User_Import_2016-08-03T10-50-54+01-00.log Thanks, Samuel

Hello, Another question - is it possible to use the "Filter": "(objectClass=user)", to do a "NOT" filter? For example if we have usernames with .admin, could we filter to bring back everything EXCEPT anything with *.admin in the username Attribute? Can this be extended to other Attributes? Thanks, Samuel

Hello, I have a few questions: I'm not sure if it's been asked but is it possible to have this import tool look at multiple DSN's within the conf? How does Hornbill / LDAP_Import deal with users that do not exist in AD any more or are Archived? (for example if someone left the council) Further investigation with regards to SSO is underway, how does Auto-Provisioning work with AD and Users? For example does it update if the user's details have been changed on the fly? Does this still require LDAP_Import to be run if Auto-Provisioning is turned on? (Sorry i dont have a great deal of knowledge in this area so might be asking the wrong question) Thanks, Samuel