I tried making my json file into the new assistant but it say this error
There was an error uploading the file appointments.json: Invalid file format. Supported formats: [‘c’, ‘cpp’, ‘csv’, ‘docx’, ‘html’, ‘java’, ‘json’, ‘md’, ‘pdf’, ‘php’, ‘pptx’, ‘py’, ‘rb’, ‘tex’, ‘txt’, ‘css’, ‘jpeg’, ‘jpg’, ‘js’, ‘gif’, ‘png’, ‘tar’, ‘ts’, ‘xlsx’, ‘xml’, ‘zip’]
but i tried making in a json file and a csv file both didn’t work
Hi,
What happens if you try and upload your file using the playground assistants page?
I get the same error when i try using the playground assistant.
Only for that file or for any file?
(extra words for the minimum sentence length checking bot)
I tryed using the same file in csv and json both formats didn’t work
Ok, but what about a totally different file? I just uploaded a pdf and it was fine, then i tried an html and that was fine, so I’m trying to see if there is something specific in that file or if it’s with your account/upload environment.
When i make a different file it works i tryed another file with pdf format and it worked. The only stuff that is in my csv file i would like to use are just some dates i got from google calendar
can you upload the file to a google drive and link it here?
here would be the link
https://drive.google.com/drive/folders/1lhEeZe8E9oRVeODDrhnxt75XntC_FqWl?usp=sharing
Ok i found out the error
in the file it had problems
{
“date”: “2023-11-12”,
“time”: “16:00:00”,
“summary”: “ajdjsad”
},
it has to be like this
thank you for your help
I’ve encountered the same issue. I wonder what went wrong.
const file = await AssistantHandler.UploadFiles({
file: [
{
"start": "2023-11-14T15:30:00+01:00",
"summary": "skdkasd",
},
{
"start": "2023-11-14T19:00:00+01:00",
"summary": "jadslk",
},
],
user_id: "ouG890XHkqh79nvlHQzftGkjKvEE",
date: "2021-10-17",
type: "prescription",
});
static CreateLocalFile = async ({ file, user_id, date, type }) => {
try {
const filePath = path.join("/tmp", `${user_id}-${type}-${date}.json`);
file.forEach((obj) => {
const jsonString = JSON.stringify(obj);
fs.appendFileSync(filePath, jsonString + "\n");
});
return filePath;
} catch (error) {
console.error("Error creating local file:", error.message);
throw error;
}
};
static async UploadFiles(params) {
try {
const filePath = await this.CreateLocalFile(params);
const fileStream = fs.createReadStream(filePath, { encoding: "binary" });
const response = await this.openai.files.create({
file: fileStream,
purpose: "assistants",
});
fs.unlinkSync(filePath);
return response;
} catch (error) {
console.error("Error uploading file:", error.message);
throw error;
}
}
You need to make the json like this
{
“date”: “2023-11-12”,
“time”: “17:00:00”,
“summary”: “jasdlk”
},
it doesn’t work when you have the T15:30:00+1:00 behind
It’s still an error. What exactly went wrong?
const file = await AssistantHandler.UploadFiles({
file: [
{
start: "2023-11-14",
summary: "skdkasd",
},
{
start: "2023-11-14",
summary: "jadslk",
},
],
user_id: "ouG890XHkqh79nvlHQzftGkjKvEE",
date: "2021-10-17",
type: "prescription",
});
static CreateLocalFile = async ({ file, user_id, date, type }) => {
try {
const filePath = path.join("/tmp", `${user_id}-${type}-${date}.json`);
file.forEach((obj) => {
const jsonString = JSON.stringify(obj, null, 2);
fs.appendFileSync(filePath, jsonString + "\r\n", "utf8");
});
return filePath;
} catch (error) {
console.error("Error creating local file:", error.message);
throw error;
}
};
static async UploadFiles(params) {
try {
const filePath = await this.CreateLocalFile(params);
console.log("readFileSync", fs.readFileSync(filePath, "utf8"));
const fileStream = fs.createReadStream(filePath);
const response = await this.openai.files.create({
file: fileStream,
purpose: "assistants",
});
fs.unlinkSync(filePath);
return response;
} catch (error) {
console.error("Error uploading file:", error.message);
throw error;
}
}
where is the time?
{
start: “2023-11-14”,
summary: “skdkasd”,
},
you just have the date and the summary
I replaced the data with new values, but it’s still incorrect.
const file = await AssistantHandler.UploadFiles({
file: [
{
"user_id":"ouG890XHkqh79nvlHQzftGkjKvEE1",
"nickName": "abcdefg1"
},
{
"user_id":"ouG890XHkqh79nvlHQzftGkjKvEE2",
"nickName": "abcdefg2",
},
],
user_id: "ouG890XHkqh79nvlHQzftGkjKvEE",
date: "2021-10-17",
type: "prescription",
});
Are you still experiencing the error? Cause I experience the same. My .json is the following:
{"profile_titles":["Senior Backend Developer","Software Engineer"],
"recent_skills":["NoSQL", "Wireframing", "Figma"],
"other_skills":["XML", "Testing"],
"recent_competencies": ["quick learner", "driven"],
"other_competencies": ["resilient", "flexible"],
"recent_experiences": ["launched product from scratch", "scaled the engine to 10m/week processed items"],
"other_experiences": ["driving company growth from 10 to 100 people"],
"location_current": "London, UK",
"experience_years": 5,
"work_permit_country": "Switzerland",
"languages": ["fluent English", "basic German", "native Italian"],
"certifications": ["PMI", "Scrum"],
"educations": ["MSc in Engineering from TU Berlin", "BSc in Management, MIT"]
}
Ani ideas why it might not let it in?
I’m experiencing the error and have no idea what can it be. I tried with a simple json file and still getting the error
{
“products”: [
{“name”:“bed”,“price”:“10”}
, {“name”:“table”,“price”:“5”}
, {“name”:“chair” ,“price”:“2”}
, {“name”:“mouse”,“price”:“0.5”}
, {“name”:“screen”,“price”:“5”}
]
}
“I added the following code at the top, and it can be uploaded successfully, but this is not a standard JSON format.”
fs.writeFileSync(filePath, "application/json\n", "utf8");
If this helps, i tried uploading a json file that with less than 1kb size and it throws me the invalid file format error. Then i added items to the file until it’s was more than 1kb and the upload was successfully. But the i tried with this json file:
{
“products”:
}
26bytes and it uploaded successfull.
So i don’t if this is the correct behavior but i’ll just upload 1kb+ json files
I got the same error on the assistant UI while uploading a simple JSON file.
Eventually I had to enclose the whole json in single quotes like ‘{“key”:“value”}’.
I was able to upload the file this way, but then when it was trying to load the file it had to fix the file.
The file appears to contain JSON data, but it starts with an extraneous single quote character. This is likely causing the JSON parser to fail. I will remove this character and then attempt to parse the JSON data again.