export.dos command returns Object code not found 
Author Message
 export.dos command returns Object code not found

Thanks Mark Brown (Pick Systems) for your response, but there must be
something more to the command than I can find. (use COPY instead of
export on D3/NT)

The old export.dos command allowed you to cocatenate the items into one
file and translate the attribute/value/sub-value marks during the
export. Can the copy command do that too? I can find no options to
support this.

My goal is to export the file to a dos text file, one item per line
translating the attribute marks to "|" and terminating the item with a
cr/lf character.

Mark



Tue, 25 Sep 2001 03:00:00 GMT
 export.dos command returns Object code not found

Mark,

Unless it's a really big file, this is one method I've used on other Pick
variants to get the data into the correct format before moving it out of
Pick.  Set up a DICT item called EXPORT with a correlative that concatenates
all the attributes with your chosen '|' separator.  You can include output
conversions as well if required for dates etc. (as shown on attribute 2
below.

001  S
002  0
003  Export
008  A;0:'|':1:'|':2(D4/):'|':3: ... :'|':n    (where n=last attribute for
export)
009  L
010  80

Then do a SELECT on the file using the EXPORT item and save the resulting
list, which is now your Pick data in the required format.

SELECT filename EXPORT

Quote:
>SAVE-LIST EXPORT.TXT

Then use COPY as Mark suggested to copy the list from POINTER-FILE (or
wherever D3/NT saves its lists) to the desired Dos directory.  This should

--

Regards, John

"Pick people do it with variable length"

Quote:

>Thanks Mark Brown (Pick Systems) for your response, but there must be
>something more to the command than I can find. (use COPY instead of
>export on D3/NT)

>The old export.dos command allowed you to cocatenate the items into one
>file and translate the attribute/value/sub-value marks during the
>export. Can the copy command do that too? I can find no options to
>support this.

>My goal is to export the file to a dos text file, one item per line
>translating the attribute marks to "|" and terminating the item with a
>cr/lf character.

>Mark



Wed, 26 Sep 2001 03:00:00 GMT
 export.dos command returns Object code not found

The copy command under OSFI will translate attribute marks into carriage
returns, but unfortunately will not concatenate items for you.

However, the following may be of some use in a general sense.  Replace
the filenames and delimiters as appropriate.

     open pickfile to f1 else stop 201,pickfile
     open "c:/dosfolder" to f2 else stop 201,"no such dos folder
     exists"
     select f1
     output = ""
     loop
         readnext id else exit
         read rec from f1,id then

             output<-1> = rec
         end
     repeat

     write output on f2,outputID

Of course, this will take a while if you're exporting a ton of data, but
this is pretty much what the old EXPORT program did.  It just had a lot
of stuff about finding the FAT on the floppy and all that.  Export was
never intended to copy data to your hard drives. OSFI is.

That concatenate option might be a good enhancement though...

--
Sincerely,

--
Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc.   USA

"The real art of conversation is not only to say the right thing in the
right place,
 but also to leave unsaid the wrong thing at the moment of temptation."



Fri, 28 Sep 2001 03:00:00 GMT
 export.dos command returns Object code not found
What a great idea.  I would never have thought of that in a million nano-years.

Quote:

> Mark,

> Unless it's a really big file, this is one method I've used on other Pick
> variants to get the data into the correct format before moving it out of
> Pick.  Set up a DICT item called EXPORT with a correlative that concatenates
> all the attributes with your chosen '|' separator.  You can include output
> conversions as well if required for dates etc. (as shown on attribute 2
> below.

> 001  S
> 002  0
> 003  Export
> 008  A;0:'|':1:'|':2(D4/):'|':3: ... :'|':n    (where n=last attribute for
> export)
> 009  L
> 010  80

> Then do a SELECT on the file using the EXPORT item and save the resulting
> list, which is now your Pick data in the required format.

> SELECT filename EXPORT
> >SAVE-LIST EXPORT.TXT

> Then use COPY as Mark suggested to copy the list from POINTER-FILE (or
> wherever D3/NT saves its lists) to the desired Dos directory.  This should

> --

> Regards, John

> "Pick people do it with variable length"


> >Thanks Mark Brown (Pick Systems) for your response, but there must be
> >something more to the command than I can find. (use COPY instead of
> >export on D3/NT)

> >The old export.dos command allowed you to cocatenate the items into one
> >file and translate the attribute/value/sub-value marks during the
> >export. Can the copy command do that too? I can find no options to
> >support this.

> >My goal is to export the file to a dos text file, one item per line
> >translating the attribute marks to "|" and terminating the item with a
> >cr/lf character.

> >Mark

--
Sincerely,

--
Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc.   USA

"The real art of conversation is not only to say the right thing in the right
place,
 but also to leave unsaid the wrong thing at the moment of temptation."



Fri, 28 Sep 2001 03:00:00 GMT
 export.dos command returns Object code not found
Couldn't get it to work. I recall that I have used that form on many occasions
in R83 but this is the first attempt in D3. It still puts just a list of item
IDs in the list. I'll have to play around with it some more.

For now I used the attribut definition here and did a file capture with the
emulator. In this case Procomm worked well. The file only had about 20k items.

Thanks to all. I have another problem I'll present in another message. My
list/sort verbs will not work!

Mark

Quote:

> 001  S
> 002  0
> 003  Export
> 008  A;0:'|':1:'|':2(D4/):'|':3: ... :'|':n    (where n=last attribute for
> export)
> 009  L
> 010  80

> Then do a SELECT on the file using the EXPORT item and save the resulting
> list, which is now your Pick data in the required format.

> SELECT filename EXPORT
> >SAVE-LIST EXPORT.TXT



Sat, 29 Sep 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. D3/NT export.dos object code not found...

2. Help : Return codes for DOS commands in Foxpro...

3. this command did not return data, and it did not return any rows

4. This command did not return data, and it did not return any rows

5. How can an object found can become a not found object

6. LOAD command not updating the recompiled object code

7. ado command object not returning count

8. VB command object with parameter does not return rows from Access 97 .mdb

9. dumpBlobs(): could not open large object: ERROR: inv_open: large object 23312462 not found

10. Returning Recordset and Return Value from Command Object

11. ado command object not accepting connection object

12. Suggestions - DOS Command - Return value


 
Powered by phpBB® Forum Software