Dear CSPro Developer Team,
I would like to transform an old MySQL database to CSDB format for longitudinal survey purpose. Since you don't have any direct tools to perform this, such as https://github.com/csprousers/SQLServer2CSpro ...
I'm trying Excel To CSPro tools, but i faced with his un-ability to support multiple worksheet excel file for dictionary creation... Normally, it should allow us to choose/map worksheet to record for dictionary creation. It allow this for CSDB creation. Do you have any workaround? Please any help!
Hope to have a global tools: External Data (CSV, txt, Excel, MySQL, PostGre, SQLServer, Oracle) to CSPro in the future!
Thanks in advance,
Excel to CSPro: multiple sheet dictionary
Excel to CSPro: multiple sheet dictionary
G.VOLNY, a CSProuser from Haiti, since 2004
Re: Excel to CSPro: multiple sheet dictionary
Unfortunately Excel2CSpro does not supporting creating a dictionary from multiple spreadsheets. You would have to create a dictionary for each worksheet and then merge them into a single dictionary by copying the records from each individual dictionary into a single dictionary.
Re: Excel to CSPro: multiple sheet dictionary
Thank you Josh! Since in SQLServer2CSpro you already implement this functionality
Thanks in advance,
Please can we have the same in Excel2Cspro?Tables in the SQL Server database are mapped to records in the CSPro data dictionary.
The systems makes a few assumptions:
Table names in the SQL server database will match record names in the CSPro dictionary
Column names in the SQL server database will match item names in the CSPro dictionary
The items used as id-items in CSPro will correspond to columns appearing in each table in SQL server, with the same name, in order to link together rows in the same case.
Thanks in advance,
G.VOLNY, a CSProuser from Haiti, since 2004