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

Error after health check #178

Closed bryanpcall closed 6 years ago

bryanpcall commented 7 years ago

I keep getting this: 6/29/2017 10:52:19 PM,Transform Data,"System.ComponentModel.Win32Exception (0x80004005): The network path was not found"

I am trying to upload CSV Files match column for column as instructed Connection to database OK

Fails after the health check.

Suggestions?

rutledgek commented 7 years ago

I'm actually having the same problem.

waynepaulj commented 7 years ago

Trying to import a family file using the latest excavator.exe from 7/16/2017. Everything worked smoothly when I used excavator in 2016.
First, the "Select / Preview" screen is blank. The first record is not displayed. Secondly, at the end of the import the following displays: 11:29:40 AM Starting health checks... 11:30:07 AM Checking for existing people... 11:30:11 AM Starting data import... 11:30:11 AM Completed import: 0 rows processed. 11:30:11 AM Could not finish upload. Check the exceptions log for details.

After closing the program, there is not a log file in the logs folder. Not sure what I am doing wrong. Any suggestions will be appreciated.

scridget commented 6 years ago

We are also having a similar issue of the excavator failing after/during the health check.. Our error is that "The system could not the file specified". We're running everything as administrator, and have all permissions opened up on the files themselves. It seems like it's able to read the file in the columns preview before the import, but it fails every time.

scridget commented 6 years ago

Actually! Just found my answer here: https://github.com/NewSpring/Excavator/issues/170

dcs619 commented 6 years ago

170 was the connection string not being set correctly, but if the Select / Preview screen is blank then Excavator wasn't able to read your import file.

If you have a running Rock instance you can copy the <RockContext> string out of RockWeb\web.connectionstrings.config and paste that into Excavator.exe.config. Don't change the connection string from the app (it will load from the config file) and see if that works.