Skip to content

Import for SharePoint

Content import for SharePoint and Office 365

  • Home
  • Pricing
  • Documentation
  • Blog
  • Contact
Posted on July 10, 2018July 10, 2018 by wpadmin

Lookup Column

Destination Column

If you want to;

  • Set a value in a lookup column.
  • Import to a list that contains a lookup column
  • Import to a document library that contains a lookup column

You can use an import mapping of lookup;

Configuration

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<ImportMapping xsi:type="ImportMapping_Lookup">
<!-- This is the field of type lookup.-->
<DestinationField>Job</DestinationField>
<SourceColumn>Job Title</SourceColumn>
<!-- This is the list that contains the lookup values -->
<LookupListTitle>Items</LookupListTitle>
<!-- This is the field in the lookup list the value of which
matches the value in the source column-->
<LookupFieldInternalName>Title</LookupFieldInternalName>
<!-- This is the CAML value type Text,Number,DateTime,Guid,MultiChoice,Lookup
for the field on in the lookup list that matches the value specified in the
source column -->
<LookupFieldCAMLType>Text</LookupFieldCAMLType>
</ImportMapping>

Source

The source could be;

  • Import Excel Data to SharePoint (7/10/2018)
  • Import ODBC Data to SharePoint (7/10/2018)
  • Import OleDb Data to SharePoint (7/10/2018)

Further thoughts

If you want to;

  • Set a value in an external lookup column.
  • Import to a list that contains an external lookup column
  • Import to a document library that contains an external lookup column

Then do get in touch.

CategoriesImportMappings TagsMeta Data

Post navigation

Previous PostPrevious Create Folders
Next PostNext Create Publishing Page

Topics

  • Documents
  • Document Sets
  • Excel
  • Folders
  • Items
  • Legacy System
  • Meta Data
  • ODBC
  • Pages

Further Reading

This blog article is a taster, you’ll need the documentation.

Get the Documentation

Import for SharePoint

Get Import for SharePoint
  • Home
  • Pricing
  • Documentation
  • Blog
  • Contact

Search

Proudly powered by WordPress