search

KingdomFirst / Excavator

We have now released Bulldozer on GitHub. Bulldozer is the super-powerful big brother to Excavator. Because Bulldozer is now published on GitHub we will no longer be supporting Excavator. Thank you for all the support here!
https://github.com/KingdomFirst/Bulldozer
19 stars 20 forks source link

Import Failed - No Logs #164

Closed markquisquirin closed 7 years ago

markquisquirin commented 7 years ago

Hi Guys,

I am trying to import a CSV file to my Rock DB. DB connection is OK and File has been read OK. image

Import preview doesn't show anything - just blank. image

Wh I ran the import I get import failed error and no logs created.

8:23:02 PM Starting health checks... 8:23:11 PM Checking for existing people... 8:23:11 PM Starting data import... 8:23:11 PM Completed import: 0 rows processed. 8:23:11 PM Could not finish upload. Check the exceptions log for details.

image

Are you able to guide me on this? Thanks.

Rock Version: Rock McKinley 6.1 SQL Server: SQL 2012 Express on an Azure VM 2012R2 CSV file from: PCO, (formatted as per excavator instruction format)

dcs619 commented 7 years ago

Hi @genchuba, it sounds like the CSV importer couldn't read the headers on your files.

You may want to verify the CSV is formatted correctly using a site like flat-file.net.