- drees
- RO CSVI
- Friday, 19 May 2017
- 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
0
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
In the version 6.5 the limmit works. in the version 7.0 not.
Drees Hoek
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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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)
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)
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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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"
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"
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »