dataferret
Member
- Joined
- Jan 7, 2005
- Messages
- 10
Hi there everyone
I have been grappling with importing ODP RDF files into a mysql database and massaging it into an appropriate schema. I have successfully managed to parse the data, dump it into a database and port it over into a suitable schema. I am using a commercial application called Powerseek SQL to manage the directory. However there is a problem which is giving me huge headaches and I cannot find an answer anywhere. Despite the sql code being perfectly valid and the database returning the records when you perform a direct sql query through a client such as phpmyadmin, Powerseek refuses to output some records. I have been in touch with the people who make it and they assure me it is not the application at fault but a problem with the sql code or the database. If I delete the records from the database and recreate them Powerseek works fine. Is there any kind of hidden or invisible characters within the RDF files which does not show up in a Windows text editor and which could be causing the problem? If so, how would I clean the text files so there are not any errors? I have tried cleaning them in Word, Xcel, formatting them as text, exporting and importing the text files, sql dumps, individual catgeories and individual levels of sub-categories and I am tearing my hair out.
I have even tried different parsers and also downloading a new structure file in case it was corrupted.
Please - if someone knows what could cause these errors, could you post some information and guidance here.
I have been grappling with importing ODP RDF files into a mysql database and massaging it into an appropriate schema. I have successfully managed to parse the data, dump it into a database and port it over into a suitable schema. I am using a commercial application called Powerseek SQL to manage the directory. However there is a problem which is giving me huge headaches and I cannot find an answer anywhere. Despite the sql code being perfectly valid and the database returning the records when you perform a direct sql query through a client such as phpmyadmin, Powerseek refuses to output some records. I have been in touch with the people who make it and they assure me it is not the application at fault but a problem with the sql code or the database. If I delete the records from the database and recreate them Powerseek works fine. Is there any kind of hidden or invisible characters within the RDF files which does not show up in a Windows text editor and which could be causing the problem? If so, how would I clean the text files so there are not any errors? I have tried cleaning them in Word, Xcel, formatting them as text, exporting and importing the text files, sql dumps, individual catgeories and individual levels of sub-categories and I am tearing my hair out.
I have even tried different parsers and also downloading a new structure file in case it was corrupted.
Please - if someone knows what could cause these errors, could you post some information and guidance here.