search

joomlaboat / custom-tables

The Custom Tables extension allows you to create, manage, and display custom data on your Joomla site. It is helpful if you need to display data that is not part of the standard Joomla content structure. For example, you could use this extension to create a custom table for product information, customer data, or any other type of data that you need to display on your site. The Custom Tables is the CRUD solution for Joomla 3.x and 4.x - CREATE, READ, UPDATE and DELETE. You can add tables, fields, and layouts to create catalogs, forms, or details pages. It has 40 Field Types: Integer (numbers), Decimal, Text String, Time, Email, Color, Image, File, User, Language, etc.
https://joomlaboat.com/custom-tables
GNU General Public License v2.0
35 stars 11 forks source link

CSV Upload Fails #83

Open ki0kk opened 4 months ago

ki0kk commented 4 months ago

I have added the CSV Upload button to my Custom Tables Catalog Page and the Upload button is displayed. When I attempt to upload a file I get a message that "Field names do not match". I have verified the field names and they are correct. I have also tried using a CSV file without any header line with the same error.

domath2k commented 4 months ago

CSV Upload Fails. Is there any way to see what the exact error is? I am only testing by importing one record. The fields defs are correct, but the import says "ERROR:" How can I see the error? There are only 5 fields. All of them are Text String, and are long enough. What could the error be? All I get is "ERROR"

ki0kk commented 4 months ago

TNX for the reply. I did eventually get a reply from Ivan on the Chat on the Joomlaboat web page. My question was if the upload feature was only in the Pro version. He responded , yes only in the Pro version. It looks like the command was provided in the documentation but some of the code must be missing without the Pro version. I'm going to do some additional testing to insure the extension can replace the list and forms features in the web site adequately. Looks like I will need the Pro version to provide all the features I need.

domath2k commented 4 months ago

Thanks for the info. I have the Pro version and still can't get the CSV Upload to work. Please let me know if you purchase the Pro version and get the Import to work. It may not be working for me because I may have somehow lost the Pro versioning licensing with an uninstall and re install of the latest version of both custom tables and the Pro plugin I recently did. I am waiting on Ivan to reply to a chat to show me how to relicense.

joomlaboat commented 4 months ago

Hello domath2k,

Can you show an example of your CSV file and the list of fields in the table?

domath2k commented 4 months ago

Table fields test-record-1.csv

domath2k commented 4 months ago

And here's the error Import error

joomlaboat commented 4 months ago

I found the problem in Import CSV method.

Please try an update:

https://github.com/joomlaboat/custom-tables

domath2k commented 4 months ago

I updated. Same error. Still not working.

joomlaboat commented 4 months ago

Do you (website) have the permission to write to /tmp folder?

domath2k commented 4 months ago

I'll double check

domath2k commented 4 months ago

I have write set. Same error.

domath2k commented 4 months ago

*write rights

joomlaboat commented 3 months ago

Please try the latest update: https://github.com/joomlaboat/custom-tables