Alan,
John Baughman has a wonderful collection of tip & tricks and one of the methods
is called ‘Array_ArraysToClipBoard’. I don’t have the code with me but perhaps
he has one that does the reverse and that may help you with your spreadsheet
import?
> On Dec 23, 2018, at 5:47 PM, Alan
h
Sent: Monday, December 24, 2018 10:18 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: lists
Subject: RE: Pasting Spreadsheet Data into 4D Records
Alan,
Take a look at XL Plugin from Pluggers
(https://www.pluggers.nl/product/xl-plugin/). It is an excellent tool for
working with Ex
> Le 24 déc. 2018 à 20:44, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> [...]
> I probably should have said that I potentially have hundreds of copy/paste
> operations to do!
When users have to do it very often, it's more efficient to copy in spreadsheet
/ paste in 4D than
f Alan Tilson via
4D_Tech
Sent: Monday, December 24, 2018 12:45 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Alan Tilson
Subject: Re: Pasting Spreadsheet Data into 4D Records
Hello Pat, Koen & Ken,
Pat & Ken- Thank you for your response but I'm trying to eliminate (especially
Hello Pat, Koen & Ken,
Pat & Ken- Thank you for your response but I'm trying to eliminate
(especially manually) creating the text file. I had been thinking of
automating the creation of the text files and using import, but...
Koen- I hadn't thought of manually (via code) parsing the text data
Hi Alan,
Just save your spreadsheet (Excel) as file-type Tab-Delmited-Text (.txt). Then
in 4D, navigate to File…Import…, change the file type to .txt, select your
saved file, select the table into which to import the data, and then match the
data (columns) to the proper field and import it.
Hi Alan,
You'll probably have to start the 'paste' from a button or menu item and write
some code.
$data:=Get text from pasteboard //you'll probably get a tab delimted text
If needed, try to find out what delimiters are used
And finally parse the text data and assign to the fields of your
You're going to have to either save it as a text file (csv or
tab-delimited) and then parse it, or use a plugin (such as Pluggers' XL
Plugin) to read the spreadsheet directly.
Pat
On Mon, 24 Dec 2018 at 00:48, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> Greetings everyone,
>
> Is
8 matches
Mail list logo