IProperty

Intellectual Property is a full-featured real estate extension for the Joomla! CMS

IPReserve

IPReserve is a reservation extension for IProperty.

IReport

Need to keep track of your IProperty stats? Meet IReport - a reporting tool for IProperty!

Work Force

Work Force is a staff listing extension for the Joomla! CMS. Show off your employees with style!

Report Card

Report Card is a testimonials extension for the Joomla! CMS. What are people saying about your company or product?

UTransport

Ultra Transport is a full-featured vehicle listing extension for the Joomla! CMS

Project Log

Project Log is a project management extension for the Joomla! CMS. The best part is, it's totally free!

Forums

Have pre-sales questions or need support for an existing subscription? Look no further - we have active support forums and pride ourselves on friendly and timely response!

The Thinkery

Not finding what you're looking for? Don't hesitate to contact us!

Before Posting...

Before posting questions in the forums, please be sure to read the FAQs by clicking on the FAQs link in the sidebar product menu. You must be logged in and have a valid subscription to access the SUPPORT FORUMS.
×
Support Policy Notice

As outlined in our Rules section (though never closely followed by our staff!), effective immediately we will no longer be taking time to provide customizations of our products.

× PLEASE DO NOT POST SUPPORT QUESTIONS HERE!

import csv in phpmyadmin

  • fchoudhary
  • fchoudhary's Avatar Topic Author
  • Offline
  • Puzzler
  • Puzzler
More
4 years 4 months ago #43158 by fchoudhary
fchoudhary created the topic: import csv in phpmyadmin
I get an error,

Invalid column count in CSV input on line 1.

I've followed the format for column heading from another topic on this forum. i have a database which i modified to fit the extension and then saving it as csv file from excel.

Thanks,

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #43159 by tim
tim replied the topic: import csv in phpmyadmin
Invalid column count is pretty common when working with csv. You must have missed a column (or have an extra column). Just carefully go through the file and verify that there's the right # of columns to fit the DB table, and that the rows also have the proper number of columns, defined by commas. Note that any empty value still has to have an empty "slot" in the row:
,,"not empty",,,,"not empty"

Please Log in or Create an account to join the conversation.

  • fchoudhary
  • fchoudhary's Avatar Topic Author
  • Offline
  • Puzzler
  • Puzzler
More
4 years 4 months ago #43160 by fchoudhary
fchoudhary replied the topic: import csv in phpmyadmin
I've attached the csv, if you dont mind looking at it.

Please Log in or Create an account to join the conversation.

Moderators: vinny
Time to create page: 0.209 seconds