Page 1 of 3
Is it possible to import data into a subform from a file?
Posted: Mon Jun 08, 2020 4:45 pm
by kknm
Is it possible to import data into a subform from a excell-file? That is, sequentially read from a given line the entire file specific fields.
Re: Is it possible to import data into a subform from a file
Posted: Mon Jun 08, 2020 4:57 pm
by kev1n
Would the clipboard also be an option to transfer data from excel to the subform (copy & paste) ?
Re: Is it possible to import data into a subform from a file
Posted: Mon Jun 08, 2020 8:35 pm
by kknm
kev1n wrote:Would the clipboard also be an option to transfer data from excel to the subform (copy & paste) ?
The clipboard does not make sense with a large amount of data. Manual entry will be faster ..
Excell is formed in another firebird database, on another computer in the local network.
Re: Is it possible to import data into a subform from a file
Posted: Mon Jun 08, 2020 9:28 pm
by kev1n
kknm wrote:
The clipboard does not make sense with a large amount of data. Manual entry will be faster ..
Are you sure? This is how I copy & paste data. In my case, manual data input would take much, much longer:
https://streamable.com/bpqm8k
kknm wrote:
Excell is formed in another firebird database, on another computer in the local network.
I don't understand this. Are you talking about MS Excel, a spreadsheet?
Where are the files located? How can nuBuilder access them?
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 7:11 am
by kknm
I can not open your link.
https://streamable.com/bpqm8k
An Excell file is readable from nuBuilder.
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 7:30 am
by kev1n
Dude, you need to provide more information.
(See my questions above)
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 7:34 am
by kev1n
Do you know where I could upload videos? Because many URLs are blocked in Russia.
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 8:02 am
by kknm
kev1n wrote:Dude, you need to provide more information.
(See my questions above)
The circled in red needs to be imported into the subform, for further editing, there will be additional fields in the line.
Field values begin with '
A file name of type 2020_06_05_D.xls or - 2020_06_05_N.xls
There is a field on the form
Date: 2020-06-05 08:00:00 or 2020-06-05 20:00:00
08:00:00 corresponds to the prefix D in the file name.
20:00:00 corresponds to the prefix N in the file name.
Using the button, you need to open the // vesydyn2 / reports folder and open the file corresponding to the Date field to read.
excell.png
Youtube is available from Russia.
This is a daily operation - there can be from 3 to 20 lines
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 8:27 am
by kev1n
Re: Is it possible to import data into a subform from a file
Posted: Tue Jun 09, 2020 8:41 am
by kknm
As an option, I can try ...
Although this is a lot of operations - find a folder, find a file, open it, select a range, add empty lines to the subform, copy the range, select the field in the first line, paste ...
The added line will also contain fields not from the file.
How to add the required number of lines to a subform?