AlexTumber Posted February 6, 2019 Share Posted February 6, 2019 Hi Everyone, In an update released this afternoon, we have added the ability to import suppliers via a csv spreadsheet through the Hornbill Admin Tool. Simply download the csv template and populate it with all of your new suppliers. If you need help with mapping the fields, there is a popup dialog which describes the data required for each column. The first row of the template is also populated with example data. As we introduce more features such as custom fields on the supplier form, as well as supplier visibility/permission checks, this template will be updated accordingly. If you have any feedback on this feature (both good and bad) we'd love to here it! We hope you find this new feature a useful addition. Alex 1 Link to comment Share on other sites More sharing options...
Gerry Posted February 6, 2019 Share Posted February 6, 2019 Great addition @AlexTumber 1 Link to comment Share on other sites More sharing options...
Dan Munns Posted February 7, 2019 Share Posted February 7, 2019 @AlexTumber looks good so far. Could we have the ability to upload images as part of the import (Supplier logos) from a UNC path? 1 Link to comment Share on other sites More sharing options...
AlexTumber Posted February 7, 2019 Author Share Posted February 7, 2019 @Dan Munns thanks for your feedback. I think this is a good idea. I'll pass this onto our development team. Alex Link to comment Share on other sites More sharing options...
Dan Munns Posted February 8, 2019 Share Posted February 8, 2019 @AlexTumber or another idea, allow us to link to an image online and import the url to the image.Will probably be easier just looking online for the images that downloading them all. Another quick thought, can we have the images centre; centre justified. I have noticed that some of the images move to the top and drives my ocd mad lol 1 Link to comment Share on other sites More sharing options...
JanS2000 Posted August 24, 2022 Share Posted August 24, 2022 Hi, I know this is an older post but we're still relatively new to Hornbill, and I'm in the process of populating our suppliers in the supplier manager app. I've downloaded the template and added our suppliers, there are only around 85 entries. How long should it take to run? Thanks. Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 14 hours ago, JanS2000 said: Hi, I know this is an older post but we're still relatively new to Hornbill, and I'm in the process of populating our suppliers in the supplier manager app. I've downloaded the template and added our suppliers, there are only around 85 entries. How long should it take to run? Thanks. Just an update on this, I cancelled the upload last night as I had to log off, so started it again this morning and so far it's been over 30 minutes and it hasn't uploaded yet. There aren't that many to upload so not sure it should take this long. I don't get any errors, just "processing suppliers" and the Hornbill logo swirling constantly. Link to comment Share on other sites More sharing options...
AlexTumber Posted August 25, 2022 Author Share Posted August 25, 2022 @JanS2000 thanks for your post. It definitely shouldn't take long. Possibly 1 second per supplier so it looks like there is an issue that isn't being handled correctly. Can I ask if there is any more information in your server service log? Alex Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 Thanks Alex, it might be something I'm doing wrong, but I can't figure out what. Where will I find the server service log? Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 6 minutes ago, JanS2000 said: Thanks Alex, it might be something I'm doing wrong, but I can't figure out what. Where will I find the server service log? Actually I think I've found the log files, in platform config? I'll have a look through and see if anything stands out and post back, thanks. 1 Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 39 minutes ago, AlexTumber said: @JanS2000 thanks for your post. It definitely shouldn't take long. Possibly 1 second per supplier so it looks like there is an issue that isn't being handled correctly. Can I ask if there is any more information in your server service log? Alex Hi Alex, I've checked the log and nothing stands out, no errors relating to supplier manager. It's just finished processing and this is the error that came up: I've used the template I downloaded from supplier manager import. Not all the fields are populated as I don't have the relevant info, so I wonder if I'm missing some mandatory fields, although I thought it normally gave a list of errors - it did when I uploaded equipment to the asset list. Link to comment Share on other sites More sharing options...
AlexTumber Posted August 25, 2022 Author Share Posted August 25, 2022 @JanS2000 if you are using chrome as your browser, press f12 to bring up the developer tools and click the network tab at the top. Then try and import your supplier spreadsheet. You should see an api call on the left per supplier record. I suspect one of these is failing. If you click on the response tab, can you see any error message? Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 10 minutes ago, AlexTumber said: @JanS2000 if you are using chrome as your browser, press f12 to bring up the developer tools and click the network tab at the top. Then try and import your supplier spreadsheet. You should see an api call on the left per supplier record. I suspect one of these is failing. If you click on the response tab, can you see any error message? I'll give this a go and come back to you. Thanks! Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 This is what I get, I saw similar error running this tool in Edge, which is our default browser. Link to comment Share on other sites More sharing options...
AlexTumber Posted August 25, 2022 Author Share Posted August 25, 2022 @JanS2000 ok thanks. I will pass this back to our development team. Looks like a bug that we should be able to fix today. Alex Link to comment Share on other sites More sharing options...
JanS2000 Posted August 25, 2022 Share Posted August 25, 2022 17 minutes ago, AlexTumber said: @JanS2000 ok thanks. I will pass this back to our development team. Looks like a bug that we should be able to fix today. Alex Brilliant, thank you! 1 Link to comment Share on other sites More sharing options...
JanS2000 Posted August 26, 2022 Share Posted August 26, 2022 20 hours ago, AlexTumber said: @JanS2000 ok thanks. I will pass this back to our development team. Looks like a bug that we should be able to fix today. Alex Morning @AlexTumber, I've just tried the import after the application update and it's worked this time, thank you! 1 Link to comment Share on other sites More sharing options...
JanS2000 Posted August 26, 2022 Share Posted August 26, 2022 I think I spoke too soon, when I've clicked save to validate the first one, it's just doing the scrolling wheel of death constantly. There wasn't anything to update, but presume I need to go in to each record to verify/validate the info and add additional, but the records contain all the information I have on record already, so no changes made. Link to comment Share on other sites More sharing options...
JanS2000 Posted August 26, 2022 Share Posted August 26, 2022 I was doing it wrong, sorry! It's working 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now