Author Topic: Pond5 CSV is not working form me. Anyone using it? (Read 5001 times)

NitorPhoto · « **on:** June 05, 2020, 01:26 »

I keep trying it since hours now on a hundred of different ways but I am going to a conclusion that it is broken. It never accepts my CSV even if it is EXACTLY in the format they describe. When it accepts my file just nothing happens, my tags are not added to the clips. Does anyone use it?

thestuckpixel · « **Reply #1 on:** June 05, 2020, 03:11 »

What columns do you use? And with what columns description?

jjneff · « **Reply #2 on:** June 05, 2020, 09:39 »

Hope these help!

https://youtu.be/PCcmm-9qMKY

https://youtu.be/egkFgCS_Kw8

NitorPhoto · « **Reply #3 on:** June 05, 2020, 10:57 »

Quote from: thestuckpixel on June 05, 2020, 03:11

What columns do you use? And with what columns description?

here are the first 2 lines....
OriginalFilename,name,description,keywords,releasenofileextension
"2020-03-29 foodorder_V1-0001.mov","Romantic couple at home drinking wine at dinner table","Elegant couple having romantic dinner at home, sitting at table in living room drinking red wine, clinking glasses, talking. Stay at home concept.","couple, drinking, wine, home, romantic, table, dinner, elegant, talking, clinking, concept, having, glasses, stay at home, red wine, living room, sitting, older, 50s, people, red, moody, indoor, indoors, love, middle aged, man, smiling, white, cosy, Caucasian, long hair, woman, room, wife, happy, husband, adult, holding, romance, communication, positive, alcohol, drinks, person, happiness, American, married, brunette, together",""

NitorPhoto · « **Reply #4 on:** June 05, 2020, 11:00 »

Quote from: jjneff on June 05, 2020, 09:39

Hope these help!

https://youtu.be/PCcmm-9qMKY

https://youtu.be/egkFgCS_Kw8

Thanks you for the help. The videos are good and useful. But I had no problem with the CSV upload at SS and Adobe. Only Pond5 is not working. In the video he downloads the CSV FROM Pond5 what I need is TO upload one - like I do on SS and Adobe.

thestuckpixel · « **Reply #5 on:** June 05, 2020, 11:18 »

Mantis · « **Reply #6 on:** June 05, 2020, 12:00 »

I could never get it to work. I manually do it.

Cider Apple · « **Reply #7 on:** June 05, 2020, 13:44 »

I've had issues in the past where if there was a space between words the system wouldn't recognize it. I also had a glitch where after effects renders would always have a space before the name of the clip started. Pond5 system hated this too.

arcfeatures · « **Reply #8 on:** June 07, 2020, 00:47 »

I use CSV to upload metadata to Pond5 all the time, had some trouble in the beginning, but now it's working pretty much flawlessly (the CSV is automatically generated in an application I wrote, so once I got it working, it has not been an issue since).
The system usually gives you feedback in the form of error messages. On the "Apply CSV" page below the submit button is where the error will appear if there is one during the processing (read every line to find the error). Also make sure to choose the appropriate information in the drop down menus above the button, otherwise it may not do anything upon pressing the button (or it may even process, but not apply the metadata to your assets).

One issue I could imagine is that your column headers are not contained in quotation marks. Here's how the headers look in my CSVs:

"originalfilename","title","description","keywords","copyright","location","price","pricelarge","priceweb","setpriceforme","aspectratio","specifysource","datecreated","containsaudio","cameraspeed","curatornote"

Not sure that's a requirement, though.

Also, perhaps try using "title" instead of the "name" column. I'm not sure what the difference is, but for me "title" is working fine.

NitorPhoto · « **Reply #9 on:** June 08, 2020, 14:27 »

Thanks for the reply! I also create the CSV with a self-made application. And I finally figured it out what caused the problem. My CSV was encoded in UTF-8 (the format they request) but truly it wasn't the raw UTF-8 but 'UTF-8 with BOM' (whatever it means). So I save the file in UTF-8 RAW and now it works flawlessly for me too.

Quote from: arcfeatures on June 07, 2020, 00:47

I use CSV to upload metadata to Pond5 all the time, had some trouble in the beginning, but now it's working pretty much flawlessly (the CSV is automatically generated in an application I wrote, so once I got it working, it has not been an issue since).
The system usually gives you feedback in the form of error messages. On the "Apply CSV" page below the submit button is where the error will appear if there is one during the processing (read every line to find the error). Also make sure to choose the appropriate information in the drop down menus above the button, otherwise it may not do anything upon pressing the button (or it may even process, but not apply the metadata to your assets).

One issue I could imagine is that your column headers are not contained in quotation marks. Here's how the headers look in my CSVs:

"originalfilename","title","description","keywords","copyright","location","price","pricelarge","priceweb","setpriceforme","aspectratio","specifysource","datecreated","containsaudio","cameraspeed","curatornote"

Not sure that's a requirement, though.

Also, perhaps try using "title" instead of the "name" column. I'm not sure what the difference is, but for me "title" is working fine.