Import from CSV File

[vbplg]

Hey everyone,
I am a newbee to Clarion. Using 5.0b with Topspeed database. Is there a way to import data from a csv file automatically without any user intervention? Users currently enter sales info. in a MSSQL database, then they have to enter some of the same info. in the Clarion 5.0b app for the shipping application. I need a way to pull this info from MSSQL to a csv file and then have the Clarion app check reguarly for the file. If the file exists, then import the file contents, assign a unique id to each row and then delete the csv file.

Any help will be greatly appreciated.

(Note: The original programmer decided to sell us the copyrights to the app because he could no longer support it. He didn't have time for us! So here I am.)

 

[SteveW40]

Hi There,

We use hand coded procedures to do this.
It's pretty straight forward.
I think there are 3rdparty programs available also to do this.
MS SQL can export to csv.

Best Regards,


Steve.

 

[vbplg]

Could you elaborate on this some? Again I am new to Clarion and I need to get this solution going as fast as possible. We are currently looking to hire a Clarion programmer to assist me with this, but there doesn't seem to be any around this area.
I checked out the Super Import/Export and Impex software solutions, but the sales reps. stated that these would not do this. That there had to be some form of user intervention. Please help me!!!