MicrostockGroup

Agency Based Discussion => Pond5 => Topic started by: NitorPhoto on June 05, 2020, 01:26

Title: Pond5 CSV is not working form me. Anyone using it?
Post by: 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?
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: thestuckpixel on June 05, 2020, 03:11
What columns do you use? And with what columns description?
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: jjneff on June 05, 2020, 09:39
Hope these help!

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

https://youtu.be/egkFgCS_Kw8
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: NitorPhoto on June 05, 2020, 10:57
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",""
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: NitorPhoto on June 05, 2020, 11:00
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.
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: thestuckpixel on June 05, 2020, 11:18
...
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: Mantis on June 05, 2020, 12:00
I could never get it to work. I manually do it.
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: Cider Apple 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.
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: 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.
Title: Re: Pond5 CSV is not working form me. Anyone using it?
Post by: NitorPhoto 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.


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.