Here are your files - altered
Also added the prefix “P”
Use Dynamo 0.9.2, it should work fine.
Piling-test.rvt
Pile-Auto-Number-with-Spline-type-2.dyn