Import of Opportunities not working correctly

[changfoot]

Hi all,

I've hit a snag with importing Opportunities.

I manage to upload the CSV, and import records, the Import Script says 20 records imported.

If I look in the DB, there they all are, with their correct assignments.

BUT, alas... When I goto my opportunity listing and list all opportunities, there is nothing there?

Not a single record appears in the list, yest the DB has records in it?


Am I missing something, I've imported before with success, except now each time I do it, it says successful, puts them in the DB but gives me stick when I view the listing?


any ideas?

[andopes]

Follow my tips here.

Cheers

[nickgiguere]

Hi ... I've run into the same problem but with Leads. I've imported leads and they show after import but then I did a search and bam, they are not there. Data is in the database but will not show in any view. I tried adding that line in the code to see the query but it doesn't seem to be working. Any advice?

[davidboris]

Hi,

Try echoing list view query (include/ListView/ListViewData,php) and run that query in database. Do you get result there?

[nickgiguere]

Thank you for the reply ... i've tried echoing the query per the link above .. it doesn't work for some reason. Not sure why.

e.g.:

         $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['inner_join']. $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];
 
echo "<LI>$main_query"; 
  

Hi,

Try echoing list view query (include/ListView/ListViewData,php) and run that query in database. Do you get result there?

[susiewilliams]

This may be an incredibly simple answer, but did you make sure you clicked the "Clear" button before searching for the Leads? Sugar saves your previous search criteria and if you want to see all records you'll need to click the Clear button before searching.

[davidboris]

Hi,

What is not working when you echo that query? Paste the query here which appears when you echo it.

And try the suggestion of Susie too.

Thank you for the reply ... i've tried echoing the query per the link above .. it doesn't work for some reason. Not sure why.

e.g.:

         $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['inner_join']. $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];
 
echo "<LI>$main_query";