Forum Discussion

NoreenJustice's avatar
NoreenJustice
Qrew Trainee
6 years ago

Auto Import from Excel Resulting in Character Problems

I am using an auto import (.net tool that uses the QB API built by someone else) process to load records into QB from an .xlsx file. The file contains text fields that are coming over with some character corruption. For example, a single and double quote ' and " are coming over as â?  The text field is used for a narrative with comments from people so the quotes are important and are needed. This issue does not occur when doing a manual import using the same .xlsx file.

Anyone have any ideas? Font related maybe?

#excel, #Dataimportandexport

​​​

------------------------------
Noreen Justice
------------------------------
Data import and export
excel
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Noreen,

    This sounds like an Encoding problem.   The .Net script needs some tweaking to make sure that the non alphanumeric characters such as ",% are parsed and Encoded to be imported.  I have had this problem multiple times with moving data in and out of QB.

    You should go back to the original developer and discuss the issue.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • NoreenJustice's avatar
      NoreenJustice
      Qrew Trainee
      6 years ago
      Thanks Don, I appreciate the feedback!

      ------------------------------
      Noreen Justice
      ------------------------------