Jump to content
samwoo

Hornbill CSV Asset Import

Recommended Posts

Hello,

We have come across some issues with the Hornbill CSV Asset Importer:

  1. The latest version of the CSV Asset Importer doesn't have the .exe files in there. I had to use the previous version.
  2. The "Location Type" field we originally populated this with a value of "Physical" and it failed with an error. I found out that it should be " 0 " for Physical. When using this, it imports successfully but the "Location Type" field is left blank. Does this mean the "Location" needs to be populated as well?

We are othewise really impressed with how easy it is to use this tool - thank you.

Cheers,

Samuel

Share this post


Link to post
Share on other sites

Hi @samwoo,

The latest release of the CSV importer (v1.1.0), released on 04/12/2017, does include the executables, and is accessible from here:

https://github.com/hornbill/goCSVAssetImport/releases/latest

With regards to the Location Type, I'll have a look and see what's going on there as this field should be independent from the Location field. I'll let you know when I've found what's causing this.

Kind regards,

Steve

Share this post


Link to post
Share on other sites

Hi @Steve G,

Apologies I think i clicked on the wrong download link in the first place, and many thanks for looking into the Location Type issue that we had.

Many thanks,

Samuel

 

Share this post


Link to post
Share on other sites

Hi @samwoo,

I've had a look at the CSV asset importer, and defined the h_location_type column to be populated using the locationType mapped column from a dummy CSV file, and the location type is populated correctly.

So from the config file:

image.png

And the CSV & resulting asset once the import has ran:

image.png

 

I've also tried hard-coding the h_location_type value in to the config JSON, but still the field is populated as expected:

 

image.png

So I'm not sure why your assets are not populated with the location type I'm afraid. If you want to PM me a snapshot of your CSV, and a copy of your import config, then I'll take a look and see if I can spot what's different for you.

Kind regards,

Steve

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×