Lantica User Forum - Cant Export!

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Cant Export!

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: [1]

Send Topic

Print

Hot Topic (More than 10 Replies)

Cant Export! (Read 2522 times)

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Cant Export! Jun 15^th, 2004 at 3:22pm	Print Post
	Since upgrading to 1.0.4 I've been having problems exporting data from Sesame. (Parent record and subrecords) Using the default settings or custom settings, the CPU meter jumps up to about 85% and sesame just sits on the export screen (after pressing export button). I tried to export (all LE's) on just 10 records and finally had to 'end task' after about 1/2 hour. I also watched the virutal memory slowly diminish, then had to restart the server due to "insufficient memory" after the 'end task'. Anyone else having problems exporting? Steve


	WWW IP Logged

jondolar Junior Member Offline Keep Trying Posts: 57 Location: Montreal Canada Joined: Dec 25^th, 2003	Re: Cant Export! Reply #1 - Jun 15^th, 2004 at 4:27pm	Print Post
	Hi Steve I also have an exporting problem. Right now, all my databases are using Relational links. I want to try going Natural Links. I follow Erika's rules`... Quote: You do not need to alter any of your existing Forms, except for the Subform containers on the Parent Form. 1. From your top level Parent Form, export all the data, including all the data from all the subrecords. Just choose Set All in the Export Spec and accept the defaults. 2. Go into your design. Delete all the subforms from your Parent Form. 3. Using Field Manager, delete all the Subrecord fields from your Parent Database. 4. Go into the design of your Parent Form. Put all the Subforms back in, this time selecting Natural Linking. 5. Go into Preview and import the file you exported. Following Rule 1, I get the following message: ASCII Export failed to create file Samples\Orders_Clients_Products All fields (form and subforms) appear corectly in the spec manager. Any Idea Regards Serge

	When all you have is a hammer, everything starts to look like nail!
	IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Cant Export! Reply #2 - Jun 15^th, 2004 at 4:31pm	Print Post
	Ya, i'm trying step 1, also. At least your getting an error message. I'm not getting anything. Probably a bug in this new version. STeve


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #3 - Jun 15^th, 2004 at 8:25pm	Print Post
	Yep, we surely busted something. We're looking into it now...

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Cant Export! Reply #4 - Jun 15^th, 2004 at 8:32pm	Print Post
	Please let us know how to work around this since its an important tool. Thanks, Steve


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #5 - Jun 15^th, 2004 at 8:33pm	Print Post
	Steve, Are you including an unbound element in your export? If so, I'm betting that removing it will fix your lockup. We are looking at catching this, but, meanwhile, getting the unbounds out of your export should fix the lockup.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Cant Export! Reply #6 - Jun 15^th, 2004 at 8:36pm	Print Post
	I think your right. There IS a workaround becuase I was able to export yesterday when only exporting a couple of LE's. If I have time, I'll try your suggestion tonight and let you know the results. Thanks, Steve


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #7 - Jun 15^th, 2004 at 9:13pm	Print Post
	Found it. Fixed it.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Cant Export! Reply #8 - Jun 15^th, 2004 at 9:19pm	Print Post
	Your quick. Thanks. So as a workaround, we can't export unbound elements, or is there a simpler remedy? Thanks, Steve


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #9 - Jun 15^th, 2004 at 9:26pm	Print Post
	Correct. The workaround is to not select unbound elements as part of your export.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jondolar Junior Member Offline Keep Trying Posts: 57 Location: Montreal Canada Joined: Dec 25^th, 2003	Re: Cant Export! Reply #10 - Jun 15^th, 2004 at 9:42pm	Print Post
	Erika As far as know, I don't ha any unbound Elements except for the subforms ??? Serge

	When all you have is a hammer, everything starts to look like nail!
	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #11 - Jun 15^th, 2004 at 9:53pm	Print Post
	Quote: Erika As far as know, I don't ha any unbound Elements except for the subforms ??? Serge Serge, Judging from your error message, you have a different problem. Either the directory you are trying to write to does not exist, or you do not have permission to write to it.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

spanitz Member Offline --Arbeit macht das Leben suess-- Posts: 29 Location: Chicago Joined: May 28^th, 2004	Re: Cant Export! Reply #12 - Jun 15^th, 2004 at 10:30pm	Print Post
	Count me in for this problem. I get the same error. I'm not sure what you mean by unbound elements, but we only have one form with all the fields on it, and are trying to export all as-is from one .DB file. ???

	Eric A. Spanitz&&Spanitz Consulting, Inc.&&www.spanitz.com
	WWW IP Logged

jondolar Junior Member Offline Keep Trying Posts: 57 Location: Montreal Canada Joined: Dec 25^th, 2003	Re: Cant Export! Reply #13 - Jun 15^th, 2004 at 10:56pm	Print Post
	Erika This is a single user app and I'm trying to save to Sesame\Data\Samples which is shared. Serge

	When all you have is a hammer, everything starts to look like nail!
	IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Cant Export! Reply #14 - Jun 16^th, 2004 at 2:44am	Print Post
	I was able to export feilds from the Parent and the subform, so I think Erika is correct in that it must be one of the unbound LE's that is crashing the export. Spanitz, an unbound LE is a field that does not store data when the record is closed. Its like a temporary placeholder for data that gets wiped out each time the record is closed. Just FYI.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #15 - Jun 16^th, 2004 at 10:32am	Print Post
	Quote: Erika This is a single user app and I'm trying to save to Sesame\Data\Samples which is shared. Serge Shared does not equate to permission. What is the Start In directory setting in your shortcut?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

jondolar Junior Member Offline Keep Trying Posts: 57 Location: Montreal Canada Joined: Dec 25^th, 2003	Re: Cant Export! Reply #16 - Jun 16^th, 2004 at 10:44am	Print Post
	Erika You'r right, It has something todo with path. If I specify full path C:\Sesame\Data\Samples\MyFile.csv, it works. if I click on Sample in the ASCII Export box and complete... Samples\MyFile.csv, it does not work. Thanks for the help. Serge

	When all you have is a hammer, everything starts to look like nail!
	IP Logged

spanitz Member Offline --Arbeit macht das Leben suess-- Posts: 29 Location: Chicago Joined: May 28^th, 2004	Re: Cant Export! Reply #17 - Jun 16^th, 2004 at 12:44pm	Print Post
	<okay - another stupid question> Steve, thanks for the explanation. How would I end up with an unbound field? I created these databases (10? 15?) years ago in Q&A and all fields are visible and used (they all save data and can be searched on later).

	Eric A. Spanitz&&Spanitz Consulting, Inc.&&www.spanitz.com
	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Cant Export! Reply #18 - Jun 16^th, 2004 at 1:09pm	Print Post
	Quote: <okay - another stupid question> Steve, thanks for the explanation. How would I end up with an unbound field? I created these databases (10? 15?) years ago in Q&A and all fields are visible and used (they all save data and can be searched on later). You probably don't have any. Why do you believe you do? Are you locking up when you try to export?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Page Index Toggle

Pages: [1]

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge