Store data's in RDBMS

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
Guest

Store data's in RDBMS

Post by Guest »

We're very happy to have a forum. We hope that whole Cspro's user around the world will help each other to resolve challenges.
The greatest challenge for us now is to store data's in RDBMS. It's because, if someone can help us to set up a tools to export txt or dat files in MySQL, PostgreSQL. That's very useful for the whole community of Cspro's user. It's the most urgent request for us.

Please, help us.
Regards,
A seven year old Cspro user.
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Store data's in RDBMS

Post by Gregory Martin »

Adding this feature to the export tool may be not be so difficult. How would you want different types of records handled? Would each record be a different table in a database (linked through the ID)? And with a multiply occurring record, would a row number field be added?

What are your thoughts on how this should be done?
Guest

Re: Store data's in RDBMS

Post by Guest »

A tools to export directly in DBMS must:
1.- Export each records without multiples occurrences items or rosters in one table, with ID items (first record, firsts items in the Cspro's dictionary) as Primary Key row.
2.- Export each multiples occurrences items in one table, with ID items as first row, no PK.
3.- Export Roster as separate records, in one table, with ID items as first row, no PK.

The ID items must be the linked row and automatically added as the first row of each table (containing occurrences items or no), Primary key when there's no multiples occurrences in a record item.

*This tools must be able to compare data files and theses already stored in the DDBMS and add only items lines who're not already in the DBMS.
*This tools must be able to "auto refreshed", use multiple data file for a specific dictionary.
Dictionary file---Multiple data file---odbc---Mysql, postgresql, Sql server, oracle
Regards,
Post Reply