Uploading csv File Not Working
reneidig496
3 Jun 2021 22:54
hi! Every time I try to upload a csv file I get the following message:
Please define "clipid", "originalfilename", "originalfilenamestart" or "namematch" to be used as a key.array ( 'originalfilename' => 0, 'title' => 1, 'description' => 2, 'keywords' => 3, 'location' => 4, 'copyright' => 5, 'setpriceforme' => 6, )
The key information is either clipid or the originalfilename. Either one of the keys MUST always be included, both cannot be used in one CSV.
Can anybody help me with what I am doing worng? I am using the template I downloaded from Pond5.
THANKS!
Rob
Please define "clipid", "originalfilename", "originalfilenamestart" or "namematch" to be used as a key.array ( 'originalfilename' => 0, 'title' => 1, 'description' => 2, 'keywords' => 3, 'location' => 4, 'copyright' => 5, 'setpriceforme' => 6, )
The key information is either clipid or the originalfilename. Either one of the keys MUST always be included, both cannot be used in one CSV.
Can anybody help me with what I am doing worng? I am using the template I downloaded from Pond5.
THANKS!
Rob
Ryan
4 Jun 2021 16:44
Hey Rob,
Thanks for reaching out! CSV issues could be any number of things, so please send us an email with the CSV attached to support@pond5.com. We'll take a look and let you know what the issue could be, and will send you back working file for you to apply!
Thanks,
Thanks for reaching out! CSV issues could be any number of things, so please send us an email with the CSV attached to support@pond5.com. We'll take a look and let you know what the issue could be, and will send you back working file for you to apply!
Thanks,
Paha_L
9 Dec 2023 19:14
i have the same problem.
Please define "clipid", "originalfilename", "originalfilenamestart" or "namematch" to be used as a key.array ( 'title "originalfilename" "description" "keywords" "specifysource" "release" "pricelarge" "price" "editorial" "copyright"' => 0, )
I have send my CSV to support. They return me bad edited my csv.
I need real help.
Please define "clipid", "originalfilename", "originalfilenamestart" or "namematch" to be used as a key.array ( 'title "originalfilename" "description" "keywords" "specifysource" "release" "pricelarge" "price" "editorial" "copyright"' => 0, )
I have send my CSV to support. They return me bad edited my csv.
I need real help.
Paha_L
11 Dec 2023 16:24
you have remove categories. after removing categories in OpenOffice and resaving csv will be such error with apply csv.
i can't open correctly csv in Exell , only in OpenOffice.
Now i solve problem with apply csv. i must remove categories before making csv.
Best, Pavel.
i can't open correctly csv in Exell , only in OpenOffice.
Now i solve problem with apply csv. i must remove categories before making csv.
Best, Pavel.
Paha_L
11 Dec 2023 17:36
when saving xls to csv - lost quotes.
helps macros -
Sub SaveAsCSVinQuotes()
Dim r As Range, c As Range, s As String
s = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "Сохранение в формате CSV в кавычках")
If s = "False" Then Exit Sub
Open s For Output As #1
For Each r In ActiveSheet.UsedRange.Rows
s = ""
For Each c In r.Cells
s = s & ";" & """" & c & """"
Next
Print #1, Mid$(s, 2)
Next
Close #1
End Sub
helps macros -
Sub SaveAsCSVinQuotes()
Dim r As Range, c As Range, s As String
s = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "Сохранение в формате CSV в кавычках")
If s = "False" Then Exit Sub
Open s For Output As #1
For Each r In ActiveSheet.UsedRange.Rows
s = ""
For Each c In r.Cells
s = s & ";" & """" & c & """"
Next
Print #1, Mid$(s, 2)
Next
Close #1
End Sub
AlexLlobet
20 Jan 2024 15:21
Thanks Paha_L for the code!
I just modified a tiny bit to make it work.
Separate with a "," comma, not a semicolon ";"
-----------------
Sub SaveAsCSVinQuotes()
Dim r As Range, c As Range, s As String
's = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "?????????? ? ??????? CSV ? ????????")
s = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "Saving as CSV with quotes")
If s = "False" Then Exit Sub
Open s For Output As #1
For Each r In ActiveSheet.UsedRange.Rows
s = ""
For Each c In r.Cells
s = s & "," & """" & c & """"
Next
Print #1, Mid$(s, 2)
Next
Close #1
End Sub
-----------------
For those of you with Excel, open the csv and save with extension "xlsm".
This allows the file to have the macro above so you can run it.
Then open the xlsm file, press Alt+ F11 to open the macro part of Excel and paste the above code (click Sheet1 on the left) and save the file.
To run the code, press F5 and save the CSV file with a new name.
The new CSV file is the one to upload.
This worked for me.
Please let me know if this works for you.
I just modified a tiny bit to make it work.
Separate with a "," comma, not a semicolon ";"
-----------------
Sub SaveAsCSVinQuotes()
Dim r As Range, c As Range, s As String
's = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "?????????? ? ??????? CSV ? ????????")
s = Application.GetSaveAsFilename(, "CSV Files (*.csv),*.csv,All Files (*.*),*.*", , "Saving as CSV with quotes")
If s = "False" Then Exit Sub
Open s For Output As #1
For Each r In ActiveSheet.UsedRange.Rows
s = ""
For Each c In r.Cells
s = s & "," & """" & c & """"
Next
Print #1, Mid$(s, 2)
Next
Close #1
End Sub
-----------------
For those of you with Excel, open the csv and save with extension "xlsm".
This allows the file to have the macro above so you can run it.
Then open the xlsm file, press Alt+ F11 to open the macro part of Excel and paste the above code (click Sheet1 on the left) and save the file.
To run the code, press F5 and save the CSV file with a new name.
The new CSV file is the one to upload.
This worked for me.
Please let me know if this works for you.
luo419773176220
28 Aug 2024 01:53
I solved this problem. When using office software, just save as .csv instead of UTF-8 option.