1

I have an Excel file of accounts which is imported from a previous CRM version (2011), and I would like to import it to CRM Online. Some columns that hold integer values might also contain “null” in case the value does not exist.

These null values are causing errors and doesn’t allow the row to be imported, it displays the message “The source data is not in the required format.” How can I get around this and let the CRM ignore the cell data when “null” and not try to insert it into the CRM?

fixer1234
  • 27,064
  • 61
  • 75
  • 116
user3340627
  • 213
  • 1
  • 2
  • 16
  • 1
    **“Some columns that hold integer values might also contain “null” in case the value does not exist.”** Seems like a datatype mismatch issue. If the value is expected to be an integer but “null” values exist, perhaps they should be “0” instead? Maybe changing the datatype for the column(s) in question would help? – Giacomo1968 Sep 07 '15 at 02:01
  • 1
    Are your 'null' columns containing 'null' as text or are they empty? If this is the case just replace the text with empty column. There shouldn't be a problem importing empty columns. If there still is a problem filter out these fields in excel and do a separate import for the ones that have a value and the ones that don't. – Bojan Borisovski Sep 07 '15 at 07:49
  • That was the problem, changing the null cells to blank fixed it. Thanks a lot for your help! – user3340627 Sep 07 '15 at 09:36
  • @BojanBorisovski It would be better if your answer is posted as an answer and the original poster would accept it. Could you copy-paste your comment as an answer and maybe rephrase it as an answer (instead of a suggestion/question)? – agtoever Sep 11 '15 at 08:06
  • I have posted the same comment as answer. @agtoever thanks for the suggestion. user3340627 I am glad it could help. Please accept my newly posted answer (the same as the comment) as answer. – Bojan Borisovski Sep 11 '15 at 09:50

1 Answers1

3

Are your 'null' columns containing 'null' as text or are they empty?

If this is the case just replace the text with empty column. There shouldn't be a problem importing empty columns.

If there still is a problem filter out these fields in excel and do a separate import for the ones that have a value and the ones that don't.

Bojan Borisovski
  • 146
  • 3