migrate to SQL
Not sure if it will work in Studio, but with Classic you could set up a ODBC user and open all the files and fields to have open access to them. Then any other person could then use ODBC to read what ever they want from the datafile, and if you use Excel to open the files it does the headings for you as well.
Thanks
Jim
JACSoft Programming Ltd. <www.jacsoft.co.nz/main.shtml>
> On 24/08/2017, at 10:02 am, Grant Thiessen bookitinc <bookit@bookitinc.com> wrote:
>
> A client for whom I have only been providing on-call support for several years, has hired a new programmer to provide them with an entirely new program to run their business, and they are doing it in SQL, and not in Omnis.
>
> Frankly, I am happy to see the last of them, but that is another story.
>
> They have requested one last service from me – to provide them with a tool to export all of the data from the multi-segment DFs that they have (3 segments), in Excel format, for subsequent import into the SQL database.
>
> They would require column headers equal to the field names.
>
> I am pretty much retired from programming. (I know, I’m only 70, what am I doing quitting so young?) However, as my programming time spent over the last several years probably is closer to days, rather than weeks, I am sure I could accomplish this, but not without false steps, and definitely not in the most efficient fashion.
>
> Does anyone have code they wish to share which would accomplish this task? It would need to step through the file structure, then export the data for each file into a separate Excel spreadsheet (I have always found tab-delimited). Probably not relevant, but they are all Mac, using Studio 4.3.x, so it’s pre-unicode, and will not be upgraded to Unicode in Studio.
>
> Or, is there a better way to do this? It’s got to be pretty straightforward, since the clients will be performing this themselves if possible, and they are remote from my location.
>
> Clean-up of data in preparation for import to SQL tables has not been discussed. If someone has code that integrates this, it wouldn’t hurt, but I am not taking responsibility for data quality.
>
> Thanks in advance,
>
> Grant
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com