AW: Import from file on forms
rudolf at bargholz.ch
Sun Jul 24 13:54:09 UTC 2022
Generally, if a users selects a group of fields in Excel, and copies this data, the data will be copied as tab delimited text. Pasting this data into a Studio entry filed will paste the CR and TAB values as well. Taking apart this text is normally a pretty easy thing to do. The only issue you might have is with enclosed text that contains embedded LF (LineFeed) values in the respective cells. I use this sometimes as an easy way to get a not too large set of data into our app.
Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> Im Auftrag von Das Goravani
Gesendet: Samstag, 23. Juli 2022 19:41
An: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Betreff: Import from file on forms
I want to present to my users on forms, the ability to import a list of records.
The problem area for me is how to present the importation of the CSV or spreadsheet.
I know I can use the "File" component to upload to a binary field. I would prefer this as it can be done on the client machine.
The problem is that File puts the file into a binary field. I need it in a list for importing.
If you have a CSV or text spreadsheet in a binary field, can you move it to a list variable? With Calculate as… or something?
Or a more complex scenario whereby you convert it in a few steps?
Other than the "File" component approach, I could always have them put the CSV on the server and fetch it from there with regular import commands.
I’m going to proceed to do it the server placed way.
If you have any input feel free to comment.
Manage your list subscriptions at https://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en