Importing resources problem

[Mike Arrowsmith]

I have attached a CSV file from which I’m trying to import a small sample dataset from the thousands we need to migrate. It has a ResourceID field populated with UUIDs but when I run the import_business_data command, I get the message:

ERROR: No column 'ResourceID' found in business data file.

Please add a 'ResourceID' column with a unique resource identifier.

I’m at a loss to see what I've done wrong though quite prepared to believe I've missed something obvious. I've also attached the mappings file.

The full command I’m using is:

python manage.py packages -o import_business_data -s 'imports/Coastal Heritage Site.csv' -ow overwrite

[Ryan Anderson]

Hi Mike,

I'm not sure exactly what is wrong here but it appears to be some sort of formatting error. I was able to import your csv file (to another resource model) by copying 'ResourceID' from the error message you received and pasting over the name of your current ResourceID column name.

Let me know if you've already tried this or if it works for you.

Ryan

[Carlisle, Philip]

Hi Mike,

I notice that your mapping file doesn’t have a ResourceID node. In the snip below I’d expect it to be between Report ID and SCHARP description.

 

This may not be the issue but if you’re importing UUIDs in you will need a node to store the value. Also in the spreadsheet you attached the ResourceID appears to just be a plain integer rather than a GUID

 

 

 

 

 

Phil Carlisle

Knowledge Organization Specialist

Information Analysis

Policy and Evidence Group

Historic England

Direct Dial: +44 (0)1793 414824

 

Many Historic England staff are working remotely at the moment and we are doing what we can to maintain our level of response but please bear with us as this may be slower than usual.

 

http://www.heritagedata.org/blog/

 

From: arches...@googlegroups.com <arches...@googlegroups.com> On Behalf Of Mike Arrowsmith
Sent: 26 April 2020 19:42
To: Arches Project <arches...@googlegroups.com>
Subject: [Arches] Importing resources problem

 

THIS IS AN EXTERNAL EMAIL:  do not click any links or open any attachments unless you trust the sender and were expecting the content to be sent to you

--
-- To post, send email to arches...@googlegroups.com. To unsubscribe, send email to archesprojec...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups "Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to archesprojec...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/ad55a6d7-a293-4df1-8f3a-610a82a804cf%40googlegroups.com.

We are the public body that helps people care for, enjoy and celebrate England's spectacular historic environment, from beaches and battlefields to parks and pie shops.
Follow us:  Facebook  |  Twitter  |  Instagram     Sign up to our newsletter     

This e-mail (and any attachments) is confidential and may contain personal views which are not the views of Historic England unless specifically stated. If you have received it in error, please delete it from your system and notify the sender immediately. Do not use, copy or disclose the information in any way nor act in reliance on it. Any information sent to Historic England may become publicly available. We respect your privacy and the use of your information. Please read our full privacy policy for more information.