1. drees
  2. RO CSVI
  3. Friday, 19 May 2017
  4.  Subscribe via email
Call to a member function getName() on null get this when i import a xml file. It is a file of 533609 rules. about 25004 titels
Accepted Answer Pending Moderation
Hello,
Can you provide us more information on where you see this error with screenshots? I would also suggest you to check your XML file with CSVI analyzer before running the import. Analyzer would tell you if there is any problem with your file. To use analyzer follow the steps
1. Select your xml file by clicking Choose file
2. Check/uncheck if your file has headers
3. Record name will be the name of your XML node for each item
4. Lines to show is the number of lines to be displayed by Analyser, by default it is 3.
5. Click on Analyze button on top.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,

Check also the number of Lines per import set in your template. With such a huge file it is important to keep this to a low number to prevent the server from failing. You can find this by editing your template and click on the Limit tab. If you don't see the Limit tab click on the Advanced button first.

Lower this number to a couple of hundred and see how that goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thank you for the assistance. If I put the file on the server. Instead of uploading. I'm not getting an error. I have the limit at 10 with a break of 5. But it seems that the break does not work anymore. The i / o on the server is getting higher and blocked than.
In the version 6.5 the limmit works. in the version 7.0 not.

Drees Hoek
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Drees,
10 lines per import would be too less for the big file you have, it must be taking too long to process the file. How about you set it to 500 or something in few hundreds?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
When the template starts He's going to be very fast. super. After a while it goes slow.
At start 10 files in 10 seconds. fast enough. But there is no time between. Later 10 files more than 30 sec. The total import takes 16 hours. I think Time between imports does not work. The server sticks to I / O usage.
The xlm file is an export from CSVI. The same fields are used for import. (Two different websites)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Which version of CSVI are you using? If you are using any older version, can you try to update to latest CSVI 7.1.0 version and check with import limit? There was a fix done for import limit in the last version. And i guess you still haven't tried to increase your import limit to some hundreds as i suggested in my previous post. Please make these changes and if you still have issues, can you post the debug log of your import?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Not that I doubted your expert. But it looks like you're right. I will continue to experiment. Not all fields are imported. They are in the example. But that's for later.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
I am getting the same error. My csv file is very large - 1200000 lines. I have set to import 500 lines 10 in between. How can I determine the best number. I am importing 7 fields. Here is a sample below of data. 1st line is headers. I actually have 2.4 million lines but have broken it up into multiple files to test. Ideally I'd like to not have to do that. When I run the analyzer I get to 99%, then nothing happens. No error, but no results either. I have also set in my site a php.ini settings of upload_max_filesize = 250MB
post_max_size = 250MB.

I am running csvi pro 7.8.0, php 7.2, joomla 3.8.12

Here is the error message: An error has occurred.
0 Call to a member function getName() on null

"Make","PartNumber","QtyOnHand","Description","Condition","StockNum","EndUserPrice"
"Caterpillar","2125322","1","Hose A","New","MM01910078896","67.5000"
"Caterpillar","2125609","1","Hose AS","New","MM1772598719","109.3500"
"Caterpillar","2125885","1","Transforme","New","MM0844312578","72.9000"
"Caterpillar","2126028","7","Seal-o-ring","New","MM1497366277","0.5805"
"Caterpillar","2126030","2","Support A","Like New","MM01663958551","49.9500"
"Caterpillar","2126073","2","Ring","New","MM0889542963","6.4800"
"Caterpillar","2126168","1","Strap","New","MM01849969658","41.8500"
"Caterpillar","2126521","2","Switch A","New","MM01986907309","8.1000"
"Caterpillar","2126593","1","Cap A","New","MM287164109","25.6500"
"Caterpillar","2126831","1","Clamp","New","MM1299259914","6.8850"
"Caterpillar","2126891","31","Retainer","New","MM01311763223","0.2700"
"Caterpillar","2126932","16","Clamp","New","MM01590546872","3.6450"
"Caterpillar","2127002","6","Cap","Used","MM800596341","16.2000"
"Caterpillar","2127246","1","Switch A","New","MM1075088319","32.4000"
"Caterpillar","2128134","2","Film","New","MM0277994085","24.3000"
"Caterpillar","2128180","1","Shaft-pump D","Aftermarket","MM2042811183","143.1000"
"Caterpillar","2128180","1","Shaft-pump","Used","MM1961476377","40.5000"
"Caterpillar","2128183","1","Impeller","Aftermarket","MM0208568249","16.2000"
"Caterpillar","2128371","1","Hose A","New","MM01251187308","10.8000"
"Caterpillar","2128425","1","Bearing","New","MM0565510544","4.0500"
"Caterpillar","2128521","2","Bracket","New","MM0104989925","81.0000"
"Caterpillar","2128594","13","Bolt","New","MM01511036077","1.6200"
"Caterpillar","2128755","15","Hose A","Like New","MM229701974","9.4500"
"Caterpillar","2129590","2","Board","New","MM01762080459","6.4800"
"Caterpillar","2129873","1","Switch A","New","MM0197547298","12.9600"
"Caterpillar","2130025","3","Harness A","New","MM126653553","648.0000"
"Caterpillar","2130499","3","Film","New","MM0958927824","4.9950"
"Caterpillar","2130617","1","Harness A","New","MM0144287124","10.8000"
"Caterpillar","2130618","1","Harness A","New","MM1014471362","6.6150"
"Caterpillar","2130715","1","Harness A","New","MM01601680730","13.5000"
"Caterpillar","2131079","2","Knob","New","MM1288666563","11.3400"
"Caterpillar","2131101","82","Bracket A","New","MM488303313","8.2350"
"Caterpillar","2131730","1","Hose Radiato","New","MM0929497504","24.3000"
"Caterpillar","2131788","2","Tube A","New","MM01285705654","27.0000"
"Caterpillar","2132248","2","Film","New","MM1521676632","13.5000"
"Caterpillar","2132432","1","Bracket","New","MM594861981","40.5000"
"Caterpillar","2133064","1","Gasket","New","MM0276281522","6.8850"
"Caterpillar","2133066","6","Pin","New","MM01730637598","3.1050"
"Caterpillar","2133201","1","CONN. Rod","Used","MM0607073684","72.9000"
"Caterpillar","2133274","1","Sensor","New","MM1493299579","189.0000"
"Caterpillar","2133417","2","Pin","New","MM01846642012","3.9150"
"Caterpillar","2133604","2","Hose A","New","MM01564699174","10.8000"
"Caterpillar","2134262","1","Seal A","New","MM867818804","5.9400"
"Caterpillar","2134631","3","Nozzle A","New","MM02001738329","4.1850"
"Caterpillar","2134635","1","Clip","New","MM0111373380","3.6450"
"Caterpillar","2135170","1","Kit-ride","New","MM0157960409","13.5000"
"Caterpillar","2136296","1","Wire A","New","MM2020208321","108.0000"
"Caterpillar","2136298","1","Wire A","New","MM01706165930","105.3000"
"Caterpillar","2136299","1","Wire A","New","MM01454498693","105.3000"
"Caterpillar","2136329","1","Harness A","New","MM1756893810","16.2000"
"Caterpillar","2136874","1","Film","New","MM01321362813","8.1000"
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Do you run your import manually via web? I am thinking if the error you see is because of session timeout in processing so many records. For such huge files it is recommended to use Command line to run the import. Have a look at setting up cron job using CSVI document. Cron job import does not run on batches so you don't need to worry about the numbers set on Limits tab. Let us know if that solves the error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
At this time yes it is manual. I am looking to test a few processes. At some point if all works out well and smoothly then possible automation of that. It really depends on the content though that comes from many suppliers.
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
Ok, what happens with manual import is that logged in user goes to idle mode when the import is running. Once the session duration is hit, Joomla logs out of the site and so you are seeing the error. By default Joomla session is 15 minutes, you can increase it from Joomla global configuration page on system tab. But again this setting will not solve your error, just that you can increase the time you would see the error and some more records would be imported. As i said earlier, best way would be automated setup, it is easy to handle those huge files. Let us know how it goes with import once you have cron job setup.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
I am going to work on setting up the cronjob today. I'll get back to you on my progress. If I need help I will reach out. Thank you for your reply and knowledge.
  1. more than a month ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


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