Export error - no data

[huruhara]

Hi,

I'm using the SugarCRM open source version 4.5.1i. We just migrated SugarCRM to a server using OS MS Window Server 2003. We are using Apache default version that comes in the package.

After we migrated we found that we are unable to export data out from the Cases module. We were able to do so previously on the old server. The .CSV files only return the colum name but no data. I've check the db, there should be atleast 61 rows selected.

Need help. Is this php scipting issue or db issue.

Thanks.

[ptemplin7]

Best guess is a DB issue. I assume you are still using mysql.

Was the old server mysql as well? Check your file permission for the cases. If the rest of the DB still exports fine and used to something happen to that file (table) when it moved.

Also check that the labels you have for the columns in the export are exactly what you have in the DB. Look for something as simple as a period at the end or data issues int he first row. I have heard of simple things like an ' in a name can break the export or import.

One other thing to try as a test. Use the mysql commands to dump the table (in Linux its mysqldump, not sure for MS) do you get the values expect when dumping that set of tables? Use a sql tool and do a SELECT * from sugarcrm.cases; Do you get all 61 rows? if not look for DB corrupted record!
You can also try copying just those tables over again and doing a file compare.

Anyway hope this helps, Good luck chasing it down.

Paris

[huruhara]

Thanks for the reply ptemplin7. I'm begining to see some light at the end of the tunnel. I try to isolate the issue as per your instruction. The export process works find with other modules except for Cases. In Cases theres quite a numbers of customized colums that i created. I will investigate further. Yes I'm using mysql.

Thanks.