Re: Pasting Spreadsheet Data into 4D Records

[Guy Algot via 4D_Tech]

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 Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Greetings everyone,
> 
> Is there a way to copy from a spreadsheet like data source and to paste
> directly into 4d while parsing it into table(s) and fields? I'm using v17
> if that matters.
> 
> I thought about saving the data into a text file and then importing the
> text file, but there seem to be unnecessary steps in there!
> 
> Thanks, did some searches but didn't find anything,
> Alan


Later,
Guy

--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Pasting Spreadsheet Data into 4D Records

[Randy Engle via 4D_Tech]

Alan,

If you have lots of spreadsheets to deal with, as Lahav said, Pluggers XL 
plugin.
It's my tool of choice for dealing with Excel at all, both creating and reading.

Randy Engle

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of lists via 4D_Tech
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 Excel, writing or reading directly.

HTH and happy holidays,

Lahav

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of 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 
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 rather than 
trying to use import commands. That seems worthwhile and not that difficult!
I probably should have said that I potentially have hundreds of copy/paste 
operations to do!
Your responses are much appreciated,
Alan

On Mon, Dec 24, 2018 at 11:37 AM Kenneth Geiger via 4D_Tech < 
4d_tech@lists.4d.com> wrote:

> 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.
>
> Regards,
>
> Ken Geiger
>
> > On Dec 23, 2018, at 5:47 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Greetings everyone,
> >
> > Is there a way to copy from a spreadsheet like data source and to 
> > paste directly into 4d while parsing it into table(s) and fields?
> > I'm using v17 if that matters.
> >
> > I thought about saving the data into a text file and then importing 
> > the text file, but there seem to be unnecessary steps in there!
> >
> > Thanks, did some searches but didn't find anything, Alan
> > 
> > **
> > 4D Internet Users Group (4D iNUG)
> > Archive:  http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > 
> > **
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Pasting Spreadsheet Data into 4D Records

[Arnaud de Montard via 4D_Tech]

> 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 export the document as csv and open it after. They do like 
it. 

-- 
Arnaud de Montard 




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**