I am able to create a Dictionary and import the headers and data only after I do the following:
- Download the raw query of information to a csv format from the database that I use everyday
- import the csv to OpenOffice then export to a .CSV (would like to skip this step) The Raw .csv does not build the data when creating the dictionary.
- open Clarion 11 and import the table into a dictionary, I have to redirect some of the selections to point to the file
- I do a New clarion project and build the app that only has the 1 Browse
- I run it and the header is there plus the data, I do test that the data is there during the Library Build.
- I test stuff like fuzzy search to test the file, it works as well on the csv file format.
- Next step is to find out what the CSV in step1 is missing/or does not have in order to skip the import/export step that I have to do with the spreadsheet.
I can also START working with the data to push the successful csv clarion 11 browse to a tps format so I can manipulate the data the way I need to see it and give it functionality.
In testing, once I had the data/headers/Browse built, I can change the data in the Open Office created csv file with notepad by adding, deleting, pasting and creating new lines of data and it shows up in the Browse Created by the App Clarion created, I do not have to run it through Open Office again, the csv can be modified and it reflects the changes in the app the wizard created.
So this is where I am at for the moment, 2 challenges ahead are to make the exported file from the data I need compatible with the Clarion Dictionary without having to push it through a spreadsheet and
then save to csv
The second objective is to create a TPS that I can move the imported CSV data to so I can manipulate the Data or create the progam. I know this may need some hard coding but will experiment and see what I can come up with, I am sure I will have more questions.
regards