Ruben

It still doesn't work... My config looks like this now: { "CSV": { "DataSourceFile": "a_csv_file.csv", "CommaCharacter": ",", "CarriageReturnRemoval": true }, "Action": "Update", "User": { "UserDN": "h_user_id", "HornbillUniqueColumn": "h_user_id", "AccountMapping": { "UserID": "{{.keysearch}}", "DisableDirectLogin": "true", "DisableDirectLoginPasswordReset": "true", "DisableDevicePairing": "" }, "Status": { "Action": "Update", "Value": "archived" } } }

So what should it be then? I just copied from the documentation. If this is wrong, is the rest of the documentation wrong too?

Hi, adding that still didn't make it work. I'm starting to wonder if the CSV file is wrong, this is how it looks. I'm trying to get the users by their login ID. h_user_id rubentest

We're making an employee portal design for one of our companies, and I've made a new company in Hornbill. However, when I make any change on the company in the employee portal, I get the following error: Error Details Error upserting option value Lukk None of the pre-existing ones throw this error, and the error is incredibly non-descript, so I have no clue if this is a bug or if I've done something wrong.

I've managed to get the sync to work now, but I'm facing a few issues that I want to resolve. Firstly, the sync doesn't seem to update the checkbox fields and instead they're kept the way they were. Secondly, I'm having loads of issues setting the language from the sync. I've set the language to "nb-NO" in the config file, but it still appears as blank on the user, even though the language is enabled. I've tried other combinations just to make sure, like "nb-NO", "nn-NO", "no-NO", "nb_NO" etc. but nothing seems to work.

I now see my issue, didn't realise I used the wrong config file... However, it says this in the output, am I doing something wrong here? [WARN] [CSV] Reading CSV file. Please wait... [WARN] [CSV] 1 of 1 returned users successfully retrieved ready for processing. [DEBUG] Processing DB User Data [DEBUG] No Unique Identifier set for this record &map[h_user_id:rubentest] This is the config I'm using now { "CSV": { "DataSourceFile": "a_csv_file.csv", "CommaCharacter": ",", "CarriageReturnRemoval": true }, "Action": "Update", "User": { "UserDN": "{{.keysearch}}", "HornbillUniqueColumn": "h_user_id", "AccountMapping": { "DisableDirectLogin": "true", "DisableDirectLoginPasswordReset": "true", "DisableDevicePairing": "" }, "Status": { "Action": "Update", "Value": "archived" } } }

Haven't gotten to this until now so sorry for the late reply. I cannot seem to get the import util to work at all. I used the sample config file for CSV and tweaked that for a test run, but it doesn't seem to work. Firstly, I'm not too sure how the CSV is supposed to look like, and secondly I'm confused about how the KeySafe should look like. For now I created a blank KeySafe for the import, but it still throws errors. > .\user_import_db.exe -dryrun -forcerun [DEBUG] ---- XMLMC SQL Import Utility V4.2.0 ---- [DEBUG] Flag - Config File conf.json [DEBUG] Flag - Log Prefix [DEBUG] Flag - Dry Run true [MESSAGE] ---- DB User Import Utility v4.2.0 ---- [MESSAGE] Flag - config goDb2HUserImport [MESSAGE] Flag - logprefix [MESSAGE] Flag - dryrun true [MESSAGE] Flag - apitimeout 60 [MESSAGE] Flag - workers 1 [MESSAGE] Flag - forcerun true [DEBUG] Checking hornbill/user-import-database for updates... [MESSAGE] You're running the latest version of this utility: 4.2.0 [MESSAGE] Successfully decrypted Hornbill instance authentication information [MESSAGE] Import Defined Page Size 0 [MESSAGE] Overridden Page Size 10000 [DEBUG] Processing Old Log Files Current Retention Set to: 0 [ERROR] API call to retrieve key information from Keysafe failed: The specified key could not be found I have entered the KeySafe key that I created in KeySafe, so I'm not sure how this is failing.

Aaah I see! Yes, the user has access to the portal.

Where do you set that access?

I have them all visible: It is worth noting that in the employee portal using another test user, everything works as expected:

Hi, We have a handful of external users who have access to Hornbill to send in tickets to us. Today, they use the same portal as the employees, and although that works fine for them, it can easily go out of hand for us. I have been looking a bit at the customer portal, but cannot seem to figure out how to configure this. No matter what I do or look at, I cannot seem to find anything to make the services appear for the test user I've made. I have added the test user to the service but it still doesn't appear in the portal. Is there anything I'm doing wrong here? I can't seem to find anything too useful in the docs either.

Hi, thanks for your reply. I'm planning on using the Azure import tool (https://github.com/hornbill/user-import-azure) to import users from Entra to Hornbill. As we're registering tickets on users who might never log in themselves, we need everyone to be available in the system.

We have been using the LDAP sync tool to get users from our AD instance to Hornbill. We now want to switch from ADFS login to Entra login, and at the same time go from importing from LDAP to importing from Entra. The issue we have is: The user ID that we use for login is the on-premises SAM Account Name. This is something we want to keep using as it makes it easier for us (otherwise we'd have to change the login ID for everyone). All of the users logging in have a SAM Account Name as they all come from AD. Is there a good way of doing this?

Hi, As of today we have nearly 8000 basic users in our Hornbill instance. We have around 3-4000 active employees today. We're continuously importing users from AD, but we don't have a routine on archiving these users when they quit. This means that we have 4-5000 users who don't work here but have active users in Hornbill. From a security standpoint, this is a non-issue as they have logged in through ADFS, where they don't have a user anymore. However, this is very messy for us, and we would like a good way to archive these users in bulk. I know there is a "select all" checkbox in the users list, but this only does like 20 or so users, which makes the archiving process super tedious and not worth. Is there a better way of doing this?

This seems to work pretty alright, thanks a lot!