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.
Store data's in RDBMS
-
- Posts: 1801
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Store data's in RDBMS
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?
What are your thoughts on how this should be done?
Re: Store data's in RDBMS
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,
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,