Subject access points' strange behaviour after CSV import

[Martín]

Hi,

I've successfully imported many hundred records (archival descriptions) with CSV command line import utility. Everything works fine after rebuilding the search index (twice in a row).

Everything is working fine but there's still s little (annoying) bug. In every arvhical description I put "es" in culture column (spanish language). ICA-Atom is configured with englisgh language. Everytime I browse an archival description, the subject access points are shown fine:

• ARQUITECTURA (Fachadas)
  
• ARQUITECTURA (Edificios monumentales)
  
• ARQUITECTURA (Terrazas)
• URBANISMO (Plazas)
  

Clicking on any of them would lead us to the "borwseTerm" page, the expected behaviour.

Now, I change the language of ICA Atom to "spanish" (or any other language other than english). Browsing again the same archival description I get this:

• /index.php/lp6fk;term/browseTerm
  
• /index.php/yjl9b;term/browseTerm
  
• /index.php/qps3k;term/browseTerm
  
• /index.php/csynn;term/browseTerm
  

Clicking on any of them would lead us to the "borwseTerm" page, the expected behaviour.

Why ICA-Atom isn't showing properly the link (the text of the link is the same as the target page itself; the expected behaviour would be showing the name of the subject, as previously stated) when I configure ICA with other language different than english? Remember, I made the import in spanish language. It doesn't make any sense.

Thank you for your help.

[Jesús García Crespo]

Hi Martín,

You may have found a bug in the import code!

Could you take a look at the database and tell me what's the value for the source_culture column in the term table for all these new records that you added during the import? Changing it to "es" may do the trick, although it would be better if we just fix the import code.

Regards,

PS: Please, send your next e-mail to ica-ato...@googlegroups.com since your question fits better in that list. Thanks!

--
You received this message because you are subscribed to the Google Groups "Qubit Toolkit Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qubit-dev+...@googlegroups.com.
To post to this group, send email to qubi...@googlegroups.com.
Visit this group at http://groups.google.com/group/qubit-dev?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Jesús García Crespo,
Software Engineer, Artefactual Systems Inc.
http://www.artefactual.com | +1.604.527.2056

[Martín]

Hi Jesús,

Yeah, in fact I solved the issue by changing that column in the database. I've noticed also other problem: in the very same import some Subject Access Points were created twice: one row for english language (source_culture = en) and another row for the spanish language (source_culture=es). That would be nice if it worked properly, but it isn't. The spanish row name for the subject access point is NULL. So, I've found records like this:

id = 1 | name = "SUBJECT_EXAMPLE_NAME" | source_culture="en"

id = 1 | name = NULL | source_culture="es"

id = 2 | name = "SUBJECT_EXAMPLE_NAME_2" | source_culture="en"

id = 2 | name = NULL | source_culture="es"

So I had to fill those NULL names with name column found in their english translation. This issue only happens sometimes. As I've stated before, most rows inserted only once (with source_culture=en).

Thanks for your help, if you need more info about the bug, please feel free to contact me again.

[Jesús García Crespo]

I'm going to pass your questions to Mike Cantelon, he may know what's going on.

Thanks,

[Jesús García Crespo]

Thanks, Martín.

I have filed an issue:

https://projects.artefactual.com/issues/4738

Saludos,

[jes...@artefactual.com]

This issue has been fixed and the fix verified.

Jessica Bushey