Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Contributor
Posts: 10
Registered: ‎03-15-2010
Accepted Solution

Inserting leads directly into the leads table

Has anyone attempted to import leads directly into the tables?  I have done it with other entities in SLX without any issues arising, but when I run insert statements against the lead and lead_address table, the inserts run correctly, but the address will not show in the GUI.  I get an error message that states that the seccodeid is an invalid field?

 

I can insert the lead only, (I.E. Name, Company, Phone, Web Site, etc.) and then manually add the address to it via the GUI and it works fine?

 

Thoughts?

 

-Greg

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Inserting leads directly into the leads table

I suggest youdo:

   A - Take a look at the imports leads code (it's all there in VBSCRIPT)

   B - Run SlxProfiler when "manually" (via gui) adding a new lead.

 

These will show you how to properly add Leads.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Copper Contributor
Posts: 10
Registered: ‎03-15-2010

Re: Inserting leads directly into the leads table

[ Edited ]

Thanks for the input RJ!

I actually did exactly what you recommended and realized that I wasn't populating the leadaddressid field in the lead table.  Once I made sure that I had populated that, the lead was created correctly.

-Greg