Field Maps - Backup

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

Moderators: StaffingSupport, s.emmons

Post Reply
chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 3:58 am

Hello,

Can anyone tell me where I can find a list of our field labels and values in the backup please?

I have a few fields that I'm not able to identify and some values I'd like to confirm.

I've tried calling support but they were unable to access my account as it is now locked / hidden.

Thanks!

Chris

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 9:24 am

Chris,

We can help, please post the fields and your PrivateLabel ID or CorporationID.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 9:36 am

Thanks Andrew. The CorpID is 2007.

The fields are:

type customText1 customText2


Thanks!

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 10:06 am

Is this for candidates or contact?
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 11:02 am

Jobs...

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 11:56 am

customText1: Stage(Pipeline Only)
customText2: Probability<br>(Pipeline Only)
type: Priority<br>(Live Jobs Only)
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 12:01 pm

Thanks.

And could you provide the list of values too please as I only have numbers....

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 12:03 pm

CustomText1:
1,2,3,4,5,6,7,8,9
Prospecting,Proposal Sent,Converted,Other Options First,Lost - No External Help,Lost - No Retained,Lost - Fees too High,Lost - Headcount,Lost - Competitor
CustomText2:
1,2,3,4
High,Mid,Low,Very Low
Type:
Hot,Warm,Cold,On Hold
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 12:15 pm

Great, thanks very much!

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 12:20 pm

Except for 'Type' I've got 0,1,2,3,4,5?

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 12:25 pm

I cannot speak to the values in the database, the current (last) field maps show just a text dropdown, with no mapping.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 12:38 pm

Okay, I got it. I think the zeros were a hangover from a previous field change.Thanks for your help, I appreciate it.

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Field Maps - Backup

Post by chris.sargent » Wed Sep 11, 2013 1:36 pm

Sorry.... I also need the values for:
willSponsor willRelocate

Please...

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

Re: Field Maps - Backup

Post by apsmith » Wed Sep 11, 2013 1:58 pm

willRelocate - Will Consider Relocation?
0,1,2,3
Not Applicable,Yes - With Assistance,Yes - No Assistance,No

willSponsor - Visa Sponsorship Provided
0,1,2
Not Applicable,Yes,No
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Post Reply