segunda-feira, 31 de agosto de 2020

DICAS 3060 -WINDEV TUTORIAL 83 -Licao 7.3-06-09-2020 11hrs-MANIPULACAO ARQUIVOS




https://youtu.be/jpDiUW806zk


Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 11:00 do dia 06/09/2020 

DICAS 3060 -WINDEV TUTORIAL 83 -Licao 7.3-06-09-2020 11hrs-MANIPULACAO ARQUIVOS
Tutoriel WINDEV : Leçon 7.3. Programmation avancée - Manipuler des fichiers externes

o Programa Fonte esta no Scm

do Repositorio do Windev
https://repository.windev.com/






ASSUNTOS

O QUE SERA ENSINADO
VISAO GERAL
TRATAMENTO DE ARQUIVOS DE TEXTO OU CSV
CRIANDO UM PROJETO MANIPULACAO_ARQUIVOS
ABRINDO EXEMPLO MANIPULACAO ARQUIVO TEXTO
   Handling text files - windows 
  
TRADUZINDO O EXEMPLO PARA PORTUGUES 
RENOMEANDO AS VARIAVEIS PARA PORTUGUES PARA MELHOR ENTENDIMENTO PORTUGUES
DESSA MANEIRA O ENTENDIMENTO FICARA MELHOR
COLOCAR O EXEMPLO NO REPOSITORIO COMO MANIPULACAO_ARQUIVOS
EXPLICANDO O MOTIVO POR FAZER A TRADUCAO   
MOSTRANDO COMO CRIAR UM ARQUIVO
MOSTRANCO COMO AS LINHAS NO ARQUIVO 
MOSTRANDO COMO SALVAR TEXTO NO ARQUIVO 
GERENCIANDO DIRETORIOS 
EXEMPLO DIRETORIOS 
   Handling directories
GERENCIANDO XML
TRADUZINDO PARA PORTUGUES 
MOSTRANDO EXEMPLO 
   Reading and writing in XML format
CRIANDO DOCUMENTO XML
LENDO O XML 
TRATAMENTO DE ARQUIVOS XLS 
EXEMPLO PRATICO XLS 
   The Excel functions
MOSTRANDO AS FUNCOES EXCEL 
MOSTRANDO CODIGO 
   
Video sobre esse Assunto
Blog sobre esse assunto
google forum sobre esse assunto 

Video original da Franca

https://youtu.be/i5yP0DtZU5Q   

Playlist Windev Tutorial Amarildo
Playlist windev Franca PcSoft
Amarildo
Windev
WxSolucoes
Matos Informatica
Repositorio Windev

Video sobre 3 Mil Videos Windev 
PlayList Pedrosao





DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
DICAS 2998 - WINDEV TUTORIAL 21 - PROJETO E ANALISE - ARQUIVOS DADOS CLIENTE - PARTE 2
DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
DICAS 3001 - WINDEV TUTORIAL 24 - PROJETO E ANALISE - IMPORTANDO ARQUIVO PRODUTO - PARTE 5
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
DICAS 3003 - WINDEV TUTORIAL 26 - RAD COMPLETO
DICAS 3004 - WINDEV TUTORIAL 27 - VISAO GERAL
DICAS 3005 - WINDEV TUTORIAL 28 - Adicionar e Modificar Janelas PRODUTOS - PARTE A
DICAS 3006 - WINDEV TUTORIAL 29 - Adicionar e Modificar Janelas PRODUTOS Formulario - PARTE B
DICAS 3007 - WINDEV TUTORIAL 30 - Adicionar e Modificar Janelas PRODUTOS ALINHAR CAMPOS - PARTE C































Lesson 7.3. Handling external files
This lesson will teach you the following concepts
  • Handling text files (CSV , ...).
  • Handling directories.
  • Handling XML files.
  • Handling XLS files.
Lesson duration

Estimated time: 20 mn
Previous LessonTable of contentsNext Lesson
Overview
WINDEV allows you to easily handle the most common data formats:
  • text files (INI, CSV, ...),
  • XML files,
  • XLS files, ...
Several families of WLanguage functions can be used to read and create these files. This allows you to easily read data generated by another software in your WINDEV applications or to create files that require a specific formatting.
Furthermore, several WLanguage functions can be used to handle the directories containing the files.
In this chapter, we will focus on:
  • Text files (text files, INI files and CSV files),
  • XML files,
  • XLS files,
  • the management of directories.
Handling text or CSV files

Overview

The external files are also called text files or files with direct access. In most cases, this type of file contains text but it can also contain binary information such as images, sounds, ...
In this lesson as in the entire WINDEV documentation, we will be talking of external files.
WINDEV allows you to handle the external files by programming. The WLanguage functions can be used to create, read ... external files. All functions can easily be identified: they all start with the letter "f".
The notion of "record" does not necessarily exist in an external file. To handle an external file, you must know its structure, which means how the data is organized inside the file.
The CSV files are text files that use a specific structure. Therefore, they can be handled like the text files.
The .INI files are also text files that use a specific structure. To handle them, WINDEV includes two specific functions: INIRead and INIWrite.

Practical example

  • Open the unit example named "Handling text files".
  • Run the test of "WIN_Text_File" window. This window groups the different operations that can be performed on the external files with WINDEV.
    Handling text files
The different window buttons propose to:
  • Create a text file.
  • Read and write in a text file.
  • Operations performed on existing files (copy, delete, read information, ...).
  • Copy a text file.
Handling directories
Several WLanguage functions are used to handle the directories and their files.

Practical example

  • Open (if necessary) the unit example named "Handling directories" and run the test of corresponding window.
  • This window groups the operations that can be performed on disks and directories:
    • create a directory,
    • find out the current directory,
    • check the existence of a directory,
    • list the directories,
    • copy and create a directory, ...
See Functions for managing external files for more details.
Handling XML files

Overview

XML (Extensible Markup Language) is a markup language, which means a language that presents information enclosed in tags. XML is a metalanguage that is used to invent new tags to isolate the elementary information that may be found in a Web page.
XML is used to structure a document containing data. A HFSQL data file containing several items and records can be exported to an XML file for example (XML* functions).
WINDEV supports:
The XML file can also be handled in the code editor directly. Simply:
  1. Drag the XML file from the file explorer and drop it in the "Project explorer" pane tab, "External descriptions" folder.
  2. Drag the XML file from the "Project explorer" pane and drop it in the code editor. The xmlDocument variable is automatically created as follows:
    <Variable name> is xmlDocument, description =  <Document name>
  3. You now have the ability to access the variable nodes by their names. These names are automatically proposed by the mechanism for automatic completion of the code editor.

Practical example

  • Open the unit example named "Reading and writing in XML format".
  • Run the test of "WIN_HandleXML" window. This window is used to:
    • create an XML file. This file is created by the XML functions.
      Reading and writing in XML format
    • read an XML file.
  • Study the code associated with each button.

Remark

We won't go into details about all the features proposed by the XML functions.
See XML functions for more details.
Handling XLS files
To handle the Excel files, WINDEV proposes:
  • the xlsXXX functions. These functions are used to read the data found in the different worksheets of an Excel file.
  • the advanced variables (xlsDocument, xlsRow, xlsColumn, xlsCell).

Practical example

A quick test of these functions?
  • To check the use of xlsXXX functions, open the unit example named "The Excel functions".
  • Run the test of "WIN_XLSFunction" window. This window is used to:
    • import data coming from an Excel worksheet.
    • export data from a Table control to Excel.
    Return to the editor to see the code of the different Button controls in the window.
  • To check the use of advanced variables, open the unit example named "XLS type".
  • Run the test of "WIN_XLS_Type" window.
    Excel functions
  • Go back to the editor and study the code of different Button controls in the window.

Remark

We won't go into details about all the features proposed by the XLS functions and the advanced types.
See Functions for managing XLS files for more details.





domingo, 30 de agosto de 2020

Menu Blog


        






Cursos

ACBR - CURSO BOLETO - ULTIMA AULA 29 03 2018

ErpAmarildo - Curso - 116 Aulas - Ultima Aula 31 01 2019 


Array - Curso WinDev - 11 Aula - Ultima Aula 22-06-2017
Arquivos - Curso WinDev - 22 Aula - Ultima Aula 04-10-2017
BARRA PROGRESS CURSO WINDEV - 2 AULA - ULTIMA AULA 13 07 2017
Backup - Curso WinDev - 1 Aula - Ultima Aula 06 04 2017 (NOVO)
BUTTON - CURSO WINDEV - 2 AULA - ULA AULA 05 07 25017 (NOVO)
Calendario - Curso WinDev - 3 Aula - Ultima Aula 20/09/2017
Certificado - Curso WinDev - 11 Aula - Ultima Aula 27/03/2017
Comandos - Curso WinDev - 47 Aulas - Ultima Aula 15 03 2019   
ComBox - Curso WinDev - 8 Aula - Ultima Aula 13/09/2017
Controls - Curso WinDev - 3 Aula - Ultima Aula 17 11 2017
Cronograma/Organizer - Curso WinDev - 2 Aula - Ultima Aula 07/03/2016
Data - Curso WinDev -18 Aula - Ultima Aula 30/09/2017
Dialogo - Curso WinDev - Funções - 10 Aula - Ultima Aula 20-10-2017
Dicas - Curso WinDev - 48 Aula - Ultima aula 22-12-2017
Daruma - Curso - Em Andamento - 003 Aulas
Documentos - Curso - WinDev22 - 1 Aula - 04/12/2016 
Email - Curso Windev - 5 Aula - Ultima aula 31-10-2017
Excel - Curso WinDev - 3 Aula - Ultima Aula 03/04/2016 
Exe Windows - Curso WinDev - 14 Aula - Ultima Aula 20/09/2016
FlexDocs - Curso Nfe/xml - Em Andamento - 024 Aulas
Ftp - Curso - 15 Aulas
Grafico - Curso WinDev - 9 Aula - Ultima Aula 06/06/2016
Imagen - Curso WinDev - 4 Aula - Ultima Aula 07/04/2017
Json - Curso WinDev - 3 Aula - Ultima Aula - 17 03 2019
HyperFile - Curso WinDev - 29 Aula - Ultima Aula 17 07 17
ListBox - Curso WinDev - 13 Aula - Ultima Aula 04/03/2017
ListView - Curso WinDev - 2 Aula - Ultima Aula 30/03/2017
Iniciante - Curso ao Avançado - Ano 2016- 245 Aulas - Ultima Aula 03-10-2016

MONITOR - CURSO AULA 2 - ULTIMA AULA 07 08 2017

Multimidia - Curso WinDev - 1 Aula - Ultima Aula 04/08/2016

ORDEM COMPRA - CURSO - AULA 5 - ULTIMA AULA 15 01 2018

Pdf - Curso Windev Pdf - 2 Aula - Ultima Aula 29 12 2016
Pivo - Curso WinDev - 10 Aula - Ultima Aula 13/11/2017
Radio - Curso Windev - 1a Aula - Ultima Aula 27 04 2017
Relatorio - Curso WinDev - 49 Aulas - Ultima Aula 15-07-2017

 Servidores - Curso - 3a Aula - Ultima 09 05 2017

Sql - Curso WinDev - 21 Aula -  Ultima aula 24-03-2017
SQLSERVER - CURSO WINDEV - 3 AULAS - ULTIMA AULA 11 01 2018
String - Curso WinDev - 48 Aula - Ultima Aula 18/11/2017

Tabela - Curso WinDev - 75 Aula - Ultima Aula 18/09/2017
Uninfe - Curso Nfe/Xml - Em Andamento - 031 Aulas
Xml - Curso WinDev - 16 Aula - Ultima Aula 06-09-2017
Zip - Curso WinDev - 1 Aula - Ultima Aula 08-10-2016
Window Janela - Curso WinDev - 8 Aula - Ultima Aula 25/02/2017 
Windows Registro - Curso WinDev - 1 Aula - Ultima Aula 27/03/2016
WinDev Mobile - Curso - 82 Aulas - Ultima Aula - 26/04/2017
WebDev - Novo Curso - Curso 30 Aula - Ultima Aula 16/11/2017
WebDev - Curso 21 Aula - Ultima Aula 29 09 2016
WebService - Novo Curso - Curso 9 Aula - Ultima Aula - 06 02 2017
WinDev21 - Resumo das Novidades - 41 - Ultima Atualização -07-05-2016
Curso Exames - Ja Fechado - 017 Aulas
Curso - Primeiro Sistema desenvolvido -Ligações- Encerrado - 032


Continuar aqui
http://doc.windev.com/en-US/search2.awp?origin=browse&cat=controls-pages-and-windows,265

Teste

Teste
teste