Avatar of jsuanque
jsuanqueFlag for Australia asked on

How can i automatically export (csv) SQL results and table contents from a Datafile (DF1).

Hi,
First of all im noobie on application dveelopment especially on Omnis Studio. Currently we have a third party software whose core software uses Omnis studio. Currently there are data (aggregated) that we need (centrally) thats not catered for on each individual locations or sectors which uses the TPS. Thus we want to extract those data (from each individual sector) to a csv file so that we could upload it to SQL server or MS Access (temporary workaround).
If theres anyone who could show me how to do it or at least channel me to any documentations and samples, i'd greatly appreciate it.
Databases

Avatar of undefined
Last Comment
jsuanque

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jsuanque

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
jsuanque

Seems to be a very unpopular software this is. Anyway what i've got somehow helps a bit.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy