OpenOffice.org

Bij Formulieren en Rapporten is de mogelijkheid tot het invoegen van een Map actief
menu --> Invoegen --> Map

BartSr schreef: ↑vr jul 29, 2022 11:29 am Bij Formulieren en Rapporten is de mogelijkheid tot het invoegen van een Map actief
menu --> Invoegen --> Map

Dit begrijp ik niet, Waar moet ik beginnen?

Werk je wel met een databasedocument?

#!/bin/bash
# this script is only working with linux.
# the purpose is that this scrip export all files from the mdb database as CSV
# The option I use
#a) Only data files are exported.
#b) Date are exported in year month day style for using in HSQLDB style
#c) Numbers are exported with a point as decimal separator
#
#The script take care all MDB files are exported as a CSV.
#For each MDB file there is made a new MAP.
#
#I have select this method there it was the most easy way to import data in CALC.
#When you still have MS Acces use MS Acces for exporting dat to a CSV. I think this is the best method.


# start this script up from the place where the MDB files are. Then the files are stored in the same map.
# It is not important where this script is.

# Set the field separator to one line
Extentie=.accdb

IFS=$'\n'

for database in $(ls -1 *.accdb )
do
DirNaam="${database%*$Extentie}" # Strip extension from the file name and make the map name

test -d "${DirNaam}" || mkdir "${DirNaam}" # Maak eventueel een map


for query in $(mdb-queries -1 "${database}")
do
#echo "Ik werk aan deze : $database $query"
#echo "Processing this : $database $query"
# etract the query
mdb-queries "${database}" $query >$DirNaam/$query.query
#mdb-prop "${database}" $query >$DirNaam/$query.query.prop # this gives properties of the query and i do see it help you

done




for tabel in $(mdb-tables -1 "${database}")
do
#echo "Ik werk aan deze : $database $tabel"
#echo "Processing this : $database $tabel"
# There are three lines in this script select the line you need
# American month day year
# Europe day month year
# HSQLDB year month day
# mdb-export -D "%m-%d-%y" "${database}" "$tabel" >"${DirNaam}/${tabel}.csv"
# mdb-export -D "%d-%m-%y" "${database}" "$tabel" >"${DirNaam}/${tabel}.csv"
mdb-export -D "%Y-%m-%d" "${database}" "$tabel" >"${DirNaam}/${tabel}.csv"
#mdb-prop "${database}" "$tabel" >"${DirNaam}/${tabel}.table.prop"
done
done