Easy to Create, Easy to Change - Easy to use!

Command::

import



Parameters


Returns/Result


Examples


Reference

import

Type

Control Command

Purpose

The import command imports a data file into the current application. It can be used to import data at any point during a procedure. After executing the import, the data can be used in the same procedure.

Syntax

import "IMPORT SPECIFICATION FILENAME" .

Usage

The import command can only be used to execute a previously defined Import Specification. The filename that follows the import command is the filename of the Import Specification. This name must be eight or fewer characters with no intervening spaces.

LAN

On a LAN (Local Area Network), if another user is currently using any resource required by the import command, DataEase displays a Resource Conflict message. While this message is displayed, DataEase automatically tries to execute the command at brief intervals.

When the required resource becomes available, DataEase automatically resumes processing and executes the rest of the procedure.

Example

 import "MAILING LIST" .

 run procedure "PRINT CONFIRMATIONS" .

 

This script tells DataEase: (1) Execute the MAILING LIST Import Specification, and (2) when the import is completed, run the PRINT CONFIRMATIONS procedure.

See Also


On the forum about import

Columns changing order Import data - csv / mail-merge -

When importing data into a form/database from a csv/mail merge file the imports fine, but when switching to table mode the columns have all been moved around out of their original order and despite moving them back to their proper order, they will b...

Product: Dataease [{8}]FIVE. Written by Kensington 03/09/13 at 15:03:05

Import form a DataEase table

I'm testing the new version of DataEase 8.1.0.1464 and I don't find the possibility to import a dataease table (.DBM) into a destination table inside my database. How can i do ? I used this function very often in the previous version of dataease. Than...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 14/02/14 at 13:15:19

Re:Import form a DataEase table

What version?  v8.1 has it....

Product: Dataease [{8}]FIVE. Written by Josef Vella 31/03/14 at 16:15:13

Re:Import form a DataEase table

It was removed with all other outdated import definitions in 8.1 and then re-implemented in 1487 and will be further updated in a later version of 8.11487 - 20.02.14 - Update! Exciting new properties added to GetCurrent() - RecordNumber and Row...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 31/03/14 at 18:47:51

DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

[@EOF@]...

Product: LegEasy DOS. Written by charmaine smit 19/05/14 at 12:00:10

Re:DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

I use DOSBOX , http://www.dosbox.com/ and it works fine, both in small and full screen.Remember that DFD does not like long file import names, so you might have to rename them to fit that length....

Product: LegEasy DOS. Written by Kensington 20/05/14 at 16:36:04

Problems during checks on import

I need to check the completion of some imports inside a DQL as follow:---- Imports Gruppi e Ruoli--delete records in MimkAnagGruppi .if count of MimkAnagGruppi > 0 then message "Tabella in uso. Operazione Interrotta !" windo...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 29/05/14 at 10:30:03

Re:Problems during checks on import

All DQLs in DataEase keep a "logical" lock on the scope of that DQL.You should never do a delete records in the same procedure as you are doing processing. It might work, but most of the time it doesn't.Run a DQL to do all the deleting...

Product: Dataease [{8}]FIVE. Written by DataEase 11/06/14 at 11:30:51

Importing a Form & data from a different DE8 app

Greetings all  Simple question ( I hope...)  I have two separate DE8 applications.  How can I import a form and it's data from one DE8 application to another DE8 application?  The form is flat with no lookups - it has about 40...

Product: Dataease [{8}]FIVE. Written by Robert Smith 24/10/14 at 09:03:18

Re:Importing a Form

You can install a form with table and Data via Application/Utilities/Install in the Main Menu/Designer Menu.To be able import the data with the Form and TDF file you need to make sure you run on a local drive without the Shared Local Database...

Product: Dataease [{8}]FIVE. Written by DataEase 28/10/14 at 07:52:26

Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

Suddnly version 8.2.0.1679 is blocking the TDF file during import from another Database (Install). You no longer get the option of installing the table.arvid...

Product: Dataease [{8}]FIVE. Written by Arvid 14/11/14 at 12:07:54

Re:Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

We have just tested this and it works "fine".We suspect that the problem is not really related to DE 8.2.0.1679 but a general problem with Installing Forms with Tables (TDF) and Data (DBM).When you select a Document during install it w...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 14/11/14 at 12:09:57

No messages during import or export operation

It's possible to avoid to display this message during an import or export operation? I suggest to use a "silent" parameter if it's possible. Thanks....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 01/12/14 at 09:10:22

Re:No messages during import or export operation

Dear Marco.Just to elaborate on this. Why is it a problem that the import show this information? What is the use case where you don't want it displayed?...

Product: Dataease [{8}]FIVE. Written by DataEase Development 01/12/14 at 18:31:59

Re:Re:No messages during import or export operation

I use import on some automatic procedure during the night and such procedures are blocked until I reconnect to the server again the next morning. I suspect that import/export use GUI that it's not available when the I'm not connected to the server. I...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 02/12/14 at 07:15:07

Re:Re:Re:No messages during import or export operation

Hello Marco. The problem with running Import on a schedule on the server is not related to the GUI messages. These messages for Import do not demand user interaction. When setting up the schedule you need to run the job with a...

Product: Dataease [{8}]FIVE. Written by DataEase 02/12/14 at 08:31:21

i hope you can help me import this to a new program here is the the compleete program i think

[@EOF@]...

Product: DataEase for Windows 5.x and before.... Written by Raymond Abrahamsen 04/02/15 at 12:08:46

Re:i hope you can help me import this to a new program here is the the compleete program i think

Hi again.We now received it all. There are 4 apps.DELEBRUKDELELAGERFAKTURAPERSONALETDo you want to move them all forwards to DE8?...

Product: DataEase for Windows 5.x and before.... Written by DataEase 05/02/15 at 12:15:53

Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

Yes that would be nice :)Thanks you...

Product: DataEase for Windows 5.x and before.... Written by Raymond Abrahamsen 06/02/15 at 08:10:17

Re:Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

hellodo you know how long that wil take????...

Product: DataEase for Windows 5.x and before.... Written by Raymond Abrahamsen 09/02/15 at 10:13:46

Re:Re:Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

Dear Raymond. The team have a lot on at the moment, but we will get back to you by end tomorrow....

Product: DataEase for Windows 5.x and before.... Written by DataEase 09/02/15 at 11:35:14

Re:Re:Re:Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

helloi have not heard from you yet.. how is it going whit the import?...

Product: DataEase for Windows 5.x and before.... Written by Raymond Abrahamsen 11/02/15 at 07:04:02

Re:Re:Re:Re:Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

TechSup tell me they have emailed you directly. If you haven't received anything, check your spam filter etc. If it got lost in space, let us know and we will resend.All the best....

Product: DataEase for Windows 5.x and before.... Written by DataEase 11/02/15 at 14:21:13

Re:Re:Re:Re:Re:Re:Re:i hope you can help me import this to a new program here is the the compleete program i think

You will be able to download the app here, if the mail failed....

Product: DataEase for Windows 5.x and before.... Written by DataEase 12/02/15 at 17:47:48

Dynamic Import File

Is there any way to create import dynamically?File name and location might change depending on the user login....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 14/11/15 at 20:48:00

Re:Dynamic Import File

Hallo there,i think it may be a solution to use a dynamic var that stores the pathname u want to use.depending on the user that is logged in. Check it by using "current user name".and than using concat to create it...Hope this giv...

Product: Dataease [{8}]FIVE. Written by Markus 14/11/15 at 21:09:18

Re:Re:Dynamic Import File

Hi Markus,That is a good idea. But, how do we use it in import ?See the screen below;<img border="0" src="file:///C:...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 15/11/15 at 15:10:42

Re:Re:Re:Dynamic Import File

Download Sample! Hello Boys. 100 points for effort, and 0...

Product: Dataease [{8}]FIVE. Written by DataEase 15/11/15 at 15:48:43

Re:Re:Re:Re:Dynamic Import File

WOW!I know DataEase can do anything :-)There are so many undocumented features. Not sure if you will document them in the future or just find out as we go along.Thank you....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 15/11/15 at 16:23:10

Re:Re:Re:Re:Re:Dynamic Import File

On the same subject. I am trying to export using dynamic file name.&nbsp;I was able to do this long time ago. But, it seems to be not working now. Could you please see the screen below and tell me what is wrong?In the following script, g...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 15/11/15 at 17:33:19

Re:Re:Re:Re:Re:Re:Dynamic Import File

Resolved!!I thought I had enough rights. But, it was an issue with the local rights. As soon as I get the rights, everything is moving smooth.Thank again for opening up the import dynamic feature....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 15/11/15 at 18:46:16

Re:Re:Re:Re:Re:Re:Re:Dynamic Import File

Glad you fixed it yourself ;-)Why you choose to do it this way when you can do it so much better and easier in ExecDQL is both worrying and depressing...he,he.Did you know that if you were to export ex. 100.000 records this way it woul...

Product: Dataease [{8}]FIVE. Written by DataEase 16/11/15 at 08:45:09

Re:Re:Re:Re:Re:Re:Re:Re:Dynamic Import File

I know you were going to say that :-)But, I have already converted all the DQLs into ExecDQL. By learning the hard way, yes it takes 100s of years...:-) using DQL export.Only thing I see about DQL, we can use whatever field separator we...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 16/11/15 at 14:09:58

Import into DataEase 8

We have done some initial testing and like what we see. How do we import records from a csv file? I guess what I'm asking is there a "field mapping"option where we can select the fields and map them.What I am seeing is that there appea...

Product: Dataease [{8}]FIVE. Written by Barry Peterson 12/01/16 at 09:50:09

Re:Import into DataEase 8

If you can't manipulate the export file i.e. decide what names the columns get in the file and you don't want to be limited to field order or use the same field names in the DataEase application, the best way is to simply make a temporary table in DE8...

Product: Dataease [{8}]FIVE. Written by DataEase 12/01/16 at 09:51:09

Import csv

I have problems to import csv data with the decimal. The coma in csv is a point and in dataease a coma.The function Import "insert decimals for fixed point field" does only work when you have 0,12 or 0,50 but not when you have 0,5...

Product: Dataease [{8}]FIVE. Written by Rainer 16/02/16 at 09:31:28

Re:Import csv

Hmmm...Commas and national characters is a returning problem in Dataease, and I think it has been "solved" a 1000 times and every time in a slightly different way...DataEase use . in cod...

Product: Dataease [{8}]FIVE. Written by DataEase 17/02/16 at 16:15:08

Importing a yes/no field

Hi there,I am trying to import data from a text file using the import dialog (and then this will be saved into a .dbi), but I am having hard time to import a yes/no field; I tried to use&nbsp;the word yes and no (using quotes ' , double quotes...

Product: Dataease [{8}]FIVE. Written by George Washington 26/04/16 at 10:26:09

Re:Importing a yes/no field

Just did a test and it worked fine. SomeText~YesNo~Choice<span style="color: rgb(192, 80, 77);"...

Product: Dataease [{8}]FIVE. Written by DataEase 26/04/16 at 11:53:10

Re:Importing a yes/no field

The name of the field in the first row of import file was mispelled (blush)....

Product: Dataease [{8}]FIVE. Written by George Washington 26/04/16 at 11:59:51

Automatic import of data

HI there,I am struggling with a data import problem. I have those data in another system that has to be imported regularly, let's say every hour, into DataEase. I scheduled&nbsp; an appropriate task in our windows server that launch dataease: d...

Product: Dataease [{8}]FIVE. Written by George Washington 27/04/16 at 06:39:52

Re:Re:Importing a yes/no field

Don't beat yourself up over it. The majority of bugs we "struggle" with in the DataEase code too is misspelling...We have an internal procedure of copy/pasting variable names as the first "debugging" round simply to help with the widespread "d...

Product: Dataease [{8}]FIVE. Written by DataEase 28/04/16 at 09:53:51

Re:Automatic import of data

At the end of the day I found easier to create a custom function that reads the input txt file and then create / update the records; it is just few lines and gives me more control over the import e.g. create a log file and check consistencies of impor...

Product: Dataease [{8}]FIVE. Written by George Washington 03/05/16 at 09:33:51

How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file?”

I understand that the .DBE file can be run using a CDF “Data Export” on a button action placed on the form itself. But I want to run multiple exports using defined .DBE files from a procedure. Is this possible?...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 29/06/17 at 13:23:59

Re:How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file??

Hi Henry.I think we have discussed this somewhere before, but we would never like to miss an opportunity to clarify this again.It is quite funny because in DFD you had imports but not exports, but then again you had the worlds best exp...

Product: Dataease [{8}]FIVE. Written by DataEase 29/06/17 at 14:16:29

Re:Re:How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file??

Hello Customer Care Team,How about a sample script using ExecDQL ?RegardsHenry...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 02/07/17 at 11:50:18

Re:Re:Re:How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file??

Download Sample I know we keep on harping on this but DQL is DQL, syntax wise that is true at least. ...

Product: Dataease [{8}]FIVE. Written by DataEase 02/07/17 at 11:54:20

Re:Re:Re:Re:How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file??

Thank you for your prompt reply and sample. It looks quite good and exports really fast. Well done.However, I do not see any mention of the “FORMEXP.DBE” file anywhere in the ExecDQL. Am I missing something or are you not using the dbe file an...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 03/07/17 at 17:45:02

Re:Re:Re:Re:Re:How can I use a defined Export .DBE file in a dql or script like I can with an Import .DBI file??

Downlaod Revised Sample! Hi. Sorry for the "long winded" reply. The short answer to your question...

Product: Dataease [{8}]FIVE. Written by DataEase 03/07/17 at 18:35:16

Import data directly from an Excel file

Hi All,Just wondering if it is possible to&nbsp;import data directly from an Excel file without having to change or save the file in a different format. In other words what is the fastest way to import data from an Excel file? I have been sa...

Product: . Written by 28/09/17 at 18:00:24

Re:Import data directly from an Excel file

Hi. SOrry for the late reply.The quick answer is no. Excel format is not purely a data format but a document format which need to be interpreted.To allow us to import directly from Excel it would mean that the user had to follo...

Product: . Written by DataEase 07/10/17 at 14:06:21

Re:Re:Import data directly from an Excel file

But it would be great to import from Excel ... but it will be fantastic for DataEase sales in Ukraine if DataEase can import from russian software called 1C ( from 7.* up to&nbsp;8.* versions).&nbsp;...

Product: Not product specific.. Written by Ihor Zakharchenko 07/10/17 at 18:48:32

Re:Re:Re:Import data directly from an Excel file

as to 1c&nbsp;https://en.wikipedia.org/wiki/1C_Company...

Product: Not product specific.. Written by Ihor Zakharchenko 07/10/17 at 18:53:20

Importing data with quotation marks.

Hi all,When I import data that has quotation&nbsp;marks in the text (see example below)&nbsp;extra quotations marks get added to the data. Is there something I can do to prevent this? If it helps to know it is&nbsp;tab delimited data that I am...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 05/02/18 at 22:48:29

Re:Importing data with quotation marks.

I think the problem is that the code is built to handle quote delimited text without there being an option to turn this off.&nbsp;A workaround is to search and replace the quote mark for a character that does not appear in your data, and then r...

Product: Dataease [{8}]FIVE. Written by Adrian Jones 07/02/18 at 15:42:04

Re:Importing data with quotation marks.

We just tested the scenario where the data attached and it worked fine.his is a tab separated file with " (copied from the data you wrote in).<img src="/s...

Product: Dataease [{8}]FIVE. Written by DataEase 08/02/18 at 21:53:51

On the blog about import

New Function in 8 - MemoReplace() - Replace a string in a memo. Wake up, this is important! (Ver. 8.0.0.1006)

So what is so important with a simple Replace function?Everything! This is how you can really manipulate your Memo's to behave the way you want them too.It is called Memo Class for a reason, it is in combination they become powerful!...

Product: Dataease [{8}]FIVE. Written by DataEase 05/10/11 at 12:19:30

IMPORTANT UPDATE of 8 - Fix of corrupted Tab Control that causes GPF (Ver. 8.0.0.1207)

We have been aware for a while that tab controls migrated from 7.x have a tendency to cause GPF when opening a form in 8.&nbsp;Tab Controls was introduced in 7.x and the implementation work was not of high quality the same as so much of the ot...

Product: Dataease [{8}]FIVE. Written by DataEase 23/01/13 at 23:45:01

Re:IMPORTANT UPDATE of 8 - Fix of corrupted Tab Control that causes GPF (Ver. 8.0.0.1207)

please send serial number DataEase 8...

Product: Dataease [{8}]FIVE. Written by peyman norouzi 31/01/13 at 13:40:14

DataEase 8 - Important Fix - Layout/Output/Orientation/WYSIWYG - Reports/DQL/Print (Ver. 8.0.0.1238)

There has been a "nasty" bug in DataEase 8 when calling a procedure/report from a script/DQL/Button where the Print Settings has been ignored and the output is done to default settings.The problem was old and go back to the "beginning" of Data...

Product: Dataease [{8}]FIVE. Written by DataEase 06/03/13 at 12:38:15

New Release - DataEase 8.0.0.1358 - Important Change! Set/GetGlobal() changed to Set/GetVar()

We have now changed SetGlobal() and GetGlobal() internal function to SetVar() and GetVar().If you have used our internal SetGlobal()/GetGlobal() function you will need to change your code to reflect the function name changes.We have ch...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/13 at 13:35:17

Important Fix in 8 - Table Already exist and mismatch between form and table (Ver. 8.0.0.1364)

DataEase 8 development has branched out. Up till now we have solely focused on adding new functionality to 8 and bug fixing has only been done when related to new functionality or old functionality impacted/used/involved in new functiona...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/13 at 16:33:08

+Wait(0.1)+ What is this and why is it so important in DataEase 8?

DataEase for Windows use POST to launch functions. For those of you that doesn't know the difference between POST and SEND in Windows I will offer a simple explanation.POST means fire and forget and leave it all to windows.SEND means - "He...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/15 at 15:58:24