[ic] Row-level export

John Beima jbeima@reality.palb.com
Thu, 21 Dec 2000 23:31:31 -0700 (MST)

God do I find this message humerious...

Your three ideas...

1) You don't need to do an SQL query. You can just use the [loop] tag and then 
format the output to the screen. That is of course if that is where you want the 
data to wind up.

2) Rip it off, good luck! Personally I would just read the docs on the [export] 
tag, I think that would be much easier...

3) External Program, too much effort, you can do what you want with idea number 

4) Had to add my own... If you need it in a seperate table, create a dummy table 
with the same columns, then search for your data and store it in the other table 
instead of displaying it to the screen. Or hey do both! Then export the dummy 

Personally I like easy answers and #1 & #4 are easy...

Gee after seeing all the questions the last two days, it is more than evident 
that users are NOT reading the documentation. If you expect to be able to dp 
anythign impressive with Interchange you need to READ not SKIM, but READ it.

John Beima

Quoting Dan <db@cyclonehq.dnsalias.net>:

> How do I do a row-level export of a given database record?
> I like the functionality of the Admin->Tables->Export Data.  I would
> like:
>     At the bottom of the table edit page, next to "Edit Checked records
> in
> sequence" would be a "export checked records".  Personally, I'm
> interested
> in a comma-, or tab-delimited text file output (exactly like the
> Tables->Export Data function).
> My ideas at implementing this:
>     - Manually: Do some sql query, format it, and output it.
>     - Rip it off:  steal the functionality from the Export Data
> function.
>     - Externally:  Does anyone know of a program that could easily be
> called
> from IC that would take arguments about accessing the database, and what
> rows to export and where to place the output?
> What do you think would be the best method?  (I'm leaning towards 'rip
> it
> off').
> Details:  IC 4.6.1-release, PostgreSQL 7.0.3, RH6.2
> Thanks for the input and peer-review,
> Dan Browning - danb@cyclonecomputers.com
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

John Beima

P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6