I don’t want to bust anyone’s bubble but the whole point of my (question/topic), Is there a way that Clarion can handle a simple import and export of Basic data into a Clarion TPS format. Pretty much the answer is no.
I was an early customer of Clarion going back to the dos version all the way up to 5.5 before I started AS400/IBM work, I didn’t loose interest I just did not have the time.
You guys have had great suggestions and some of them worked, I do not mind hard coding if necessary, but when I purchased this software again, 30 odd years later, I assumed this minor issue was addressed so developers can get to creating the app instead of having to code to get the data. You would think that the neandrathal Clarion would have evolved to tackle this simple task 30 years later and would just be a simple procdure without plugins or additional coding, as far as my knowledge that did not happen.
There are a lot of hoops to jump through to accomplish this simple task, disappointed in Clarion at the moment, I did SQL work for 7 years but do not want to do it in my home enviroment and developement process unless absolutely necessary. SQL is wonderful but I do not want to use that as an alternative to gathering data for a TPS file when a simple import procedure should be in place for the Clarion product, this should have been implemented years ago. On the drawing board, it should be let’s take DataA to DataB, and this is how we do it, it doesn’t matter which format it is in.
So, why do I not have a problem exporting data and importing the same data file into google sheets, excel or OpenOffice and manipulating with no issues. I can take the same file with Clarion and it is sucking it’s thumb trying to figure out what to do. It probably depends on format, but why have other companies figued it out and Clarion is still sitting on their hands, this should be a simple import/export function/procedure so design and functionality of the project can move along without being a cumbersome task building the foundation of the App in the first place. Sure the Dictionary can be manipulated to show the data from a .csv but the Clarion development environment to create an application is lacking in utilizing the work that has already been performed in the Dictionary you created. Wonderful you can create a Browse on the CSV, Not to wonderful on the options to manipulate it or convert to a TSP, this should be a procedure within the Clarion development environment.
I am sure this has been asked and addressed many times but I am not a firm believer in re-creating the wheel when softvelocity/Clarion can do better. No matter what file format needs converted, there should be a better way to manipulate it within the Clarion program, right now it is Dictionary design and hard coding to get a simple project off the ground due to Data Manipulation with the Clarion tools, this should be an all inclusive process.
Regards,