Problems to set account_id in sql statement

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello. Can someone help me ?

I’m pushing documents to suitecrm database with a software called Drivve, in this statement I want to do one more thing.
Set account_id and account_name

All documents now gets in the right place in upload folder, but in database it doesen’t have any account_id or account_name attached to it.

2 
Insert into documents (
id, 
date_entered,
date_modified,
modified_user_id, 
created_by,
description,
deleted,
assigned_user_id,
document_name,
doc_id,
doc_type,
doc_url,
active_date,
exp_date, 
category_id,
subcategory_id,
status_id, 
document_revision_id,
related_doc_id, 
related_doc_rev_id, 
is_template,
template_type)
Values(
"{DOC-GUID}",
"{TimeStamp}", 
"{TimeStamp}", 
"{user_id}", 
"{user_id}", NULL, '0', 
NULL,
CONCAT("<[Dokumenttype] name>", "-", "{TimeStamp}"),
NULL, 
"Sugar", 
NULL, 
"{TimeStamp}", 
CASE IFNULL("{Sluttdato Måned}", 0)
   WHEN 0 then NULL
   ELSE CASE IFNULL("{Sluttdato År}", 0)
      WHEN 0 THEN NULL
      ELSE LAST_DAY(STR_TO_DATE(CONCAT("01","{Sluttdato Måned}","{Sluttdato År}"), "%d%m%Y"))
   END 
END,
"<[Kategori] category_name>", 
"<[Kategori] subcategory_name>", 
"Active", 
"{DOC-GUID}", 
NULL, 
NULL, 
'0', 
NULL
)
3

I think you will be interested in reading this article

https://pgorod.github.io/How-Documents-Stored/