Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

SQL not showing results - where is debug output?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: SQL not showing results - where is debug output?
#53295
SQL not showing results - where is debug output? 9 Years, 1 Month ago Karma: 0
Hi,

Im having problems with both CSV imports and SQL connections, I know its not the addin its me but trying to diagnose it is a bit difficult.

How do I find the exact directory to store the CSV the url for my site (internally as an intranet) is:

http:\\intranet

The article url is

intranet/index.php?option=com_content&view=article&id=23

a working link is

intranet/images/Documents/TestExcelDocument.xlsx

If I add the .csv to images/Documents/testcsv.csv I just get the article header.

If I try and connect to an SQL DB I get the same but cant diagnose why.

Any ideas please? Thanks
The administrator has disabled public write access.
 
#53297
Re:SQL not showing results - where is debug output? 9 Years, 1 Month ago Karma: 746
Hello,

You can set "Choose source type -> SQL -> Debug" parameter to "Yes" to find a problem with DB connection.

About CSV files, the extension doesn't support ability to show data from MS Excel files (.xlsx). It can show data from CSV files. If file is located in Joomla! sub-folder, use the following value for "CSV -> Path to CSV file" parameter:

images/Documents/testcsv.csv

Check that the path is correct (it is case-sensitive). If it doesn't help, could you send screenshot(s) of module settings page and CSV file by email?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#53299
Re:SQL not showing results - where is debug output? 9 Years, 1 Month ago Karma: 0
Hi,

Apologies I put .xlsx instead of csv the document is csv. I have sent you screenshots of the setup which as far as I can see replicates that of the demonstration video.

Thanks
The administrator has disabled public write access.
 
Go to topPage: 1