DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4

---

https://youtu.be/WRrRpIGLwk8

Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 10:00 do dia 19/08/2020 QUARTA
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
Tutoriel WINDEV : Leçon 3.3.d. Projet et analyse - Importation CSV
https://windevdesenvolvimento.blogspot.com/2020/08/dicas-3000-windev-tutorial-23-projeto-e.html


ASSUNTOS

1. CRIANDO UM ARQUIVO TEXTO
2. NESSE ARQUIVO TEXTO CVS, CRIAR OS CAMPOS , E VALORES
3. IMPORTAR O ARQUIVO TEXTO E GERAR A ANALISE


https://doc.pcsoft.fr/fr-FR/?1410087521&name=lecon_33_projet_analyse

Video original da Franca
https://youtu.be/UVsWtUYpDAw

Playlist Windev TUTORIAL
https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

---

Importing a CSV file

A different method will be used to create the "PaymentMode" data file, which contains the payment characteristics: importing a CSV file.

	Remark	A CSV file is a text file that uses a specific format. This file contains data on each line. The data is separated by a separation character (a comma, a semi-colon or a tabulation).

From the CSV file containing the data, WINDEV will create:

• the description of data file in the analysis,
• the HFSQL data file with the data found in the CSV file.

• To import a CSV file into the analysis:
  1. In the ribbon, on the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import file/table descriptions".
     

     	Tip	To import a CSV file (or any other file) into the analysis, you also have the ability to Drag and Drop the CSV file (from the Windows explorer) to the data model editor. This will be presented in the next paragraph.
  2. The file import wizard starts.
  3. Go to the next step.
  4. Select the format of files to import. In this case, select "Text file".
     
     Go to the next step of the wizard.
  5. Specify the path of file to import: "\Tutorial\WD\Exercises\WD My First Database\PaymentMode.csv" in the WINDEV setup directory.
  6. Go to the next step of the wizard.
  7. Specify the following import parameters:
     • The records are delimited by: "<Carriage Return/Line Feed>".
     • The columns are delimited by: "<Semicolon>".
     • The strings are delimited by: "<None>".
     • Decimal separator: "<Automatic: dot or comma>"
       
  8. Don't forget to check "The first row contains the names of columns".
  9. Go to the next step.
  10. The structure of data file that will be created is displayed.
      
      Keep the default options. Go to the next step of the wizard.
  11. The content of CSV file will be automatically converted to HFSQL format. The wizard proposes to create the HFSQL file in the project directory.
      
      Keep the proposed options and go to the next step.
  12. Validate the wizard. WINDEV creates the data file.

• Let's study the description of the imported data file:
  1. Select the "PaymentMode" data file.
  2. In the popup menu (right mouse click), select "Description of data file".
  3. Change the data file caption in the window that opens up: delete "(Imported)".
  4. Click the  icon to display the description of the data file items.
  5. This data file contains no automatic identifier and no unique key. We are going to switch the "Code" item to unique key:
     • Position the selection bar on the code item if necessary.
     • In the right section of screen, click "Unique key".
       
  6. We get the following data:
     
  7. Validate the item description window and the data file description window.

---

ErpMatos - TgsSistemas

skype:amarildo.matos.informatica

email: amarildo.matos@gmail.com

whats: 51984197742

Youtube: Amarildo Matos

http://www.amarildomatos.com.br

https://groups.google.com/forum/#!forum/amarildowindev

www.windev.com

https://www.pcsoft.fr/webinaires.htm?p=forumpcs

https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp

https://www.windev.com/windev/WD-Express.htm

https://www.windev.com/windevmobile/WM-Express.htm

http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html

---

---

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