I am trying to see if I can make csv file work like database sql with columns that sort and pagination.

to create an ari data table based on a csv file, I copied the module that runs this table:

www.eggsa.org/sarecords/index.php/stellenbosch-ngk/marriages-1689-to-1788
(where sorting and pagination work fine)

I changed the path to the csv file and the column headings to produce this table:

www.eggsa.org/sarecords/index.php/military-records/retirements-at-the-cape-1818-1826

but on that table the pagination and sorting is not working and I would like it to.

I do not know what the various CSV settings are for:

Path to CSV file - that is OK - I get the data
Delimiter and Enclosure - OK - like sql
File encoding - OK - file is utf-8 so nothing set here

but the rest?:

Remoting method Auto-detect CURL PHP extension PHP fopen function Socket
Heading No Yes
Auto-detect mode No Yes
Strict mode No Yes
Offset
Limit
Sort by
Sort direction Ascending Descending

Any help would be appreciated.

Thank you,

Richard

It seems this is a problem with CSV file. Try to set "CSV -> Strict mode" parameter to "Yes" in module settings.

Regards,
ARI Soft

That did the trick - thank you.

This is a smart and useful piece of software - thank you.

But can you explain a little please - what would that mean - strict mode?

Can you explain the other parameters for the CSV section?

Remoting method Auto-detect CURL PHP extension PHP fopen function Socket
Heading No Yes
Auto-detect mode No Yes
Strict mode No Yes
Offset
Limit
Sort by
Sort direction Ascending Descending

what are they for?

Thanks,

Richard

I think I'm having the same problem, but can't locate the

"CSV -> Strict mode" parameter to "Yes" in module settings.

I have the report article and all the data is displayed with the export csv info, but when I run a date query on the data - The data appears in a table, but the export csv information goes away and it is just a plain table.
Any ideas?
Thank you so much for this amazing tool!
Tk

to richardball: each parameter contains tooltip with description.

to tknight: where we can see the problem?

Regards,
ARI Soft

You can see it at:
www.stlareachamber.com/categories/list-of-reports/158-reports-2.html

a query from start: 2007
End: 2008 will give you a new table without sorting.
Thank you so much,
Tasha
(sorry, I have made public)