Need Help? Let's Find the
Answer Together!

Sorry, we didn't find any relevant articles for you.

Send us your queries using the form below and we will get back to you with a solution.

Support Home FAQ Import Files When selecting a file we get BLOB is not a valid UTF-8 string

Table of Contents

1. Open with Notepad and Save as UTF-8 format

When selecting a file we get BLOB is not a valid UTF-8 string

Table of Contents

1. Open with Notepad and Save as UTF-8 format

The most common cause for this is importing a file that is not a CSV (for example, importing an Excel format file). Check you're importing a CSV. If that doesn't solve it, try the steps below.

1. Open with Notepad and Save as UTF-8 format

The simplest way to fix this is to open with windows notepad, then select File > Save As - Next ot the SAVE button, select "UTF-8" from the encoding picklist and then SAVE.

When selecting a file we get BLOB is not a valid UTF-8 string How do we create recurring payments from Import Files? What fields are required to import Credit Cards? What fields are required to import tokenised cards? How can I Import Direct Debits? Which Transactions will be charged when Importing Cards/Direct Debits? Do I need to do anything about the warning that is displayed in step 2 of the import file process? How many rows of data can I Import? Should I import Credit Card and Direct Debits in the one Import Batch? Should we import fundraisers first? Fundraisers are not being correctly matched, or are Created and linked to the wrong Account/Household When I process the batch, the "Import File Line Item Payment Txn's" are not being created In Peer-to-Peer imports, the fundraiser's contact role is being listed as Soft Credit, but I want it to be listed as Fund Raiser. How do I update it? I keep getting errors with "Bad value for restricted picklist", but I checked and the value is exactly as it appears in the picklist. What's wrong with it? How do I remove old custom import templates that I don't use any more? How to Import Expiry Date to Recurring record if the import file feature is not used to charge card or for an auth transaction? Do Import Files send Receipts? Why the Import has not loaded any line items or why is the total amount is $0 Why can users not save the Import File Templates or they are getting an access error to Import File Settings Object Which Campaign is allocated if there are multiple campaigns with the same name - e.g. John’s Birthday Why am I not getting the Import file processing email confirmation? How to trigger the import file processor manually? Why is the Expiry date not being stored on the Payment Txn and Recurring payment? Why is an Opportunity not created for the first/ Auth transaction when importing recurring payment data? Import cannot proceed because Authorise Transaction workflow/flow is enabled

Updated at July 27th, 2024