Normal Topic Export - Import Problem (Read 713 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Export - Import Problem
Oct 28th, 2010 at 2:37pm
Print Post Print Post  
Hello!

I wish  to export data using a report (EXPORT) data in external - Application "AUFNAHME" . So i import the exported file (Ascii) again in the running Form.
Only the export file is created. But the Import part is locked?
I recognized that the manually Import function is not available anymore.
So i must leave and restart Sesame again to end the Import-part.

why is the import is locked and the subroutine Importieren() does not happen.

must i use two Button one for the Export und One for the Import?
Thank you for your help.

...

Subroutine Importiere()

var n as Int
var vLfdNr as Int
var vsucheab as String
var VCL as String
var vFile as String 
var vFH as Int
var vASC as String = "F:\Sesame2\Data\EXPORT\AUFNAHMEHeute.TXT"
var vStr as String
var vRun as Int
var vSpec as String
var vdatei as String

     Loiter(4000)
//@Msg("Das Exportieren ist fertig und Danke fürs Warten..")

     vSpec   = "Importiere von AUFNAHME"

      vRun    = @LoadImportSpec(vSpec)
     If vRun = 1
     {
           If FileExists(vASC )
           {
                 RunImportSpec(vASC)
           }
           Else
           {
                 @Msg("Ich finde die import Datei nicht " + vASC)
           }
     }
     Else
     {
           @Msg("Die Import spec name " + vSpec +" nicht vorhanden!")
     }

End Subroutine



IF @Mode() = 0
{
vList1  = "SEROLOGIE;CHEMIE;Abb"

           PopupSelectPosition(3, @XPos(ThisElement) + (@Width(ThisElement) / 2) , @YPos(ThisElement) + @Height(ThisElement))
           vDatei = @PopupChoiceList("@m" + @Replace(vList1, ";", ";@m"), " Welche Datei möchten Sie importieren?")
           vdatei  = @Replace(vdatei, "@m", "")


IF vDatei <> "abb" then
{
vRSMax = @XResultSetSearch(@FN,"SEROLOGIE", 0,2, "!LfdNr=Max1")
IF vRSMax > -1 then
{
vMax = @XResultSetValue(vRSMax, "LfdNr")
vMax = @str(@replace(vMax,",00000000",""))
}
XResultSetClose(vRSMax)

vRSHandle = @XResultSetSearch("Data\MDLAUFNAHME.DB", "Aufnahme", 0,2, "!LfdNr=>" + vMax ,  "!SEROLOGIE=YES" )
     
IF(vRSHandle > -1) Then
{
     XResultSetSort(vRSHandle, "LfdNr:1")
     vRSRecordCount = @XResultSetTotal(vRSHandle)
    IF @ASKUSER("SIND SIE SICHER DASS SIE  ",  vRSRecordCount + " DATENSÄTZE EXPORTIEREN","UND HIER IMPORTIEREN MÖCHTEN?") = "YES"
     THEN {
vFileName = @XResultSetPrintReport("EXPORT",vRSHandle, 4)

XResultSetClose(vRSHandle)

@MSGBOX(vRSRecordCount + " Aufträege wurden zu Datei " + sPath + vExportFile," exportiert","")       

IMPORTIERE()

}
}

}
else
@MSGBOX(" Leider KEINE Datensätze für den export ","zu " +  vExportFile," gefunden Für Hilfe fragen Sie einfach Herrn Dr. Belhareth")       
}

Throwfocus(Ruhe)
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Export - Import Problem
Reply #1 - Oct 29th, 2010 at 6:57pm
Print Post Print Post  
Hello Amor,

Quote:
But the Import part is locked? 
I recognized that the manually Import function is not available anymore. 


Are you saying that the import spec window is now gone?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Export - Import Problem
Reply #2 - Oct 29th, 2010 at 8:05pm
Print Post Print Post  
Hello Ray-
Yes, the import spec window is  gone.

Thanks.
« Last Edit: Oct 30th, 2010 at 2:11pm by Amor »  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Export - Import Problem
Reply #3 - Nov 1st, 2010 at 8:09pm
Print Post Print Post  
Hello Amor,

I have tried to replicate this here in a simple case but I have been unable to. Can you send me all the files I would need to test this to support@lantica.com along with how to run the import and export routine so that I can see what you are seeing?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged