Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.codenullapp.com/llms.txt

Use this file to discover all available pages before exploring further.

If you want to import data with an excel file you need to follow these next steps:
  1. Create an Import Hook
  2. Add an action of type Import to the feature where you want to import the data

​
Create an Import Hook

Go to ‘Application designer’ and create a new hook and we will fill up the next fields:
  1. Name: Name of the import hook.
  2. Type: Import Excel
  3. Table: Choose a table if you want to map the excel header directly to the table columns.
  4. Code: Add your implementation in case you want to have your own logic to process the excel data
  5. Template: Upload the example template of the columns/data you want to upload. This file will be downloaded by the user once you add the action
  6. Save the hook

​
Import data directly to the table

If you want Codenull does all the job for you, you must define the header of your excel with the same names as your table has. For instance, the Roles table has only one column, “Name”. Your template header should have the same label. Once you select a table the field `Code` will be hidden
If you want to import data into multiple tables using this approach then you must define the fields of the other table separated by a dot. for instance MyOtherTable.ColumnName
This approach is helpful when you do not need any special logic and your excel can match with your database tables

​
Import data using a custom implementation

In case you have a complex scenario when you need to have a special excel or insert into some complex database model this may be a better approach. To use this don’t select a table and just add your logic to the code field. Next you can see an example: 
// add your own logic as you do on the other hooks
// you will have three objects to process your data (jsonData, workbook, options)
// jsonData: the imported data as a JSON object with the next structure
//     {
//        worksheets: [{ items: [....]}]
//     }
// workbook: exceljs's workbook instance https://github.com/exceljs/exceljs
// options: { userInfo }

const importConceptos = async(jsonData) =>{
    //here you need to insert as you want
    //for instance:
    const tableModel = modelsapp.Concepto;
    return await tableModel.bulkCreate(jsonData.worksheets[0].items);
}
importConceptos(jsonData, workbook, options);
The next example is a more complex scenario 
//
const importPersonasAsync = async (jsonData, options) => {
  const personaModel = modelsapp.Persona;
  if (!jsonData.worksheets[0].items || jsonData.worksheets[0].items.length === 0) {
    throw new Error("No se encontró información para importar.");
  }
  const data = jsonData.worksheets[0].items.map((persona) => {
    let Email = persona.Email;
    if (persona.Email && typeof persona.Email === "object") {
      //excel cuando reconoce algun email lo manda con la estructura { text: "", hyperLink: ""}
      Email = persona.Email.text;
    }

    const EsBautizado = persona.EsBautizado === "Si" || persona.EsBautizado === "Sí";

    return {
      ...persona,
      Email,
      EsBautizado,
      IglesiaId: options.userInfo.IglesiaId,
    };
  });
  console.log("inserting data...");
  return await personaModel.bulkCreate(data);
};

importPersonasAsync(jsonData, options);

​
Read parameters (querystrings) from the site in the import excel hook

options.queryParameters.Id 
// Id is the name of the query string in the URL //
//example: 
https://app.azurewebsites.net/feature/611d55524ee0f00181a6d7?Id=5F11A127-5547-47BC-97B1-0032D1C7F5DD

const importEntityAsync = async (jsonData, options) => {
    console.log(options.queryParameters.Id); // Id from UI

};

importEntityAsync(jsonData, options);

​
Add an action of type Import to your feature

After you have created the hook you can use the import button, now Edit the feature you want to add the new action button and fill up the fields.
  1. Type: Button
  2. Id: Random
  3. Button Type: Import
  4. label: Text you want to show in the button
  5. design: Theme color you want to show (primary, secondary)
  6. Hook: You have to choose the hook you created before (This only will display hooks of Import type)
  7. Save the feature
Now you are ready to use the control, then go to the feature (page) where you added the new import button and will find two options:
  1. Import: Click on the left button if you want to import the data with the excel template
  2. Download template: Click on the right button to download the excel template you uploaded before during the hook creation.

​
Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the ask query parameter: 
GET https://codenull.gitbook.io/dev/configurations/hooks/import-excel-files.md?ask=<question>
The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.