1. franayala
  2. RO CSVI
  3. Monday, 14 September 2015
  4.  Subscribe via email
Hi Roland,

We need to import a XML file from a remote server.

When we use a url like http://www.domain.net/folder/file.xml no problem. All work ok.

But when we use a url like http://user:passs@domain.net/folder/file.xml ... not work. Unable to get tue file.

A navigator can open the file without problems. The url is correct for a navigator, but your plugin seems not capable to read the file using this url estructure.

Can you support to me?

Thanks a lot.
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
ok. PM sent!

Thanks a lot, Roland!
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland,

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

Your patch is for 6.12

Sorry!!
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
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!!!
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,

This code is included in the 6.2.0 release, so you can use a user/pass in the URL.
  1. more than a month ago
  2. RO CSVI
  3. # 13
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!