Resolved Error when using a url with user and pass

Hello,

CSVI is not doing anything specific for loading the XML file as it asks PHP to get the file. What happens if you use the username and password in the URL? Could you send me a private message with the real username/password and URL so I can take a look?

ok. PM sent!

Thanks a lot, Roland!

Hello,

The username/password was not supported. The attached patch file adds support for this. You can load the patch file and this should work now. If the patch file says that no file has been uploaded, you can unzip the file manually and follow the path in the zipfile. You can copy the 2 files to the correct location.

Hi Roland,

Please, forgive me. Our version is 5.21.2 (((

Your patch is for 6.12

Sorry!!

Hello,

No new features are being added to CSVI 5 anymore as CSVI 6 is the main version. If you plan to keep using CSVI 5, the only way would be to use a cron job to download the file regularly. You can download the file manually and put it on the server or use the file upload to load it into CSVI. This is recommended anyway when testing, otherwise you need to download the file on every try.

The problem is:

I try to install CSVI Pro 6 but the issue detailed in your installation guide appears. And we can not make a clean installation because we have a lot of custom import templates and we can not delete it.

Maybe we can save the templates from csvi 5 to use in csvi 6? This is possible?

Thanks

I understand what you are saying. Not sure how you installed CSVI 6 first but let's try this. First make a backup or test on a test site. Uninstall CSVI 5 and remove the table csvi_settings, now try to install CSVI 6. Does that work?

Hi Roland,

1) I make a backup.
2) I uninstall CSVI 5
3) I delete the table CSVI_SETTINGS
4) I Install CSVI 6
5) The error described in CSVI 6 installation guide appears

If i delete all tables except CSVI_TEMPLATE_SETTINGS and try to install CSVI 6 all ok, but no templates found.

Any idea to not loose the CSVI 5 templates?

Thanks!

Hello,

The error described in CSVI 6 installation guide appears

You are talking about the error in regards to the csvi_settings table correct?

If yes, let's do the following

1. Make a backup
2. Uninstall CSVI 5
3. Remove the table csvi_settings
4. Execute this sql statement

   CREATE TABLE IF NOT EXISTS `#__csvi_settings` (
   
     `csvi_setting_id` int(11) NOT NULL AUTO_INCREMENT,
   
     `params` text NOT NULL,
   
     PRIMARY KEY (`csvi_setting_id`)
   
   ) CHARSET=utf8 COMMENT='Configuration values for CSVI';

   Replace the #__ with your own prefix
5. Install CSVI 6

This should automatically convert your old templates to the new template style.

Hi Rolandd,

No, no. The error is

Unknown column 'csvi_log_id' in 'field list' SQL=SELECT csvi_log_id FROM #_csvi_logs ORDER BY csvi_log_id

I use your last instructions but the same error.

If i delete logs table CSVI is installed OK but no templates displayed.

No problem, Rolandd, i try to create a clean installation and all templates in test site and when all ok i try to move to real site.

This is very urgent for our company today.

Great support. Seriously.

Thanks!!!

Hello,

I use your last instructions but the same error.

This error is not in the instructions, so we are talking about something different.

No problem, Rolandd, i try to create a clean installation and all templates in test site and when all ok i try to move to real site.

Ok, this is a good moment then to get used to the new layout. Feel free to post any questions you have.

Thanks!!!

You're welcome.

Hi Rolandd,

Your custom code to allow user and pass in url in 6.12 version can be used in 6.20 versión?

Thanks!

Hello,

This code is included in the 6.2.0 release, so you can use a user/pass in the URL.