Provider: |
 Beaussier en ligne |
Maintainer: |
oooforum |
Bewertung: |
(2 votes)
|
Anwendung: |
Base |
Tags: |
Database, query, table, Tables, Base, csv, export, conversion, convert |
Screenshots: |
http://www.beaussier.com/images/exportcsv.png |
Beitragsdatum: |
Freitag, 18 Dezember, 2015 - 05:10 |
Statistiken |
Week: Nicht getrackt - Monat: Nicht getrackt - Jahr: Nicht getrackt - Timeline |
english: ExportCSV allows to export table or query content in a CSV file.
Once installed, you run this conversion through a dialog in Tools menu.
french: ExportCSV permet d'exporter le contenu d'une table ou d'une requête dans un fichier CSV.
Une fois installée, vous exécutez cette conversion grâce à une boîte de dialogue dans le menu Outils.
german: ExportCSV ermöglicht es Inhalte aus Tabellen und Abfragen in eine CSV-Datei zu exportieren.
Nach der Installation der Extension wird diese in Base unter Menü > Extras aufgerufen. Der Anwender wird mittels Dialog geführt.
If you want this extension in another language, you could help in translation.
Thanks to contact me: oooforum [at] free [dot] fr
| Version | Operating system | Compatibility | Release date | ||
|---|---|---|---|---|---|
| 1.1.0 | System Independent | 3.4, 4.0, 4.1 | 29/03/2017 - 11:05 | Weitere Informationen | Download |
Kommentare
Create a table like below:
CREATE CACHED TABLE EXPORT_DATE02 (MY_DATE DATE NOT NULL PRIMARY KEY, MY_VALUE INTEGER);
Insert data like below:
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-01', 1);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-02', 2);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-03', 3);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-04', 4);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-05', 5);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-06', 6);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-07', 7);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-08', 8);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-09', 9);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-10', 10);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-11', 11);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-12', 12);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-13', 13);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-14', 14);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-15', 15);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-16', 16);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-17', 17);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-18', 18);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-19', 19);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-20', 20);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-21', 21);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-22', 22);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-23', 23);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-24', 24);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-25', 25);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-26', 26);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-27', 27);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-28', 28);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-29', 29);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-30', 30);
INSERT INTO EXPORT_DATE02 (MY_DATE, MY_VALUE) VALUES('2024-01-31', 31);
Confirm data with statement below:
SELECT * FROM EXPORT_DATE02;
When use function: Export to CSV for the table, works with > Languages and Locales > General > Local setting: French (France)
When use function: Export to CSV for the table, produces error > Languages and Locales > General > Local setting: English (USA)
That is, the date MM/DD/YY is not accepted for a month, since, it does not get translated to ISO date format.
Please post this question on https://beaussier.com/sections/viewforum.php?f=2&
Hi, this is perhaps not the correct place for posting an issue, but I couldn't find your email for support cases.
Quotes are not escaped by exporting text fields with text separator quotes ("). The correct behavior should be to substitute all quotes (") with double quotes ("").
Otherwise very helpful add-on. Thanks!
Please update and all will be fine