Match your columns to fields

Mapping tells the import which column in your file belongs in which field on the record. DealJourney proposes a mapping for you, shown with an KI-konfidensgrad per column (KI-forslag brukt).

Check every proposal, especially the confident ones. A column mapped to the wrong field imports cleanly and silently: no error, just data in the wrong place, found weeks later. The confidence score describes the guess, not whether it is right. A column whose name is exactly the field's name, in the language you use DealJourney in, is shown as a certain match.

Each field gets one column. When two columns would fit the same field, such as a full name next to separate first and last names, the proposal gives the field to the better fit and leaves the other unmapped or moves it to its next best field. The proposal is also double-checked: when the second check would pick a different field, the column is moved to the ones that need your attention, and its explanation names the alternative. Start your review there.

Felt som ikke finnes i filen. A field can take its value from a column, or you can give every row in the file the same value for a field the file does not have. Under the column list, choose Legg til et felt, pick the field and its value: one customer type, one account manager, one source or campaign for the whole import, without adding a column to the spreadsheet. The value is treated exactly as if the file had a column holding it on every row, so it also applies to records the import updates, not only to new ones. A person is picked by name and matched by their email. Saved mappings remember these values too.

Custom fields are importable. Any field your company has added appears in the Databasefelt list alongside the built-in ones, so your own project numbers and categories arrive with everything else instead of being typed in afterwards.

Linking to customers. Automatisk Kundetilknytning (Anbefalt): Koble {{model}} automatisk til eksisterende kunder i din leietaker. Velg hvilket felt på kunden det skal matches mot, og velg deretter CSV-kolonnen som inneholder den verdien.

You choose what to match on, and the choice decides how well it works:

• Kundenavn: Velg CSV-kolonnen som inneholder kunde-/firmanavn. Vi matcher dem mot eksisterende kunder i systemet ditt (uten å skille mellom store og små bokstaver).
• Organisation number, which is the more reliable option whenever you have it. Verdier normaliseres til kun sifre, så formateringsforskjeller ignoreres. Names vary in punctuation and legal suffix; registration numbers do not.
• A custom field, when your own reference is what ties the two together. Matcher kunder der det egendefinerte feltet «{{field}}» er lik verdien i denne kolonnen.

Rows whose customer cannot be matched still import: they simply arrive unlinked, which is easy to miss because nothing fails. Check for records with no customer after an import rather than assuming everything connected.

Save a mapping and use it again. When the same export arrives every month, Lagre som mal… keeps the whole set-up: which column goes where, the fixed values, the primary record type and the note you wrote about the file. Saved mappings belong to the workspace, so a colleague can use yours.

They are listed under Lagrede maler on the first import screen, before you choose a file, where you can also delete one you no longer need. Click one to choose it, then choose your file: the file goes straight to the mapping step with that saved mapping applied, without the AI matching. Click the chosen one again to go back to mapping without it. If you did not choose one, a saved mapping that matches the file's columns is offered straight away, and Last inn mal on the mapping step lets you pick any of them by hand. Columns the file no longer has are dropped, and columns the saved mapping does not know about are left for you to map.

Fjern alle tilordninger starts the mapping over. Fjern alle tilordninger og start på nytt? Filvalget ditt beholdes.