The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Bulk loading accounts
Posted: 14 Apr 09 11:59 AM
|
Hi,
I loaded about 180 new accounts using a temp table and writing insert sql like:
'INSERT INTO account (accountid, account, addressId, mainphone, createuser, createdate)
select accountid, [account-Account Name], addressid, [Account-Main Phone] ,'XXXXXXXXXXXXX', getdate() from standardAccounts'
Everything looks fine But Only admin can see these accounts on the front end.
I am missing something but not sure what.
Any suggestions will be greatly appreciated.
thanks,
Yogesh
|
|
|
|
Re: Bulk loading accounts
Posted: 14 Apr 09 12:50 PM
|
You must populate the SeccodeId column. In fact, there is a lot of stuff you must do. Run a sql trace and enter a new account via the UI to capture all of the required records and fields. Your best bet is to mimic the application.
Timmus |
|
|
|
Re: Bulk loading accounts
Posted: 14 Apr 09 2:35 PM
|
Yes. I did. Infact it is looking fine for the admin user. Just does not show up for other users. Do I need to publish or something??
I tried ctrl+F5 and completely logging out and back in.
It did not help.
|
|
|
|
Re: Bulk loading accounts
Posted: 14 Apr 09 2:36 PM
|
Yes. I did. Infact it is looking fine for the admin user. Just does not show up for other users. Do I need to publish or something??
I tried ctrl+F5 and completely logging out and back in.
It did not help.
|
|
|
|
Re: Bulk loading accounts
Posted: 14 Apr 09 10:05 PM
|
Yes you did what? You have missed something and the best way to track it down is to add an account through the UI and trace the database transactions. Then compare your code to what the application does. Something is different.
Another thing to trace is the select statement being issued. Login as admin and capture the SQL statement that returns the account(s). Login as a user that cant see the data - capture that SQL statement and compare to the admin statement.
And yes, I am trying to help you learn how to reverse engineer the system. Teach a man to fish and all that. 
Timmus |
|
|
|
Re: Bulk loading accounts
Posted: 15 Apr 09 10:15 AM
|
Hi Timm,
Your second tip helped. I did not populate _UC columns causing them to not appear on search. I am all set for this one now.
Thank you very much for your help on this. I really appreciate it.
|
|
|
|
Re: Bulk loading accounts
Posted: 16 Apr 09 4:17 AM
|
Here is another common issue when writing custom import solutions:
Remember to populate account.addressid and account.shippingid. There are places in SLX LAN client where it is assumed to be safe to do an inner join between Account and Adress tables on these fields - thus you must popualte them with valid addressid values or the inner joins will fail and zero records will be returned. |
|
|
| |
|