Import

06.07.2020 13:13
#1
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Import

Hello

I am trying to import Label using Universal Import but this after import it comes blank
my import is just ID and label columns ?

I have a large block of data like this ...
IeUniCSVImport Object ( [app] => JApplicationAdministrator Object ( [docOptions:protected] => Array ( ) [scope] => com_jshopping [_clientId:protected] => 1 [_messageQueue:protected] => Array ( ) [_name:protected] => administrator [profiler:protected] => [template:protected] => stdClass Object ( [template] => isis [params] => Joomla\Registry\Registry Object ( [data:protected] => stdClass Object ( [templateColor] => [logoFile] => ) [separator] => . ) ) [charSet] => utf-8 [mimeType] => text/html [modifiedDate] => [client] => JApplicationWebClient Object ( [platform:protected] => [mobile:protected] => [engine:protected] => [browser:protected] => [browserVersion:protected] => [languages:protected] => Array ( ) [encodings:protected] => Array ( ) [userAgent:protected] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36 [acceptEncoding:protected] => gzip, deflate, br [acceptLanguage:protected] => en-AU,en-GB;q=0.9,en-US;q=0.8,en;q=0.7 [robot:protected] => [detection:protected] => Array ( ) ) [document:protected] => JDocumentHTML Object ( [_links] => Array ( ) [_custom] => Array ( ) [template] => [baseurl] => [params] => [_file] => [_template:protected] => [_template_tags:protected] => Array ( ) [_caching:protected] => [_html5:JDocumentHTML:private] => [title] => Victory Badges - Administration - Universal CSV Import Settings [description] => This is a sample project data joomshopping [link] => [base] => [language] => en-gb [direction] => ltr [_generator] => Joomla! - Open Source Content Management [_mdate] => [_tab] => [_lineEnd] => [_charset] => utf-8 [_mime] => text/html [_namespace] => [_profile] => [_scripts] => Array ( [/media/jui/js/jquery.min.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/jui/js/jquery-noconflict.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/jui/js/jquery-migrate.min.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/jui/js/bootstrap.min.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/betterpreview/js/script.min.js?1455543983] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/system/js/mootools-core.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [/media/system/js/core.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [https://victorybadges.com/components/com_jshopping/js/functions.js] => Array ( [mime] => text/javascript [defer] => [async] => ) [https://victorybadges.com/administrator/components/com_jshopping/js/functions.js] => Array ( [mime] => text/javascript [defer] => [async] => ) ) [_script] => Array ( [text/javascript] => jQuery(document).ready(function(){ jQuery('.hasTooltip').tooltip({"html": true,"container": "body"}); }); var betterpreview_texts = { 'url': 'URL', 'nonsef': 'Non-SEF URL', }; ) [_styleSheets] => Array ( [/media/nnframework/css/style.min.css] => Array ( [mime] => text/css [media] => [attribs] => ) [/media/betterpreview/css/style.min.css] => Array ( [mime] => text/css [media] => [attribs] => ) [https://victorybadges.com/administrator/components/com_jshopping/css/style.css] => Array ( [mime] => text/css [media] => [attribs] => Array ( ) ) ) [_style] => Array ( ) [_metaTags] => Array ( [http-equiv] => Array ( [content-type] => text/html; charset=utf-8 ) [standard] => Array ( [keywords] => ) ) [_engine] => [_type] => html [mediaVersion:protected] => 65df9ab0164a0285efb8f7469c58cafa [helix] => Helix Object ( [document:Helix:private] => JDocumentHTML Object *RECURSION* [importedFiles:Helix:private] => Array ( [0] => /home/victoryb/public_html/plugins/system/helix/core/wp_shortcodes.php [1] => /home/victoryb/public_html/plugins/system/helix/shortcodes/accordion.php [2] => /home/victoryb/public_html/plugins/system/helix/shortcodes/alert.php [3] => /home/victoryb/public_html/plugins/system/helix/shortcodes/button.php [4] => /home/victoryb/public_html/plugins/system/helix/shortcodes/carousel.php [5] => /home/victoryb/public_html/plugins/system/helix/shortcodes/column.php [6] => /home/victoryb/public_html/plugins/system/helix/shortcodes/divider.php [7] => /home/victoryb/public_html/plugins/system/helix/shortcodes/gallery.php [8] => /home/victoryb/public_html/plugins/system/helix/shortcodes/hide.php [9] => /home/victoryb/public_html/plugins/system/helix/shortcodes/icon.php [10] => /home/victoryb/public_html/plugins/system/helix/shortcodes/map.php [11] => /home/victoryb/public_html/plugins/system/helix/shortcodes/progressbar.php [12] => /home/victoryb/public_html/plugins/system/helix/shortcodes/tab.php [13] => /home/victoryb/public_html/plugins/system/helix/shortcodes/testimonial.php [14] => /home/victoryb/public_html/plugins/system/helix/shortcodes/typography.php [15] => /home/victoryb/public_html/plugins/system/helix/shortcodes/video.php ) [_less:Helix:private] => [_shortcodes_scripts] => Array ( ) [_shortcodes_styles] => Array ( ) [inPositions:Helix:private] => Array ( ) [inHeader:Helix:private] => Array ( ) [inFooter:Helix:private] => Array ( ) [beforeModule:Helix:private] => Array ( ) [afterModule:Helix:private] => Array ( ) [layout:Helix:private] => [inline_css:Helix:private] => ) ) [language:protected] => JLanguage Object ( [debug:protected] => [default:protected] => en-GB [orphans:protected] => Array ( ) [metadata:protected] => Array ( [name] => English (en-GB) [tag] => en-GB [rtl] => 0 [locale] => en_GB.utf8, en_GB.UTF-8, en_GB, eng_GB, en, english

 
06.07.2020 14:29
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

example csv file?
configuration addon?

 
06.07.2020 23:30
#3
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

these are my addons
1 Inform availability product 1.3.1
2 Addon Label time 1.0.4.0
3 Addon Label multiselect 1.1.7
4 Free price 1.0.1
5 JoomShopping Filter extended 4.3.2
6 Universal CSV Export 3.12.3
7 Universal CSV Import 3.14.1
8 Addon product shipping 2.6.0

the csv file was simply 2 columns ID, Label
as it did not work, I expanded it to id,label,characteristics,manufacturer,name which for some reason caused the error.
labels.csv

 
07.07.2020 08:48
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

1. configuration import addon
2.
Your file with column
id,characteristics,manufacturer,name

 
07.07.2020 09:43
#5
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

I tried again with no luck

this is the csv file
labels1.csv

 
07.07.2020 14:49
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

Universal CSV Import configuration?

 
07.07.2020 15:05
#7
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

as requested
Aw: Import
import_config_2.jpg

 
07.07.2020 15:12
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

url?
admin login?
(forum privta msg.)

 
07.07.2020 23:35
#9
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

will send message

 
08.07.2020 20:59
#10
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

Problem in Addon
Product Label time

Universal CSV import - import in field joomshopping label.

For import in field Product Label time
use field
label_time_id

 
09.07.2020 00:06
#11
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

thank you for your assistance on this

will their be a new update for the import function
what about the export function, that is exporting the label name but not ID

 
09.07.2020 00:57
#12
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

this worked fine however I need to expand the import to include start and end dates please
not all my labels require dates and if an item is originally on sale with a date then I need to be able to clear it via an import
thank you

 
09.07.2020 06:34
#13
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

I have updated it through a sql query so all good but it is still an issue in the future
thank you

 
09.07.2020 08:04
#14
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 22449
Quote
Aw: Import

Universal CSV Import Settings
Aw: Import

add fields
label_date_start
label_date_end


Last change: 09.07.2020 08:06
 
09.07.2020 08:51
#15
victorybadges
Joomshopping forum user no avatar
Name: Nick
09.07.2012
Posts: 235
Quote
Aw: Import

thank you

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.