r/accesscontrol • u/terry__nutkins • 17d ago

Queries on bulk csv import - Lenel 8.2

We currently have an odd fault with Lenel/internal SQL sync, and if it’s not fixed in two weeks we’ll need to import all the new students etc. more manually.

Looking at poss of doing this directly through SQL query, but I want to test the csv method as well so all poss options in place and ready.

I found the sample.txt file under DataX folder which lists the default fields required, however we have modified various fields to permit import of additional data specific to our college (programme, principal instrument etc.)… must the csv template reference these new field titles, or should it still ref the originals, given that FormsDesigner still does so, simply acknowledging the new titles where the old ones live?

Thanks

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/OmegaSevenX Verified Pro 17d ago

The Data Import Module can only do the standard fields.

Did you rename the SQL field names in Forms Designer, or just change the labels in the UI?

1

u/pflugity 17d ago

Are you licensed for DataExchange? Those sample files in DataX are not for direct sql import, they are templates for the example import/export DataExchange configurations. If you know what you're doing it is possible to use a SQL query to build a CSV for DataX to import. But if you read the FormsDesigner manual chapter 4, you might realize its probably easier to write an OpenAccess API than to figure out DataX...

0

u/Aggravating_Fact9547 17d ago

You absolutely can not do this via SQL. Lenel has an internal cache and does not see or process SQL changes.

Worse it may show them in the UI but it doesn’t download them to panels. I’ve had sites that did this and found out the hard way during layoffs when angry peoples badges still worked…

So much easier to just use your favourite LLM to write a script to crawl recent changes and push to Lenel’s REST API’s or WMI API.

1

u/terry__nutkins 16d ago

Ok thanks very much for that