Pull Excel Data from Multiple Sheets

I need a solution

I’m working on a project where I receive an excel spreadsheet (.xlsx) with 3 different sheets. I’m trying to pull data in from just one of those sheets. I’ve created an Excel Generator that pulls the data perfectly when there is just one sheet on the spreadsheet, but I can’t seem to specify which specific sheet I’m trying to pull the data from in my Read File or my Dynamic Class Read components when there is more than just 1 sheet.

Please help, thank you in advance!

0

Related:

  • No Related Posts

Block specific google document on google doc

I need a solution

Hi team,

I am just wondering if we could block one specific google document url https://drive.google.com/file/d/xxxxxxxxxxxxxxxxxxxxxxx/view?usp=drive_web

I do not want to block the whole domain but only that google document url.

I have tried:

1. https://drive.google.com/file/d/xxxxxxxxxxxxxxxxxxxxxxx/view?usp=drive_web

2. drive.google.com:443/file/d/xxxxxxxxxxxxxxxxxxxxxxx/view?usp=drive_web

Those didn’t work.

0

Related:

  • No Related Posts

How to move SEPM from one server to another

I need a solution

Hello Everyone

I need a bit of guidance please.

I’m in the process of moving our Symantec Endpoint Protection Management installation from one server to another.

I have done a backup and saved the recovery file.

I need to know how to proceed with the installation of the new server etc.

– Do I choose to do a new/First Site Install with the previosuly saved Recovery Configuration file along with choosing same site name as the one on the old system and enter the Admin and DBA password to be the same as the old system and then when the installation is finished do a restore from backup. 

But then how do I make sure the Clients only talk to the new server … Change server priorities?

Or

– Do I do an Additional Site install, with the previosuly saved Recovery Configuration file, along with choosing a different site name than the old one( it wont let me choose the same site name), enter the replication server details (of the old system) along with Admin and DBA passwords the same  and when finished do a restore from back up and then change the Priority of the old and new server so that the new server takes over control of the clients?

This last option seems best but I got an error during the installation (database creation and initialization) where it said that it could not finish aggregating data for replication.

Can anyone please advise?

Thanks

J

0

Related:

  • No Related Posts

Upgrade issues from 1.2.1.3

I need a solution

Have a CAS running OS – 1.2.1.3 which only allows to upgrade from HTTP. Have a HTTP server running with the 1.3 file needed to start the upgrade path but keep getting “Error 500 Internal Server error” after the file is downloaded. Ive tried this from 2 different web servers and get the same issue. Any ideas? Thanks. 

0

Related:

  • No Related Posts

Looking For EndPoint Encryption and DLP Solution

I need a solution

Dears,

we are looking for an urgent DLP and Encryption solution,

we need to encrypt all our data that reside in Laptops and PCs, need to ensure in case of lost missing or due to abuse data is safe.

We need to Encrypt our Email we have Exchange 2016.

We need to prevent te leakage of some document and databases.

we have SEP in place and most of our Environment are Windows and Microsoft, we tried to contact symantec partner but most of the partner if not all in our country are passive awaiting for the customer PO, no real help explaining or giviing real information and answering question.

Best Regards,

0

Related:

  • No Related Posts

Client computer slow when SEP client is managed

I need a solution

Hi everyone

We are experiencing weird issue and I was wondering if we are alone.
Situation is, single domain, single SEPM (v14.2.1.1031.0100) on Windows Server 2012 with about 80 clients. Some clients are  v14.2.1.1031.0100, most of them v14.2.1.1015.0100, about 50/50 32:64-bit, predominantly Windows 7 Pro, the rest Windows 10 Pro.

About 2 weeks ago my computer (32-bit Win 7, SEP client v14.2.1.1031.0100) started being very slow. Slow meaning every operation took much longer then usual, any user input delayed, system response slugish, lots of “(not responding)” windows, especially if application performed anything network related. Symptoms like when you have HD bad sectors or failing optical drive so it takes a while for the computer to respond, but without frantic HD LED activity or anything in Windows logs. As I had no other user complaints I started hardware diagnostics and after few days had to give up, everything seems to be in order HW-wise.
I’ve made some internal DNS changes round about that time so the next couple of days I’ve spent playing with those. But when I reverted to the original setting issue remained.

I then CleanWiped my computer and issue was gone! Reinstalled SEP Client, issue returned.
Then I tried custom installing SEP client, removing component by component to determine which one was responsible. That took me couple of days again, as issue does not happen immediately after reboot. Sometimes among all that slugishness you get half an hour of uninterrupted operation, but this is rare. Usually when this behaviour starts computer is pretty much unusable.
Custom, component by component, installation did not point to the cause. Even with firewall component only computer was unusable after a while.

I then tried unmanaged client. Typical installation, everything there and with unmanaged client computer was running the whole day like it was brand new! As soon as I SylinkDrop it and connect to SEPM, responsiveness drops dramatically.
I then thought there may be something wrong with my rules, but the problem happens even when client is connected to the group with default rules only. Nothing out of the ordinary in SEP client logs.

Few days after I started troubleshooting procedure other users started complaining as well. As these were all 32-bit Win 7 users I thought that was something to look at, but then complaints started to come from some others as well. Worst affected was brand new Dell laptop with 64-bit Win 10 (identical laptop, bought at the same time, with installed identical software runs pretty much unaffected!?). 

At the moment I’m running 5-6 worst affected computers, including my own, as unmanaged with some -importconfig (half)solution.

Anyone have any idea what could cause such behaviour?
Where do I look?

Regards

0

Related:

  • No Related Posts