Inserting leads directly into the leads table

[gneal0907]

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

[RJLedger]

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.

[gneal0907 · Accepted solution]

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