Jump to content

Data Import Problem on a Windows Server


sporthorsebreeder

Recommended Posts

Hello
I have just imported a test database of listings into my business directory phpmydirectory.
All went ok except I have noticed that the many categories and sub-categories have been added again even though they were already in the categories setup.

When the directory was installed the categories were imported in and the database is using UTF-8 collation/charset and its adding \r\n to the end of the entries for some reason. 

I don't know a great deal about php and mySQL but I had a search on the internet and what I can gather is that the \r\n characters that are being added are because php and mySQL are being hosted on a Windows server. 

I fould this on one website

[quote]If you are connecting from a Windows based machine, the Lines terminated by entry should normally be set to \r\n (the default suggested by phpMyAdmin). Windows uses both a carriage return character (\r) and a newline character (\n) to terminate the lines of text files. If your text file contains values for every field, listed in the same order as the fields are defined in the MySQL table, then the Column names box can be left blank. Finally, click Submit to upload the data file to the server and the records will be automatically appended to the table.[/quote]



Has anyone else found this problem and what is the best way to fix it?

I am running phpmydirectory v. 10.4.6
Windows Server 2003 running IIS v6
PHP Version 5.0.5
mysql 4.1.7
phpMyAdmin 2.6.4-pl4

Thanks for any help.
Hugh
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.