Byggfakta SMART Documentation

Learn how to use and configure the Byggfakta SMART app in CRM.

Table Of Contents

Introduction

The Byggfakta SMART app, is a standard plugin that allows to to import, qualify and work with construction projects from all of the Nordic countries directly in your CRM system.

With the Byggfakta SMART app you can import projects manually and/or automatically directly into your CRM system, as either a SMART Project or directly as an Opportunity. This allows you to implement the app directly into your current workflow.

Dataflow

The data for Construction Projects, Companies, and Contacts are all provided and kept up to date by Byggfakta.

The data for Construction Projects can hit either the Project entity, or the Opportunity Entity. For the specific entities for each CRM see the CRM specific explanations.

Data is also generated in the app (Opportunities and Connections), which is imported to CRM.

To help match existing data, a search is made on Companies and Contacts. This is only relevant, if the users are allowed to import Companies/Contacts.

Comparing data to see what data is linked, and connected requires lookups on Companies, Contacts, Opportunities, and Connections.

A few lists are looked up in the admin panel, and if relevant at the import moment. This includes:

  • Users

  • User groups (Superoffice)

  • Opportunity Type

  • Opportunity Stage

  • Opportunity Source

  • Company Category

  • Company Industry

  • Consent Lists (Source, Purpose, Legal Base) (Superoffice)

List of features

  • Import Projects as either SMART Projects or Opportunities.

  • Select the statuses you want to import to CRM (Allows for both automatic and/or manual transfer).

  • Map your SMART users to your CRM users, to make sure the projects reaches the right person.

  • Create Companies, and Contacts directly in the Byggfakta SMART app, with up-to-date data provided by Byggfakta.

  • Intelligent duplicate prevention allows you to make the app recognize you existing CRM data.

  • Link the relevant Contacts to the project using native connections in CRM, to aid your existing workflow.

  • Construction Projects are automatically kept up-to-date with the AutoUpdater.

  • Construction Projects from all of the Nordic countries.

  • Language of the app follows the local language of the CRM for each user.

Hotline

Support is available through Siteshop (support@siteshop.dk or +45 70 20 19 78).

Configuring the Byggfakta SMART App

General Settings

  1. “SMART App Active”, this toggle enables/disables the whole app. With this toggled off, no contruction projects will be transfered, AutoUpdate will turn off, and users will not be able to import through the forms.

  2. Client Id and Client Secret. These are the API credentials. Contact Byggfakta to receive these credentials.

  3. Importing Construction Projects
    • Toggle whether Construction projects should automatically update. The update runs nightly.
    • Select the SMART statuses, that should be imported to CRM.
    • Select the SMART statuses, that should be kept up-to-date.

  4. Should the users be presented with a link to the Company/Person to SMART.

  5. Select which users groups are allowed to import data from the form. All other users will be able to see data in the form, but not import. (SuperOffice only)

  6. User mapping.
    • Mapping to the CRM users, will assign that CRM user as the owner of the projects.
    • Only SMART users in this mapping will have their construction projects transferred to CRM.
    • You can have a one-to-many mapping, by simply selecting several SMART users to the same CRM user.
    • In case of problems with fetching projects, a fallback default user from the mapping can be selected.

Project Settings

  1. Toggles if the project id from SMART should be appended to the name of the imported project.

  2. When available the app will write dates to CRM, so that the CRM understands that it is a date, but fields are available that stores the date in text format, here you can define the date format of those fields. The syntax used is the regular Microsoft defined date format syntax.

  3. SMART has several different names for a project, ranging from a short description of the project, to a more unique human friendly name. Several options are available to ensure the name of the imported entity suits your workflow. No matter which option is selected for the header, the project id can always be appended to the project to ensure complete uniqueness and clarity.

  4. Options to add additional roles to the project members imported from the form.
    • If the company’s role should be added to the contacts, as if it was their own
    • If the company’s role should be written in the description that accompanies a connection in some systems.

  5. When available the app will write dates to CRM, so that the CRM understands that it is a date, but fields are available that stores the date in text format, here you can define the date format of those fields. The syntax used is the regular Microsoft defined date format syntax.

  6. SMART has several different names for a project, ranging from a short description of the project, to a more unique human friendly name. Several options are available to ensure the name of the imported entity suits your workflow. No matter which option is selected for the header, the project id can always be appended to the project to ensure complete uniqueness and clarity.

  7. Some data has several values from SMART, but only a single place to put them in CRM. E.g. the default date of an opportunity, is only a single field. These can be mapped to suit your workflow when dealing with default CRM entities. All the selectable fields has a further description in the Available Fields section.

  8. Which fields should be updated when a project is either moved to a new folder (That is selected to import/update) or when auto updating. Do note that allowing the app to update names can make it harder to find projects you are already working on.
    • It is recommended to update at least the end date and description. If the original end date is of importance to your workflow, we recommend adding the “Original End Date” field to CRM, so that both dates are available to you. The description is usually only appended to in SMART.

  9. Options to add additional roles to the project members imported from the form.
    – If the company’s role should be added to the contacts, as if it was their own
    – If the company’s role should be written in the description that accompanies a connection in some systems.

  10. Be very careful when changing this, and make sure you know what you are doing. This setting changes whether the app considers SMART Construction Projects as Opportunities or Projects. Changing this will make future Construction Projects be imported as the new selection, but since the app related fields are probably not installed this will fail. The form you currently have will also fail. Should you want to change the entity of the SMART construction projects, we highly recommend you contact Siteshop, and coordinate this for the best experience.

Company import configuration

  1. Default values for newly imported companies, imported through the form.

  2. What contact information should be imported (When available) from SMART

  3. What information that should be placed on an enxisting company, when linking a SMART company to an excisting company in CRM.

  4. Where to place the different addresses from SMART.
    • (SuperOffice only) note that the visible address fields are dependent on the address format of the country of the company.

Person configuration

  1. When importing a project, the person in the project becomes the contact person. If there is no person in the project or any other default contact person, then a “dummy” should be chosen.

  2. To create a “dummy” contact, you need to select a prefix.

  3. You can mark the dummy person as “retired,” which means they will not appear on lists.

  4. Choose where new people come into SuperOffice from.

  5. Select the purpose for their entry into the system.
    Choose the legal basis reason.

  6. Select categories, purposes, and legal bases. The idea here is that you can have categories consisting of both customers and prospects.

  7. When new individuals are imported, you can choose to import their Mobile and Work Phone.

  8. Check daily for updates to Name, Mobile, and Work Phone.

Opportunity

  1. When the customer/project has already been imported, the “Opportunity” button, if selected, can create a new sale.

  2. The “Amount” is displayed in percentage (%) and indicates what percentage of the project’s total value should be paid for your service.

  3. By default, it tries to assign “you” as responsible, and if not possible, it uses the default selected in the list field.

  4. Displays current/ongoing sales for the individual or company.

Available Fields

Many fields are available. A lot of them are relevant for most cases, but some contain internal ids of Byggfakta SMART, and might only be relevant, if you build something on top of the Byggfakta SMART app. These are available, but not recommended for every normal use case.

SuperOffice

All the fields ending in “sotrans”, are translated lists, that will appear in the local language of the SuperOffice client.

Installing fields

To install more fields in SuperOffice, go to “Settings and Maintainance”, select “Fields” in the left hand menu, and add the fields you want with the appropriate ProgId.

For example, to add the field containing the type of Eco Certification, the following steps are done:

1. Open the “Settings and Maintenance” in the burger menu in the top right corner:

2. Go to “Fields”, and select the entity where the field should be added, in this case “Projects”. And add a new field.

3. Give it the desired name that should be shown in SuperOffice (It is possible to add translations to show different names for different local SuperOffice languages if so desired).

Fill out the Data Type, and ProgId for that specific field. These can be found in the table below.
Save the field.

4. Data will appear in the field with every new import, or when a project is updated. If you want to manually force a project to get the data, simply modify the project in SMART (e.g. changing the status, and changing it back).
If all existing projects needs the have data loaded in, contact Siteshop to get a forced update of all your active projects.

Field NameProgIdDataTypeNote
Amount of apartmentssmart:apartmentsNumber
Assigned tender rolessmart:assigned_tender_rolesText:199Id field, not recommended
Amount of buildingssmart:buildingsNumber
Categories Idssmart:categories_idsText:39Id field, not recommended
Categories Namessmart:categories_namesText:199Comma separated list
Amount of categoriessmart:categories_numNumberThe number of categories
Main category Idsmart:category_idText:39Id field, not recommended
Main category namesmart:category_nameText:39
Translated main category namemesmart:category_sotransList:Smart Category
Citysmart:cityText:39
Client Statusessmart:client_statusesText:39Id field, not recommended
Construction Areasmart:construction_areaNumber
Contract Type Idsmart:contract_type_idText:39Id field, not recommended
Contract Typesmart:contract_type_nameText:39
Translated contract typesmart:contract_type_sotransList:Smart Contract Type
Country Idsmart:country_idText:39Id field, not recommended
Country Namesmart:country_nameText:39
Translated Country Namesmart:country_sotransList:Smart Country
Craftssmart:craftsText:39Id field, not recommended
Decontamination Areasmart:decontamination_areaNumber
Delivered Atsmart:delivered_atDateCreation date
Demolition Areasmart:demolition_areaNumber
Descriptionsmart:descriptionText:199
Detailed Stage Idsmart:detailed_stage_idText:39Id field, not recommended
Detailed Stagesmart:detailed_stage_nameText:39
Translated Detaild Stagesmart:detailed_stage_sotransList:Smart Detailed Stage
Construction type Idsmart:dev_type_idText:39Id field, not recommended
Construction typesmart:dev_type_nameText:39
Translated construction typesmart:dev_type_sotransList:Smart Dev Type
District Idsmart:district_idText:39Id field, not recommended
Districtsmart:district_nameText:39
Translated districtsmart:district_SoTransList:Smart District
Ecocertification Idsmart:ecocertified_type_idText:39Id field, not recommended
Ecocertification namesmart:ecocertified_type_nameText:39
Translated ecocertification namemesmart:ecocertified_type_sotransList:Smart Ecocertified Type
Expected Tender Rolessmart:expected_tender_rolesText:39Id field, not recommended
Finish Datesmart:finish_dateDate
Original Finish Datesmart:original_finish_dateDateSet at import time, never updated
Finish Date Accuracy Idsmart:finish_date_accuracy_idText:39Id field, not recommended
Finish Textsmart:finish_textText:199
Floorssmart:floorsNumber
Framework Agreementsmart:framework_agreementText:39
Geo Accuracy Idsmart:geo_accuracy_idText:39Id field, not recommended
Gross Areasmart:gross_areaNumber
Gross Volumesmart:gross_volumeNumber
Project Idsmart:project_idText:39Key id to identify the SMART Project
Location latitudesmart:location_latText:39Geographic coordinate system
Location longitudesmart:location_lonText:39Geographic coordinate system
Materials Idssmart:materials_idsText:39Id field, not recommended
Materialssmart:materials_namesText:199Comma separated list
Amount of materialssmart:materials_numNumberThe number of materials
Modified Atsmart:modified_atDate
Monthssmart:monthsText:39
Postcodesmart:postcodeNumber
Postcode Textsmart:postcode_textText:39City, postcode
Project Namesmart:project_nameText:39
Property Designationsmart:property_designationText:39
Publish Source Idsmart:publish_source_idText:39Id field, not recommended
Publish Sourcesmart:publish_source_nameText:39
Translated Publish Sourcesmart:publish_source_sotransList:Smart Publish Source
Region Idsmart:region_idText:39Id field, not recommended
Regionsmart:region_nameText:39
Translated regionsmart:region_SoTransList:Smart Region
Renovation Areasmart:renovation_areaNumber
Residence Formssmart:residence_formsText:39Id field, not recommended
Roles Idssmart:roles_idsText:39Id field, not recommended
Rolessmart:roles_namesText:199Comma separated list
Amount of rolessmart:roles_numNumberThe number of roles
Source Idsmart:source_idText:39Id field, not recommended
Stage Idsmart:stage_idText:39Id field, not recommended
Stagesmart:stage_nameText:39
Translated Stagesmart:stage_sotransList:Smart Stage
Start Datesmart:start_dateDate
Original Start Datesmart:original_start_dateDateSet at import time, never updated
Start Date Accuracy Idsmart:start_date_accuracy_idText:39Id field, not recommended
Start Textsmart:start_textText:199
Streetsmart:streetText:39
Street Numbersmart:street_numberNumber
Titlesmart:titleText:39
Uncertainty Idsmart:uncertainty_idText:39Id field, not recommended
Uncertaintysmart:uncertainty_nameText:39
Translated uncertaintysmart:uncertainty_sotransList:Smart Uncertainty
Underground Floorssmart:underground_floorsNumber
Update Endedsmart:update_endedDate
Updated Atsmart:updated_atDateTime of last update from Byggfakta
Usage Areasmart:usage_areaNumber
User Emailsmart:user_emailText:199Smart user data
User Idsmart:user_idText:39Smart user data
User Namesmart:user_nameText:199Smart user data
User Phonesmart:user_phoneText:39Smart user data
User Project Status Idsmart:user_project_status_idText:39Id field, not recommended
User Project Statussmart:user_project_status_nameText:39Smart user data
Translated Project Statussmart:user_project_status_sotransList:Smart User Project StatusSmart user data
Budgetsmart:valueNumber
Budget range greater thansmart:value_range_gteText:39
Budget range less thansmart:value_range_lteText:39
Budget Textsmart:value_textText:39
Versionsmart:versionText:39Id field, not recommended
Status (what happens)smart:what_happensText:39
Smart Urlsmart:smart_urlText:199
smart:project_custom_1Going to be used in future versions
smart:project_custom_2Going to be used in future versions
smart:project_custom_3Going to be used in future versions
smart:project_custom_4Going to be used in future versions
smart:project_custom_5Going to be used in future versions
Disable AutoUpdatesmart:disable_autoupdateCheckbox

Field NameProgIdDataTypeNote
Company IDsmart:company_idText:39
Versionsmart:versionText:39
Namesmart:nameText:199
Org NRsmart:org_nrText:39
Par IDsmart:par_idText:39
Cfar IDsmart:cfar_idText:39
Cfar NRsmart:cfar_nrText:39
Company NRsmart:company_nrText:39
Company Typesmart:company_type_nameText:39
Company Typesmart:company_type_name_SOListList:Smart Company Type
Countrysmart:country_nameText:39
Countrysmart:country_name_SOListList:Smart Country
Regionsmart:region_nameText:39
Districtsmart:district_nameText:39
Citysmart:cityText:39
Postcodesmart:postcode_textText:39
Location LATsmart:location_latText:39
Location LONsmart:location_lonText:39
Active Contactssmart:active_contactsNumberA count
Source IDsmart:source_idText:39
Updated atsmart:updated_atDate
Phonesmart:PhoneText:39Extracted from Communications
Mobilesmart:MobileText:39Extracted from Communications
Faxsmart:FaxText:39Extracted from Communications
Emailsmart:EmailText:199Extracted from Communications
Websitesmart:WebsiteText:199Extracted from Communications
Skypesmart:SkypeText:39Extracted from Communications
Client Company Foldersmart:client_company_folder_nameText:39
Delivered atsmart:delivered_atDate
Modified atsmart:modified_atDate
smart:company_custom_1Going to be used in future versions
smart:company_custom_2Going to be used in future versions
smart:company_custom_3Going to be used in future versions
smart:company_custom_4Going to be used in future versions
smart:company_custom_5Going to be used in future versions
Postal Address Addresssmart:postal_address_1_addressText:39
Postal Address Citysmart:postal_address_1_cityText:39
Postal Address Countrysmart:postal_address_1_countryText:39
Postal Address Districtsmart:postal_address_1_districtText:39
Postal Address Mainsmart:postal_address_1_mainText:39
Postal Address Postcodesmart:postal_address_1_postcode_textText:39
Postal Address Regionsmart:postal_address_1_regionText:39
Postal Address Streetsmart:postal_address_1_streetText:39
Postal Address Street Numbersmart:postal_address_1_street_numberNumber
Visit Address Addresssmart:visit_address_1_addressText:39
Visit Address Citysmart:visit_address_1_cityText:39
Visit Address Countrysmart:visit_address_1_countryText:39
Visit Address Districtsmart:visit_address_1_districtText:39
Visit Address Mainsmart:visit_address_1_mainText:39
Visit Address Postcodesmart:visit_address_1_postcode_textText:39
Visit Address Regionsmart:visit_address_1_regionText:39
Visit Address Streetsmart:visit_address_1_streetText:39
Visit Address Street Numbersmart:visit_address_1_street_numberNumber

Field NameProgIdDataTypeNote
Contact IDsmart:contact_idText:39
Versionsmart:versionText:39
First Namesmart:first_nameText:39
Last Namesmart:last_nameText:39
Source IDsmart:source_idText:39
Updated atsmart:updated_atDate
Phonesmart:PhoneText:39
Mobilesmart:MobileText:39
Faxsmart:FaxText:39
Emailsmart:EmailText:199
Websitesmart:WebsiteText:199
Skypesmart:SkypeText:39
Client Company Folder Namesmart:client_company_folder_nameText:39
Delivered atsmart:delivered_atDate
Modified atsmart:modified_atDate
smart:person_custom_1Going to be used in future versions
smart:person_custom_2Going to be used in future versions
smart:person_custom_3Going to be used in future versions
smart:person_custom_4Going to be used in future versions
smart:person_custom_5Going to be used in future versions

Dynamics 365 Sales

Field NameColumn nameDataTypeNote
Apartmentssiteshop_smart_apartmentsNumber
Assigned Tender Rolessiteshop_smart_assigned_tender_rolesText:199
Buildingssiteshop_smart_buildingsNumber
Categories Idssiteshop_smart_categories_idsText:39
Categoriessiteshop_smart_categories_namesText:199
Categories Numsiteshop_smart_categories_numNumber
Category Idsiteshop_smart_category_idText:39
Categorysiteshop_smart_category_nameText:39Configurable in admin (Default off)
Citysiteshop_smart_cityText:39
Client Statusessiteshop_smart_client_statusesText:39
Construction Areasiteshop_smart_construction_areaNumber
Contract Type Idsiteshop_smart_contract_type_idText:39
Contract Typesiteshop_smart_contract_type_nameText:39Configurable in admin (Default off)
Country Idsiteshop_smart_country_idText:39
Countrysiteshop_smart_country_nameText:39
Craftssiteshop_smart_craftsText:39
Decontamination Areasiteshop_smart_decontamination_areaNumber
Delivered Atsiteshop_smart_delivered_atDate
Demolition Areasiteshop_smart_demolition_areaNumber
Descriptionsiteshop_smart_descriptionText:199Configurable in admin (Default Description)
Detailed Stage Idsiteshop_smart_detailed_stage_idText:39
Detailed Stagesiteshop_smart_detailed_stage_nameText:39Configurable in admin (Default off)
Dev Type Idsiteshop_smart_dev_type_idText:39
Dev Typesiteshop_smart_dev_type_nameText:39Configurable in admin (Default off)
District Idsiteshop_smart_district_idText:39
Districtsiteshop_smart_district_nameText:39
Ecocertified Type Idsiteshop_smart_ecocertified_type_idText:39
Ecocertified Typesiteshop_smart_ecocertified_type_nameText:39Configurable in admin (Default off)
Expected Tender Rolessiteshop_smart_expected_tender_rolesText:39
Finish Datesiteshop_smart_finish_dateDate
Original Finish Datesiteshop_smart_original_finish_dateDate(Insert only on original creation)
Finish Date Accuracy Idsiteshop_smart_finish_date_accuracy_idText:39
Finish Textsiteshop_smart_finish_textText:199
Floorssiteshop_smart_floorsNumber
Framework Agreementsiteshop_smart_framework_agreementText:39
Geo Accuracy Idsiteshop_smart_geo_accuracy_idText:39
Gross Areasiteshop_smart_gross_areaNumber
Gross Volumesiteshop_smart_gross_volumeNumber
Project Idsiteshop_smart_project_idText:39Configurable in admin (Default on)
Location Latsiteshop_smart_location_latText:39
Location Lonsiteshop_smart_location_lonText:39
Materials Idssiteshop_smart_materials_idsText:39
Materialssiteshop_smart_materials_namesText:199
Materials Numsiteshop_smart_materials_numNumber
Modified Atsiteshop_smart_modified_atDate
Monthssiteshop_smart_monthsText:39
Postcodesiteshop_smart_postcodeNumber
Postcodesiteshop_smart_postcode_textText:39
Project Namesiteshop_smart_project_nameText:39Configurable in admin (Project name vs. title (Default Project name)))
Property Designationsiteshop_smart_property_designationText:39
Publish Source Idsiteshop_smart_publish_source_idText:39
Publish Sourcesiteshop_smart_publish_source_nameText:39
Region Idsiteshop_smart_region_idText:39
Regionsiteshop_smart_region_nameText:39
Renovation Areasiteshop_smart_renovation_areaNumber
Residence Formssiteshop_smart_residence_formsText:39
Roles Idssiteshop_smart_roles_idsText:39
Rolessiteshop_smart_roles_namesText:199
Roles Numsiteshop_smart_roles_numNumber
Source Idsiteshop_smart_source_idText:39
Stage Idsiteshop_smart_stage_idText:39
Stagesiteshop_smart_stage_nameText:39
Start Datesiteshop_smart_start_dateDate
Original Start Datesiteshop_smart_original_start_dateDate(Insert only on original creation)
Start Date Accuracy Idsiteshop_smart_start_date_accuracy_idText:39
Start Textsiteshop_smart_start_textText:199
Streetsiteshop_smart_streetText:39
Street Numbersiteshop_smart_street_numberNumber
Titlesiteshop_smart_titleText:39Configurable in admin (Project name vs. title (Default Project name)))
Uncertainty Idsiteshop_smart_uncertainty_idText:39
Uncertaintysiteshop_smart_uncertainty_nameText:39
Underground Floorssiteshop_smart_underground_floorsNumber
Update Endedsiteshop_smart_update_endedDate
Updated Atsiteshop_smart_updated_atDate
Usage Areasiteshop_smart_usage_areaNumber
User Emailsiteshop_smart_user_emailText:199
User Idsiteshop_smart_user_idText:39
User Namesiteshop_smart_user_nameText:199Possibly mapped in the admin
User Phonesiteshop_smart_user_phoneText:39
User Project Status Idsiteshop_smart_user_project_status_idText:39
User Project Statussiteshop_smart_user_project_status_nameText:39
Valuesiteshop_smart_valueNumber
Value Range Gtesiteshop_smart_value_range_gteText:39
Value Range Ltesiteshop_smart_value_range_lteText:39
Value Textsiteshop_smart_value_textText:39
Versionsiteshop_smart_versionText:39
What Happenssiteshop_smart_what_happensText:39
Smart Urlsiteshop_smart_smart_urlText:199Calculated by us. Options in admin panel
siteshop_smart_project_custom_1Going to be used in future versions
siteshop_smart_project_custom_2Going to be used in future versions
siteshop_smart_project_custom_3Going to be used in future versions
siteshop_smart_project_custom_4Going to be used in future versions
siteshop_smart_project_custom_5Going to be used in future versions
Disable AutoUpdatessiteshop_smart_disable_autoupdateCheckbox

Field NameColumn nameDataTypeNote
Company IDsiteshop_smart_company_idText:39
Versionsiteshop_smart_versionText:39
Namesiteshop_smart_nameText:199
Org NRsiteshop_smart_org_nrText:39
Par IDsiteshop_smart_par_idText:39
Cfar IDsiteshop_smart_cfar_idText:39
Cfar NRsiteshop_smart_cfar_nrText:39
Company NRsiteshop_smart_company_nrText:39
Company Typesiteshop_smart_company_type_nameText:39
Countrysiteshop_smart_country_nameText:39
Regionsiteshop_smart_region_nameText:39
Districtsiteshop_smart_district_nameText:39
Citysiteshop_smart_cityText:39
Postcodesiteshop_smart_postcode_textText:39
Location LATsiteshop_smart_location_latText:39
Location LONsiteshop_smart_location_lonText:39
Active Contactssiteshop_smart_active_contactsNumberA count
Source IDsiteshop_smart_source_idText:39
Updated atsiteshop_smart_updated_atDate
Phonesiteshop_smart_PhoneText:39Extracted from Communications
Mobilesiteshop_smart_MobileText:39Extracted from Communications
Faxsiteshop_smart_FaxText:39Extracted from Communications
Emailsiteshop_smart_EmailText:199Extracted from Communications
Websitesiteshop_smart_WebsiteText:199Extracted from Communications
Skypesiteshop_smart_SkypeText:39Extracted from Communications
Client Company Foldersiteshop_smart_client_company_folder_nameText:39
Delivered atsiteshop_smart_delivered_atDate
Modified atsiteshop_smart_modified_atDate
siteshop_smart_company_custom_1Going to be used in future versions
siteshop_smart_company_custom_2Going to be used in future versions
siteshop_smart_company_custom_3Going to be used in future versions
siteshop_smart_company_custom_4Going to be used in future versions
siteshop_smart_company_custom_5Going to be used in future versions
Postal Address Addresssiteshop_smart_postal_address_1_addressText:39
Postal Address Citysiteshop_smart_postal_address_1_cityText:39
Postal Address Countrysiteshop_smart_postal_address_1_countryText:39
Postal Address Districtsiteshop_smart_postal_address_1_districtText:39
Postal Address Mainsiteshop_smart_postal_address_1_mainText:39
Postal Address Postcodesiteshop_smart_postal_address_1_postcode_textText:39
Postal Address Regionsiteshop_smart_postal_address_1_regionText:39
Postal Address Streetsiteshop_smart_postal_address_1_streetText:39
Postal Address Street Numbersiteshop_smart_postal_address_1_street_numberNumber
Visit Address Addresssiteshop_smart_visit_address_1_addressText:39
Visit Address Citysiteshop_smart_visit_address_1_cityText:39
Visit Address Countrysiteshop_smart_visit_address_1_countryText:39
Visit Address Districtsiteshop_smart_visit_address_1_districtText:39
Visit Address Mainsiteshop_smart_visit_address_1_mainText:39
Visit Address Postcodesiteshop_smart_visit_address_1_postcode_textText:39
Visit Address Regionsiteshop_smart_visit_address_1_regionText:39
Visit Address Streetsiteshop_smart_visit_address_1_streetText:39
Visit Address Street Numbersiteshop_smart_visit_address_1_street_numberNumber

Field NameColumn nameDataTypeNote
Contact IDsiteshop_smart_contact_idText:39
Versionsiteshop_smart_versionText:39
First Namesiteshop_smart_first_nameText:39
Last Namesiteshop_smart_last_nameText:39
Source IDsiteshop_smart_source_idText:39
Updated atsiteshop_smart_updated_atDate
Phonesiteshop_smart_PhoneText:39
Mobilesiteshop_smart_MobileText:39
Faxsiteshop_smart_FaxText:39
Emailsiteshop_smart_EmailText:199
Websitesiteshop_smart_WebsiteText:199
Skypesiteshop_smart_SkypeText:39
Client Company Folder Namesiteshop_smart_client_company_folder_nameText:39
Delivered atsiteshop_smart_delivered_atDate
Modified atsiteshop_smart_modified_atDate
siteshop_smart_person_custom_1Going to be used in future versions
siteshop_smart_person_custom_2Going to be used in future versions
siteshop_smart_person_custom_3Going to be used in future versions
siteshop_smart_person_custom_4Going to be used in future versions
siteshop_smart_person_custom_5Going to be used in future versions

Salesforce

Field NameSalesforce field nameDataTypeNote
Apartmentssmart_apartments__cNumber
Assigned Tender Rolessmart_assigned_tender_roles__cText:199
Buildingssmart_buildings__cNumber
Categories Idssmart_categories_ids__cText:39
Categoriessmart_categories_names__cText:199
Categories Numsmart_categories_num__cNumber
Category Idsmart_category_id__cText:39
Categorysmart_category_name__cText:39Configurable in admin (Default off)
Categorysmart_category_sotrans__cList:Smart CategoryConfigurable in admin (Default off)
Citysmart_city__cText:39
Client Statusessmart_client_statuses__cText:39
Construction Areasmart_construction_area__cNumber
Contract Type Idsmart_contract_type_id__cText:39
Contract Typesmart_contract_type_name__cText:39Configurable in admin (Default off)
Contract Typesmart_contract_type_sotrans__cList:Smart Contract TypeConfigurable in admin (Default off)
Country Idsmart_country_id__cText:39
Countrysmart_country_name__cText:39
Countrysmart_country_sotrans__cList:Smart Country
Craftssmart_crafts__cText:39
Decontamination Areasmart_decontamination_area__cNumber
Delivered Atsmart_delivered_at__cDate
Demolition Areasmart_demolition_area__cNumber
Descriptionsmart_description__cText:199Configurable in admin (Default Description)
Detailed Stage Idsmart_detailed_stage_id__cText:39
Detailed Stagesmart_detailed_stage_name__cText:39Configurable in admin (Default off)
Detailed Stagesmart_detailed_stage_sotrans__cList:Smart Detailed StageConfigurable in admin (Default off)
Dev Type Idsmart_dev_type_id__cText:39
Dev Typesmart_dev_type_name__cText:39Configurable in admin (Default off)
Dev Typesmart_dev_type_sotrans__cList:Smart Dev TypeConfigurable in admin (Default off)
District Idsmart_district_id__cText:39
Districtsmart_district_name__cText:39
Districtsmart_district_SoTrans__cList:Smart District
Ecocertified Type Idsmart_ecocertified_type_id__cText:39
Ecocertified Typesmart_ecocertified_type_name__cText:39Configurable in admin (Default off)
Ecocertified Typesmart_ecocertified_type_sotrans__cList:Smart Ecocertified TypeConfigurable in admin (Default off)
Expected Tender Rolessmart_expected_tender_roles__cText:39
Finish Datesmart_finish_date__cDate
Original Finish Datesmart_finish_date__cDate(Insert only on original creation)
Finish Date Accuracy Idsmart_finish_date_accuracy_id__cText:39
Finish Textsmart_finish_text__cText:199
Floorssmart_floors__cNumber
Framework Agreementsmart_framework_agreement__cText:39
Geo Accuracy Idsmart_geo_accuracy_id__cText:39
Gross Areasmart_gross_area__cNumber
Gross Volumesmart_gross_volume__cNumber
Project Idsmart_project_id__cText:39Configurable in admin (Default on)
Location Latsmart_location_lat__cText:39
Location Lonsmart_location_lon__cText:39
Materials Idssmart_materials_ids__cText:39
Materialssmart_materials_names__cText:199
Materials Numsmart_materials_num__cNumber
Modified Atsmart_modified_at__cDate
Monthssmart_months__cText:39
Postcodesmart_postcode__cNumber
Postcodesmart_postcode_text__cText:39
Project Namesmart_project_name__cText:39Configurable in admin (Project name vs. title (Default Project name)))
Property Designationsmart_property_designation__cText:39
Publish Source Idsmart_publish_source_id__cText:39
Publish Sourcesmart_publish_source_name__cText:39
Publish Sourcesmart_publish_source_sotrans__cList:Smart Publish Source
Region Idsmart_region_id__cText:39
Regionsmart_region_name__cText:39
Regionsmart_region_SoTrans__cList:Smart Region
Renovation Areasmart_renovation_area__cNumber
Residence Formssmart_residence_forms__cText:39
Roles Idssmart_roles_ids__cText:39
Rolessmart_roles_names__cText:199
Roles Numsmart_roles_num__cNumber
Source Idsmart_source_id__cText:39
Stage Idsmart_stage_id__cText:39
Stagesmart_stage_name__cText:39
Stagesmart_stage_sotrans__cList:Smart Stage
Start Datesmart_start_date__cDate
Original Start Datesmart_start_date__cDate(Insert only on original creation)
Start Date Accuracy Idsmart_start_date_accuracy_id__cText:39
Start Textsmart_start_text__cText:199
Streetsmart_street__cText:39
Street Numbersmart_street_number__cNumber
Titlesmart_title__cText:39Configurable in admin (Project name vs. title (Default Project name)))
Uncertainty Idsmart_uncertainty_id__cText:39
Uncertaintysmart_uncertainty_name__cText:39
Uncertaintysmart_uncertainty_sotrans__cList:Smart Uncertainty
Underground Floorssmart_underground_floors__cNumber
Update Endedsmart_update_ended__cDate
Updated Atsmart_updated_at__cDate
Usage Areasmart_usage_area__cNumber
User Emailsmart_user_email__cText:199
User Idsmart_user_id__cText:39
User Namesmart_user_name__cText:199Possibly mapped in the admin
User Phonesmart_user_phone__cText:39
User Project Status Idsmart_user_project_status_id__cText:39
User Project Statussmart_user_project_status_name__cText:39
User Project Statussmart_user_project_status_sotrans__cList:Smart User Project Status
Valuesmart_value__cNumber
Value Range Gtesmart_value_range_gte__cText:39
Value Range Ltesmart_value_range_lte__cText:39
Value Textsmart_value_text__cText:39
Versionsmart_version__cText:39
What Happenssmart_what_happens__cText:39
Smart Urlsmart_smart_url__cText:199Calculated by us. Options in admin panel
smart_project_custom_1__cGoing to be used in future versions
smart_project_custom_2__cGoing to be used in future versions
smart_project_custom_3__cGoing to be used in future versions
smart_project_custom_4__cGoing to be used in future versions
smart_project_custom_5__cGoing to be used in future versions
Disable AutoUpdatessmart_disable_autoupdate__cCheckbox

Field NameSalesforce field nameDataTypeNote
Company IDSiteshop__smart_company_id__cText:39
VersionSiteshop__smart_version__cText:39
NameSiteshop__smart_name__cText:199
Org NRSiteshop__smart_org_nr__cText:39
Par IDSiteshop__smart_par_id__cText:39
Cfar IDSiteshop__smart_cfar_id__cText:39
Cfar NRSiteshop__smart_cfar_nr__cText:39
Company NRSiteshop__smart_company_nr__cText:39
Company TypeSiteshop__smart_company_type_name__cText:39
Company TypeSiteshop__smart_company_type_name_SOList__cList:Smart Company Type
CountrySiteshop__smart_country_name__cText:39
CountrySiteshop__smart_country_name_SOList__cList:Smart Country
RegionSiteshop__smart_region_name__cText:39
DistrictSiteshop__smart_district_name__cText:39
CitySiteshop__smart_city__cText:39
PostcodeSiteshop__smart_postcode_text__cText:39
Location LATSiteshop__smart_location_lat__cText:39
Location LONSiteshop__smart_location_lon__cText:39
Active ContactsSiteshop__smart_active_contacts__cNumberA count
Source IDSiteshop__smart_source_id__cText:39
Updated atSiteshop__smart_updated_at__cDate
PhoneSiteshop__smart_Phone__cText:39Extracted from Communications
MobileSiteshop__smart_Mobile__cText:39Extracted from Communications
FaxSiteshop__smart_Fax__cText:39Extracted from Communications
EmailSiteshop__smart_Email__cText:199Extracted from Communications
WebsiteSiteshop__smart_Website__cText:199Extracted from Communications
SkypeSiteshop__smart_Skype__cText:39Extracted from Communications
Client Company FolderSiteshop__smart_client_company_folder_name__cText:39
Delivered atSiteshop__smart_delivered_at__cDate
Modified atSiteshop__smart_modified_at__cDate
Siteshop__smart_company_custom_1__cGoing to be used in future versions
Siteshop__smart_company_custom_2__cGoing to be used in future versions
Siteshop__smart_company_custom_3__cGoing to be used in future versions
Siteshop__smart_company_custom_4__cGoing to be used in future versions
Siteshop__smart_company_custom_5__cGoing to be used in future versions
Postal Address AddressSiteshop__smart_postal_address_1_address__cText:39
Postal Address CitySiteshop__smart_postal_address_1_city__cText:39
Postal Address CountrySiteshop__smart_postal_address_1_country__cText:39
Postal Address DistrictSiteshop__smart_postal_address_1_district__cText:39
Postal Address MainSiteshop__smart_postal_address_1_main__cText:39
Postal Address PostcodeSiteshop__smart_postal_address_1_postcode_text__cText:39
Postal Address RegionSiteshop__smart_postal_address_1_region__cText:39
Postal Address StreetSiteshop__smart_postal_address_1_street__cText:39
Postal Address Street NumberSiteshop__smart_postal_address_1_street_number__cNumber
Visit Address AddressSiteshop__smart_visit_address_1_address__cText:39
Visit Address CitySiteshop__smart_visit_address_1_city__cText:39
Visit Address CountrySiteshop__smart_visit_address_1_country__cText:39
Visit Address DistrictSiteshop__smart_visit_address_1_district__cText:39
Visit Address MainSiteshop__smart_visit_address_1_main__cText:39
Visit Address PostcodeSiteshop__smart_visit_address_1_postcode_text__cText:39
Visit Address RegionSiteshop__smart_visit_address_1_region__cText:39
Visit Address StreetSiteshop__smart_visit_address_1_street__cText:39
Visit Address Street NumberSiteshop__smart_visit_address_1_street_number__cNumber
Siteshop__smart_project_relation__c

Field NameSalesforce field nameDataTypeNote
Contact IDsmart_contact_id__cText:39
Versionsmart_version__cText:39
First Namesmart_first_name__cText:39
Last Namesmart_last_name__cText:39
Source IDsmart_source_id__cText:39
Updated atsmart_updated_at__cDate
Phonesmart_Phone__cText:39
Mobilesmart_Mobile__cText:39
Faxsmart_Fax__cText:39
Emailsmart_Email__cText:199
Websitesmart_Website__cText:199
Skypesmart_Skype__cText:39
Client Company Folder Namesmart_client_company_folder_name__cText:39
Delivered atsmart_delivered_at__cDate
Modified atsmart_modified_at__cDate
smart_person_custom_1__cGoing to be used in future versions
smart_person_custom_2__cGoing to be used in future versions
smart_person_custom_3__cGoing to be used in future versions
smart_person_custom_4__cGoing to be used in future versions
smart_person_custom_5__cGoing to be used in future versions

CRM Specifics

SuperOffice

Dynamics 365 Sales

Salesforce