I am a "newbie" to Sesame.  I have a very simple, very small data base that I am working with that I have "translated" from Q&A 5.  I am trying to create a "merge" file and receive the following error:

ASCII Export failed to create file Data\merge <merge filename>

Any and all assistance is very much appreciated.

Thanks...

Cliff

Hi Ray...

That is the exact error we are receiving.  I have tried the same procedure several times on two different computers using different iterations of the same data base.  The merge file name we are trying to create is simply mail.txt. 

Is there a "debug" file somewhere that can give me some clue as to what is wrong?  I am either not following the procedure correctly though I it appears to be fairly simple or there is something wrong with my database though it works fine in Q&A.


Frustrated...

Cliff

Yes, understood.  I have tried "mail.txt" to no avail.
I have also tried a few others like test.txt, merge.txt, mgl.txt, etc.

Hello Cliff,

Could you lead me through step by step on what you are doing from the time you enter Sesame to the time that you get that error message?

Also are you running Client/Server or Standalone?

-Ray

Hello Cliff,

Sesame will translate the Q&A databases and I have never heard of a user before who could not export data from a translated Q&A database.

Try exporting just one field. Let me know if it works.
Try exporting just one record. Let me know if it works.

-Ray

The process I am using is as follows:

I open Sesame Plus.
Then select "Translate Q&A", select the appropriate Q&A "DTF" file, then click "ACCEPT" and the thing chugs along with an indication that the translation is 100% complete.

We are then prompted to save the database with a new name.  We select MGL_Q for the file name.  The "DB" extension is applied automatically.

We are then able to view and otherwise work in the translated database.

To export data:  we select "export mgl" in the "spec" window on the left hand side of the application.  We select any single or all or any combination of fields accepted with the default "O" designation for variable field length (changing this has no effect on output).  We then right click the export "spec" bar and then select "RUN" (we have also optionally tried selecting "Results Commands" "Export Data" from the menu on the left upper side of the application window with no change in output).

Once we select "RUN" we are then presented with the ascii export window.  We leave everything as the default except for naming the output file and selecting "Field Name Header" (we have optionally not selected "Field Name Header" with no change in output).

We have tried various output file names as previously indicated.  Some of them are: mail.txt, test.txt, thisone.txt and so on....

Once we have settled on an output file name we then click "Accept" and are immediately presented with the error:  "ASCII Export failed to create file C:\Sesame\Data\test.txt"

Any and all help very much appreciated.

Thank you...

Clff

Hello Cliff,

You either have to run a search in Search/Update mode or have added records in Add Data mode in order to export the data. You have to tell Sesame what data you want exported before you can export it.

-Ray

Cliff,

Just curious, how were you able to see the export spec and run an export WITHOUT a result set?