10-07-2010 01:12 PM
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
Solved! Go to Solution.
10-07-2010 02:08 PM
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.
10-07-2010 05:38 PM - edited 10-07-2010 05:39 PM
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