• houdini987
  • NEWBIE
  • 0 Points
  • Member since 2005

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Hello all.

First timer here, I'm hoping someone has tried this before and can lend a hand.  We have the Professional license of Salesforce and I just downloaded the Excel Connector Add-In.  I'm able to query the case table without a problem, but I have some unanswered questions...

1) I cannot retrieve any data from CaseComment, CaseSolution, or Solution (receive "No data returned for this Query").  I know I have comments and solutions posted against my sample data online--is this a software limitation?    

...fyi, I did install the Professional Edition of Excel Connector

2) When looking at the Case data, it appears that each case is issued an internal (hex?) CaseID number.  I'm assuming this is some sort of RecordID.  If I want to import my legacy cases through this interface, will I have to create new CaseID's for them?  If so, what rules need to be applied to draw up these new numbers?

Many thanks to whoever reads this and takes the time to repond!