Import problem after intial install

[techsoft3d]

Hi all,

Linux server, client is firefox on the mac.


Fresh install on the server, all of the i's dotted and t's crossed. Then I import. The import file is a csv from a mysql query of the older contacts/customer DB that was created in house, ~6500 records. The CVS has gone through excel to clean up the data. On Sugarcrm I have created a bunch of custom fields to hold necessary data from the old db, support_status, vertical_market sales_leads etc etc. I map the fields in the third page of the import in what seems to be a proper and same manner, allow sugar to create the primary ID. The import seem to work. But when I then look accounts by clicking the tab, I get nothing. When I search for a name (IMSI) that I know is good, nothing. Here is the kicker, when I query

"select * from accounts where name = 'IMSI';"

I find my records.


I am confused....

[Angel]

What does the DELETED column show for that record when you execute the query?

[techsoft3d]

it shows 0

[techsoft3d]

Also i presume that I should see all of the imported accounts when I click on the account tab, if I have not specified anything to search for.

[techsoft3d]

also the latest, SugarPro-4.5.1e.

[Angel]

Does the same happen if you login as admin?

To which user are the accounts assigned to?

Does the same happen for accounts you type in?

What happens if you click "Clear" on the search form?

[techsoft3d]

good questions all,

my login is admin, I have not set up users as of yet, so the accounts are admin

clear doesn't help, and I have not yet added another other account, what is weird is that on my home page, the accounts list show up in my accounts.

E

[techsoft3d]

Does the same happen for accounts you type in?

What happens if you click "Clear" on the search form?

Yes even happens with accounts that I add,

I have started from th every begining, fresh unzip install w/dropped created sugar mysql. added one account "test" using the new account pane on acoounts page. cannot find it in the basic search.

[Angel]

Something is not right. I can't think of a reason why it would behave that way on a fresh install.

Can you elaborate on your environment? i.e. PHP and MySQL versions, web server, etc...

[nathanfunk]

I am having essentially the same problem as you. Fresh install, imported accounts and contacts (except I didn't add custom fields). Have you managed to look at the log? It should be sugarcrm.log in the install directory. I modified the log4php.properties file to:

log4php.rootLogger=fatal, A2
log4php.rootLogger=error, A2
log4php.rootLogger=warn, A2
log4php.rootLogger=info, A2
//log4php.rootLogger=debug, A2

I have some of my log output in this thread:

http://www.sugarcrm.com/forums/showthread.php?t=24508

I am curious whether yours has the same errors.

Nathan