Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

mapping - skipped worksheet

Hello,
I'm trying to run a mapping but I cannot import my worksheet in xlsx in the importer list. Can you tell me what's wrong ?
Here are my sheets (mapping and data).
Thank you very much !

Comments

  • the data sheet is not completely ready..

  • Hello
    I am not an expert but I tried checking your mapping refinery using the JSONlint online validator and it shows several errors. You could try going to JSONlint.com and pasting or retyping your refinery in the validator to try and fix it. For example the comma after "creator" in line 5 should not be there. Hope this helps.

  • Thank you for your response. I try to use JSONlint but I don't understand... It is said :
    Error: Parse error on line 1:
    Rule type, Source, C
    ^
    Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '[', got 'undefined'

    I think that I'm not good enough with code to use this tool...

  • Hi,
    You only have to copy this part of your mapping i.e. the refinery into the Validator
    {
    "relationships" : [
    {
    "relatedTable": "ca_objects",
    "type" : "drawing",
    "relationshipType": "creator", }}
    ,
    {
    "relatedTable": "ca_entities",
    "type" : "ind",
    "preferredLabels" : [{"forename": "^3", "surname":"^4"}],
    "attributes" : {
    "biography":"^5"
    }} {"matchOn": ["idno"]}

    It wIll look like this
    {
    "relationships": [{
    "relatedTable": "ca_objects",
    "type": "drawing",
    "relationshipType": "creator",
    }
    },
    {
    "relatedTable": "ca_entities",
    "type": "ind",
    "preferredLabels": [{
    "forename": "^3",
    "surname": "^4"
    }],
    "attributes": {
    "biography": "^5"
    }
    } {
    "matchOn": ["idno"]
    }

    Then run Validate JASON, it will show this error

    Error: Parse error on line 5:
    ...Type": "creator", } }, { "relatedT
    ----------------------^
    Expecting 'STRING', got '}'

    If you remove the comma after "creator"
    and run Validate again it will show what appears to be a bracketing error on line six - fix this and run Validate again until all the errors are eliminated.

    Just about every mapping I ever compiled failed on mistakes in the refinery and the only way to fix them is to just keep trying.
    You can also try just typing your refinery code directly into the Validator and sort out the mistakes there and then - this avoids copying any possible invisible characters/ formatting from your spreadsheet into the Validator. When you get it right you can copy and paste into your mapping. Hope this helps :)

  • This version of the refinery validates
    {
    "relationships": [{
    "relatedTable": "ca_objects",
    "type": "drawing",
    "relationshipType": "creator"
    },
    {
    "relatedTable": "ca_entities",
    "type": "ind",
    "preferredLabels": [{
    "forename": "^3",
    "surname": "^4"
    }],
    "attributes": {
    "biography": "^5"
    }
    }, {
    "matchOn": ["idno"]
    }
    ]
    }

  • Hello, Thank you very much for your explanations. I corrected some error but I always have the same message... Well, I asked my teacher, I will see if he can fix it.

Sign In or Register to comment.