dbTalk Databases Forums  

jBase Spooler - how do I write to a file?

Go Back dbTalk Databases Forums Databases comp.databases.pick jBase Spooler - how do I write to a file?

comp.databases.pick comp.databases.pick


Discuss jBase Spooler - how do I write to a file? in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rockingred
 
Posts: n/a

Default jBase Spooler - how do I write to a file? - 10-27-2003 , 03:33 PM






I have a hold entry. I want to write the output to a file to transfer
to my NT side. If I type in "SP-EDIT 40" I seem to drop into a regular
editor. So... :



1. Is the spooler already using a file and I can use a simple copy
command. If so what is the name of the file that I'ld want to copy
from. (The ? command did not show me a file name).



2. Can I use the "FIS filename itemname" in jBase to copy the record to
a new place where I can play with it?



3. Is there some other command I should be using to copy a hold entry
to a file?



I tried checking the jBase Knowledgebase, but couldn't find anything
dealing with writing hold entries to files.


--
Posted via http://dbforums.com

Reply With Quote
  #2  
Old   
rockingred
 
Posts: n/a

Default Re: jBase Spooler - how do I write to a file? - 10-28-2003 , 08:36 AM






Originally posted by Terry Layne

Quote:

Under Linux you'd look in /var/jspooler/jobs/formqueue_n and
find files

named by their job number. These are simple text files and you could

copy somewhere and do whatever with them. I'm sure NT has something

just as simple and easy to deal with. :-)


hmmm... I'll have to hunt and see if I can find the directory...



Quote:
I don't know, what is FIS?



Whoops typo. "FS(filename itemname" is a standard Pick Editor command
that can be used to copy items. On second thought this one definitely
would NOT work for the use I intend to put it to.



You could set up another FORMQUEUE with a printer device of
PROG myscript where myscript would take whatever was thrown at it and
write one copy to a directory of your choice and then print another
copy to the printer you would normally use.



This might be the solution we have to go with. However that means all
the printing of items we want to copy could only be done to one
printer, because I have no intention of creating 20 phantom printers.



If the print job is created by a Basic program it would be
easier to just modify the program to send a copy off for processing
and print another copy.



It is a Basic program, however it's one provided by a 3rd party
vendor. If we change it we would have to compare every update they
send us to our version and reinsert our printer code if there is a
change. We're trying to avoid doing that, because if we forget just
once we lose our copies.



If it comes from a jQL statement you my want to

play with the pseudo printer idea. Playing with records in the
spooler

directory might be considered bad form in some shops, so make sure no

one is looking if you go that way.


Actually the department head suggested we might want to set up another
printer and force the printing program to use that printer... So we may
be headed down this route.



Thanks for all your suggestions... it gives me a few ideas.


--
Posted via http://dbforums.com


Reply With Quote
  #3  
Old   
rockingred
 
Posts: n/a

Default Re: jBase Spooler - how do I write to a file? - 10-29-2003 , 09:11 AM



On Release 13 or 15 you should use:



SP-EDIT entry# (I

then you will be prompted for Filename and Itemname. So in a program
your code would look like:



DATA "WORKFILE TEST"

EXECUTE "SP-EDIT ":HOLD.ENTRY.NO:" (I"


--
Posted via http://dbforums.com

Reply With Quote
  #4  
Old   
Simon Verona
 
Posts: n/a

Default Re: jBase Spooler - how do I write to a file? - 11-02-2003 , 03:55 PM


as a footnote to this.. jBase has a little documented command called
jspcmds...

eg you can do

Quote:
jspcmds COPYDELETE dosfilename.txt 5
(where 5 is the print job no and dosfilename.txt can be any dos/unix
filename)..

Check out the jbase knowledgebase (www.jbase.com) for further details..

regards
Simon
"rockingred" <member35589 (AT) dbforums (DOT) com> wrote

Quote:
On Release 13 or 15 you should use:



SP-EDIT entry# (I

then you will be prompted for Filename and Itemname. So in a program
your code would look like:



DATA "WORKFILE TEST"

EXECUTE "SP-EDIT ":HOLD.ENTRY.NO:" (I"


--
Posted via http://dbforums.com



Reply With Quote
  #5  
Old   
rockingred
 
Posts: n/a

Default Re: jBase Spooler - how do I write to a file? - 11-04-2003 , 08:11 AM



Originally posted by Simon Verona

Quote:
as a footnote to this.. jBase has a little documented command called

jspcmds...



eg you can do



jspcmds COPYDELETE dosfilename.txt 5



(where 5 is the print job no and dosfilename.txt can be any dos/unix

filename)..



Check out the jbase knowledgebase (www.jbase.com) for further
details..



regards

Simon


"Little documented" is right! I used the jBase search function and only
found notes about the patches for this command, but not the actual usage
of it. I then tried the Knowledgebase Main Index, looked under SPOOLER
and it doesn't mention the command at all.



Is there a hard copy jBase manual that is worth getting that would
include this command? (I prefer hard copy because I can scribble
additional information on the pages, for example in my Pick Pocket Guide
in the blank "Notes" pages provided in the back I list the pages on
which to find User Exits, Date Conversions, Money Conversions, Time
Conversions etc.)


--
Posted via http://dbforums.com


Reply With Quote
  #6  
Old   
Simon Verona
 
Posts: n/a

Default Re: jBase Spooler - how do I write to a file? - 11-07-2003 , 03:20 PM


I think you can download reference manuals in pdf file from jBase's web site
(www.jbase.com). Don't bank on them being any more complete though.

I guess jBase's problem is like most software companies (ourselves
included)... Documentation of new software takes longer than actually
writing it.. so if something is written initially for only a specific user,
it doesn't get documented - but slowly more and more users will use it (I
was informed of the command by jBase's developer support team).

jBase is a great product, unfortunately jBase sometimes do their best to
hide some of the "greatness"!!!

Regards
Simon
"rockingred" <member35589 (AT) dbforums (DOT) com> wrote

Quote:
Originally posted by Simon Verona

as a footnote to this.. jBase has a little documented command called

jspcmds...



eg you can do



jspcmds COPYDELETE dosfilename.txt 5



(where 5 is the print job no and dosfilename.txt can be any dos/unix

filename)..



Check out the jbase knowledgebase (www.jbase.com) for further
details..



regards

Simon



"Little documented" is right! I used the jBase search function and only
found notes about the patches for this command, but not the actual usage
of it. I then tried the Knowledgebase Main Index, looked under SPOOLER
and it doesn't mention the command at all.



Is there a hard copy jBase manual that is worth getting that would
include this command? (I prefer hard copy because I can scribble
additional information on the pages, for example in my Pick Pocket Guide
in the blank "Notes" pages provided in the back I list the pages on
which to find User Exits, Date Conversions, Money Conversions, Time
Conversions etc.)


--
Posted via http://dbforums.com



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top