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?
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.