0

Data upload from WORD

I’m a Trustee of a charity and we receive applications for grants from other charities. We want to record basic details of these applicants into a database by auto upload of the WORD application form into a table. I converted the Application form into a WORD FORM useing design, saved as a txt. File but NINOX is not identifying the different elements of the form to match with fields in the table. what am I doing wrong? Can NINOX upload txt. Files? Is there a better way?
 

2 Antworten

null
    • Leonid_Semik.2
    • vor 1 JahrFri, May 3, 2024 at 2:43 PM UTC
    • Gemeldet - anzeigen

    Ninox can read the txt files.

    let fileName := last(split(text('Image Field'), "/"));
let fileLink := fileUrl(this, fileName);
let fileResponse := do as server
        http("GET", fileLink)
    end;
let fileText := text(fileResponse.result);
Text Field:=fileText
      • Frederick_Proudfoot
      • vor 1 JahrFri, May 3, 2024 at 6:36 PM UTC
      • Gemeldet - anzeigen

       

      Thanks, but when I load the txt. File useing the normal import Csv file I get multiple records whenever there is delimiter in the txt. File, ie a comma. How can I get the data to accurately populate the Ninox table. I tried copying the WORD table to accelerate but it produced data in multiple rows and columns. Ninox needs a CSV file with 1 row. How can I create a one row record in a txt file or by copying to xcel which can then be uploaded to Ninox

      eric

Anmelden, um zu antworten

Content aside

  • vor 1 JahrFri, May 3, 2024 at 6:36 PM UTCZuletzt aktiv
  • 2Antworten
  • 49Ansichten
  • 2 Folge bereits