[Isis-users] Jsonl files - import into ISIS

[spinaker]

Dear Renate

_Concerning your 2nd question, how to clean fields with <> chars_
a) prepare a text file, with this content
     <|
     >|
and save it with the name  xxx.txt

b) now you create a gizmo file
    mx seq=xxx.txt  create=triang now

c) Then you apply this gizmo to your databse
   mx your_base  create=xxx1 now -all tell=1000 gizmo=triang,tag1,tag2 
...  etc
   where tag1,tag2  are the fileds concernet, ex:  gizmo=triang,12,18,25

d) now you clean your database
    mxcp   xxx1  create=final clean tell=1000
   ready !!! enjoy it

_Now , let's see your first questions, about the conversion of a JSON 
text file into isis structure_
You sent me a file with examples, I copied below the first record
Maybe there is some converter out there (I don't know) but we'd need at 
least  the layout of the record, with definitions of the labels, then it 
would be possible to prepare a conversion procedure to substitute these 
labels with appropiate labels like examples below
!ID mmmmmm
!vXXX!...contents of tag XXX.............
!vYYY!...contents of tag YYY.............
...
Then you could use the CISIS program ID2I to convert the file , but 
first the first, do you have a definition of the layout?
Regards
Ernesto Spinak

------------------------------------------------------------------------
*JSON RECORD*
{"doi": "10.1080/21645515.2017.1330236",
"year": 2017,
"genre": "journal-article",
"is_oa": true,
"title": "Advancements in DNA vaccine vectors, non-mechanical delivery 
methods, and molecular adjuvants to increase immunogenicity",
"doi_url": "https://doi.org/10.1080/21645515.2017.1330236",
"updated": "2018-06-19T00:17:12.337035",
"publisher": "Informa UK Limited", "z_authors":
[  {"given": "John J.",
     "family": "Suschak",
      "affiliation":
      [  {"name": " U.S. Army Medical Research Institute of Infectious 
Diseases, Fort Detrick, MD, USA"} ]
      },
      {"given": "James A.",
         "family": "Williams",
          "affiliation":
       [  {"name": " Nature Technology Corporation, Lincoln, NE, USA"}]},
      {"given": "Connie S.", "family": "Schmaljohn", "affiliation": 
[{"name": " U.S. Army Medical Research Institute of Infectious Diseases, 
Fort Detrick, MD, USA"}]}],
    "journal_name": "Human Vaccines & Immunotherapeutics",
    "oa_locations":
    [{"url": "http://europepmc.org/articles/pmc5718814?pdf=render",
     "pmh_id": "oai:pubmedcentral.nih.gov:5718814",
        "is_best": true,
          "license": "cc-by-nc-nd",
          "updated": "2018-01-22T13:10:35.073612",
          "version": "publishedVersion",
          "evidence": "oa repository (via OAI-PMH title and first author 
match)",
          "host_type":
          "repository",
          "url_for_pdf": 
"http://europepmc.org/articles/pmc5718814?pdf=render",
          "url_for_landing_page": 
"http://europepmc.org/articles/pmc5718814"}],
          "data_standard": 2,
          "journal_is_oa": false,
          "journal_issns": "2164-5515,2164-554X",
          "published_date": "2017-06-12",
          "best_oa_location": {"url": 
"http://europepmc.org/articles/pmc5718814?pdf=render",
          "pmh_id": "oai:pubmedcentral.nih.gov:5718814",
           "is_best": true,
           "license": "cc-by-nc-nd",
           "updated": "2018-01-22T13:10:35.073612",
           "version": "publishedVersion",
           "evidence": "oa repository (via OAI-PMH title and first 
author match)", "host_type":            "repository", "url_for_pdf": 
"http://europepmc.org/articles/pmc5718814?          pdf=render",
          "url_for_landing_page": 
"http://europepmc.org/articles/pmc5718814"},
"journal_is_in_doaj": false}


------------------------------------------------------------------------








El 14/03/2019 a las 3:46, Renate Morgenstern escribió:
> Hi Ernesto,
>
> Hope you are doing fine?
> Is it possible to convert Jsonl files to ISIS? Please advise.
> I am attaching one so that you can have a look at it.
> It contains 2000 records. The whole file contains more than 100000 
> records.
>
> Secondly, I am cleaning an ISIS database which comes from Winisis. I 
> want to get rid of the <> around articles (the, an, an, der, die das, 
> etc) from the title field.
> Example: ^a<The> history of Africa
> Is there an mx proc which I could use?
>
> Thanks for your help in advance.
>
> Renate
> -- 
> Renate Morgenstern
> Tel.: +264 61 242124
> Cell: +264 81 2910284
> Fax: 088637518
> Windhoek, Namibia
>

-- 
   .^.                                .^.
   ( )                                ( )
   ===                                ===
  =[=]================================[=]=
   | |  Ernesto Spinak                | |
   | |  spinaker at adinet.com.uy        | |
   | |  Montevideo, Uruguay           | |
   | |  tel/fax  (598) 2622-3352      | |
   | |  celular  (598) 99612238      | |
  =[=]================================[=]=
   ===                                ===
   ( )                                ( )
    V                                  V

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20190317/8e510312/attachment.html>