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 dtagcayman@yahoo.com 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 grohmann.papier@t-online.de 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. 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 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 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 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
Importing data with quotation marks.
Hi all,When I import data that has quotation marks in the text (see example below) extra quotations marks get added to the data. Is there something I can do to prevent this? If it helps to know it is 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. 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
Modify Import DBI file source
Is there DE8.5 DataEase Import file spec modify function that can update the import source file on an existing DBI file?In DE 6.53 there is a set of CDF's from Lawrence Fox which includes a WizModifyImport function that does this.Unfortuna...
Product: . Written by Sam Bird 23/11/22 at 04:35:49
Re:Modify Import DBI file source
The reason the CDF's from 6.x doesn't work is because the format was changed not in 8 but in 7 for some reason that nobody alive can answer.It was changed from the standard binary file structure that has been DataEase since DFD 1.0 to XML....
Product: Dataease [{8}]FIVE. Written by DataEase 23/11/22 at 12:08:51
Re:Re:Modify Import DBI file source
The data source file has a proprietary format which cannot be changed. All that changes is the name of the file.If there is no 8.5 alternative for WizmodifyImport then i suppose the only option is to use a single DBI definition with a stat...
Product: Dataease [{8}]FIVE. Written by Sam Bird 23/11/22 at 17:50:25
Re:Re:Re:Modify Import DBI file source
You just change the name of the file in the DBI. Easy as chips. Its a text file in XML format....
Product: Dataease [{8}]FIVE. Written by DataEase 23/11/22 at 18:25:14
Re:Re:Re:Re:Modify Import DBI file source
ok, i see that now.Thank you...
Product: Dataease [{8}]FIVE. Written by Sam Bird 24/11/22 at 01:47:28
Importing Date Data
Hi, have been using Datease for over 30 odd years, originally DOS then windows. I had been using LegEasy 6.53 and thought id treat myself to an update, unfortunately only Dataease 8.5 is available so I have purchased this. I am in the process of rewri...
Product: DataEase 8.5 Runtime. Written by steve Turnbull 07/04/23 at 16:18:12
Re:Importing Date Data
Are you trying to import directly from the DBM files? If so the format has changed from 6 to 7 (and 8) so DBM import might not get the date format correctly (there was a lot of mess with changing over from how to decide the format from co...
Product: DataEase 8.5 Runtime. Written by DataEase 12/04/23 at 11:28:14
Re:Re:Importing Date Data
Sorted, It was my own fault, I did read on the help menu regarding date fields being the same. I made sure that they were but forgot to check the computer date which was the extended version. Changed both databases to match and imported perfect. Thank...
Product: DataEase 8.5 Runtime. Written by steve Turnbull 13/04/23 at 14:19:38
Register
Sign In
