Update column values when bulk uploading to picture library

%3CLINGO-SUB%20id%3D%22lingo-sub-1523172%22%20slang%3D%22en-US%22%3EUpdate%20column%20values%20when%20bulk%20uploading%20to%20picture%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%223%22%3EHello%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EI'm%20trying%20to%20bulk%20upload%20images%20to%20the%20Picture%20Library%20under%20our%20site%20content%20using%20a%20CSV%20file%20via%20the%20SparePoint%20Migration%20tool.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EThe%20CSV%20template%26nbsp%3Bmentions%20updating%206%20columns%26nbsp%3Bfor%20information%26nbsp%3B-%203%20source%20and%203%20destination%20to%20make%20sure%20the%20files%20follow%20the%20right%20path.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3ESince%20we%20have%20other%20columns%20in%20our%20library%20-%20tagging%20the%20images%20as%20below%3A%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rb_CP_0-1594812330934.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205440iBCB03D71133657E0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22rb_CP_0-1594812330934.png%22%20alt%3D%22rb_CP_0-1594812330934.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3ECan%20I%20-%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E1.%20Add%20these%20columns%20to%20the%20CSV%20file%20that%20I'm%20uploading%20so%20the%20columns%20match%20and%20the%20information%20is%20updated%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E2.%20Is%20there%20any%20other%20way%20I%20can%20automate%20the%20process%20of%20column%20data%20matching%20without%20having%20to%20fill%20them%20out%20individually%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1523172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1540802%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20column%20values%20when%20bulk%20uploading%20to%20picture%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540802%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697295%22%20target%3D%22_blank%22%3E%40rb_CP%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EAbout%20%22%3CSPAN%3E%26nbsp%3BIs%20there%20any%20other%20way%20I%20can%20automate%20the%20process%20of%20column%20data%20matching%20without%20having%20to%20fill%20them%20out%20individually%3F%3C%2FSPAN%3E%22%3CBR%20%2F%3EAre%20the%20values%20present%20inside%20the%20pictures%3F%20(e.g.%20keywords%2C%20GPS%20location%2C%20...)%3F%3CBR%20%2F%3EIf%20so%2C%20there%20are%203rd%20party%20tools%20that%20will%20fully%20automate%20the%20process%20of%20filling%20the%20columns.%3C%2FP%3E%3CP%3EPaul%20%7C%20SLIM%20Applications%20(-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fwww.slimapplications.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.slimapplications.com%2F%3C%2FA%3E)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1706667%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20column%20values%20when%20bulk%20uploading%20to%20picture%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706667%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4831%22%20target%3D%22_blank%22%3E%40Paul%20de%20Jong%3C%2FA%3E%26nbsp%3BHi%20Paul%2C%20we%20tried%20using%20third%20party%20data%20extraction%20and%20realized%20that%20for%20other%20columns%20that%20had%20new%20information%2C%20we'd%20have%20to%20manually%20fill%20it%20in.%20We%20populated%20columns%20manually%20for%20a%20bulk%20of%20images%20we%20uploaded!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20though.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I'm trying to bulk upload images to the Picture Library under our site content using a CSV file via the SparePoint Migration tool. 

The CSV template mentions updating 6 columns for information - 3 source and 3 destination to make sure the files follow the right path. 

 

Since we have other columns in our library - tagging the images as below: 

 

rb_CP_0-1594812330934.png

 

Can I - 

1. Add these columns to the CSV file that I'm uploading so the columns match and the information is updated?

2. Is there any other way I can automate the process of column data matching without having to fill them out individually?

 

Thanks!

2 Replies

@rb_CP 
About " Is there any other way I can automate the process of column data matching without having to fill them out individually?"
Are the values present inside the pictures? (e.g. keywords, GPS location, ...)?
If so, there are 3rd party tools that will fully automate the process of filling the columns.

Paul | SLIM Applications (https://www.slimapplications.com/)

@Paul de Jong Hi Paul, we tried using third party data extraction and realized that for other columns that had new information, we'd have to manually fill it in. We populated columns manually for a bulk of images we uploaded! 

 

Thank you though. :)