can't find skillid list and category id list mapping for contact list - 02284230

Post questions on how to interpret your Bullhorn SQL Server backup of your Database.

Moderators: StaffingSupport, s.emmons

Post Reply
latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

can't find skillid list and category id list mapping for contact list - 02284230

Post by latifkhan771 » Fri Jul 01, 2016 7:25 am

I have a standard backup from bullhorn, I have migrated the candidates
But can't figure out contact list skill id and category id .

SELECT userid, skillidlist, categoryidlist FROM bh_usercontact where recordtypebits = 2

skilllidlist is always empty, and categoryidlist is a kind of invalid ids. they will have values 45,45 but these ids never exist in category tables.
Where can I find the exact mapping for skills and categories.

pmularski
Bullhorn Support Staff
Posts: 900
Joined: Wed Dec 31, 1969 8:00 pm

Re: can't find skillid list and category id list mapping for contact list

Post by pmularski » Fri Jul 01, 2016 3:44 pm

Good Afternoon Latifkhan771,

I have moved your post to the backup forum. Please take a look at the following post, and let me know if you have any remaining questions.

viewtopic.php?f=34&t=2811
Patrick Mularski
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

Re: can't find skillid list and category id list mapping for contact list

Post by latifkhan771 » Tue Jul 05, 2016 4:27 am

I can find categories, but skills are missing.

Using this query give me empty list while there must be one row.
SELECT * FROM `bh_userskill` WHERE `userid` = 18154
Can some one please give me a proper query to get skills of user (Contact NOT candidate).

latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

Re: can't find skillid list and category id list mapping for contact list

Post by latifkhan771 » Tue Jul 12, 2016 11:07 am

Can someone reply to this post please......

pmularski
Bullhorn Support Staff
Posts: 900
Joined: Wed Dec 31, 1969 8:00 pm

Re: can't find skillid list and category id list mapping for contact list

Post by pmularski » Tue Jul 12, 2016 4:51 pm

Good Afternoon Latfikhan771,

The answer depends entirely on when your backup was created. Prior to a recent database change, skills were not included in the backup structure, and needed to be provided independently. Now, this is no longer the case, and the skills table is included in the backup.

When was your backup created? It would also help to know what company it was created for, but you can feel free to private message me that information if you do not feel comfortable posting it in a public forum.
Patrick Mularski
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

Re: can't find skillid list and category id list mapping for contact list

Post by latifkhan771 » Wed Jul 13, 2016 3:37 am

It was standard backup created on 19 june 2106 ,
I was expecting values in this table "BH_UserSkill" but none of the userid exist in this table.

latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

Re: can't find skillid list and category id list mapping for contact list

Post by latifkhan771 » Fri Jul 15, 2016 4:41 am

Any luck with this query ?
let me explain it again.

I have a standard backup taken on 19 june 2106 from bullhorn,
I have imported most of the data, Just one thing is missing or cant find it.
Each contact person should have a list of skills and categories. But i am not able to find it.

SELECT userid, skillidlist, categoryidlist FROM bh_usercontact where recordtypebits = 2
in table bh_usercontact skilllidlist is always empty, and categoryidlist is a kind of invalid ids. they will have values 45,45 but these ids never exist in category tables.

Where can I find the correct data in DB.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: can't find skillid list and category id list mapping for contact list

Post by apsmith » Fri Jul 15, 2016 9:54 am

Sorry for the delayed response.

That data will be contained in the BH_userSkill and BH_UserCategory tables joined back to the BH_UserContact table using userID for the candidate or contact.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

latifkhan771
User
Posts: 7
Joined: Fri Jul 01, 2016 7:13 am

Re: can't find skillid list and category id list mapping for contact list

Post by latifkhan771 » Mon Jul 18, 2016 10:54 am

i have mentioned it already on Tue Jul 05, 2016 9:27 am

Using this query give me empty list while there must be one row.
SELECT * FROM `bh_userskill` WHERE `userid` = 18154

This table does not entries for any of the contact list. Is there any reason.......?

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: can't find skillid list and category id list mapping for contact list

Post by apsmith » Mon Jul 18, 2016 11:40 am

Are you sure that you are using the correct field? in field mappings, you can rename any field to be called Skill, but the underlying field would be called skillID if this was that table.

Can you post your corpID and I will check the DB on our side?
Andrew Smith
Director, Technical Operations
Developer Forum Admin

shossain
User
Posts: 7
Joined: Wed Dec 31, 1969 8:00 pm

Re: can't find skillid list and category id list mapping for contact list

Post by shossain » Thu Jul 21, 2016 2:39 am

Hi Latfikhan771,

The setup for this client is a little bit different for Contacts. Could you please try the below:

SELECT desiredCategories,desiredSkills FROM BH_Client
Shamim Hossain
Senior Technical Support Analyst
B U L L H O R N

89 York Street, 11th Floor, Sydney, MA 2000
617-478-9126 (US Support)
+44 800 032 2848 ext. 9131 (UK Support)
+61 2 8073 5089 (APAC Support)

Post Reply