[SalesForce] Import to Data Extension even if the CSV file has no rows (and has only header)

An import step of my automation fails. I tried to imitate that import manually and I realized that Salesforce does not continue the import when the file is empty. In my case, my file contains only the header and no rows.

But I do want to overwrite the destination Data Extension even when there are no rows. If the file is empty, I simply would like my Data Extension to be empty, too.

How can I let empty files count as import as well?

Best Answer

In order to do this, you will need to contact SFMC Support and request a business rule "Allow Blank File Processing" to be enabled on your instance.

This allows the import of empty files without halting the process. By default the settings in the backend force a stop on blank imports, but with this business rule enabled it is changed to continue.

Related Solutions

[SalesForce] Triggered Automation Studio: Data Extension Import Error

We're having the same problem. Have the file transfer activity before the import but we're still getting an error at the import step. It provides basically no information:

The error occurred during Step 5 of 6:

 5.1 ImportDefinition : Import_Sent
       Status: Error
       Start Time:  7/3/2014 10:30 AM Central Standard Time (no DST)
       Error Time:  7/3/2014 10:30 AM Central Standard Time (no DST)

Any information on anyone who got this to work would be amaaazing.

[SalesForce] Create SFMC data extension from CSV file

There's nothing built-in the platform to do something like that.

There's also nothing stopping you from writing something (in SFMC or not) with the SFMC Web Services to do it.

I use a combination of Excel and LINQPad script (using our own version of the SFMC SDK) to create Data Extensions.

Best Answer

Related Solutions

[SalesForce] Triggered Automation Studio: Data Extension Import Error

[SalesForce] Create SFMC data extension from CSV file

Related Topic