csv - Using Apex Data Loader to load records into object with master details relationship -

-

i need load data 2 objects. able load data 1 object using data loader. second object has master-details relationship first object need have unique record id of records of first object in csv file. how can add record id's csv file?

you download "master" records after initial upload , perform mapping similar (name -> id). in excel achieved vlookup. once have generated new list of "detail" objects, there should no problem uploading them. mapping "id->uploaded records" available in success log file created apex data loader.

but better way loudly "screw salesforce id, don't need no stinking id" :) think if "master" has unique field. can "id" existing system import salesforce. create field in salesforce (if didn't already) , mark "external id". afterwards able use external id instead of normal salesforce id way make link between source , target. in pseudocode:

with normal salesforce id must

insert detail_object (name, somevalue, master_id) values ("foo", "bar", [some valid salesforce id])

with external ids can have easy , tell salesforce heavy lifting

insert detail_object (name, somevalue, master_id) values ("foo", "bar", (select id master_object some_field_marked_as_external_id = "123")

check out data loader user guide quick start , play external ids if can (in free developer edition maybe?). it's easier use describe it.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more