Windev21 Aulas,Estudos e Desenvolvimento: DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO

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:

To import a CSV file into the analysis:

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.

The file import wizard starts.
Go to the next step.
Select the format of files to import. In this case, select "Text file".

Go to the next step of the wizard.
Specify the path of file to import: "\Tutorial\WD\Exercises\WD My First Database\PaymentMode.csv" in the WINDEV setup directory.
Go to the next step of the wizard.
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>"
Don't forget to check "The first row contains the names of columns".
Go to the next step.
The structure of data file that will be created is displayed.

Keep the default options. Go to the next step of the wizard.
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.
Validate the wizard. WINDEV creates the data file.